Amount of data by date

I am looking to see if I can run a simple Live Report on the amount of data added to the External doc store by date. I want start tracking how much content we add by day.

Find more posts tagged with

Comments

eLink User

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

I think something like this might work for you:

select sum(datasize)/1000 from dversdata where vercdate => %1

....where %1 is whatever date system paramater you care to use...

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, November 18, 2002 11:19 AM
To: eLink Recipient
Subject: Amount of data by date

Amount of data by date Posted by PfizerDevTeam (Developers, Pfizer) on 11/18/2002 12:01 PM

I am looking to see if I can run a simple Live Report on the amount of data added to the External doc store by date. I want start tracking how much content we add by day.

Siegbert_Fries_(siemensicnuser13_-_(deleted))

I think this report could fit:select to_char(vercdate,'YYYY.MM.DD')"Day", count(*) "Count", avg(datasize)/1024 "AvgFileSize KB", sum(datasize)/1048576 "TotalFileSize MByte" from DVersData group by to_char(vercdate,'YYYY.MM.DD') order by to_char(vercdate,'YYYY.MM.DD') descIt will list the counted files, average and total filesize that are stored on a daily basis in descending order. MByte means 1024 KBytes. But keep in mind, that files that were deleted meanwhile are not recognized

Pfizer_Developers

Thats an awesome report! It provided the exact results I was looking for. Thanks for the assistance.