enterprise vault sql query to find unsecured items in each partition

[GulzarShaikhAUS]

Hi,

Can someone help me in getting the sql query to find out unsecured items in each vault partition. We have close to 150 paritions and I can see shared unsecured items waiting to get cleared from watch file.

Thanks in advance.

[Manideep_Neeli · Accepted solution]

use <EVVSDB>
select DB.PartitionName, COUNT(*) as Items_Unsecured from <EVVSDB>.dbo.WatchFile VS
inner join <EVDD>.dbo.PartitionEntry DB
on VS.IdPartition = DB.IdPartition
where
VS.ItemSecured=0
group by
db.PartitionName

/*
where <EVDD> is Enterprise Vault Directory database name
and
<EVVSDB> is Enterprise Vault Vault Store Database name
*/
 

[GulzarShaikhAUS]

Thanks mate though there is no table called db.PatitionName in 10.0.4.

 I had to work on PartitionID but still it gave me expected results.

thanks