This has come up many times as our company is very large. I need to figure out a way to return what databases that a “Group” belongs to. That way if the group name needs changed or if it is requested to be deleted I know what it will affect. We have literally hundreds of Notes databases and this would be extremely handy.
Here are my thoughts…
The only way I think this can be done is to create a nightly agent (due to the large number of db) that returns the database names in a field for each Group in our Address Book. So for example, if you opened the “Southside” group in the Address Book, you would see a field with the names of the databases that contains that group. Except this is way above my head, I’ve been programming in Notes for only 3 years and I don’t have the slightest clue on where to get started, can someone please help?
Subject: RE: Expert help needed to find groups used in databases.
Thanks for the quick response! I’ve Been there - done that. I can run a search on the Catalog.nsf but it doesn’t locate the nested groups. For example if a database ACL contained a group “HR” and nested inside that group was “HRDirectors” and I was looking for HR Directors in the Catalog.nsf it would not find it. Additionally, all the databases who’s property “List in Database Catalog” is unchecked will not even show up in the Catalog.nsf database. That’s why I was leaning towards a nightly agent, any other ideas?
Subject: RE: Expert help needed to find groups used in databases.
What about traversing the notes data directory for *.nsf, and interogating each database acl using the notesacl class and comparing it with groups in the nab.
You might be able to utilize the notesdbdirectory class for this.
Subject: RE: Expert help needed to find groups used in databases.
Hello!
I have been thinking about implenting this in DomainPatrol for some time now. I have the code but I have not come around to do it yet.
Using DomainPatrol you can already categorize all databases acl entries, much like the view in the catalog.nsf database.
The thing is that I have not yeat decided on how to store the information and how to update it.
I would very much appreciate any good thougths on this - how it would best coexist with the infromation that is already stored within the DomainPatrol database as it is today.
DomainPatrol is an open source project and you can download the template at OpenNTF.org or the bundled scanner and the template at http://domainpatrol.org