which audit table stores asset data in servicenow

[reyservicenow]

Would it be the sys_history_line table? This table seems like it can be used for anything.

[reyservicenow]

Ok basically i shouldnt report on no audit tables?   due to the high volume information? Most likely if i do try to report on the sys_audit table then i would have to really set long filtered report to get to the specific record or just filter by the sys_id of the record and then filter by the field of the record apart from the sys id?  

[Jon Barnes · Accepted solution]

if you do report on the audit table, you will want to ensure you control what is being queried. I wouldn't open that up to the business users because they could query anything and bring down your instance completely. So, if you knew the business users wanted to track changes to a specific field in a specific table, you could create a report that only an admin can modify that would query for changes in that specific table/field combination.

If you decide to do that, I would be sure to add an index to the sys_audit table on the tablename, fieldname, and maybe sys_created_on columns in a composite index. Then, you can create your report to show any changes to that field and table in the last 30 days or whatever. I don't know if SNOW will be thrilled with that index because I imagine it will take up alot of space. Also, be aware that indexes will generally speed up your queries, but can slow down your inserts, and since there are alot of inserts on the sys_audit table, this could be a problem over time, but I don't know how much.

Also, if the client knows which table and field they want to report changes on, you may consider setting up a metric definition to track it, and then you can report on the metric instance table.

So, long story short, you do have options for reporting, but just have to be careful because the tables are so large.

have a look at this wiki article about reporting on system tables, if you decide to take that approach.

Reporting on System Tables - ServiceNow Wiki

[reyservicenow]

Ok well thanks for your answers and help!