Wanda and David,

Thank you both.  This gives me exactly the information I was looking for.  I 
think I need to learn (more) SQL.

Thank you again,
Jim

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Prather, Wanda
Sent: Friday, October 03, 2014 10:40 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Counting VMs

There are "reports" in the TSM/VE plug in that will show you that stuff.
But if you want to create your own reports, simple way is to use the timestamp 
on the filespace:

Backup status of all your VM's in TSM/VE, order by name (1) or timestamp(3) as 
you want :

select substr(filespace_name,9,18) as VM, filespace_id as FSID, cast(backup_end 
as char(19) )  - as "Backup Completed" from filespaces where 
node_name='VEDATAOWNERNAME'  - order by 1


Another way, all VM's that haven't backed up in the last 30 hours:

select substr(filespace_name,9,16) as VM,  - cast(backup_end as char(19) ) as 
"Backup Completed" -
 from filespaces where node_name='VEDATAOWNERNAME'   and -
timestampdiff(8,cast( (current_timestamp-backup_end) as char(22)))>30 - order 
by 2

This will *not* tell you if you have any VM's that have never backed up, i.e. 
never had a filespace created.
For that you have to go to the VE Reports page or talk directly to VCenter.

 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Schneider, Jim
Sent: Friday, October 03, 2014 11:29 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Counting VMs

I have not found an easy way to find out which VMs are backed up.  My 
workaround is 'q occ' for the datamover node and specify the stgpool (to 
exclude the CNTL data, and remove duplicates), and count the lines.  The 
filespace name has the VM name.  Does anyone have a better method?  I currently 
back up 19 VMs on 2 TSM servers but the number is about to increase 
dramatically, and somebody thinks I should keep track of these things.

Any help would be appreciated.

Thank you,
Jim Schneider

**********************************************************************
Information contained in this e-mail message and in any attachments thereto is 
confidential. If you are not the intended recipient, please destroy this 
message, delete any copies held on your systems, notify the sender immediately, 
and refrain from using or disclosing all or any part of its content to any 
other person.