Video: How to configure ION/SPM/PME to report on archived data?
Issue
How to configure ION/SPM/PME to report on archived data.
Product Line
ION Enterprise 6.x
StructureWare Power Monitoring 7.x
Power Monitoring Expert 7.x, 8.x, 9.x, 2021, 2022
Environment
Running reports.
Cause
User has archived historical data and wishes to run reports on them.
Resolution
Archives are, by default, attached as a database to the SQL instance used by ION/SPM/PME. If they have been detached, they will need to be re-attached to the ION instance using SQL.
Assuming the archives are attached to the ION instance in SQL:
2. Click on Tools
3. Click on Reports Configuration. This will open up the Reports Configuration window.
4. In the Reporting Configuration window under the Reports tab, select the archive that a report is needed from under the Location of report data drop down menu and Click Ok.
Note: After the changes, reports will now only run on the selected archive. The date range available for reporting will be limited to the date range the archive database contains.
Do not forget to set the "Location of report data" drop down back to the live database (ION_Data) once archive reporting has been completed. The same procedure must be followed.
Video guide:
Released for: Schneider Electric Canada
Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales inquiry online and en expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Center
Find support resources for all your needs, in one place.