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:[email protected]] On Behalf Of Geoff Gill Sent: Thursday, July 12, 2012 9:13 AM To: [email protected] 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
