Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The following cmdlets help you automate the administration of your SQLdm SQL Diagnostic Manager deployment.

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 SQLdm SQL Diagnostic Manager permissions on a server

Revoke-SQLdmPermission

Revoke SQLdm SQL Diagnostic Manager permissions on a server

New-SQLdmMonitoredInstance

Add a SQL Server Instance that you want monitored by SQLdmSQL Diagnostic Manager

Set-SQLdmMonitoredInstance

Configure options on your SQL Server Instance

Remove-SQLdmMonitoredInstance

Remove a SQL Server Instance from SQLdm SQL Diagnostic Manager monitoring

Set-SQLdmAppSecurity

Enable or disable Application Security for SQLdmSQL Diagnostic Manager

New-SQLdmUser

Create a new SQLdm SQL Diagnostic Manager user

Set-SQLdmUser

Modify an existing SQLdm SQL Diagnostic Manager user

Remove-SQLdmUser

Remove an existing SQLdm SQL Diagnostic Manager user

New-SQLdmDrive

Create a drive for connecting to the SQLdm Repository

...