Sort nodes by Connection Profile

bluefunelemental

I would like to be able to sort my NCM nodes by the connection profile since I might need to update all of say one profile to a new one. Today I cannot see an easy way to do this in the GUI wither in the NCM node list (node tree), configuration management view, nor the core node management view. 

bluefunelemental

Just a note - I have not upgraded yet to 7.3.2 but found a work around I quite like anyway.

I just let my discoveries add the nodes and allow it to pick the best connection profile. Then I have a SQL agent job that copies the connection profile name into the Node Group field. This way I can effectively sort by Node Connection profile and it's easier.

Apologies if anyone else already posted the same.

update n

  SET n.nodegroup = c.name

  FROM [Orion].[dbo].[NCM_NodeProperties] n

  LEFT OUTER JOIN Orion.dbo.NCM_ConnectionProfiles c on c.id=n.connectionprofile

WHERE n.connectionprofile > 0

  ;