05-08-2012 01:57 PM
I saw someone asked this same question a while back but there was no solution mentioned.
I am wanting to try out some of the Data Analysis reports, when I go into "Data Analysis Reports" and try and run a report in there it is not working. I don't even get the option to select the site name. I have no problems running the Operational Reports.
I saw some articles that mentioned that FSA needs to be enabled, but we don't use that and are not licensed for it. Any ideas how I can get this working?
Solved! Go to Solution.
05-08-2012 11:57 PM
Ah, ok. Well you can use the archive rate report or possible just some sql scripts.
I like to use the following to review customers archiving rates:
--Daily Rate
select "Archived Date" = left (convert (varchar, archiveddate,20),10),"Daily Rate" = count (*),"Size" = sum (itemsize)
from saveset
where archiveddate > dateadd("dd", -30, getdate ())
group by left(convert (varchar, archiveddate,20),10)
order by "Archived Date" Desc
--Monthly Rate
select "Archived Date" = left (convert (varchar, archiveddate,20),7),"Monthly Rate" = count (*),"Size" = sum (itemsize)
from saveset
where archiveddate > dateadd("mm", -12, getdate ())
group by left(convert (varchar, archiveddate,20),7)
order by "Archived Date" Desc
--Yearly Rate
select "Archived Date" = left (convert (varchar, archiveddate,20),4),"Yearly Rate" = count (*),"Size" = sum (itemsize)
from saveset
where archiveddate > dateadd("YY", -3, getdate ())
group by left(convert (varchar, archiveddate,20),4)
order by "Archived Date" Desc
05-08-2012 02:17 PM
well those reports are purely for FSA reporting and report collections, its meant to show file usage on file servers, amount of duplicate data and such, its not for any other kind of archiving (i.e exchange, domino, sharepoint, journaling etc)
05-08-2012 02:26 PM
Ah.. So there are no canned reports availble to look at storage trends for journaled items?
05-08-2012 02:39 PM
What trends are you looking for other than archive rate? You looking for types of attachments and such?
05-08-2012 03:08 PM
We are going to be adding 1500 people to our journal process. Our storage team wants to know how much we capture on average every year so we can use that as a baseline.
05-08-2012 11:57 PM
Ah, ok. Well you can use the archive rate report or possible just some sql scripts.
I like to use the following to review customers archiving rates:
--Daily Rate
select "Archived Date" = left (convert (varchar, archiveddate,20),10),"Daily Rate" = count (*),"Size" = sum (itemsize)
from saveset
where archiveddate > dateadd("dd", -30, getdate ())
group by left(convert (varchar, archiveddate,20),10)
order by "Archived Date" Desc
--Monthly Rate
select "Archived Date" = left (convert (varchar, archiveddate,20),7),"Monthly Rate" = count (*),"Size" = sum (itemsize)
from saveset
where archiveddate > dateadd("mm", -12, getdate ())
group by left(convert (varchar, archiveddate,20),7)
order by "Archived Date" Desc
--Yearly Rate
select "Archived Date" = left (convert (varchar, archiveddate,20),4),"Yearly Rate" = count (*),"Size" = sum (itemsize)
from saveset
where archiveddate > dateadd("YY", -3, getdate ())
group by left(convert (varchar, archiveddate,20),4)
order by "Archived Date" Desc
05-09-2012 03:39 AM
Or you can just view uasge.asp and record the values on a daily basis which over time will provide growth trending. http:\\evsever\enterprisevault\usage.asp.
You can use excel and link to an external data source (URL) to pull the values
05-09-2012 08:50 AM
Thanks Tony - As always....