SQL Query to find EV archives that do not have permissions

[Rajesh_Velaga1]

SQL Query to find EV archives that do not have permissions

[Wayne_Humphrey · Accepted solution]

Every Archive will have permissions.

 SELECT TOP 1000 
      [ArchiveName],
      [SID],
      [OwningTrusteeIdentity],
      [AutoSecurityDesc],
      [ManualSecurityDesc]
FROM [EnterpriseVaultDirectory].[dbo].[ArchiveView]