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.

When you check ACL of database, sometimes it is very hard to say which particular user has enough rights for example to delete documents in database or who has required role. This code will check each entry in ACL, then it will check if this is a group or user (using Domino Directory), and if this is a group expands all group members, then it will export result to Excel file, where you can use autofilter for easy records navigation

I suggest to use this code as agent in your mail file (create new agent 'ExportACL2Excel' triggered from Actions menu selection), so it can be triggered by 2 ways:

1) by Actions menu in of your mail file - in this case you will select database from catalog
2) create smarticon with the following formula - in this case script will proceed any opened database:
DBServer := @ServerName;
DBName:=@Subset(@DbName; -1);
ENVIRONMENT ExportACL2ExcelDBServer:= DBServer;
ENVIRONMENT ExportACL2ExcelDBName := DBName;
@Command([MailOpen]);
@Command([ToolsRunMacro]; "ExportACL2Excel");
@Command([FileCloseWindow])