Use Get-ADPrincipalGroupMembership with other Active Directory domains

Question: I use the Powershell cmdlet Get-ADPrincipalGroupMembership to get AD group membership of IDs within the current domain, but how can I use Get-ADPrincipalGroupMembership to check the membership of an ID in another domain? Answer: Yes , The Get-ADPrincipalGroupMembership cmdlet will return the group membership of the specified user , in the current domain of the logon executing this cmdlet . To access the group membership of a specific ID , you'll need to use the -server switch . Example Get-ADPrincipalGroupMembership 'ID1' -Server 'anotherdoamin' | select name If you want to read on how to access the group membership of... Read more →

How to master Mount-Diskimage in Powershell

Question: I want to set up a script to Mount a Disk in an automated way utilising Powershell ? The image exists as an ISO on a network path and requires to be made available as a drive letter & path. It doesn't have to be a dedicated drive letter - just the next letter after the highest. So for example , if I already have E:, F:,G: than I want it to be set as I: . I have some code in the script which can identify the drive letter assigned Answer: The Powershell code below will create the... Read more →

How to search SQL Server Agent Command Text for a string

Question: I'd like to find all SQL Server Agent Jobs with a certain string within the Command section . There's been a change in reference to a database table, therefore I need to review all SQL Server Agent Jobs and check they are not referencing this database table. Is there a sql query I can use to search for the string? As an extra request - do you have any advice on how to run this query across multiple SQL Server Instances and create a report? Answer: Both of these tasks are possible . Firstly , let's look at t-sql... Read more →

How to find Active Directory groups with Get-ADGroup search filter

Question: How can I find a list of AD groups with a specific search filter on the name column. ? In this case I want to find all AD groups in the default OU group with a search string. Answer: Assuming you are in the current Domain group \ OU group , find an example of Get-ADGroup which will filter on the search string "admin" Get-ADGroup -Filter "name -like '*admin*'" -Properties * | select name if you need to commit the Get_ADgroup search onto another server - than you'll need to use the -server switch Get-ADGroup -Filter "name -like '*admin'"... Read more →

How To Automate SQL Server Vulnerability Assessment

Powershell SQLVulnerabilityScan cmdlet is a great addition to the Powershell cmdlet libraries. Most of you know it's available through Microsoft Azure - using the interactive Advanced security pane . The powershell cmdlet - SQLVulnerabilityScan - is available through the SQL Server modules , the SMO and a bunch of new Powershell cmdlets. It's currently in Public Preview. The first step is to check that you can execute the cmdlet , point to a SQL Server and extract the report from the Vulnerability Scan. This powershell snippet - connects to a SQL Server and runs the scan over a specific database... Read more →