The following cmdlets help you automate the administration of your SQL Diagnostic Manager deployment.
To use SQL Diagnostic Manager snapin, you have to enable the provider and register the SQLdm drive.
Cmdlet Name | Description |
|---|---|
Get-SQLServers | Retrieve a list of SQL Servers on the network |
Escape-SQLdmName | Allows you to specify server names containing special characters, such as |\?/<>[]:* |
Grant-SQLdmPermissions | Grant SQL Diagnostic Manager permissions on a server |
Revoke-SQLdmPermission | Revoke SQL Diagnostic Manager permissions on a server |
New-SQLdmMonitoredInstance | Add a SQL Server Instance that you want monitored by SQL Diagnostic Manager |
Set-SQLdmMonitoredInstance | Configure options on your SQL Server Instance |
Remove-SQLdmMonitoredInstance | Remove a SQL Server Instance from SQL Diagnostic Manager monitoring |
Set-SQLdmAppSecurity | Enable or disable Application Security for SQL Diagnostic Manager |
New-SQLdmUser | Create a new SQL Diagnostic Manager user |
Set-SQLdmUser | Modify an existing SQL Diagnostic Manager user |
Remove-SQLdmUser | Remove an existing SQL Diagnostic Manager user |
New-SQLdmDrive | Create a drive for connecting to the SQLdm Repository |
Set-SQLdmLogging | Set the logging level of the SQL Diagnostic Manager provider. |