Anyone have an idea or suggestion on a way to search across multiple databases and generate a report that will tell you when the last time an email was sent from a database?
Basically we’ve had bad admin practices done here and now there are old user mail databases still in the system and no one is sure on who needs to go! So apart from manually looking at every single database we thought that looking at last sent would be a good way to judge if someone is still here or not.
Any suggestions would be highly welcome. Thanks!
Subject: Searching multi db’s for last sent email
I think all the documents created with “Memo” and “Reply” will have a field called “posted date”.So you can create a view in each users mail database and sort the view then get the first documents posted date value.
But if the document is deleted from the entire mail database then this wont work.
Subject: RE: Searching multi db’s for last sent email
I’d be looking at a two pronged approach, firstly from a “Who” rather than “What” is active on my system.
I don’t think it’ll populate backwards usage, but for ensuring you can check in the future who is active on your system, look into enabling the Domino License Tracking (details in the Help). It logs All users and Active users, and shows you the last month of access. So you can tell who hasn’t hit your system for a few months, using the different protocols. It gathers the information so you don’t have to.
And I guess this second idea only helps if these No send mail files aren’t receiving mail too, but the Catalog has a “Database last modified” field that you could make a view, and probably ditch a few databases that haven’t been active for a while.
I’m sure there are great scripts that can loop through databases and check the last sent date, but I’m afraid I can’t help with anything that sophisticated.
Hope you get it sorted.
Kirsty
Subject: RE: Searching multi db’s for last sent email
Thanks for the tips guys, I’ll give it a shot!
Subject: RE: Searching multi db’s for last sent email
License tracking is a good idea, but as Kristy pointed out, you might not have enabled it, and she is correct in that it cannot look into the past.
If it’s not enabled, another option that may or may not have been enabled is Activity Tracking. If that has been set up (again, it won’t look backwards in time) you can do an activity analysis for session activity and review the results by username.
Or, if your mail server’s LOG_SESSIONS parameter is set to 1, you can perform a log analysis searching for server log entries indicating session opens, and then filter the obscenely long list of hits for unique names.
Databases also store user activity information, but it’s not easily accessible for more than one db at a time. There are thrid party tools for this kind of analysis, I seem to recall…