Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 918
  • Last Modified:

How to get the user activity on a database for a long period?

is there any way to get the user activity on a database for a period of say 6 or 7 months  along with the username and the time of access ? i believe the useractivity tab on the database properties cannot hold the details pertaining to a period of 6 months... is there any other log file or something where this detail would be available? or is there any way to gather this information?

thanx in advance

@nu
0
anu_sha
Asked:
anu_sha
1 Solution
 
madheeswarCommented:
u can look at log.nsf

It holds all the info
0
 
CRAKCommented:
Log.nsf is usually set to delete docs after a few days (7 or 10).
You may need to alter some settings to monitor over 6 or 7 months, or e.g. create a (local?) replica: replicate only FROM the server (not "to") and do not replicate deletions.

This is for notes, right? Not for web access?
0
 
Bozzie4Commented:
Actually, on R6, you don't need to augment the log retention time to get activity data, if you enable activitly logging, so is it R6 or R5 ?

cheers,

Tom
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
anu_shaAuthor Commented:
It is R5... and does the user activity get logged automatically or should any setting be explicitly enabled?

cheers
@nu
0
 
Bozzie4Commented:
On R5, depending on what you want, you don't need to increase the retention time either.

Check the views Database/Usage Activity documents.  They do contain number of uses per database, but not who did what.  If you want that information, it is stored in the database (File/Database/Properties/'I' - User Detail)

To have that information in the log.nsf, you'll need to increase the log retention time:  it's done in Notes.ini :
Log=LOG.nsf,1,0,31,40000

for instance, for 31 days, and documents that are 40000 bytes (I think) big.

cheers,

Tom
0
 
Bozzie4Commented:
And yes, the 40000 in the above example means size of the log document (for Miscellaneous for example) in bytes (appr.)

Tom
0
 
qwaleteeCommented:
The user activity log can hold years and years of data -- or only one day worth.  It isn't limited by the number of entries.  It just holds a maximum, I think, of 64k worth of log data.  So, if the database has frequent usage, you will get limited info.  If the database has infrequent usage, you could get that far back.

On ething you could do if it only holds a month or two of data is to gather the info weekly, and do a marge of the new and old adat (because there will have to be overlap -- if there isn't overlap, that means you are losing data).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now