How to find logs of table update
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-09-2015 12:47 AM
I have a situation where some entries have been added in Department table and I am not able to trace how they came there.
I have checked the transaction logs, but it doesn't show any log for a values got inserted.
Could anyone please suggest how to find that?
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-09-2015 08:46 AM
As far as i know, Service-Now doesn't retain logs for so long, still you can ask the HI team, if they can help you out in this issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-09-2015 08:19 AM
If the cmn_department table is being audited, then you'll be able to select the History, List menu option from the record header menu (the one you get when you right-click on the top header bar of the record) to find out the change history of the record. If you don't have auditing set on, then all you'll get is the Calendar with the creation and last update date.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-10-2015 02:57 AM
Thanks guys, but would that only be restricted to any configuration changes or would that also tell you when records were added to the table the last time. As I am looking for logs of records inserted in the cmn_department table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-12-2015 12:58 AM
If you're just looking for numbers inserted, a trend report on the Created date for Departments would probably give you what you need. You could then drill in to it to get a list of the departments created on particular days.
