Need to update the records instead of creating the records on software installation table

[Maradani Revat1]

Hi,

We get the software installation data from systrack and if we get a latest version of any software on the device, the old version data need to be set to disabled and new version record should be created.

For example, on Device xyz, if there is a Microsoft edge with version Microsoft edge 1.5 installed on 09/15/2025 and on 09/16/2025 Microsoft edge 1.6 is updated then in software installation table Microsoft edge 1.5 state should be disable to false and new record Microsoft edge 1.6 need to be created.

Can anyone please let me know how can we achieve this?

[mujeebqasimi]

yeah you can just handle this in the import/transform. when systrack sends a new record, check if that device + software already has an active one. if it’s an older version, flip it to inactive. then drop in the new record with active=true.

easiest spot is in the transform map (before/after script) or a business rule on the install table. that way every new version disables the old and adds the new automatically. keeps the history but makes sure only the latest stays active.

[MadhanMaddy]

Hi @Maradani Revat1 ,

There are multiple ways to achieve this functionality. The recommended which I think would be using Discovery which is main for use cases like these for identifying devices & model versions using jobs. 

Or else we have our very own old Integration. If you provide more details on this I can help you with the Integration on how this can be achieved.

Please Mark this as Accepted or Give a like if this helped you in anyway. 

Thanks In Advance.