So, I've been cobbling together a few SQL queries lately that help get large amounts of information from EV. I figured I'd provide one of these to everyone. As I post these queries I will also provide the information it gathers below so people know what they are looking at. I hope these queries are as helpful to others as they have been for me.
(Note: As we cannot take into consideration every environment, please run these queries with caution as they MAY cause performance issues while being run)
-- Start Query
-- Prerequisite : Must be run on SQL instance with EnterpriseVaultDirectory DB
USE EnterpriseVaultDirectory
SELECT Distinct
CASE WHEN AV.archivename IS NULL THEN '--Folder' ELSE AV.archivename END AS 'ArchiveName/Folder?'
,CASE WHEN AV.Type = '5' THEN 'Shared'
WHEN AV....