question

abhrfh-8495 avatar image
0 Votes"
abhrfh-8495 asked purnachandrar answered

Powershell

hi All

Need help. I am fairly new to Powershell. I am looking for a PowerShell script that scans all SQL servers on the network or the domain and searches for a particular user/login.
We are busy with an audit and there are three accounts that no one has a recollection of and we would like to disable these accounts.

Thank you in advance.

windows-server-powershell
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

purnachandrar avatar image
0 Votes"
purnachandrar answered

@abhrfh-8495 - You can install SQL PowerShell module and try to connect SQL server to scan user logins. You may need to write some lines of code to achieve your objective

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.