Hi Dojo!
I would like to know if there's a way to display the element alarms within a specific view in a table. The "Get Element" query can retrieve the element alarms, but I haven't found a parameter to link it with the view or view ID.
While the alarms table can filter based on view, I need to achieve this through a query so that I can represent it in a column and bar component. Basically, I want to do the same thing as the alarm report but with the ability to filter by view.
Thank you!
Hi Yahya,
You could use the data source 'Get View Relations'. This data source will provide the View ID and the IDs of the child components (e.g. elements in the view). You could use this together with the data source 'Get Views' to display View name linked to an element (using join operators).
P.S.1 Keep in mind that an element can be included in multiple views.
P.S.2 Keep an eye on the performance of the GQI query. In order to get the view name, quite a few join operators are required.
Hope it helps.
Hi Yahya,
Just for completeness, while the reply for Miguel is correct for most of our users, it shows some limitations:
- Alarms that have view impact through View impact configuration | DataMiner Docs will not be covered
- Aggregation alarms (About aggregation rules | DataMiner Docs) will not be covered
- Current view configuration will be applied on alarms from the past. (view changes will not be covered)
The (active) raw alarms contain the view impact directly (cfr alarm console Cube "Views" column). The GQI GetAlarms data source does not have that column, but an ad hoc source would be able to bring that into your dashboards/LCApps. Are you familiar with ad hoc GQI (Get ad hoc data | DataMiner Docs)?
Non-active alarms (loaded from DB) could also show some of the limitations listed above atm. I'll not go into the details here, it's complicated and will depend on the type of storage you have and version of your DataMiner software.
In case you have no ambition for an ad hoc source, keep an eye open on the catalog in the coming months, I'm planning to add some extended alarm sources.