NCM Custom SWQL Query

carlowen‌

NCM should have this as a default report already.

However, here is the SWQL used within that default report.

SELECT DISTINCT
CASE
  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.Icon


FROM Cirrus.NodeProperties AS NCMNodeProperties
JOIN Orion.Nodes AS Orion ON Orion.NodeID=NCMNodeProperties.CoreNodeId
JOIN Orion.NodesCustomProperties AS OrionCustomProperties ON Orion.NodeId= OrionCustomProperties.NodeId
INNER JOIN Orion.Vendors AS OrionVendors ON Orion.Vendor=OrionVendors.Name
LEFT JOIN (SELECT NodeID FROM Cirrus.ConfigArchive) AS ConfigTable ON NCMNodeProperties.NodeID=ConfigTable.NodeID
ORDER 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'.

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?

Thank you,

-Will

carlowen‌ Were you able to get this SWQL query to provide what you needed?

Thank you,

-Will

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