Delete records from the Software Installations table after they are no longer visible in SCCM.

[MayurGavhane]

Hi All,

I want to know what happens in the CMDB table when assets are deleted or removed from the SCCM.

If asset 'Install Status' gets changed to 'In Stock' or 'Retired', or how we can understand that this asset is no longer in SCCM, then we can delete records from the 'Software Installations' table.

How can we delete records from the Software Installations table after they are no longer visible in SCCM?

There is an out-of-the-box 'Scheduled Script-(SAM - Remove Installations for retired or stolen configuration items)' Will that work as per our requirements?

Please help me find solutions to this, and let me know if you need anything else.

Thanks,

Mayur.

[Dr Atul G- LNG]

@AJ-TechTrek Any thoughts here.

@MayurGavhane 

As per my understanding there 2 mapping tables

If we remove, then as per these tables action will be taken.

[AJ-TechTrek]

Hi @MayurGavhane ,

Please refer the below articles, which may help.

https://www.servicenow.com/community/cmdb-blog/support-for-removed-software-functionality-in-service...

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024