cancel
Showing results for 
Search instead for 
Did you mean: 

Data Analysis Reports Issue

Andrew_Tankersl
Level 6

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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

View solution in original post

7 REPLIES 7

JesusWept3
Level 6
Partner Accredited Certified

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)

https://www.linkedin.com/in/alex-allen-turl-07370146

Andrew_Tankersl
Level 6

Ah.. So there are no canned reports availble to look at storage trends for journaled items?

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

What trends are you looking for other than archive rate?  You looking for types of attachments and such?

Andrew_Tankersl
Level 6

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.

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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

Percy_Vere
Level 6
Employee Accredited

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

 

Andrew_Tankersl
Level 6

Thanks Tony - As always....