Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Audit extension problem

    Posted 05/24/22 10:38 AM
    Hi all,

    we need to find out the assignment to a cognos role/group per user.

    I think this should be possible with the audit extension but i failed to generate the WAR file:

    error: org.apache.tools.ant.Main      was not found

    Did anyone run into the same problem and have a solution?
    IBM support "can" not help as there is no support for the audit extension.
    We are running 11.1.7 and i am not sure if the audit extension is still running under this version.

    Or is there another way to check to which group a user is assigned?

    Thanks in advance for any comments.

    ------------------------------
    Andreas Wycisk
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Audit extension problem

    Posted 05/25/22 09:37 AM

    Hi,

    I think tools like BSP MetaManager can help with things like documenting your security. I don't think the author of the Audit Extension is still with IBM, sadly.

    Cheers!

    MF.



    ------------------------------
    Mark Fry
    Technical Consultant
    ------------------------------



  • 3.  RE: Audit extension problem

    Posted 05/30/22 11:18 AM
    Hi Marc,

    we use BSP but the needed information is not included in our license (or maybe at all).

    But thanks for your answer.

    BR
    Andreas

    ------------------------------
    Andreas Wycisk
    ------------------------------

    Original Message


  • 4.  RE: Audit extension problem

    Posted 05/31/22 02:05 AM

    Hi Andreas, 

    If you have BSP metamanager already, then you would be having access to the Document section under which you will find Canned Reports > Audit > Account Security Audit output that can give you what you are looking for. 

    Regards,
    Kiran



    ------------------------------
    Kiran Passumarthi
    www.linkedin.com/in/kiranpassumarthi
    ------------------------------

    Original Message


  • 5.  RE: Audit extension problem

    Posted 05/26/22 04:37 PM
    Hi,

    You might run this query in your Content Store database

    SELECT
obj.NAME AS user_group,
UPPER(COALESCE(props33.USERID, props33.NAME)) AS user_id
FROM CMOBJECTS o
INNER JOIN CMCLASSES c on c.CLASSID = o.CLASSID
INNER JOIN CMOBJNAMES obj on o.CMID = obj.CMID and obj.ISDEFAULT = 1
INNER JOIN CMREFORD1 ref ON o.CMID = ref.CMID
INNER JOIN CMOBJECTS acc on ref.REFCMID = acc.CMID
INNER JOIN CMOBJPROPS33 props33 on acc.CMID = props33.CMID 
INNER JOIN CMCLASSES cacc ON acc.CLASSID = cacc.CLASSID 
WHERE c.NAME = 'group' AND cacc.NAME = 'account'

​


    ------------------------------
    JEAM COELHO
    Cognos Solution Architect

    LinkedIn: https://www.linkedin.com/in/jeamcoelho/
    ------------------------------



  • 6.  RE: Audit extension problem

    Posted 05/27/22 12:05 PM
    Hi Andreas

    I came accross the same problem with ant library components. How i resolved:

    Please have a look at the build.bat file. It is telling the necessary .jar files üand locations. Please download them and put in the proper places.

    Then it will be resolved.

    Let me know if you need further assistance.

    ------------------------------
    Sukru Haciyanli
    Www.istanalytics.com
    ------------------------------

    Original Message


  • 7.  RE: Audit extension problem

    Posted 05/30/22 11:24 AM

    Hi Sukru,

    thanks for your answer... i will check the missing JAR files and where i can download them.

    For sure i give you an update.

    BR

    Andreas



    ------------------------------
    Andreas Wycisk
    ------------------------------

    Original Message


  • 8.  RE: Audit extension problem

    Posted 05/30/22 11:22 AM
    Edited by System Admin 01/20/23 04:10 PM
    Hi Jeam,

    i checked your SQL statement and it looks quite promising.

    Thanks for sharing.

    Do you have other helpful SQL statements or a good source? The content store is still not well documented
    ( i know the documents regarding table name and possible content).

    More interesting would be real life use cases and answers from the content store (like your SQL).

    Thanks again.

    BR
    Andreas

    ------------------------------
    Andreas Wycisk
    ------------------------------

    Original Message


  • 9.  RE: Audit extension problem

    Posted 06/06/22 06:26 PM

    Hi Andreas,

    I have some scripts to my specific needs.

    A good start point to understand Content Store tables is the CSsize_profiling.sql script. It is located in your content manger install folder/configuration/schemas/content.



    ------------------------------
    JEAM COELHO
    Cognos Solution Architect

    LinkedIn: https://www.linkedin.com/in/jeamcoelho/
    ------------------------------

    Original Message


  • 10.  RE: Audit extension problem

    Posted 05/30/22 04:44 AM
    Hi Andreas,

    Did you try the Audit Extension from this IBM page?
    IBM Cognos c11AuditExtension

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------



Related Content