TOC question

[influx]

Does anyone know a quick way to gather TOC information from a netapp backup. Is there a table I can run a select against? or do I have to go thru the nasbackups and q toc for the specific creationd and creationt? Thanks.

 

[tsm_dude]

I use the web client and log in to a normal tsm client using the admin account. I can then see the NAS node and expand all the backup files etc, select PIT, see what date the backup was taken etc. I never tried the restore node from the server as this way works ok.

 

[influx]

I need the TOC info. Specifically size.

 

[bully]

Only via Q toc.
for example.
query toc netapp /vol/vol1 creationdate=12/06/2002
creationtime=11:22:46 format=detailed

 

[yampam]

Try that select :
select NODE_NAME,FILESPACE_NAME,STATE,TYPE,LL_NAME,BACKUP_DATE from backups where type='TOC' and backup_date>current_timestamp -1 days

Yam