How to list the files on a tape with their backup dates/times?

[ldmwndletsm]

Can anyone provide me with a query to list the contents of a volume and include the backup dates/times for each file?

A `q content volume`, with or without format=detailed, would give me the NODE_NAME, Filespace Name, 'Client's Name for File' and FSID but no backup date. From the second and third fields, I could construct the values for HL_NAME and LL_NAME, and I could then do a query on the backups table for the matching NODE_NAME, HL_NAME, LL_NAME and FILESPACE_ID and then get the BACKUP_DATE ... maybe???

BUT:

1. How do I know that the matching entry in the backups table corresponds to the entry in the `q content volume`? It might not be the correct one even though the FILESPACE_ID, HL and LL_ NAME matches, right? There could be different versions of the file on different volumes.

2. Even if this works, this seems ridiculous. There must be a faster and more efficient way to do this?

 

[marclant]

Join the CONTENTS and the BACKUPS table on the OBJECT_ID field, that will ensure it's the same object.