Is there a way to get a report for interface count by node? We do not use NCM. I found one discussion, but the web report writer did not allow or give me the aggregate option.

leonejames1

Is there a way to get a report for interface count by node? We do not use NCM. I found one discussion, but the web report writer did not allow or give me the aggregate option.

sum_giais

Hello there @leonejames1.

Here's how you could do that with a SWQL query datasource. This could be done natively with the report builder but for me, it's quicker to do it with SWQL directly.

Steps to create the report:

 - Create new Report
 - Add Content
 - Then add custom table resource
 - Change Selection method to "Advanced Database Query (SQL, SWQL)"
 - Set Query Type to "SWQL"
 - Paste query below into text box
 - Name the datasource and click add to layout
 - Edit table and add columns
 - Add the Caption, IP_Address, Status, and InterfaceCount columns
 - Set the Display setting on the Caption to Details Page Link, click enable tooltips
 - Set the Display setting on the Status field to Status Icon (Watermark)
 - Arrange and/or customize your columns further as needed
 - Click submit

SWQL Query:

SELECT
     n.Caption
    ,n.IP_Address
    ,n.DetailsUrl
    ,n.Status
    ,n.ChildStatus
    ,COUNT(n.Interfaces.InterfaceID) AS [InterfaceCount]
FROM Orion.Nodes AS n
GROUP BY n.Caption
    ,n.IP_Address
    ,n.DetailsUrl
    ,n.Status
    ,n.ChildStatus
ORDER BY [InterfaceCount] DESC

Let me know if you have any questions and/or trouble getting this setup!