veritas:Just what I need. The ability to use variables for server and instance above so I can point at any of my production servers would be good
I’m using log parser lizard mainly for statistics on IIS logs, event logs and active directory and for parsing log4net logs with regular expressions for system diagnostics. I don’t have much experience in parsing textline and tab separated files. But you can try to set ‘options’ in the query. Ex:
select top 500 substr(text,0,22) as Date, substr(text,23,9) as Source, substr(text,32) as Message from '\\#SQLSERVER#\c$\#INSTANCE#\LOG\ERRORLOG' where Message not like '%Log backed up%' and Message not like '%DBCC TRACEON%'and Message not like '%Login failed%' and Message not like '%Database backed up%' and Message not like '%Database log truncated%'and Message not like '%DBCC CHECKDB%'
and add SQLSERVER and INSTANCE in program options (on the toolbar).
veritas: Just That should have said of course that when I try to set it up in Log Parser Lizard I get the error. It doesn't give the error on first entering the properties but it doesn't seem to save them and gives the errors on exit
I can see that there are some issues and bugs when changing the type of a saved query and his properties :(, but I believe that there is workaround (delete the old query and copy-paste to the new one) until I fix them. Thank you for pointing them out. I will fix them as soon as possible.
kcb263: this looks like a nice tool. Unfortunately I keep getting "Attempted to read or write protected memory. This is often an indiction that other memory is corrupt."
I am using LPL on a Win XP SP2 and Win 2003 Server. I very rarely have this kind of messages. Mainly when I am selecting groups from Active Directory with a lot of members and try to scroll up/down :(. Can you specify a bit more about conditions under which you have these messages?
Please don’t curse the programmer for the bugs.