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
Determine Nodegroup of a Nodeid
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
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