Locate inactive user accounts in Lotus Domino version 8.0.1

Hello experts,
Can anyone guide me as to how one can locate inactive user accounts in Lotus Domino. We have around 700 email accounts and I need to find a solution where I can start disabling or deleting inactive accounts.
A built in Lotus feature will be the best option, however if we need a third party solution then we might try the demo first.

KASPBoodaiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mbonaciCommented:
If all your users have mail databases you can check Catalog.nsf on your mail server to find out "Database percent used" and "Database Activity" (number of reads in previous period).

Like this:

831 - Number of days in reporting period
7 - Number of uses in reporting period
343 - Number of reads in reporting period
84 - Number of writes in reporting period
0
mbonaciCommented:
For most convenient analysis you can create custom view that would show the data (sortable) you need from the database documents.
0
Sjef BosmanGroupware ConsultantCommented:
Same idea, but based on a different database: use log.nsf, and open the view Usage/By Size. There is a column Weekly Usage, and if you open a document you can see the size of the view indexes. If the size is 0, the particular view hasn't been used for more than 45 days. If you define "inactive" as "not used in the last 45 days", well, there's the view to check.
0
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

KASPBoodaiAuthor Commented:
Guys i checked for the settings both catalogue and log.nsf you suggested but the list would display all active users only. For eg we know there is one user xyz@abc.com who has left the co for years, this account would not be displayed either in catalogue or log.nsf. The log.nsf also displays records for only 10 days so the data in it is limited.
Any other solution or I might be missing sumthing. For your info we enabled user license tracking today, is this option anythg to do with finding out inactive users.
0
mbonaciCommented:
That will show when the Lotus client licenses expire, so it'll help only if you, when you registered your users, put certification expiration date relative to current date.
0
KASPBoodaiAuthor Commented:
So can you elaborate what u want me to do in order to locate inactive users?
0
mbonaciCommented:
All the data will be in Domino User License Tracking database (USERLICENSES.NSF), which was automatically created when you enabled license tracking.

Also, you can also try to find inactive users by certificate expiration date here: open Domino Administrator > Configuration tab > Certificates > Certificate expiration
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sjef BosmanGroupware ConsultantCommented:
> ... the list would display all active users only...
Not true. Open log.nsf on the server, click Usage and then By Size, you'll see a long list of ALL databases on your server. You could enhance that view, e.g. add a column containing the monthly activities of a database. When that value is 0, the database hasn't been used during the last month.
0
KASPBoodaiAuthor Commented:
We wont be able to check inactive users based on certifcates as lot of users have the ID file stored locally on the PC, so even if their account shows its expired they are still able to use their account based on the id file stored locally.
On the Usage by size window I am unable to  add monthly activities column. Do I have to add it using designer?
0
Sjef BosmanGroupware ConsultantCommented:
> Do I have to add it using designer?
Exactly. It might be better to make a copy of that view, and then modify it.
0
RonaldZaalCommented:
The description of this link is : " Database primarily to help administrate Notes users and find unused "

http://www-10.lotus.com/ldd/sandbox.nsf/ecc552f1ab6e46e4852568a90055c4cd/e0ff0464768be1a085256b37004f25b6?OpenDocument&Highlight=0,users
So it may be what you want.
0
mbonaciCommented:
That's a great little piece of code Ronald.

Taking this Ronald's code into consideration, I would create an agent that would use NotesDbDirectory to cycle through mail databases and for each of them create a document with the last access information.
0
KASPBoodaiAuthor Commented:
Thanks will try out this add on and let you guys know.
0
KASPBoodaiAuthor Commented:
OK guys I think I require more information on how to use this tool. I tried double clicking on the ns4 file it did open showing me all the options like active users, inactive users but unfortunately dont see any email accounts or any data. All the options are blank, so I believe there is something more I need to do to make this work.
For your information the tool says works for R4 and R5 and we are using the latest R8.
0
mbonaciCommented:
Any LotusScript experience?
0
mbonaciCommented:
This is the code that gets all mail databases size.
You can use it as an example on how to loop through mail databases in LotusScript.
Sub Initialize
		 Const srvName = "YourMailServer"
		 Const mailFolder = "mail"
		 Dim s As New NotesSession
		 Dim dbdir As NotesDbDirectory
		 Dim db As NotesDatabase
		 Dim dbSize As Double
 
		 Set dbdir = s.GetDbDirectory(srvName)
		 Set db = dbdir.GetFirstDatabase(1247)
 
		 Do Until db Is Nothing
		 		 'backslash is to exclude dbs that arent in Mail folder (or one of its subfolders) and have mail in the file name
		 		 If Instr(db.FilePath, mailFolder & "\") Then
		 		 		 dbSize = dbSize + db.Size
		 		 End If
		 		 Set db = dbdir.GetNextDatabase
		 Loop
 
		 'do something with the result
		 Print Cstr( dbSize / 1024 / 1024 )		 'Print size in MB
		 
End Sub

Open in new window

0
KASPBoodaiAuthor Commented:
Sorry mate no scripting skills in my arsenal. Actually I am fairly new to Domino thats why I am relying on forums and sites like these to get things working,
0
Sjef BosmanGroupware ConsultantCommented:
About the User Control database that Ronald sent the link for: did you read the introduction in the database (Help/About this Database)? It tells you exactly what you should do, even with some images. And it runs fine on our R8.5.1 system...
0
mbonaciCommented:
Agree with Sjef, there are few solutions proposed, I don't know what do you expect, you have to make at least small effort to get that information...
0
Sjef BosmanGroupware ConsultantCommented:
From the question: "Can anyone guide me ...". IMHO there is sufficient guidance in the posts above. Maybe the Asker expects too much from us poor experts (who are volunteers, I hope you knew that!), we know many solutions but the final action is never ours. If you are new in the Notes world, and you're used to other mail systems, be careful not to start a local revolution. And don't expect to master Domino in 2 months. Instead, try to be flexible and open to a sometimes different world. Very much like we, we're learning all the time.

Rest assured, many things are possible in a Domino environment. There usually is a Notes' way to do it, but it sometimes isn't exactly the way you would expect. In your capacity as Admin, you might be asked to execute some draconian measures. Often, you may have to do so because your predecessor grew somewhat sloppy over the years, or new policies were imposed, or whatever. Just ask, we'll supply the answers if we know them, but don't expect a forum to be a replacement for the Admin training you've postponed.

@Thermo: I can only recommend to give RonaldZaal 300 points, and mbonaci and me 100 each for other correct suggestions. But I really hope that the Asker closes this question himself.
0
mbonaciCommented:
I agree with Sjef's proposal.
0
RonaldZaalCommented:
Who dares not to agree with Sjef ?!?
0
Sjef BosmanGroupware ConsultantCommented:
My wife...
0
KASPBoodaiAuthor Commented:
OMG you guys are so upset...I agree that what suggestions you guys offered are valid and should have worked... I tried these solutions but they didnt work as per our requirement. There is nothing to feel offended about.
0
Sjef BosmanGroupware ConsultantCommented:
Like in your other question: your requirements were incomplete, so what do you expect?

I repeat, we're not offended, it takes a lot more to offend us. And if we were, you'd have seen quite different reactions! ;-))
0
mbonaciCommented:
No one here is offended, don't involve feelings, (this is strictly business:)
That's simply how EE works, if a proposed solution did not work for you, you should describe what happened, which errors you encountered, ...

We expect from the question asker to be proactively involved in the process of finding the solution to HIS problem.
Not ask a question and expect from us to give you a complete, wrapped_with_cherry_on_top solution, although that's exactly what you'll get here.

For that kind of work search Google on rentacoder.

That's all.
0
KASPBoodaiAuthor Commented:
kk
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.