Hey all, I'm hoping to outsource some cycles!
I am working on a modern dashboard to be displayed on a wall monitor, so real estate is limited as the widgets need to be larger/more viewable from afar.
What I have:
- A SAM component that returns a value (0 or 4, to be exact) depending on where an application is active and where it is standby
- Groups (Containers) that have other things such as interfaces and other SAM components inside, separated between site 1 and site 2.
What I'm trying to do:
I have several applications that I'm trying to put on this dashboard with a KPI widget. I would like to configure the widgets to evaluate the SAM component first for the status of 0 or 4 to determine where the app is currently hosted. THEN, query the status of that site's group. I am trying to avoid having 10 widgets when my technicians only need to see the 5 that are active.
The "failover" groups may be up or down at any given time, but are not relevant to the group that will be watching and would cause a great deal of extra noise.
What I have tried:
I've tried some SWQL statements that run subqueries (not supported) and UNION (sort of supported? but I possibly did it wrong. probably. Probably did it wrong). The way I used UNION it grabbed both the active and failover as well as the component alert status. I could possibly further tune this to work using <> with 0 and 4 but it pulls both values so it's not very useful in that form.
Further info:
First table is Orion.ComponentAlert (using status and display name)
Second table is Orion.Container (attempting to use status and display name)
Any help greatly appreciated!
-Hawk
