asked on

Determining if databases still being used

I am tasked with determing which databases are still being used in our organization. To trim the list down i would like to include a parameter in a view that only includes databases that have had writes to them in the past 6 months. How can i access the property in the Database Properties>Info>UserActivity > User and Write fields programmatically? I'd like to be able to do something with this info (maybe set a boolean value to true if x number of users and x amt of writes have been triggered in the last 6 months) but dont know how to get to that property(?)

Or can this be done?

Thanks!

p_partha

You can try accessing the database last modified property and check when it was used. I had a similar requirement, and I had some code, will try to dig in for you

Partha

ASKER CERTIFIED SOLUTION

p_partha

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

p_partha

and in the servername field enter the server name and click on the button

Partha

SysExpert

I would look at the Noets Log DB temlate since it has a view that shows usage.

The problem is that it incldes Server access, and DB's may be read on any server, s that you need to have a consolidated view of AL the servers, not just one.

If these are Mail DB's. I prefer to use the Sent view to see when the last email was sent . This is usually a good indicator.

I hope this helps !

TheRookie32

ASKER

@p_partha:

I believe the last modified property is for when the design of the database was modified, not necessarily documents added to it...

will work with your code though and see what i come up with... thanks!

Sjef Bosman

There is no need to code anything, the info is there. It is not the Notes Log you should look in, it is the Catalog database (catalog.nsf). The only requirement is that the Catalog-task is running every night. Databases can be excluded from the normal views of this database, but don't worry, they are all in the database.

NARoberts

You can also look in you admin client under "server" "status" and "database users" to see current activity. You could watch that to see if someone is in it right now. It won't show history though. Probably the catalog is best place to look for that.

TheRookie32

ASKER

@sjef - it will require a bit of coding as i dont want to have to physically look at each of the databases because we have about 2000+ of them.

Thanks for your replies! I believe i got it...

Sjef Bosman

I think you could have created a simple view in the Catalog, displaying exactly what you need... But if you're happy, I'm happy :)

p_partha

Sjef Bro,
You seem to be a Happy Man !!!

Partha :)

Sjef Bosman

Yeah...