PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/08/2014 2:15 PM by  Terry Wier
TM reporting: audit log XML parsing
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
bearcat32
Hr Apps Admin
TriHealth
Basic Member
(22 points)
Basic Member
Posts:12


Send Message:

--
09/30/2014 8:07 PM
    Has anyone tackled parsing the TM audit logs and have sample SQL code to share or suggestion to tackle? If you don't use the audit log in reporting do you make use of the business class export tables for transactional history?

    Thanks.
    Woozy
    Private
    Private
    Veteran Member
    (3469 points)
    Veteran Member
    Posts:701


    Send Message:

    --
    10/01/2014 2:11 PM
    Hi bearcat32,

    Ahh yes...the dreaded audit log. The bane of a our existance.

    At our company, we do parse the audit log - but it is a nightmare. Our TM system is on DB2, but we weren't able to do much with DB2 SQL directly. We actually ended up using MS SSIS packages and SQL Stored Procedures to pull the data and handle the parsing duties. We have a pretty limited set of tables (maybe 15?) and data items that we report on. All the parsed data is pushed into our MSSQLServer data warehouse which is used for historical and trend reporting.

    Unfortunately, I don't have anything to share with you. The process was built by our DBA team, and i really don't have any way to get to it.

    Sorry I can't help much more than this...
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Terry Wier
    Private
    Private
    Basic Member
    (39 points)
    Basic Member
    Posts:13


    Send Message:

    --
    10/08/2014 2:15 PM

    Greetings all LTM users,

    Dashboard Gear's HR Reporting Tool Kits:

    As mentioned one of the issues that is particularly difficult in LTM is reporting out of the AUDIT_LOG fields which are chunks of XML. Dashboard Gear has a component in our reporting solution (a reporting and analytic data mart) where we provide easy access to the AUDIT_LOG data thus allowing you to use more traditional tools and report writers like Crystal, Cognos, SSRS, etc. to access that data.

     

    If you would like to speak with one of our developers feel free to let me know.

     

    Terry Wier

    Dashboard Gear

    terry.wier@dashboardgear.com

    You are not authorized to post a reply.