SAM application monitor - Use in report

wv5819

Dear,

I created an application monitor that will pull data (text/string) from some host using Powershell, this works and the information is displayed under the application monitor of the assigned Nodes.

An example of a monitor

But I don't see any possiblity to have this information in a report? 

Is this out-of-the-box possible or do we need to do some SQL like query to extract the data?

Report should be something like

NODE1

field1

field2

Field3

....

NODEx

....

Thanks

m-milligan

You can do this report with the Dynamic Query Builder.

Create a new report and add  a Custom Table. For your data source, choose Nodes. Here's a sample query (I'm reporting on Nodes and limiting them by Caption):

Now set up your table like this. As you add columns, you'll have to choose Component from the "Orion Object" dropdown in order to add the Component/Name and Component/Current Component Statistics/Statistic Data columns.

The resulting report will look like this: