SAM - What is the OOB Behaviour of Software Installations (cmdb_sam_sw_install)

[Vishnu9]

Hello All

I need an understanding on how software Installation (cmdb_sam_sw_install) table works.

I have Software discovery enabled and I see multiple same software installation records for same CI getting created as new version is discovered, is this the expected behaviour?

What I need to know is, it possible to update existing software installation record for any upcoming subsequent updates without creating a new installation record ?

I have attached screenshot below for reference, Please provide you inputs!

Thanks 

[Manmohan K]

Hi @Vishnu9 

You are looking at the wrong column

The ci is stored in installed on field. 

There would be a duplicate only if multiple software record is created with same "installed on" CI for same software

[Vishnu9]

Yes the above list of records in attached image is installed on same device, but each record has difference only at version level.

Does difference in discovered version level , creates new installation record or updates existing installation record?

[Manmohan K · Accepted solution]

@Vishnu9 

Software installations are identified uniquely by their Display name, Version and Discovery source.

So only when the combination of the three attributes match with existing record, the record will be updated. Otherwise a new record will be created

[Vishnu9]

Thank You @Manmohan K for the solution.