Modern Dashboards in Orion 2020

WinterSoldier

Hi ,

Has anyone tried to do grouping in modern dashboards for custom table?

I am not able to do grouping based on custom properties. Please help me out

Also, please do share new ideas for modern dashboards.

Thanks in advance.

@AlexSoul @aLTeReGo

Find more posts tagged with

custom_properties

Modern Dashboard

npm

orion_npm

Accepted answers

jm_sysadmin

I have used it a few times, and it should work, show me what you want to do and we can work through it. Below is an example that I used. (the order by gets ignored I think but you can do 'stuff' to order it in the widget I think)

All comments

jm_sysadmin

WinterSoldier

Hi @jm_sysadmin,

Thank you for your response. You can see below query where I am trying to group by but facing error.

SELECT
' '+ N.Caption AS NODE --/Orion/View.aspx?View=NodeDetails&NetObject=N:${NodeID}
,CONCAT('/Orion/images/StatusIcons/small-',ToString(N.StatusLED)) AS [_IconFor_NODE]
,C.ComponentName AS CMPNT --/Orion/APM/MonitorDetails.aspx?NetObject=AM:${ComponentID}
,A.Name AS APP --/Orion/APM/ApplicationDetails.aspx?NetObject=AA:${ApplicationID}
,' '+ C.StatusDescription AS Status
,CONCAT('/Orion/images/StatusIcons/small-',TOString(C.StatusDescription),'.gif') AS [_IconFor_Status]
,N.DetailsURL as [_Link_for_NODE]
,A.DetailsURL as [_Link_for_APP]
,C.DetailsURL as [_Link_for_CMPT]
FROM Orion.APM.Component C
INNER JOIN Orion.APM.Application A ON a.ID = C.ApplicationID
INNER JOIN Orion.Nodes N ON n.NodeID = A.NodeID
INNER JOIN Orion.NodesCustomProperties NCP ON NCP.NodeID=A.NodeID
WHERE

N.Status<>'9' AND NCP.ASP30 = 'True' AND
C.StatusDescription Not in ('Up','Unmanaged','Disabled','Critical','Warning') -- Component is not Up
Order by N.NodeID ASC

Group by NODE, CMPT, APP, Status, [_IconFor_NODE], [_IconFor_Status], [_Link_for_NODE], [_Link_for_APP], [_Link_for_CMPT]

Note : If I don't use grouping then I will get proper output. But I want to group it by Node first and then as mentioned above.

jm_sysadmin

Change the Group By to use the Columns from the SWQL views we have like:

Group by N.NodeID, N.Caption, C.ComponentName, A.Name, C.StatusDescription, N.StatusLED, N.DetailsURL, A.DetailsURL, C.DetailsURL
Order by N.NodeID ASC

WinterSoldier

Hi,

We are able to group by NodeName but we are seeing multiple Node Name entries. When we tried from web report or report writer, we are seeing one Node name entry.