Software installation Table Updates

[loberle]

Hello,

I am wondering how the software installation table is updated after the records are brought in from discovery..(cmdb_sam_sw_install)

It appears if I delete a CI, then the software installations tied to that record are also deleted. So there is some sort of connection.

If the CI is moved to disposed, are the software installation records tied to that CI also deleted? 

What happens if the CI simply moves back to inventory? Or the machine is re-imaged? 

Is there a way to create a rule that states if the CI meets criteria XXXXX, then remove all of the software installations records from the table.

Thanks

[Mike Condon · Accepted solution]

Hi,

  I can provide some guidance for you:

If the CI is moved to disposed, are the software installation records tied to that CI also deleted? 

• No, you need to create business rules to handle this

What happens if the CI simply moves back to inventory? Or the machine is re-imaged? 

• Discovery/SCCM will re-add it and any new software

Is there a way to create a rule that states if the CI meets criteria XXXXX, then remove all of the software installations records from the table.

• Yes. You could setup a rule to remove the software installations from a device that is returned to stock. That way when its deployed again, new installations will be created.   

Thanks

Mike

[loberle]

Thanks Mike!

So basically, I should create a rule that states if the CI is not active and in use, delete software installation records.