how to check if last update on a field is a certain user.

samadam
Kilo Sage

I need to find if the last update on a field is a certain user? This is on the cmdb_ci_computer table. I am looking at the audit table but I dont see a good way to figure out what is the last update for each ci record. any ideas?

5 REPLIES 5

samadam
Kilo Sage

This is a one time script as I have to pull data to verify the data on if the last update is by system or not. Even if I order by date there might be multiple entries for the same record so wondering on how to get just the last updated line from audit table for this one field.