How to create a report with a list of users who currently have data archived.
We have a tool called QVMAUSRS EXEC that will give you a list of users who have ever archived a file.
It creates an output file called LISTOF VMAUSRS which lists each user who has current archived data or has ever had any. Once you have the output file, it may be a good idea to break it up into sections or user IDs so you can issue a VMARCH QUERY FILES command against that particular list of users. You may even find users that no longer have data.
Your QUERY command will be something like this: VMARCH Q FILES * * (OWNER xxxx SOURCE *
QVMAUSRS EXEC is attached to this Knowledge Document