I am found a couple TDP SQL nodes that aren't inactivating there backups so TSM
isn't expiring them...
What I am trying to find is the oldest backup date for each server with a name
like _TDP.
I can get this:
Node Name HL_NAME
BACKUP DATE STATE
---------------------
------------------------------------------------------------- ------------
--------------
XYZ_TDP //
2009-08-17 ACTIVE_VERSION
XYZ_TDP //
2009-09-13 ACTIVE_VERSION
XYZ_TDP //
2009-09-14 ACTIVE_VERSION
XYZ_TDP //
2009-09-15 ACTIVE_VERSION
XYZ_TDP //
2009-09-16 ACTIVE_VERSION
What I really want is something like this:
Node Name HL_NAME
BACKUP DATE STATE
---------------------
------------------------------------------------------------- ------------
--------------
XYZ_TDP //
2009-08-17 ACTIVE_VERSION
ABC_TDP //
2009-09-13 ACTIVE_VERSION
123_TDP //
2009-09-14 ACTIVE_VERSION
Is this possible ?
Thanks,
Bruce Kamp
TSM Administrator
(817) 568-7331
