How can we help you today?

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>
2. Create a new Query Module and configure it as shown below. In this example, the database snapshot name is "ION_Data_Snap":

Query module setup registers

3. In Vista, on a diagram, create a new Data Log Viewer and configure it as shown below:
Link query server


4. Data can be seen up to the time the snapshot was taken:

Data up until snapshot

Schneider Electric Canada

Explore more
Range:
Users group

Discuss this topic with experts

Visit our community and get advice from experts and peers on this topic and more
Explore more
Range:

Need help?

Need help?

Product Selector

Product Selector

Quickly and easily find the right products and accessories for your applications.

Get a Quote

Get a Quote

Start your sales inquiry online and en expert will connect with you.

Where to buy?

Where to buy?

Easily find the nearest Schneider Electric distributor in your location.

Help Center

Help Center

Find support resources for all your needs, in one place.

  • Help and Contact Center
  • Contact Sales
  • Find our Offices
  • Where to Buy
  • Careers
  • Company Profile
  • Investors
  • Newsroom
  • Report a Misconduct
  • Product Documentation
  • Product Selectors
  • Software and Firmware
  • Product Substitution and Replacement
  • Blog
  • Events
  • Schneider Electric Community
  • Sustainability
  • Legal Information
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings