Audit Extension & License Counts

[tranboelsterli]

Hello,
I've been using the Audit Extension "Capabilities Users Hierarchy" to get the Active Directory groups and logon IDs to count licenses.  The issues are:
1) I must know which AD groups belong to which Public Folders (i.e. Each Public Folder is a Business Unit (BU) / Customer in my Enterprise environment)
2) If any AD group has AD sub-groups, the Audit Extension displays the AD sub-groups as members.  It does NOT expand the AD sub-groups, therefore I must use an internal process (i.e. net2info) to get the logon IDs of each AD sub-group.
3) Then, I have to manually load all the logon IDs to an Access database and get the distinct CAIs within each Public Folder / BU, based on the highest license type.  For example, if the logon ID has Professional license in Development environment and Consumer license in Production, I count this login ID to have Professional license.
4) The last issue is that there are duplicate logon IDs across BUs.

Is there another way of counting licenses more effectively without any manual intervention?  KPMG auditors (who work for IBM) don't have a way.  BSP Audit application can not resolve the issues above.  If SDK is the only solution, we don't have any SDK expertise in-house, do we need to pay for an IBM SDK consultant?  I thank you any help in advance! 

[mrl72]

Did you ever get this working?

We have a similar issue when trying to audit our licenses. We use AD as our authentication source but our support team need the AD userid (Windows login ID) in order to contact the users. Cognos only stores the username in the audit database so we're looking at alternative ways to get this information directly from within Cognos. Does the Audit Extension give you this info?

Cheers.