Page History
The following cmdlets help you automate the administration of your SQL Diagnostic Manager deployment.
| Note |
|---|
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. |
...