It is currently 23 Jun 2018 7:59


Post new topic  Reply to topic  [ 2 posts ] 
Author Message
PostPosted: 14 Dec 2010 2:39 
Offline
Nouveau
Nouveau
User avatar

Joined: 02 Sep 2010 12:00
Posts: 3
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


Top
   
 Post subject:
PostPosted: 15 Dec 2010 7:38 
Offline
Nouveau
Nouveau
User avatar

Joined: 29 Oct 2007 12:00
Posts: 67
Location: Chennai
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


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 2 posts ] 

All times are UTC+02:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved