Default Report "Ip Addresses on each Interface", some switches have no interfaces

Question

I'm just trying to run this report to see the ip addresses on the switches to make a clean excel doc. A large amount of the switches only show the name but nothing under them. While others have all interfaces. I compared switched "Edit Node" page but they are identical. The switches that show nothing in the report also show all their interfaces and ip's on their summary page.

Any help is greatly appreciated.

yaquaholic · Accepted Answer

Hello Daisyahoy,

Looking at the report's SWQL you can see the query is (cleaned up a little):

SELECT [data].[DisplayName] AS [DisplayName], 
              [data].[InstanceSiteId] AS [InstanceSiteId] FROM orion.nodes AS data 
WHERE [data].[NodeProperties].[NodeID] IS NOT NULL 
AND [data].[NodeProperties].[Interfaces].[IpAddresses].[IPAddress] IS NOT NULL 
WITH NOLOCK

Picking this apart using the SWQL Studio, I found that the NodeProperties is an NCM based table, and that the data].[NodeProperties].[Interfaces].[IpAddresses].[IPAddress] is actually pointing to the NCM.Interfaces SWQL table, not an NPM one.  
And my table is also devoid of any interface information, despite having all of our switches in NCM. 
After a bit of head scratching and a search on Thwack it turns out that you need the "Nightly Network Inventory" Job enabled and run to populate the NCM.Interfaces table.So, running the NCM Job called  "Nightly Network Inventory" should sort you problem.

Rich