Home / Commands / Invoke-sqmInstanceInventory
Invoke-sqmInstanceInventory
Inventory sqmSQLTool v1.8.2+
Creates a complete inventory of a SQL Server instance as a structured report (TXT + CSV).

Examples

Invoke-sqmInstanceInventory
Invoke-sqmInstanceInventory
Invoke-sqmInstanceInventory -SqlInstance "SQL01", "SQL02" -ContinueOnError
Invoke-sqmInstanceInventory -SqlInstance "SQL01", "SQL02" -ContinueOnError
$info = Get-sqmClusterInfo -ClusterName "MYCLUSTER"
$info = Get-sqmClusterInfo -ClusterName "MYCLUSTER"
    if (-not $info.Success) { Write-Error $info.ErrorMessage; return }
    $info.ClusterName
    $info.Nodes | Format-Table
    $info.Roles | Where-Object OwnerNode -eq "Node1" | Select Name, IPAddresses
Get-sqmClusterInfo -IncludeCoreGroup
Get-sqmClusterInfo -IncludeCoreGroup

    Queries the local cluster and returns all roles including the core group.
← Previous Command
Invoke-sqmConfigRollback
Next Command →
Test-sqmSsasDirectoryPermissions