Cognos Analytics

 View Only
  • 1.  Audit Extension cleaning

    Posted Fri February 10, 2023 07:42 AM

    Hello All,

    My question is how to clean my AuditExtension database which contains records of different tests. Do i have to delete manually the records in the following tables with AUDIT_ID =  <number> ?

    AE_STATUS
    AE_ITEM_LOOKUP_FAILURES
    AE_AUDIT_TYPE_LOG
    AE_AUDIT_FILTER_LOG
    AE_AUDIT_TYPE_LOG_ROLE
    AE_AUDIT_TYPE_LOG_CONTENT
    AE_AUDIT_TYPE_LOG_ACCOUNT
    AE_AUDIT_TYPE_LOG_STATUS
    AE_AUDIT_FILTER_LOG_CONTENT
    AE_AUDIT_FILTER_LOG_ACCOUNT
    AE_ROLEAUDIT_*
    AE_ACCOUNT_*
    AE_CONTENT_AUDIT_*
    AE_SECURITY_MEMBERS
    AE_LOG_MESSAGES

    A_I_L_FAIL_CA_OWNER ?
    A_I_L_FAIL_CA_POL ?

    Thank you for your help !



    ------------------------------
    LOIC POTIN
    ------------------------------


  • 2.  RE: Audit Extension cleaning

    Posted Fri March 10, 2023 08:31 AM

    Hi Loic, I also would like to learn. Did you have a chance to find an answer?

    Regards

    Sukru



    ------------------------------
    Sukru Haciyanli
    ------------------------------



  • 3.  RE: Audit Extension cleaning

    Posted Mon March 13, 2023 10:21 AM

    Hi Sukru,

    No answer yet to my question and no test on my side up to now. It is still an active question.



    ------------------------------
    LOIC POTIN
    ------------------------------



  • 4.  RE: Audit Extension cleaning

    Posted Tue March 14, 2023 08:17 AM

    Hi Loic

    I am looking into this now. What version are you using?



    ------------------------------
    TREVOR COMEAU
    ------------------------------



  • 5.  RE: Audit Extension cleaning

    Posted Mon March 20, 2023 12:11 PM

    Hi Loic

    I've been working on testing the upcoming Audit Extension and helping with the docs. I can confirm that there is no feature in what we provide that will clean up content in the database. I do plan to make sure we document the commands that will remove old records.
    What I have been using thus far is just (Delete from <table> where Audit_ID=<X>). Likely the same thing you are using.



    ------------------------------
    TREVOR COMEAU
    ------------------------------



  • 6.  RE: Audit Extension cleaning

    Posted Tue March 21, 2023 09:49 AM

    Hello Trevor, 

    Thanks for your answer.

    It confirms my thought to do it manually but i wanted to know if it  was the only way to do it.

    Loic Potin



    ------------------------------
    LOIC POTIN
    ------------------------------