Application Status in Modern Dashboard

As I am new to the whole writing SWQL, I am looking to create a modern dashboard table widget that will display applications that are down, and will use a custom properties from the node table

So something like

Application Name | Status | Down Time| Assigned Node | Node.CustomProperties. (going to use as a filter)

Thanks

Find more posts tagged with

sam

Modern Dashboard

Accepted answers

All comments

ecmel

You can use a query similar to this one (It lists applications of nodes that have City custom property set to London):

SELECT A.Name as [Application Name] 
, A.DetailsUrl as [Application Link]
, A.Status as [Application Status]
, A.CurrentStatus.LastTimeUp as [Last Time Up]
, A.Node.Caption as [Assigned Node]
From Orion.APM.Application A
Where A.Node.CustomProperties.City='London'

"Application Status" column returns numeric value for the application status code. You can configure Modern Dashboard column format to display status icon and value as displayed below: