How to find which computer removed the software from SCCM imports

[rahul16]

The above image is a record of SCCM imports from the table sn_sccm_integrate_sccm_2019_removed_software.

How to find which computer has uninstalled or removed the pycharm software.

[shloke04]

Hi,

You should be able to find the computer data by following the steps below to know from which machine the software was removed:

1) Navigate to CMDB CI table by typing "cmdb_ci.LIST" from Application Navigator search

2) Now put a filter as Correlation ID is your Resource ID shown in screenshot above.

This will give you unique computer record as shown below:

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[shloke04]

Also to note here is if you are using the new Service Graph connector for SCCM then I don't think the above approach will work as Resource ID gets mapped to in sys_object_source table directly.

So you need to follow below steps in case of Service graph connector:

1) Navigate to "sys_object_source" table by typing "sys_object_source.LIST" as shown below:

2) Hot enter in your keyboard and then search Resource ID shown in your screenshot above in ID field as shown below:

Now as soon as you run this filter this will give you the target computer record from where the software was removed. You need to open the record mentioned in Target field as shown below:

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[rahul16 · Accepted solution]

or we can get data from sn_sccm_integrate_sccm_2019_computer_related or sn_sccm_integrate_sccm_2019_computer_related.LIST table