Hello, can someone advise me if it is possible to create a NCM Custom SWQL Query to tell me the NCM node status = "Not Backed Up"
carlowen
NCM should have this as a default report already.
However, here is the SWQL used within that default report.
SELECT DISTINCTCASE WHEN ConfigTable.NodeID IS NOT NULL THEN 'backedUp' ELSE 'notBackedUp'END AS NCMNodeStatus,Orion.NodeID AS CoreNodeID,Orion.Caption,ConfigTable.NodeID,Orion.IPAddress,Orion.DetailsUrl,Orion.ChildStatus,Orion.Vendor,Orion.Status,Orion.Icon,OrionVendors.IconFROM Cirrus.NodeProperties AS NCMNodePropertiesJOIN Orion.Nodes AS Orion ON Orion.NodeID=NCMNodeProperties.CoreNodeIdJOIN Orion.NodesCustomProperties AS OrionCustomProperties ON Orion.NodeId= OrionCustomProperties.NodeIdINNER JOIN Orion.Vendors AS OrionVendors ON Orion.Vendor=OrionVendors.NameLEFT JOIN (SELECT NodeID FROM Cirrus.ConfigArchive) AS ConfigTable ON NCMNodeProperties.NodeID=ConfigTable.NodeIDORDER BY Orion.Caption ASC
This will show you a list of all NCM devices, and whether they have been backed up or not.
I hope this helps.
Thank you,
-Will
Hi Will,
Cirrus.NodeProperties not found while executing query.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Cirrus.NodeProperties'.
--Jatin
jatin31
What version of NCM are you using?
Also, where are you running this query, SDK?
carlowen Were you able to get this SWQL query to provide what you needed?
wluther,
I was executing it directly into Database manager. Finally It worked successfully into report editor.
I need a query for getting configuration change time stamp into report.
Thx
Jatin
