select node_name, domain_name from nodes where domain_name in (select domain_name from bu_copygroups where integer(retextra) >365*4 and retextra <>'NOLIMIT' or retextra = 'NOLIMIT' or integer(verexists) >365*4 and verexists <>'NOLIMIT')
This looks at all the management classes in a domain and plays some games. You need to verify that it works correctly. What it does is selects the domains with management classes that meet the criteria and matches against the node definitions to give you a list. -----Original Message----- From: mobeenm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 1:14 AM To: [EMAIL PROTECTED] Subject: Re: Querying Client's Management Class I would like to know the nodes using a particular management class. I have about 150 clients belonging to NT_DOMAIN, UNIX_DOMAIN and VMS_DOMAIN. Now i would like to know which of these clients is backing up data with a retention of more than say 4yrs? Is there any way to do this. A dumb way to do this is probably go to each client node and check its include/exclude/dsm.sys to find out the retention. But what i would like to do is, run a query to find out all the filespaces on a node that have a retention of greater than 4yrs and i would like to do this to all the nodes in the 3 domains mentioned above. Thanks Mobeen -----Original Message----- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:47 AM To: [EMAIL PROTECTED] Subject: Re: Querying Client's Management Class You realize that a management class is part of policy set and that you can set which management class is the default management class. So, what is your real question, do you want to know which is the default management class for each node or every management class in the active policy set for the domain. Do you want the active policy set or every policy set? I will not say this can be done, but your question is not clear enough. Unfortunately, it does not appear that inner join is supported. -----Original Message----- From: mobeenm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 8:21 PM To: [EMAIL PROTECTED] Subject: Querying Client's Management Class Hello TSMers, I want to find out all the clients registered on my TSM for their management classes. Is there a query that i can do? Appreciate your response. Regards Mobeen [EMAIL PROTECTED]
