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.  Computers visible in BigFix are not visible in ILMT

    Posted 09/03/25 09:42 AM

    Hello,

    We have 2 out of about 1000 computers which are visible / present in the BigFix (Console) but not present / visible in the ILMT.

    I can see their ID metioned in the Data Import log:

    2025-09-03 12:38:24:929 (+0:00:00.078) INFO: The computer with the following ID: 1611069270 on the Data Source datasource will be reactivated and restored.

    2025-09-03 12:38:24:929 (+0:00:00.000) INFO: The computer with the following ID: 549537885 on the Data Source datasource will be reactivated and restored.

    Message is indicating those will be restored - means visible again ?, but despite of few Data Imports computers are still in the BigFix only, not in ILMT.

    Tried to unsubscribe and subscribe back in BigFix (to ILMT site) but no result - still the same problem.

    Any hints how to "recover" those, so both would be visible again in the ILMT.



    ------------------------------
    JAN FLEGR
    ------------------------------


  • 2.  RE: Computers visible in BigFix are not visible in ILMT

    Posted 09/05/25 02:54 AM

    Hello,


    At first you have to check if some other computers with the same Host/IP pair as those missing one are present in the ILMT.
    If so, it would mean that some BigFix agent duplicates exist in the environment....

    I'd start with enabling debug level of data import logging: https://www.ibm.com/docs/en/license-metric-tool/9.2.0?topic=codes-import-logs
    and look around ComputerReconciliationImportStep.
    Check if any duplicates have been reported...verify if those missing IDs are being shown up or not.

    At last let me know the ILMT Server version which you are using as some fixes around Computer Reconciliation/Reactivation been delivered in the past.



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

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



  • 3.  RE: Computers visible in BigFix are not visible in ILMT

    Posted 09/05/25 08:35 AM

    Hi Oktawian,

    We have ILMT 9.2.40.

    With Import debug enabled, I could identify those references to the one of machines in question:

    DEBUG:  (Importcom.ibm.license.mgmt.etl.core.actions.ComputerReconciliationImportStep) About to insert a computer - DatasourceReplacementComputer [remoteId=1611069270, ipAddress=10.154.130.85

    10.145.96.74

    , endpointId=null, name=luu1383o

    , lastSeen=Fri Sep 05 11:13:52 UTC 2025, isCurrent=true ]

    2025-09-05 11:27:58:798 (+0:00:00.000)

    {:id=>2254, :datasource_id=>1, :remote_id=>1611069270, :last_seen=>2025-09-05 04:28:09 UTC, :created_at=>2018-04-05 04:31:05.227 UTC, :deleted=>true, :updated_at=>2025-09-01 13:00:20.44 UTC}

    2025-09-05 11:28:01:205 (+0:00:00.250) DEBUG: Updating last_seen on computer 1611069270 to 2025-09-05 11:13:52 UTC.

    2025-09-05 11:28:01:205 (+0:00:00.000) DEBUG: Updating last_seen on computer 549537885 to 2025-09-05 11:17:05 UTC.

    2025-09-05 11:28:01:205 (+0:00:00.000) DEBUG: START Updating statistics for table [computers_persistent]

    2025-09-05 11:28:01:252 (+0:00:00.047) DEBUG: END Updating statistics for table[computers_persistent]

    2025-09-05 11:28:01:252 (+0:00:00.000) DEBUG: START Updating statistics for table [computers_scd]

    2025-09-05 11:28:01:267 (+0:00:00.015) DEBUG: END Updating statistics for table [computers_scd]

    I could not see any duplicities, maybe you could find out something, so I am attaching the debug log of this Import.

    Computers with issues are 1611069270 - luu1383o and 549537885 luu3312t



    ------------------------------
    JAN FLEGR
    ------------------------------

    Original Message


  • 4.  RE: Computers visible in BigFix are not visible in ILMT

    Posted 09/06/25 05:34 AM

    Hello Jan,

    Please ask forum moderator to delete that Import log as this is a public forum.
    That Import log file could contain some potentially confidential data.

    As to the import process it all looks good.
    Something else is going on....


    I'd start with checking the output from following SQL queries:
    select * from dbo.computer_dimension where name like '%luu1383o%'
    select * from dbo.computers where id in (select computer_id from adm.computer_hw where hostname like '%luu1383o%')
    select * from dbo.computers where remote_id = '1611069270'

    Please send me the output through direct Email or by Support ticket.



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

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

    Original Message


Related Content