Browse FAQs

A script to determine the number of waveforms for each device in the PME system

Published date: 09 March 2020

Issue
Determining the number of waveforms generated by each device

Product Line
Power Monitoring Expert (PME)

Environment
SQL Server Management Studio (SSMS)

Cause
Troubleshooting database performance problem

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*

Run the following script in SSMS:
 
use ION_Data
SELECT wl2.SourceID, s.Name as 'Source Name', COUNT(*) AS 'Number of Waveforms'
FROM  WaveformLog2 wl2
inner join Source s on wl2.SourceID = s.ID
group by wl2.SourceID, s.name
order by 'number of waveforms' desc

NOTE: Either copy the above script or download and run the attachment in SSMS

Below is an example:



 

Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.