Well, since you asked for "any suggestions"...

It seems to me you could get this report using a command like 

select archive_date,filespace_name from archives a,file_name from contents c 
where archive_date >= current_timestamp - 1 days and  a.node_name = c.node_name 
and a.filespace_name = c.filespace_name

or 

select backup_date,filespace_name from backups b,file_name from contents c 
where backup_date >= current_timestamp - 1 days and  b.node_name = c.node_name 
and b.filespace_name = c.filespace_name

However, I haven't tested these commands, and I'm not about to.   
On our system, any such command would run forever and probably die before it 
completed.
I have long since given up trying to use select statements using either the 
contents or backups tables, they are way too big.
If this report is not produced regularly, maybe it's because your predecessor 
gave up too!

P.S.  HL_NAME and LL_NAME  are not what you need... those are the IP address 
and port number for a client.

- Margaret

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Geoff Gill
Sent: Thursday, July 12, 2012 9:13 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [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