Return
-
Title
How to export sessions from Workload Analysis by drilldown or command line? -
Description
How to export sessions from Workload Analysis drilldown? -
Resolution
WORKAROUND 1:
Use the Export icon towards the top-right corner of screen that's shaped as a disk to save the displayed SQL
WORKAROUND 2:
Use Command prompt or Powershell to export desired data with the following steps:
On the Spotlight Diagnostic Server Host:
1. Open a comand prompt or powershell session as admin and navigate to:C:\Program Files (x86)\Quest Software\Spotlight Enterprise\Console2. Execute "DS-CLI.CMD"4. Run the below command below:get-workloadanalysis -connectionname xxxxx_sqlserver -startdate "2025-1-30 00:00:00 AM" -enddate "2019-2-10 12:00:00 PM" -Resource "CPU"
Note:1. Change the 'xxxxx' text to the name of SQL Server connection. Change the start and end dates accordingly.2. Resource should be the same as shown in the Workload Analysis drilldown in Spotlight. It can be any one of the following: CPU, Duration, Logical Reads, Physical Reads, Writes3. The exported file named "WorkloadAnalysis_ xxxxx_sqlserver _Logical Reads_ 20191028000000_20191029120000.csv", will be placed on the folder where the DS-CLI.CMD file is located, which by default is:C:\Program Files (x86)\Quest Software\Spotlight Enterprise\Console4. If the exported file shows empty, verify the start and end, time and date selected show results on the drilldown, and make sure you include the AM/PM.NOTE: The path parameter cannot be included on the command up until version 15.0 due to defect ID SES-2053, this will be addresed on a future release.
-
Additional Information
https://help.spotlightessentials.com/enterprise_commandline_getworkloadanalysis