PME - Procedure to Extract Data from a Database Snapshot using Vista
Issue
There is a need to query a database snapshot.
Product Line
ION Enterprise 5.x
ION Enterprise 6.x
StruxureWare Power Monitoring 7.x
Power Monitoring Expert 7.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Power Monitoring Expert 2024
Environment
Vista
Cause
A database snapshot was taken.
NOTE: The procedure on how to create a database snapshot is explained in article FA282751.
Resolution
The procedure to connect to a snapshot is the same as connecting to an archive:
1. In Designer, go to File > Open > QUERYSERVER.<server name>
1. In Designer, go to File > Open > QUERYSERVER.<server name>
2. Create a new Query Module and configure it as shown below. In this example, the database snapshot name is "ION_Data_Snap":
3. In Vista, on a diagram, create a new Data Log Viewer and configure it as shown below:
4. Data can be seen up to the time the snapshot was taken:
Released for: Schneider Electric Thailand
