Is this issue direct related to log parser lizard? It implies it is not if so and is a general log parser query then please start a new thread and don't hijack this one.
How do u pull the history of files from another computer on the network?
Here is the query that Lizard states I put the
\\networkComputer in the code but it won't work. Can somebody help me with this please.
Thanks in advance.
SELECT
TOP
20
EXTRACT_FILENAME(Path),
EXTRACT_PATH(Path),
DIV(Size,
1048576),
LastWriteTime FROM\\NetworkComputer c:\*.*
WHERE
LastWriteTime <
SUB(TO_LOCALTIME(SYSTEM_TIMESTAMP()),
TIMESTAMP('0001',
'yyyy'))
ORDER BY
DIV(Size,
1048576)
DESC
steve schofi...
5681 Posts
MVP
Moderator
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jul 13, 2010 02:36 AM|LINK
security event logs require you to be a local admin on the remote system. Is the account you are using is administrator?
Steve Schofield
Windows Server MVP - IIS
http://iislogs.com/steveschofield
http://www.IISLogs.com
Log archival solution
Install, Configure, Forget
skibo
7 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jul 13, 2010 04:12 PM|LINK
Yes, I have Verified that I am a local Admin on the Remote system.
Thank you for the repsonds.
Any more ideas that I might be doing wrong?
Rovastar
3321 Posts
MVP
Moderator
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jul 14, 2010 10:10 AM|LINK
Is this issue direct related to log parser lizard? It implies it is not if so and is a general log parser query then please start a new thread and don't hijack this one.
skibo
7 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jul 15, 2010 01:45 AM|LINK
skibo
7 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jul 15, 2010 01:47 AM|LINK
OK, For Everybody who Helped me here is the Code I was able to figure it out:
IN "Log Parser Lizard"
select * from\\skibohp-vf4b5cn.Tekworld.Tekworldusa\Security WHERE
EventID NOT IN (541;542;543) AND EventType = 8 AND EventCategory = 2
The Key is the EventType=8 NOT 1
Thanks to everybody who tried to help.
skibo
7 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jul 15, 2010 01:49 AM|LINK
Lizard Log Parser is an awesome Application, I highly recommend it.
skibo
7 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jul 15, 2010 07:25 PM|LINK
On log Lizard APP.
How do u pull the history of files from another computer on the network?
Here is the query that Lizard states I put the \\networkComputer in the code but it won't work. Can somebody help me with this please.
Thanks in advance.SELECT
TOP 20 EXTRACT_FILENAME(Path), EXTRACT_PATH(Path), DIV(Size, 1048576), LastWriteTime FROM\\NetworkComputer c:\*.* WHERE LastWriteTime < SUB(TO_LOCALTIME(SYSTEM_TIMESTAMP()), TIMESTAMP('0001', 'yyyy')) ORDER BY DIV(Size, 1048576) DESClizardlabs
40 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jun 06, 2011 02:34 PM|LINK
Hi to all! Just to say that a new version 2.0.0 of Log Parser Lizard released. Among the list of new features and improvements are:
You can download this version from here: http://www.lizard-labs.net/log_parser_lizard.aspx
Greetings to all users of MS Logparser and Log Parser Lizard :) Thnx.
qbernard
5016 Posts
MVP
Moderator
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jun 07, 2011 01:35 AM|LINK
Bernard Cheah
Edgar the Pa...
13 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jun 07, 2011 05:36 PM|LINK
Hello lizardlabs,
Thank you for the new version of the app! I have a question: Will our licenses acquired for version 1.9.1 work on this new 2.0.0 version?