Issue
In some cases it is only required to present daily (or hourly) data instead of every 15 minutes; in other words, the query should return one record per day instead of 96 records (24 x 4 records/hr).
Product Line
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Environment
Vista
Cause
The Data Log Viewer Query Wizard shows the query that the Data Log Viewer runs against the SQL database to create the table that is seen in Vista. This query can be configured to put further specifications on what data is shown.
Resolution
Please note that the following procedure will provide the interval data at the specified time (not the aggregated value on that period)
The following filter can be implemented in Vista > Data Log Viewer to only poll data on a daily basis at 2:00 AM:
The result is:
Similarly, for 2:00 PM, the following query can be used:
And the result:
The following illustrates a filter for hourly data at the top of the hour:
And the result:
Publikováno pro: Schneider Electric Česká republika




Potřebujete pomoc?
Nástroj pro výběr produktů
Rychle a snadno vyhledávejte správné produkty a příslušenství pro vaše aplikace.
Získejte nabídku
Poptejte nás online a náš lokální specialista se s vámi spojí!
Kde nakoupit?
Jednoduše najděte nejbližšího distributora výrobků Schneider Electric ve vašem okolí.
Centrum nápovědy
Zdroje podpory pro všechny své potřeby najdete na jednom místě.