InfoSphere Optim

 View Only

  • 1.  Trying to create an "audit" view of activity

    Posted Fri August 16, 2019 09:46 AM
    Hi All,

    Can anyone share their experience of creating audit information on who's done what on an Optim TDM system.

    Have I got all the relevant tables?

    ·        OPTIM.OPTIM_AUDIT_RECORDS

    ·        OPTIM.PSTDBA2

    ·        OPTIM.PSTOBJ2

    ·        OPTIM.OPTIM_TRANSACTION_CONTENT

    Thanks,
    Barbara

     



    ------------------------------
    Barbara Brown
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Trying to create an "audit" view of activity

    Posted Tue August 20, 2019 01:41 PM
    Hi Barbara,

    These are the tables covering all of the audit details.

    OPTIM_AUDIT_RECORDS
    OPTIM_TRANSACTION_CONTENT
    OPTIM_DEFINITION_CONTENT
    OPTIM_CONFIGURATION_CONTENT
    OPTIM_SERVICE_INSTANCES
    OPTIM_FILE_CATALOG

    Thanks,
    Tulasi

    ------------------------------
    Tulasi Uppu
    ------------------------------

    Original Message


  • 3.  RE: Trying to create an "audit" view of activity

    Posted Wed August 21, 2019 06:16 AM
    What do you mean by audit? I have a script to gather all masked columns from covert runs.


    Thanks,
    Ed
    Sent with Work

    The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.

    Please refer to https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of www.bnymellon.com.



    Original Message


  • 4.  RE: Trying to create an "audit" view of activity

    Posted Mon August 26, 2019 12:53 PM
    Thanks Tulasi!

    Hi Ed,

    I have two use cases really

    1. To catch errors particularly around unauthorised activity

    2. To have a view of the amount of activity undertaken

    Thanks,
    Barbara

    ------------------------------
    Barbara Brown
    ------------------------------

    Original Message


  • 5.  RE: Trying to create an "audit" view of activity

    Posted Tue August 27, 2019 12:04 PM

    Unauthorized? I don't see how the transaction content can show that.

    Activity? That I can help with.

    I don't know if the attached file will come through. It is the query I use to pull CONV runs from OPTIM_TRANSACTION_CONTENT. It is 151 formatted lines, so I did not paste it here. I can upload it to the site if I ever have a second.

    We populate a table with this every day and publish the data for the applications to review. They see the columns they are masking f for tables in specific databases.

     

     

     

    Thanks,

    Ed Lipson

    Director

    BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217

    Information Lifecycle Management

    T 718.315.4763 |  F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com

     


    The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.

    Please refer to https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of www.bnymellon.com.



    Original Message


  • 6.  RE: Trying to create an "audit" view of activity

    Posted Wed August 28, 2019 01:13 PM

    Out of curiosity do any of these tables contain information on the queries executed using Optim Connect? My guess is no but thought I would ask. Currently we grab the NAV_UTIL logs and parse through them but would be easier if it was a table I could run a query against.

     

    Thanks

    Donna Simmons 

    Applications Systems Engineer, AVP

    Wells Fargo EDM System Tools and Utilities

    M 540-553-5369

     

     




    Original Message


  • 7.  RE: Trying to create an "audit" view of activity

    Posted Wed August 28, 2019 02:12 PM

    No, Queries are not captured in this table. You may be able to set traces and log them via Connect Studio, but we don't so have no experience.

     

     

     

    Thanks,

    Ed Lipson

    Director

    BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217

    Information Lifecycle Management

    T 718.315.4763 |  F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com

     


    The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.

    Please refer to https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of www.bnymellon.com.



    Original Message


  • 8.  RE: Trying to create an "audit" view of activity

    Posted Tue August 27, 2019 12:09 PM
    I added the query to the library

    CONV Query of OPTIM_TRNASACTION_CONTENT 



    ------------------------------
    Ed Lipson
    BNYMellon
    Brooklyn NY
    718 315 4763
    ------------------------------

    Original Message