Hello,

Currently I am trying to get the cacls permissions assigned to a folder directory of the database data files.  I can get the list of directories now I am stuck on feeding each line into a loop as I am a complete newbie.

[String] $inventoryinstance="Server\Instance"
[String] $inventorydatabase="Database"

$smoAssembly = [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")
if (!($smoVersion))
{ Set-Variable -name SmoVersion -value $smoAssembly.GetName().Version.Major -Scope Global -Option Constant

-Description "SQLPSX variable" }
[reflection.assembly]::LoadWithPartialName('Microsoft.SqlServer.SMOExtended') > $null

#Get-DataFilePath
function Get-DataFilePathList
{
$instance = New-Object ('Microsoft.SQLServer.Management.SMO.Server') $inventoryinstance
$database = $instance.Databases[$inventorydatabase]
#Param ($database)
$result=$database.ExecuteWithResults("SELECT InstanceName, DBName, DataFilePath from dbo.tblDatabases")
$result.Tables | foreach {$_.Rows}
}

Get-DataFilePathList | foreach {$_.DataFilePath | Write-Output}

The output from this is the data file directories:

D:\MSSQL10.DEV806MSSQL\MSSQL\DATA\master.mdf
D:\MSSQL10.DEV806MSSQL\MSSQL\DATA\tempdb.mdf
D:\MSSQL10.DEV806MSSQL\MSSQL\DATA\model.mdf
D:\MSSQL10.DEV806MSSQL\MSSQL\DATA\MSDBData.mdf
D:\MSSQL10.DEV806MSSQL\MSSQL\Data\DBA_Maint.mdf

What's the best way to feed the output from this; $_.DataFilePath into a Foreach loop to get the permissions. (cacls/Get-Acl) Thanks in advance for the response.

You could do something like this. The code below works for folders or files, though its relying on your function to return some sort of path to 'something' whether that be a folder or file name.