Technical FAQs

Ask a Question

Power Monitoring Expert - How To Determine Which Sources Have Future Data

Issue: 
Sources in a PME system that have improperly set clocks can cause issues due to the erroneous nature of the timestamps. On large systems, it can be difficult to determine exactly which source(s) are incorrectly configured. 

Product Line: 
StruxureWare Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x / 8.x / 9.0

Environment: 
SQL Server Management Studio

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.


The attached query will scan the ION_Data.DataLog2 table and return all sources that have a timestamp greater than the current date and time. This list can then be used to investigate the devices to ensure they are properly configured. 
 
Was this helpful?
What can we do to improve the information ?