Geoff,

I agree with Erwann, it looks like the backup table.
Minus the date, you can get similar results from a "query content" command 
against any/all tape volumes.
Otherwise, don't be too afraid of querying the backups table, but it will 
probably take a long time. You should send output to a file:
        dsmadmc id=<user> pass=<password> -outfile=./myoutputfile.txt -tab 
select * from backups
(This is a very heavy, long running query... but I've done it.)

best regards,
Michael






-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT vm.marist DOT edu] On Behalf Of 
Erwann Simon
Sent: Thursday, July 12, 2012 12:31 PM
To: ADSM-L AT vm.marist DOT edu
Subject: Re: [ADSM-L] Select or Query help

Hi Geoff,

These columns are from the backups table, wich is to be queried with caution.

Columns are (something like) backup_date, filespace_name, hl_name and ll_name.

Regards,
Erwann

----- Mail original -----
De: "Geoff Gill" <avalnche96 AT YAHOO DOT COM>
À: ADSM-L AT VM.MARIST DOT EDU
Envoyé: Jeudi 12 Juillet 2012 18:13:12
Objet: [ADSM-L] Select or Query help

Good day all,

Below is a section of a file I was sent. I'm told the person who did this is 
long gone and nobody knows what command he used to get it. I was hoping someone 
might recognize it and help recreate it since I'm not sure we'll even be able 
to contact that person for help.

There are no headers for the columns but they seem obvious. You can see from 
the output the date, file://server/drive, file\path and filename. The filename 
and data in the file seems to indicate that this command is run to output one 
specific dates worth of data of every file a specific node backed up.

If anyone has any siggestions I would be eternally grateful because I'm being 
hammered to get an answer so I can run it and get the data.

      2011-10-17         \\bpsnt91\c$     \DOCUMENTS AND         NTUSER.DAT
02:36:24.000000                          SETTINGS\AFSADEV\
      2011-10-17         \\bpsnt91\c$     \DOCUMENTS AND         NTUSER.DAT.LOG
02:36:24.000000                          SETTINGS\AFSADEV\

     2011-10-17         \\bpsnt91\c$     \DOCUMENTS AND         NTUSER.INI
02:36:24.000000                          SETTINGS\AFSADEV\
Thank You
Geoff Gill

This message and any attachments are solely for the use of intended recipients. 
The information contained herein may include trade secrets, protected health or 
personal information, privileged or otherwise confidential information. 
Unauthorized review, forwarding, printing, copying, distributing, or using such 
information is strictly prohibited and may be unlawful. If you are not an 
intended recipient, you are hereby notified that you received this email in 
error, and that any review, dissemination, distribution or copying of this 
email and any attachment is strictly prohibited. If you have received this 
email in error, please contact the sender and delete the message and any 
attachment from your system. Thank you for your cooperation