03-26-2015 06:22 AM
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.
Solved! Go to Solution.
03-26-2015 07:21 AM
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)
03-26-2015 07:21 AM
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)
03-26-2015 07:56 AM
Great thank you. I was off in a different direction using views.
03-26-2015 08:34 AM
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)
03-26-2015 08:37 AM
Looks right, yep.
03-26-2015 08:54 AM
Great thanks very much!
03-26-2015 08:57 AM
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 :)