Looking to report on data from the syslog table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-28-2012 02:00 PM
I'm looking to report on data stored in the system log.
The 2 tables I'm interested in are the Log Entry table (syslog) and the Transaction Log Entry table (syslog_transaction).
I've tried the using the regular report interface. In the report definition form, both of these tables are missing in the pick list for table.
I was able to get some data to parse thru with Perl on my local system. I entered the table name with .list appended in the filter box and got a list. I right clicked and exported the list via Excel and had it mailed to me. Several manual steps, ouch!
Is there any way to get this report in S/N's regular functionality?
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-28-2012 02:14 PM
http://wiki.servicenow.com/index.php?title=Reporting_on_System_Tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-31-2012 06:13 AM
But I had a very odd experience before seeing ther page.
I received the usual email notice about your reply and the link to the wiki page was in that email. When I clicked on the link (in the email message), I was taken to an empty page with text saying something to the effect that I could be the first to contribute to this page. I was just about to write a reply asking if you had even seen the page. And then I clicked on the link in this forum discussion, and it took me to the page with all the information I needed.
After some analysis, I noticed that the the system added some periods to the end of your URL, giving me a link with this value: "http://wiki.servicenow.com/index.php?title=Reporting_on_System_Tables..." When I removed the periods at the end, it worked too!
I'm glad I checked this out as I would have been extremely embarassed to erroneously point out that the page was blank, when it was not.
I'm passing this along so that you are aware of this side effect of replying with just a URL. Perhaps a space and a short sentence after the link would prevent this sort of thing.
That said, I am grateful that you passed the pointer along and am deciding if I should add the syslog table to the glide.ui.permitted_tables property.
THANK YOU!
