The query below is giving me the data about the management classes defined in the domains with a retention over 5 yrs. This information is right. But it need not necessarily mean that if an MC is defined in a domain its being used by a node.
I think i am confusing people here. I shall try to put it in simple terms 1. I have 150 clients, say 50 NT Client, 50 UNIX Clients and 50 VMS Clients 2. I have been doing archives and backups on these clients. 3. There are 3 domains namely NT_DOMAIN, UNIX_DOMAIN and VMS_DOMAIN. All the 50 NT clients are defined in NT_DOMAIN, 50 Unix clients in UNIX_DOMAIN and 50 VMS Clients in VMS_DOMAIN. 4. Each of the 3 active policy domains mentioned above has multiple management classes in addition to the DEFAULT_MC. Each of these active policy domains has MCs with retentions like 1yr, 2yr, 3yr and 5yrs while the DEFAULT_MC has a retention period of 180 days. 5. Many of the NT, UNIX, and VMS clients backup/archive data. For example a UNIX node might backup the data using DEFAULT_MC (180 days retention) and the same node for some filesystems might apply a retention period of 5yrs (this is done using include/exclude). Now coming to my question How do i find out which are the nodes in NT, VMS and UNIX domains that have actually data backed up using management class using retention of 5yrs. The query given below (by seay) is looking at the policy domains to determine this. But some times there might be a situation where a 5yr MC might be defined in the policy domain but it might not be used by some nodes. I would appreciate your help in answering this. Thanks again Mobeen -----Original Message----- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 3:12 PM To: [EMAIL PROTECTED] Subject: Re: Querying Client's Management Class 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]
