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
If all you want is a count of VMs that have a backup, this should work:
select count(*) from filespaces where node_name='NODEOFVMEBACKUPNODE'
-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
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)
