sandrine_goetha
7 years agoLevel 6
reporting billing account and youngest item
Hello, I know how to find out in the reports which billing account is applied on the archive. I also know still in the reports how to find the youngest archived item. What I would like to do i to ...
- 7 years ago
Sandrine,
The info you want is in the ArchiveView view and IndexVolume table. You can join them on RootIdentity like this:
SELECT ArchiveName , VaultEntryId AS ArchiveId , SID AS BillingAccount , OldestItemDateUTC , YoungestItemDateUTC , OldestArchivedDateUTC , YoungestArchivedDateUTC FROM ArchiveView JOIN IndexVolume ON IndexVolume.RootIdentity = ArchiveView.RootIdentity
Example results:
(I included all the Oldest and Youngest dates but obviously you can cut out what you don't need.)
Since the Billing Account is only stored as a SID in SQL, you would need to run an AD lookup to convert that to a more legible username. I have attached a PS function that does this.
Example results:
Hope that helps!
--Chris