cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

Is there any way to list device template choice for all nodes?

I want to know which nodes have "Device Template" not set to "Auto Determine"

Is there any way to list, search, or report on the Device Template setting for all nodes?

Node Details/Edit Node/Manage node(s) with NCM -> Yes

Node Details/Edit Node/CLI Device Template/Device Template Dropdown

Labels (1)
Tags (1)
0 Kudos
1 Reply

sfreemire

Try this SWQL query, and see if it looks like it will work for you.

SELECT
ncm.CoreNodeID
--,CASE
--    WHEN dtn.TemplateID IS NULL THEN 'AUTO'
--    ELSE TOSTRING(dtn.TemplateID)
END AS DeviceTemplate
,ncm.EngineID
,ncm.NodeCaption
,ncm.SystemOID
FROM NCM.Nodes AS ncm
LEFT JOIN Cli.DeviceTemplatesNodes AS dtn ON dtn.NodeId=ncm.CoreNodeID

WHERE dtn.TemplateID IS NOT NULL

Take out the WHERE clause (and remove the comments from the CASE statement) and see them all.

The WHERE clause with "IS NOT NULL" should show you the nodes which are currently using device templates.

The WHERE clause with the "IS NULL" should show you the nodes which are "auto" choosing the device templates.

I thought this was a default report, but I might be thinking of the connection profiles.


Either way, test it out and see if the results look like what you would expect.

Thank you,

-Will

0 Kudos