enterprise vault sql query to find unsecured items in each partition
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.
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
*/
