I was wondering what is the best way to find all clients on the grid that do not belong to a group. I'm having problems keeping up with what clients belong to a group and which dont. I have around 1300 clients imported to 10 centers right now and I cant seem to keep a handle on what clients are already in a group.
Have you tried the Client manager interface through Enterprise manager ? This easily allows you to move clients and relocate them.
When you say do not belong, do you mean default group ? If so Client Manager should do the trick but you can also use policy manager in the Avamar Admin console.
When I say do not belong I mean after I imported the vCenters in to the grid I created groups then added clients to them. After a month or so new vm's were spun up and people began to utilize "import multiple clients" from the administrator without assigning them to a group. It is these clients that I need to get a handle on.
Thanks for the reply!
I use an xls spreadsheet with a pivot table and a connection to the Avamar MCS database for this exact purpose. We also have our VM's split between Optimised and Standard for retention so it shows me which VM's are in which group, which are in both (don't wnat that but can happen sometimes) and also which are only in the 'Default' group (ie not in any active group.
I only do this for a single vCenter in our main data center with 250 - 300 VM's but it should help with what you want to do.
Before I used the pivot table with live DB connection I used to just export the groups from the DB using the Postgre SQL Admin client and run vlookup - this is fine if you do this infrequently but if it's a regular process then the live connection to the pivot table is better.
You need the Postgre SQL admin installed (I have 9.1) then you can connect to your MCS DB using these details:
Host: 'your Avamar node/grid name'
Maint DB: mcdb
The viewuser, as the name suggests, is only able to view the DB so it won't allow you to mess up the tables.
The details for the connection to our pivot table spreadsheet are:
SQL query / command
SELECT v_group_members.group_name, v_group_members.enabled, v_group_members.client_name, v_group_members.cid, v_group_members.dataset_name, v_group_members.retention_name, v_group_members.use_client_ds, v_group_members.use_client_rp, v_group_members.use_client_timeout, v_group_members.use_client_retry, v_group_members.restore_only, v_group_members.domain, v_group_members.full_client_name
FROM public.v_group_members v_group_members, public.v_group_members v_group_members_1
WHERE v_group_members.client_name = v_group_members_1.client_name AND ((v_group_members_1.group_name='Default Virtual Machine Group'))
if the clients are not backed up, but registered in Avamar maybe you can use the standard report "Clients - Unprotected" in the Avamar report section. this gives you an overview of clients that aren't protected.