Get-SQL Instance and the Credential user with PowerShell ISE
Feb 24, 2021
We can get info from SQL Server with PowerShell. I used Windows Powershell ISE.
You can following the below steps.
Finding SQL Server instance, version number, Product level, host platform, and with a credential user.
Finding databases, status, sizes, space available, recovery model, compatibility level, owner, collection, and containment type.
Finding all login objects from my instance.