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

Consulter notre FAQ

Issue
A SQL query is needed to determine the number of waveforms generated by each device in a PME system.

Product Line
ION Enterprise 6.0
StruxureWare Power Monitoring 7.0.x
Power Monitoring Expert 7.0
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023

Environment
SQL Server Management Studio (SSMS)

Cause
When a database becomes too large this can lead to performance issues with the system. Waveforms take up a considerable amount of space. In order to begin troubleshooting the database performance problem it is helpful to see the number of waveforms recorded by individual devices in the system.

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:

Example