Browse FAQs

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

Published date: 28 December 2018

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

SQL Server Management Studio


*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 ?

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.