
OpenNTF Code Bin
About This Code
Brief Description:
Audit your server's databases with this tool. Manage your ACLs and more.
Contributor:
Stan L Uptagrafft
Notes Version:
R6.x, R5.x, R7.x
Last Modified:
08 Apr 2006
OpenNTF Disclaimer
All of the program code and information presented in the OpenNTF.org Code Bin are provided "as-is", and should be used at your own risk. OpenNTF.org make no express or implied warranty about anything in the Code Bin, and OpenNTF.org will not be responsible or liable for any damage caused by the use or misuse of anything from this site. OpenNTF.org makes no guarantees about anything. Please thoroughly test all of the knowledge and code you find here before you attempt to use them in your production environment.
Code / Description
This is a Notes database. Although I used ver7 to create it, the code should work just fine with R5 and above. This will collect information on the fly of all the databases that match your search criteria or use asterisk to collect information about every database (nsf) on your server, or local. This will remember each time you execute, so you can monitor changes ea. week/month and show differences across servers. Find out if you have scheduled agents set to run on incorrect servers! Find out if one ACL is different from another replica's ACL. See which are full text indexed or scroll through a view of all databases and see the maximum internet access settings.
Updated 4/8/06 - Now collects new ACL setting 'Replicate of Copy Documents'
Usage / Example
I have many servers and have unique security settings which must vary on different servers. This tool has been very helpful and I hope someone here finds use for it too. The button used to launch the agent is above the menu! - I suppose I should have made this more obvious. Push 'Audit Server Content' and the popup will then ask for a server name... type one... or 'Local' then the next popup will ask for search criteria... if you type names... then it will search your server for filenames with 'names' within it's name... it's not case sensitive. Then sit back and watch as it trolls your server collecting tons of info, then a popup reports how many database were looked at, and how many matched your search criteria. That's about it, there are some helpful buttons to easily open the ACL to make your fixes. I'll often just delete all the documents when I'm done and run it again, however if you keep them you can easily see which were created on each day so you can track changes. Your feedback is welcomed. Enjoy.
Updated 4/8/06 - Users were calling me with new problems in some applications: They could not copy selected text, nor even print documents. The cause was this new ACL setting was required. I needed a report which shows me which users and in which databases did not have this privilege. Now the agent collects this info for each entry and I've added a view which shows 'w/o Copy and Replicate'.
Code Attachments
Comments
Posted by Enio Basso on 03/02/2006 01:02:03 PMrwf Workflow Example add
Hi Stan.
Now i attached the rwf Workflow Example...
Posted by Stan L Uptagrafft on 03/08/2006 08:39:04 AMrwf Workflow Example add
Thanks Enio,
I'll go and download your example right away:
http://www.openntf.org/Projects/codebin/codebin.nsf/CodeByDate/CDFD834B96816DA586257103003D78CA
Posted by Matt White on 11/16/2006 09:24:00 AMvery useful code
Hi Stan,
This is a great database, saved me hours of work, thanks
Matt
Posted by P J Harper on 07/23/2007 11:14:02 AMGreat!
Thanks this is a huge time saver. I do have one question. Is there a way to get it to let you know which roles are associated with each name in the ACL?
Posted by P J Harper on 07/23/2007 11:14:03 AMGreat!
Thanks this is a huge time saver. I do have one question. Is there a way to get it to let you know which roles are associated with each name in the ACL?
Posted by Stan L Uptagrafft on 07/23/2007 12:26:35 PMsure...
The roles for each ACL entry are right beside the 'Type'