Need to get these results from powershell into a sql table.

Question

$adgroups = Get-ADGroup -Filter "name -like 'DL'" | sort name

$data = foreach ($adgroup in $adgroups) {
$members = $adgroup | get-adgroupmember | sort name
foreach ($member in $members) {
[PSCustomObject]@{
Group = $adgroup.name
Members = $member.SamAccountName
}
}
}

$data

Answer 1

The easiest way may be to create a CSV and import the CSV into the SQL table.

Get-ADGroup -Filter "name -like 'DL'" | #Is the filter correct? Or should it be "DL*"?
    Sort-Object name |
        ForEach-Object
            $groupname = $_.name
            Get-ADGroupMember $_ | 
                Sort-Object name |
                    ForEach-Object{
                        [PSCustomObject]@{
                            Group = $groupname
                            Members = $_.SamAccountName
                        }
                    } | Export-Csv SomeFileName.csv -NoTypeInformation

If you want to use PowerShell to import the CSV there are examples of how to do this if you search for "powershell import csv into sql".

Answer 2

Hi,

You can use Invoke-Sqlcmd to execute Transact-SQL statements if you need to insert data into a sql table with a powershell script.
For more details you can refer to this link
https://learn.microsoft.com/en-us/powershell/module/sqlserver/invoke-sqlcmd?view=sqlserver-ps

Best Regards，
Ian

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.