Hello,I’m researching how I can consolidate database usage across multiple domino servers. All of our servers are logging activity to the Activity Trends database (activity.nsf). Does anyone have an easy way to consolidate all activty trends info so that all of the info can be access within a single database for better visability into overall usage of Domino databases?
Subject: Re: Activity Trends - How To Consolidate Activity.nsf across multiple servers? Reporting Tools
Hi Ben
It’s not an easy solution as it requires additional tools, but I do have an idea that might help.
-
Start by getting a tool to change the replica ID of all copies of the Activity.nsf, searching for “domino change replica id in database” brought up a few results.
-
Set all instances of the database on all servers that you’re going to aggregate to the same replica id
-
For each instance, change the replication settings so the spoke servers don’t pull any new documents from any other server.
-
On the main management server that you’re going to collate all the other activity in to, make sure it’s set to pull documents from any other database.
-
Verify replication is running between the hub server and spokes.
You’ll end up with a hub database that will contain all the activity of all the servers. I don’t know if the views will need modifying to suite the data from multiple sources, but the data will be there. I’ve done this with the log.nsf and it worked OK, but it did get rather big.
Good luck !
Simon