alm_hardware table - Update field on an asset if field values changes for user in Assigned To

[Malin1]

Hi! 

On an Asset record in the alm_hardware table we set:

• Owned by same as the Manager of the Assigned To,
• Location the same as the Assigned To Location and
• Cost Center same as Assigned To.Cost Center 

This works fine at insert, i.e. when we assign an asset to a user, but if the user gets a new Manager and Cost center or changes location the change is not reflected on the asset. Therefore we now have Assets where Owned by and Manager of Assigned To, Cost center and location are different...

...so what is the best way to first find the asset record/s where we have different values and then update the asset record to be the same again?

Thank you 🙂

[Dr Atul G- LNG]

Hi @Malin1 

My understanding say, you need to run or trigger event , if the manager/cost center/location get change it update the records.

[Malin1]

Hi!

Yes correct. It is not crucial that is done real-time it could be done in a daily batch-job.

[Dr Atul G- LNG]

Yes, you can do via flow designer as well.