Reporting - List of files to be removed by storage expiry

[vanadasd]

Hello Everyone!

We are doing file archiving and we're about to start using storage expiry for the first time.  Is there a report or SQL query available to list all of the files that will be removed when storage expiry runs? We are using retention categories based on the modified date.

Thank you!

[AndrewB · Accepted solution]

yes, check out this thread for examples

https://www.veritas.com/community/forums/measuring-throughput-storage-expiry

[vanadasd]

Thanks for your help!

I pieced a bunch of posts together (including the one AndrewB provided) and I was able to create a SQL script that will list every file that will be expired on a certain date.

I will post my findings tomorrow in case anybody finds it helpful.