{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.
Search FAQs
A script to determine the number of waveforms for each device in the PME system
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

Schneider Electric Saudi Arabia

Attachment(s)
WaveformCount.SQL.sql [229 Bytes]
Explore more
Range:
Articles that might be helpful Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Range: