Determine Nodegroup of a Nodeid

remfleyf · Post by **remfleyf** » 14 Dec 2010 2:39

Hi everyone !

I am searching a query or something else that can tell me the nodegroup who belong to a nodeid.

The ctm_menu can list me all the nodeid who are in a nodegroup but I want all the opposite.

Thank you for your help

rchkevin · Post by **rchkevin** » 15 Dec 2010 7:38

Try this query. This should give you nodeid and node group name. This is query is for CTM 6.4 ver schema. Change the query if you are using a diff version of CTM. CTMUSER is the CTM USER ID

SELECT DISTINCT CMS_NODGRP.GRPNAME, CMS_NODGRP.NODEID
FROM CTMUSER.CMR_NODES CMR_NODES, CTMUSER.CMS_AGPRM CMS_AGPRM, CTMUSER.CMS_APPGRP CMS_APPGRP, CTMUSER.CMS_NODGRP CMS_NODGRP, CTMUSER.CMS_NODID CMS_NODID