Finding oldest file in an archive.

[htijnar]

hi
I am trying to figure out the oldest file in an archive.
When I try

dsmc retr -pick /directory/path/

I see only archive date.
So, what I tried is restoring all files one-by-one and checking date time stamp on files.

What is confusing me is that

dsmc query archive /directory/path returns 333 files but if I do a

select NODE_NAME,ARCHIVE_DATE,CLASS_NAME,FILESPACE_NAME,D ESCRIPTION from ARCHIVES where NODE_NAME='NODE' ORDER BY ARCHIVE_DATE

and grep by date for date when /directory/path was archived, I get more results.

Is there a way to query oldest file in an archive without restoring the archive?

[smajl]

In GUI you see creation/last modification date