Issue running Powershell Module for Spotlight on SQL Server Enterprise

I am getting an error when trying to use powershell module for Spotlight on SQL Server Enterprise 12.4.0.24

1. browse to "E:\Program Files (x86)\Quest Software\Spotlight Enterprise\Console\"
2. execute ds-cli.cmd
3. get-connection

error:

Fullscreen

1
2
3
4
5
6
get-connection : The system cannot find the file specified
At line:1 char:1
+ get-connection
+ ~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (System.Collecti...nnectionEntry]]:List`1) [Get-Connection], Exception
    + FullyQualifiedErrorId : GetConnections,DiagnosticServer.Install.Utilities.PS.GetConnectionCommand
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

get-connection : The system cannot find the file specified
At line:1 char:1
+ get-connection
+ ~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (System.Collecti...nnectionEntry]]:List`1) [Get-Connection], Exception
    + FullyQualifiedErrorId : GetConnections,DiagnosticServer.Install.Utilities.PS.GetConnectionCommand

MichaelD over 6 years ago

Gita Sharifi, are you able to help with this issue?
- Gita Sharifi over 6 years ago in reply to MichaelD
  
  Hi Michael, I don't see a problem with the command. Try opening ds-cli.cmd with "Run As Admin" option and see if that works. Otherwise, please contact our support team.
  - MichaelD over 6 years ago in reply to Gita Sharifi
    
    thanks, tried 'Run as Admin' already
    I will contact support team
MichaelD over 6 years ago

It turns out you need to be in the local windows group "Spotlight Diagnostic Administrators" as an individual and not within another Active Directory group.
- Gita Sharifi over 6 years ago in reply to MichaelD
  
  Thanks for sharing Michael. Yes, our team has logged this as a future product change.
  Just for your information on any future Spotlight PS command issues, you can look at the below log file in order to obtain more details about the nature of the issue:
  
  C:\Users\<user name>\AppData\Roaming\Quest Software\Spotlight\<latest folder>\Support\DSClientLogs\DiagnosticServer.Install.Utilities_xxxxxxx_Errors.txt
  - MichaelD over 6 years ago in reply to Gita Sharifi
    
    Thanks!