Backup Central

We are in the final stages of a build out and I was given a question today that I was uncertain how to answer. We have several locations and have made groups by location code, the further separated them into windows, unix, DBA, and a few other groups. This was done for security purposes.

The question I was asked is if there is a way to see if a system is not put in a group. A report possibly that could list out systems that are not in any group. Is that possible?

The issue is there are so many systems and the groups are becoming muddled so people don't know if the system is in the proper group.

Thanks.


__._,_.___
Reply to sender ([email]jconnell < at > columbus.rr.com?subject=Re%3A%20Using%20groups%20and%20managing%20groups%20question[/email]) | Reply to group ([email]commvault < at > yahoogroups.com?subject=Re%3A%20Using%20groups%20and%20managing%20groups%20question[/email]) | Reply via web post | Start a New Topic
Messages in this topic (1)
Recent Activity:

• New Members 6

Visit Your Group

Commvault Documentation here:
http://documentation.commvault.com/
Text-Only ([email]commvault-traditional < at > yahoogroups.com?subject=Change Delivery Format: Traditional[/email]), Daily Digest ([email]commvault-digest < at > yahoogroups.com?subject=Email Delivery: Digest[/email]) &bull; Unsubscribe ([email]commvault-unsubscribe < at > yahoogroups.com?subject=Unsubscribe[/email]) &bull; Terms of Use




.

[img]http://geo.yahoo.com/serv?s=97359714/grpId=7450851/grpspId=1707277520/msgId=4871/stime=1300386460/nc1=4507179/nc2=4025373/nc3=5191954[/img]
__,_._,___

Run this SQL Query will list the clients which have no group assigned. If you comment out the "where" statement you will get a list of all clients and their assigned groups.

use CommServ
SELECT c.name as Client,cg.name as "Group"
From APP_Client c
LEFT JOIN APP_ClientGroupAssoc cga on cga.clientId = c.id
LEFT JOIN APP_ClientGroup cg on cg.id = cga.clientGroupId
where cg.name IS NULL
order by c.name,"Group"