Single Dashboard widget data from with TWO DIFFERENT source entities?

Hey team -

Traditional System Admin here (not even an *accidental* DBA). I'm trying to do some nifty things in a dashboard. I've kind of figured my way around using the graphical query builder, but the data I want seems to be in two different places, but I want it to appear in one table widget.

As an example:

- I have cool information about my Exchange databases in Orion.APM.Exchange.DatabaseAlert, like which e-mail server has the active copy.

- I also have cool information in Orion.APM.Exchange.DatabaseFile, which has things like database size.

How would I get my table to show data about my databases when the data is in two different entities? Thaks in advance!

Find more posts tagged with

entities

exchange2013

Dashboards

Accepted answers

All comments

neomatrix1217

Are these KPI metrics? you can have two separate values in one block as seen below not sure if that's what you are looking for?

jcordle

Sorry - no, this would be for Tables.

neomatrix1217

Can you show me an example?

adam.beedell

You want a UNION or weird join. Union for

thing name | thing data | etc
other thing | other data | etc

weird join for

thing name | thing data | unrelated thing name | unrelated thing data

in SWQL bracketed FROM queries kinda work as a CTE kinda. Talk to your DBA if you have one and be patient while they scratch their head at why you would want to it this way

You can also do Select Y.X, Z.A FROM X, Z

You'll run into problems if your responses have many lines, use for summaries