Support for Removed Software functionality in Service Graph Connector for SCCM integration

[amitsharma]

Removed Software functionality in legacy SCCM integration (SCCM 2016 integration or older)
Removed Software functionality depended on following tables:
• ADD_ REMOVE _PROGRAMS_DATA_DD
• ADD_REMOVE_ PROGRAMS _64_DATA_DD
• INSTALLED_SOFTWARE_DATA_DD
Above tables were updated by database triggers inside SCCM, in Microsoft Endpoint Manager Configuration Manager/System Center Configuration Manager (SCCM) builds 1902 and newer, Microsoft disabled these triggers, breaking Removed Software functionality.

It is advisable for legacy SCCM integration customer to upgrade to Service Graph Connector for SCCM integration to utilize the support for Removed Software functionality. In Service Graph Connector for SCCM, Removed Software has been reimagined and reimplemented

Removed Software functionality in Service Graph Connector for SCCM integration
• Current implementation Removed Software does comparison software instance/install on ServiceNow instance with SCCM and removes those from the CMDB that are no longer in SCCM. For comparison it uses following attribute for matching software instance/install
     o Publisher
     o Software name
     o Software version
     o Resource Id
• There is no dependency on database triggers or other SCCM-side extensions
• No longer dependent on SCCM Group ID
• Will cleanup SCCM 2016 installed software records too**
• Works with both cmdb_software_instance and cmdb_sam_sw_install

** Important note: Removed Software only assesses computers still in SCCM. If a computer is removed from SCCM, we expect that IT lifecycle management will act on the Computer CI. Changing the Computer Status to Retired will remove all SAM Software Installs for the CI in the CMDB, via Business Rule “Remove Installs for Retired/Stolen CI “. This is outside the scope of SG-SCCM. Also operating system related record created by legacy SCCM integration are not cleaned.

Troubleshooting Removed Software functionality in Service Graph Connector for SCCM integration
After running ‘SG-SCCM Removed Software’ scheduled data import software instance/install on ServiceNow instance will be expected to be synchronized with SCCM.
To check what software instance/install is deleted open import set table name sn_sccm_integrate_sccm_2019_removed_software [SG-SCCM Removed Softwares]
associated with ‘‘SG-SCCM Removed Software’ data source. This import set table has one row associated with each Computer CI.
An example records shown in following figure.

• Names: This field shows currently installed software (as partial Source Native Keys for Software Install – concatenation of Publisher, Software Name and Software Version)
• ResourceID: This field shows Computer’s Resource ID
• Comments: This field shows count and name of software instance/install is deleted.

[Lee Ring]

In my environment, all comments show: "Computer CI not found for computer source native key:<nnnnn>|null" where nnnnn is the resource id.  Is this an issue in the SCCM data or in the transform?

Thanks for any guidance.

[jgates]

If you are using Service Graph Connector for Microsoft SCCM version 3.0 or later it may be an issue with multi-instance.

By default there are OOTB scheduled imports such as the one below.  These are NOT supposed to be used as they do not populate the connection alias.

Instead, when you go through the guided setup and add a connection alias via flow designer. 

It will create new scheduled imports for that connection such as the example below that populates the connection id via the pre script.

These are the scheduled imports that need to be run.

[shivani42]

Hello All,

I have seen in my instance. Where the removed software import ran and deleted some of the records. When i checked in SCCM these records are still available. I checked in stagging table sn_sccm_integrate_sccm_2019_removed_software_list with the resource iD of the CI. I found in names column the software is available but in installation table, these are not available.

For example- I saw WinRAR software is not available in installation table, but it is available in name field value of the same CI in sn_sccm_integrate_sccm_2019_removed_software_list table.

Any idea about it??