IBM License Metric Tool (ILMT)

IBM License Metric Tool (ILMT)

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  audit_trails.csv empty

    Posted Fri September 20, 2024 12:43 PM

    In recent ILMT snapshots, the "audit_trails_csv" is empty, no data recorded.  I have checked the permissions, roles, assignments, etc. without finding a reason for this lack of data.  What else would lead to this file being empty?



    ------------------------------
    Burton Culley
    ------------------------------


  • 2.  RE: audit_trails.csv empty

    Posted Sat September 21, 2024 03:12 AM

    Hello,


    The only time when 'audit_trails.csv' is completely empty is the fresh installation before first import...
    I take that this is not a case here...

    Does 'Audit Trail' report shows any content ?

    What about other files from 'audit snapshot' package ?...is everything in order ?...is the 'data_condition.txt' filled in ?
    Does tema log shows any errors around AuditTrailsCsvGenerator line ?



    ------------------------------
    Thank you,
    Oktawian

    Oktawian Powązka, L3 Support
    IBM License Metric Tool
    ------------------------------



  • 3.  RE: audit_trails.csv empty

    Posted Mon September 23, 2024 12:42 PM

    I have not noted any of the other files with issues.  The summary, daily, and other files are filled in as expected.  Over the past 8 quarterly snapshots, five of the audit_trails.csv's are blank:

    Row No. Modification Type Modified By Modification Date Details

    The one which isn't the next most recent (Q3-24 = blank, Q2-24 = filled in, Q1-24-Q2-23 = blank):

    Row No. Modification Type Modified By Modification Date Details
    1 Product Bundles imported successfully SYSTEM 6/4/2024 Product Bundles file version 1313406 was imported successfully.
    2 FlexPoint bundles imported successfully SYSTEM 6/4/2024 The import of the FlexPoint bundles file version 1313406 was successful.
    3 Canonical 2 catalog upload SYSTEM 6/4/2024 The Canonical 2 catalog file version 1313406, dated 2024-03-03, was uploaded.
    4 Charge units upload SYSTEM 6/4/2024 The charge unit data file version 1313406 was uploaded.
    5 PVU table upload SYSTEM 6/4/2024 The PVU table version 2024-03-06 was uploaded.

    All of the snapshots have been run by the same person, indicating the permissions and roles are correct.  

    Burton



    ------------------------------
    Burton Culley
    ------------------------------



  • 4.  RE: audit_trails.csv empty

    Posted Tue September 24, 2024 01:39 AM

    Hello,


    All is clear,
    At the start you've mentioned that 'audit_trails_csv is empty'.
    So, I took that is empty regardless of a time range...

    The Q2-24 period shows up the upgrade activities.
    Have you run any ILMT upgrades in Q1-24, Q2-23 period ?


    Basically, 'Audit Trail' report is only triggered by activities (upgrade, Server parameter alteration, soft. confirmation/reassignment, VM managers setup etc.).
    The open question remains what (if any) have been conducted at those aforementioned time periods...



    ------------------------------
    Thank you,
    Oktawian

    Oktawian Powązka, L3 Support
    IBM License Metric Tool
    ------------------------------



  • 5.  RE: audit_trails.csv empty

    Posted Tue September 24, 2024 09:40 AM

    If I may clarify, to be sure I underestand, in quarters without changes, there will be no entries in the audit_trails.csv, presumably because there is nothing to track or audit.

    In the previous quarters, I am unsure if there were any changes.  There was a personnel change, and the snapshot collection was inconsistent.  There were re-classifications performed in Q2-24.  From your reply above, this would be consistent with the audit_trails recording data for Q2-24

    Thank you,

    Burton



    ------------------------------
    Burton Culley
    ------------------------------



  • 6.  RE: audit_trails.csv empty

    Posted Wed September 25, 2024 04:38 PM

    If indeed there were some re-classifications performed in Q2-24 those are not shown on your output...that's weird.

    For a quick check just please rebundle something and verify of 'Audit Trail' report (https://xxx:9081/sam/audit_trail_reports) shows anything new...



    ------------------------------
    Thank you,
    Oktawian

    Oktawian Powązka, L3 Support
    IBM License Metric Tool
    ------------------------------