Avamar grid - Howto determine still stored data marked with "No End Date"

Hello folks,

I just have viewuser permissions only, to query the mcs database directly and in parallel I can use DPA as well. Being not able to execute mccli commands.

For billing reasons we have to check backups marked with "No End Date" too (currently I couldn't get an answer for that on demand backups without a defined retention period). When I query the mcs database for example the last year, I get a lot of records with "No End Date" returned, but understood as well, that an adminstrator is able to delete them manually.

So my question is:

Is there an existing flag, column in a view or whatever available, which could give me a hint that these are still in used dedup volumes or it is just a historical entry in the database and the real data are already removed by the administrator?

In other words: How can I determine the used deduped data amounts still on on the Avamar storage for records marked with "No End Date"?

Many thanks in advance to all the gurus out there.