Cognos Analytics

 View Only
Expand all | Collapse all

Audit extension problem

  • 1.  Audit extension problem

    Posted Tue May 24, 2022 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

    IBM Champion
    Posted Wed May 25, 2022 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 Mon May 30, 2022 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
    ------------------------------



  • 4.  RE: Audit extension problem

    Posted Tue May 31, 2022 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
    ------------------------------



  • 5.  RE: Audit extension problem

    Posted Thu May 26, 2022 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 Fri May 27, 2022 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
    ------------------------------



  • 7.  RE: Audit extension problem

    Posted Mon May 30, 2022 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
    ------------------------------



  • 8.  RE: Audit extension problem

    Posted Mon May 30, 2022 11:22 AM
    Edited by System Fri January 20, 2023 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
    ------------------------------



  • 9.  RE: Audit extension problem

    Posted Mon June 06, 2022 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/
    ------------------------------



  • 10.  RE: Audit extension problem

    IBM Champion
    Posted Mon May 30, 2022 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
    ------------------------------