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@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: Friday, October 03, 2014 10:40 AM To: ADSM-L@VM.MARIST.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@VM.MARIST.EDU] On Behalf Of Schneider, Jim Sent: Friday, October 03, 2014 11:29 AM To: ADSM-L@VM.MARIST.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.
