dreinhardt
Kilo Patron

Hi @Patrick Quinlan,

I would recommend the following steps to test before raising a support case. We had a similar issue with the attributes and a full reset solved the problem for us.

 

1. Set Software Asset Management Properties "Enable scheduled jobs when using third party Datasource Integration Framework" to TRUE (you're using Discovery and SCCM)

2.  Reset the attributes "Active" to TRUE and "Deduplicated" to False in the [cmdb_sam_sw_install] table.

3. Execute the SAM job "SAM - Deduplicate Install Table"

4. Compare the results and raise a support case if necessary

 

 

ChatGTP snipped

// Initialize a GlideRecord for the cmdb_sam_sw_install table
var gr = new GlideRecord('cmdb_sam_sw_install');

// Add a query if you want to limit the scope of updates (optional)
// For example: gr.addQuery('active', false);

gr.query();

if (gr.hasNext()) {
    // Set the fields to be updated
    gr.initialize(); // Prepare for a bulk update
    gr.setValue('active', true);
    gr.setValue('deduplicated', false);

    // Perform the bulk update
    gr.updateMultiple();
    
    gs.print('Bulk update completed: Set "active" to TRUE and "deduplicated" to FALSE for all records.');
} else {
    gs.print('No records found to update.');
}

 

Best, Dennis

Should my response prove helpful, please consider marking it as the Accepted Solution/Helpful to assist closing this thread.