Can anyone please help put together a SWQL query that will count all of the elements (nodes/volumes/interfaces) associated with custom property that we apply to our nodes (i.e. City).
I have the following, but this only counts the nodes associated to the "City" custom property and doesn't include the interfaces/volumes elements associated to the nodes.
SELECT Count(NodeID) as [Node Count]
, N.CustomProperties.City
FROM Orion.Nodes N
Group By N.CustomProperties.City
ORDER By N.CustomProperties.City
Can anyone help put together something that would generate output similar to:
| "City" Custom Property (applied to Node) | Nodes | Interfaces | Volumes | Total Elements |
| Berlin | 23 | 54 | 2 | 79 |
| Paris | 46 | 76 | 4 | 126 |
| London | 90 | 132 | 10 | 232 |
Thanks.
