We are currently moving our servers from NT 4.0 to Win2K. As I monitored the
backup of our first initial Win2K servers, I noticed the System Object
filespace did not display a "Last Backup Completion Date/Time" on the TSM
server. I was able to see successful completion of the System Objects in the
client's log, but it always made me nervous that I could not see the dates
on the server. I checked the list server and noticed other people were
having the same problems and concerns. I placed a call with TSM and they
came up with the following script:

select distinct backup_date from backups where node_name='NODENAME' and
filespace_name='SYSTEM OBJECT'

Keep in mind that the node name is case sensitive. It's not the most
automated solution, but at least you can verify the TSM knows when the
System Objects are backed-up. If anyone has a better solution or sees a
problem with this one, please let me know.

Thanks.

Kyle Kinzer
Fairfax County Government