Please, Dojo
I’m looking for a way to export a specific set of Alarm Console Columns for monthly reports,
in the following scenario:
History wise, looking at 30 days each time – so possibly avoiding queries to the webAPI as the data to be aggregated could be too much to generate the report before a query timeout.
Alarm data to be aggregated from multiple local DBs: number of DMAs > 10;
all with Cassandra local DB, no Cassandra cluster, no elastic.
Possibly looking into an offload DB solution in the longer term as the data set is likely to increase, but for now all that I’d need is a quick and convenient way to generate the monthly history for the above columns without stressing too much the DMAs.
Tried with .csv, but I can’t get all the columns I need – e.g. missing “comments”
Using the standard component in Reports & Dashboards I get the data but not all the columns I need
This figure of 2276 is the average from any new element being tested – estimating the same for each DMA (fully licensed and fully loaded ~ 400 element min.)
Shall I necessarily split this into multiple reports?
Any hint is welcome – thanks
Hi Alberto,
Maybe an option is to use the GQI queries to retrieve alarms:
- You can select which columns from the alarm console should be included in the query (The column ‘Comments’ is available)
- You could export the result in a CSV file
- You could filter based on time
Below an example of the query:
Hope it helps.
PS: Please keep in mind that the old report module will be soon EOL (DataMiner Functionality Evolution and Retirement)
Thanks for your insight, Miguel – much appreciated: will try the GQI alternative for sure!
EDIT:
As for the reporter module as it is now, I understand there is no possibility to add any new feature – is there a way to migrate old reports to the newer app before EOL?
Hi Alberto,
I noticed that you already asked this question in another post.
For reference, see the answer in the following question:
https://community.dataminer.services/question/transition-from-legacy-reporter-dashboards-to-new-dataminer-dashboards-app/
Miguel, please, do you know where I can retrieve an example of the relevant syntax where custom alarm properties are also retrieved?
As this question has been inactive for a long time, we will now close it. If you want further assistance, could you post a new question?