| Author |
|
MrGibbage
Super User
Joined: October 23 2006
Location: United States
Online Status: Offline
Posts: 513
|
| Posted: December 20 2009 at 09:09 | IP Logged
|
|
|
I can't seem to find any documentation or anything
pertinent here in the forums on filtering the event log.
When you press the "Filter" button, you are presented with
a dialog that looks like it is quite powerful, but I can so
far only write expressions that don't evaluate or
expressions that actually evaluate yet return nothing. So,
let's start simple. How would I filter my log to show
where the "Type" is "Macro"?
|
| Back to Top |
|
| |
MrGibbage
Super User
Joined: October 23 2006
Location: United States
Online Status: Offline
Posts: 513
|
| Posted: December 21 2009 at 20:01 | IP Logged
|
|
|
No one has tried filtering their event log???
|
| Back to Top |
|
| |
MrGibbage
Super User
Joined: October 23 2006
Location: United States
Online Status: Offline
Posts: 513
|
| Posted: December 22 2009 at 21:03 | IP Logged
|
|
|
Dave?
|
| Back to Top |
|
| |
judetf
Senior Member
Joined: January 23 2008
Online Status: Offline
Posts: 234
|
| Posted: December 26 2009 at 10:54 | IP Logged
|
|
|
I'm no expert, but if you filter "type = 8" you will filter for macros.
I determined this by opening up the multi-editor and running this SQL command: select * from eventlog
That result set shows everything in the event log, and lets me see that the lines where macros run are 'type' 8, thus leading to the above filter.
The SQL command also reveals that the eventlog table only seems to contain a few columns, one of which is 'event' which appears to translate to the 'details' column you see when you open the actual event log. So, I thus figure I can try using the event log filter to filter on 'event'.
After a little trial and error I determined that the filter is caps-sensitive, and so when I filter on "event like 'Macro%'" I get all event log entries that begin with "Macro".
That should hopefully be enough to get you started?
jtf
|
| Back to Top |
|
| |
BeachBum
Super User
Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880
|
| Posted: December 26 2009 at 11:15 | IP Logged
|
|
|
Sorry I didn’t beam in earlier. I’m not expert but:
SELECT * FROM EVENTLOG WHERE TYPE=30 OR TYPE=31
2 - IR
3 - INCOMING
4 - X10
8 - MACRO EXECUTED
9 - TIMED EVENT EXECUTED
10 - TIMED EVENT CREATED
11 - TRIGGER
12 - SEND KEYS
16 - GLOBAL
28 - USER MSG
30 - INCOMING INSTEON
31 - OUTGOING INSTEON
SELECT * FROM EVENTLOG WHERE EVENT = 'PLM'
SELECT * FROM EVENTLOG WHERE (EVENT LIKE '%04.BB.8F%')
__________________
Pete - X10 Oldie
|
| Back to Top |
|
| |
MrGibbage
Super User
Joined: October 23 2006
Location: United States
Online Status: Offline
Posts: 513
|
| Posted: December 26 2009 at 19:20 | IP Logged
|
|
|
This is so cool! I never really thought about hitting the
databases directly like that. Now I can do exactly what I
need to do. Awesome, guys! :)
I saw that web access was stored in a separate table,
"weblog". I then peeked around in there. I was wondering,
what other tables are there? I ran the "show tables" SQL
command, but that just gave an error. What command lists
all the tables here?
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome General
Topic: Filtering the Event Log
