Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-04-2024 03:05 PM
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.