Will software record get deleted from Software installation table after software is uninstalled
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2022 12:51 AM
Hello ,
We have integrated Microsoft Intune and Jamf with Our ServiceNow instance, We are importing all computers and mobile information from these two connectors. Our query is if any software is uninstalled from any mobile/computer will that software record get deleted from software installation table(cmdb_sam_sw_install)?. We have noticed for one computer, One software in uninstalled from that computer, But that software record is still available in the software installation table but active install filed marked as 'false'.
Is this functionality working as expected or is it a bug? If it is a bug how to get it resolved? Please help
Regards,
Piroshan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-02-2024 10:47 AM
Hi @Piroshanrao
Can you please check this it might be helpful.
Maark it Helpful and Accept Solution!! If this helps you to understand.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2024 06:34 AM
It seems to me after all that the installations should not be deleted, cmdb_sam_sw_install is a table to dump data that will be reconciled after and if compliant only the installations that are being used will appear on the workbench. And active install serves for this: When the same software installation is discovered by multiple discovery sources, only one will be set to “active = true”. The remainder will be set to false. This is to avoid double-counting in reporting.
Mark Helpful and Accept Solution!! If this helps you to understand.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-18-2024 11:09 AM
Hi All,
Please see this article and this might help you around the questions on automatic software deletion in software installation table once uninstalled :
Understanding the inner details of software instal... - ServiceNow Community
Thanks,
Parul Chaudhary
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2025 06:20 AM
Yes, the Intune service graph connector does delete the Software Installation [cmdb_sam_sw_install] records.
You would be using one of these two scheduled data imports,
SG-Intune Software Reports
SG-Intune Software
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1641546
On both there is a post script that calls new IntuneIntegrationUtil().removeSoftware()
/nav_to.do?uri=sys_script_include.do?sys_id=6a4e0342773310102dfb23446810611c
Within removeSoftware(), sn_cmdb_int_util.RecordRemoval().removeRecords() is called.
/nav_to.do?uri=sys_script_include.do?sys_id=8c0f9c9f77a35110a52b1bfaae5a99d0
Amongst other queries in _RecordRemoval().querySysObjectSource(), the guts of it is,
Source [sys_object_source] . Last scan [last_scan] < Data Source [sys_data_source] . Last success import time [last_success_import_time]
To see a summary of delete counts search the syslog for messages starting with either of the following:
SGC_COMMON_UTIL_INFO : Number of records deleted -
IntuneIntegrationUtil: removeSoftware()
/now/nav/ui/classic/params/target/syslog_list.do%3Fsysparm_query%3Dsys_created_onONToday%40javascript%3Ags.beginningOfToday()%40javascript%3Ags.endOfToday()%255EmessageSTARTSWITHSGC_COMMON_UTIL_INFO%2520%3A%2520Number%2520of%2520records%2520deleted%2520-%255EORmessageSTARTSWITHIntuneIntegrationUtil%3A%2520removeSoftware()%26sysparm_first_row%3D1%26sysparm_view%3D
