All-in-one Admin Tool Collections of tools for Domino Admins

All-in-one Admin Tool that consists of a collection of tools, that will help admin for quick troubleshooting agent related issues.

1. Updated version (V2.1) of the "Out Of Office Diagnostic Tool"
2. Tool to present a selectable list of profile documents for removal from a database
3. Prohibit Design Element Diagnostic Tool which presents design elements that have the prohibit flag enabled with the option to remove the flag
4. Create a LotusScript copy of a database primarily to be used for database corruption
5. Rebuild a mail database Inbox due to corruption or accidental removal of the documents from the folder
6. Given a list of mail databases this will edit the ACL entry for the mail file owner to editor, designer, or manager
7. If you suspect that you have duplicate templates on a server this will present you with a comprehensive list of duplicates
8. Given a list of databases this tool will enable or disable all background agents in a database by editing the database property "Disable background agents for this database"
9. Given a server name in your organization this tool will gather your specified mail database attributes and create a Comma Separated Value (CSV) file to be opened as a spreadsheet
10. DXL Tool to export a select document to XML format

To download the tool and refer complete details here

IBM released Notes/Domino 8.5.2 Fix Pack 3

Notes/Domino fixpack 3 is availbale for download, it included some new features (the whole fixlist can be found here):

SPR# EFEZ8FLKMF - Ensure that updates to admin.exe and designer.exe are installed only if those components are already installed.

SPR# XTCN8GPEN9 - Fixed a Mac specific client hot-fix issue where a Hot Fix needs space between FP (fixpack) and SHF for the basic portion of the string.

SPR# AHAS8BSH8B - Prior to this fix, Drag and Dropping of files to Notes was slow and large files sometimes failed.
SPR# DCHR7PU3LL - Tables with long fields are not wrapping when printed. If the table size exceeds the paper size, we will shrink the table to fit the paper. This avoids truncating printed content but will affect the original table layout. (Technote #1416913)
SPR# HIKA8E7RT3 - A MIME message which contains <![endif]> is not rendered correctly with embedded browser enabled, resolved in client. (Technote #1499287)

SPR# JDAM7DBS9U - Message received if exceeding mail file capacity should specify mail file size limitation. Regression in 8.5.

To download Notes/Domino 8.5.2 Fix Pack 3 from Fix Central, click the link 

Extracting Lotus Connections Profiles information .... Tags

I have been busy this days working on Lotus Connections 301 implementation. I had some interesting findings thats i would like to share with you all.

I will provide some quick glance on Profiles DB2 table details. I have used this tables value to get the list of users with their tags lists, also used to populate users with predefine tag values.

Profiles DB contain table EMPLOYEE which contain information about users attributes and their values. This information is then published in Pofiles for that user. Few of them are listed below.
 
PROF_UID
PROF_UID_LOWER
PROF_LAST_UPDATE
PROF_GUID
PROF_DISPLAY_NAME
PROF_GIVEN_NAME
PROF_SURNAME
PROF_IS_MANAGER

You  can use this information to compare and extact require reports. I will be using this information to extract Peoples with tags they added to their profiles.

Extract data from PEOPLE_TAG, which contain information on Tags. PEOPLE_TAG contains below information.

PROF_TAG_ID          - (This is simply a UUID randomly generated)
PROF_SOURCE_KEY  - (This is the user that the tag is assigned to)
PROF_TARGET_KEY   - (This is the user that the tag is assigned to)
PROF_TAG                - (which is the actual tag itself)

I did compare the PROF_TAG value with employee table, to get the list of users and their tags.

You can also extract this information using TDI, i use DB2 source to collect this information.