The Windows credentials used to run the Spotlight Client grant required permissions for the Spotlight Client to access the Spotlight Diagnostic Server, to configure the Spotlight Diagnostic Server, to acknowledge and snooze alarms, and execute actions on monitored systems like kill and pause.
The Windows credentials used to run the Spotlight Client must be a member of at least one of the following groups to access the Spotlight Diagnostic Server. The Spotlight Diagnostics User groups are created on install of the Spotlight Diagnostic Server. The Spotlight diagnostic user groups are as follows.
The following tables document the permissions granted to each level of membership. For membership information and to increase your level of membership, see Spotlight diagnostic user groups.
Table 79: Permission to configure Spotlight
Configure Ribbon Tab | Administrator | User | Read-only | |
---|---|---|---|---|
|
Add/Delete connection profiles | Yes | Yes | No |
Add/Replace/Delete tags | Yes | Yes | No | |
Enable/Disable monitoring connections | Yes | Yes | No | |
|
Yes | Yes | No | |
|
Alarm Action Editor | Yes | Yes | No |
Run a program when a threshold is reached | Yes | No | No | |
|
Yes | Yes | No | |
|
Add, edit and remove planned outagaes | Yes | No | No |
|
Yes | Yes | No | |
|
Yes | No | No | |
|
Yes | Yes | No | |
|
Yes | Yes | No | |
|
Yes | Yes | No | |
|
Change Display | Yes | Yes | Yes |
Troubleshoot Spotlight | Yes | Yes | Yes | |
|
Select a Diagnostic Server | Yes | Yes | Yes |
Configure the database maintenance schedule | Yes | Yes | No | |
Configure PagerDuty | Yes | Yes | No | |
Configure the auto-update facility | Yes | Yes | No | |
Configure the Diagnostic Server's mail server | Yes | Yes | No | |
Configure the Playback Database | Yes | Yes | No | |
Configure the SNMP Trap | Yes | Yes | No | |
Configure the Spotlight Statistics Repository | Yes | Yes | No | |
Configure the use of Extended Events | Yes | Yes | No | |
Federate Diagnostic Servers | Yes | Yes | No | |
|
Configure uploading to Spotlight Cloud | Yes | Yes | No |
|
Yes | Yes | No | |
Configuration Templates | Apply Configuration To… | Yes | Yes | No |
Save as Template | Yes | Yes | No | |
Delete Template | Yes | Yes | No | |
Rename Template | Yes | Yes | No |
Table 80: Permission to acknowledge, snooze and ignore alarms from the Spotlight Client
Monitor | Alarms | Action | Administrator | User | Read-only | |
---|---|---|---|---|
|
Yes | Yes | No | |
|
Yes | Yes | No | |
|
Yes | Yes | No |
Table 81: Permission to execute tasks on a monitored SQL Server from the Spotlight Client
Monitor | SQL Server Drilldowns | Administrator | User | Read-only | |
---|---|---|---|---|
|
Sessions | |
Yes | No | No |
|
Indexes | Update Statistics | Yes | No | No |
|
SQL Agent Jobs | |
Yes | No | No |
Service Status | Start / Stop Service | Yes | No | No | |
Cluster Services | Take Offline Cluster Services | Bring Online Cluster Services | Move Group |
Yes | No | No | |
|
Change parameter | Yes | No | No |
|
|
Yes | No | No |
Table 82: Permission to execute tasks on a monitored Windows Server from the Spotlight Client
Monitor | Windows Drilldowns | Administrator | User | Read-only | |
---|---|---|---|---|
|
Processes | Terminate | Yes | No | No |
Services | Start | Yes | No | No | |
Services | Stop | Yes | No | No | |
Services | Pause | Yes | No | No | |
Services | Resume | Yes | No | No |
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy