how to check if last update on a field is a certain user.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-15-2017 01:49 PM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-18-2017 07:00 AM
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.