How are Software Discovery Models created?

[snow_04]

Hi,

OOB Software Discovery Models gets created automatically based on the data being discovered and stored in Software Installations Table. But for us Software Discovery Models for some Product are not getting created even if the data is present in Software Installations table.

Is there an particular function or script accessible to us which needs to be debugged to fix this.

Kindly assist!!

[mikewhalley]

My recommendation is to create and submit a HI ticket.

[Daniel Slocum]

The following Business Rule on the Software Installation table creates a Discovery Model or links the newly inserted Software Installation record to an existing Discovery Model. 

Create a Software Normalization

This is a Before business rule.  The issue you describe could be caused if the Busines Rule completed but there was an error completing the insert of the Software Installation record. 

As Mike suggested, a HI Incident may be useful in determining the root cause.

[snow_04]

Thanks a lot Daniel and Mike.

Will contact the ServiceNow HI Team before making any changes to OOB Business Rule.

One other issue say when a Software is removed from a Physical Device, it's getting removed from SCCM as well, but the same is not getting deleted from Software Installations table which is causing a data count conflict for us.

Any inputs on this would be really helpful.

[Chad Peterson]

Hi, 

Reference this community answer here. 

New versions of SCCM 1906 and higher will most likely continue to have this issue,  Triggers are getting deactivated by Microsoft for the two dedicated tables. I've dealt with this at clients in recent past as well.  Have your SCCM team re-enable the triggers on the two tables below if they are disabled. 

SCCM_Ext.Add_Remove_Programs_DATA_DD

SCCM_Ext.Add_Remove_Programs_64_DATA_DD)t

https://community.servicenow.com/community?id=community_question&sys_id=8b7f1198db380c546064eeb5ca96...