cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Query: Number of items in Vault Store not on legal hold by year.

jprknight
Level 3

Hi all,

Today I am trying to work on selecting the number of savesets in a Vault store database grouped by year.

Has anyone done this before or have any pointers on it?

Thanks,

Jeremy.

1 ACCEPTED SOLUTION

Accepted Solutions

Rob_Wilcox1
Level 6
Partner

This should help:

 

select year(s.ArchivedDate) as 'year',
    COUNT(s.SavesetIdentity) 
from saveset s    
where s.SavesetIdentity not in (select SavesetIdentity from HoldSaveset where holdsaveset.savesetidentity = s.SavesetIdentity)
group by year(s.ArchivedDate)

Working for cloudficient.com

View solution in original post

6 REPLIES 6

Rob_Wilcox1
Level 6
Partner

This should help:

 

select year(s.ArchivedDate) as 'year',
    COUNT(s.SavesetIdentity) 
from saveset s    
where s.SavesetIdentity not in (select SavesetIdentity from HoldSaveset where holdsaveset.savesetidentity = s.SavesetIdentity)
group by year(s.ArchivedDate)

Working for cloudficient.com

jprknight
Level 3

Great thank you. I was off in a different direction using views.

jprknight
Level 3

Does the same query for those on legal hold look like this?

select year(s.ArchivedDate) as 'year',
    COUNT(s.SavesetIdentity) 
from saveset s    
where s.SavesetIdentity in (select SavesetIdentity from HoldSaveset where holdsaveset.savesetidentity = s.SavesetIdentity)
group by year(s.ArchivedDate)

Rob_Wilcox1
Level 6
Partner

Looks right, yep.

Working for cloudficient.com

jprknight
Level 3

Great thanks very much!

Rob_Wilcox1
Level 6
Partner

Just one thing.  Do not tell anyone I helped you with SQL ...  I tell everone I know nothing about it ..  It makes life more peaceful.   Ooopps I just posted it on the interwebz :)

 

Working for cloudficient.com