How to count all the unique users for Domains from all NAB groups.

5 pts.
Tags:
Application development
Developing secure applications
Lotus
Lotus Domino
NAB
How would one count the number of unique users among all the groups in a NAB with a collective count based on the domain of their names, ensuring each name is counted only once regardless of the number of group memberships?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Among the nearly infinite numbers of doing this, here are some ideas.

Create a copy of the view “Groups.” Call the new view “Group Members Full”. Delete all the columns except the Group column. Add a new Categorized column before Group. Call that column “Name.” Choose the field Members as the contents for the column. Refresh and save the view. When collapsed, this view will have the total number of unique names for your NAB. Click and drag the first column. The message line will display the number of selected lines. This will include the names of groups that are contained in other groups.

If you want a prompt to show the number of unique names in the view, create a formula action with this code. (this is derived from code I have that works. This specific code combination is untested. Let me know if it works.)

GroupMembers := @Trim(@Unique(@DbColumn(“” : “NoCache”;””;”Group Members Full”; 1)));
NumMembers := @Elements(GroupMembers);
@prompt([ok]; “Number of names”; @text(NumMembers))

Document this new view in whatever you use to document systems. Make sure you save it to a code library or Notes design object store somewhere that is documented and known. If the nab design takes it out due to an upgrade or whatever reason, replace it from your code library.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following