Usage reports- Download Upload (MBs) by location

Livelink9.7.1

Hi,

I have to collect Usage reports e.g. Download Upload (MBs) by location (we have offices in different countries). How can we do that?

Best regards,

Baber.

Find more posts tagged with

Comments

Colin_Schmidt

If you record in the User Profile, the location, that would help a great deal. To report the operations you're after, they have to be set on in the audit interests. If they're not on, turning them on is not retroactive....only from that point on.

If you don't have the location recorded in the User profile, do you have a location-related word in any of the Group membership names? I use this because it's the only reliable avenue I have. You may have to resort to that approach. TimeZone probably wouldn't work or be reliable either. A possible obscure field (Title) might help, but they're typically exact and limited and have nothing to do with the site, but each company has their "way".

The data itself and its attributes may present an option for location.

Colin J.

On Tue, Feb 4, 2014 at 1:47 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Usage reports- Download Upload (MBs) by location Posted bybaber.amin@dolphinenergy.com (Amin, Baber)On 02-04-2014 01:43

Livelink9.7.1 Hi, I have to collect Usage reports e.g. Download Upload (MBs) by location (we have offices in different countries). How can we do that? Best regards, Baber.
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.

Baber_Amin

Hi,

I have created report which is based on user profile parameter officelocation but to be honest I think there should be some kind of tracking based on IP format. To count logins I was able to do counting based on IP format.

My report is as below:

select DISTINCT da.dataid, dv.filename, dv.filecdate, da.auditdate,dv.datasize/(1024*1024) "File Size MBs", (select name from kuaf where id=PERFORMERID) "User",

(select officelocation from kuaf where id=PERFORMERID) "Officelocation"

from dauditnew da, dversdata dv

where

(

(select upper(officelocation) from kuaf where id=PERFORMERID) like upper('%ABC%')

OR (select upper(officelocation) from kuaf where id=PERFORMERID) like upper('%XYZ%')

)

and auditstr in ('Fetch', 'View') and (auditdate>='01-JAN-2014' and auditdate<='01-FEB-2014')

and da.dataid=dv.docid and da.value1=dv.versionname

order by dv.datasize/(1024*1024) desc;

Best regards,

Baber Amin.