Hi Dojo,
Currently working on a use-case to permanently disable Alarm Data from the Offload settings:
Ideally, with the possibility to still generate a data insight on a monthly basis, so evaluating two main scenarios, but keen to hear from the community if there’s more options available:
1.Build a GQI dashboard that allow users to select views/elements and days to retrieve the alarm count
for the selected days/views/elements (so, relying just on the Cassandra general DB, no Offload needed);
Are there any recommended components for this?
How is the Drop-Down component in 10.4 affecting the presentation of the data
fetched with a GQI Query Filter?
2. Any table that I can copy regularly from the local DMA(s) to a file via scripting,
to export the data only once a month?
Would CSV be an option or likely to become an unmanageable amount of rows for DMAs with thousands of alarms logged every day?
Hi Alberto,
Data Aggregator could be an option for your use case.
This feature allows you to schedule the execution of GQI queries (dashboard app is required). The result of these queries can be stored in a CSV file.
For example, you could trigger a GQI query once a day to get specific alarms from the system. They could be offloaded to a CSV file.
If you require aggregation, you could for example trigger another GQI query (using Data Aggregator) that will process the previous CSV file and store the aggregated values in a new file.
To display the content of the CSV files in a dashboard, your could this ad-hoc data source: SLC-GQIDS-CSV
Drawback here is that you will not be able to set the input arguments of the GQI query at the moment that the GQI is triggered (input arguments will be hardcoded).
Hope it helps.