« Previous Next »

Thread: Selecting Server Event Log from Local machine

Last post 06-09-2009 4:32 PM by Solburn17. 3 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (4 items)

Sort Posts:

  • 04-11-2009, 10:14 AM

    • cci
    • Not Ranked
    • Joined on 04-11-2009, 10:03 AM
    • Posts 9

    Selecting Server Event Log from Local machine

    This question has been asked before but not answered.  I am an admin and would like to query the security log on our server from my workstation. Assuming the simplest

     "SELECT * FROM SERVER,Security"

     or

    "SELECT * FROM \\Server\c$\windows\system32\config\SecEvents.evt"

    I will get an error that the file is being used by another process. I saw the last person who asked this question just gave up, assuming it couldn't be done. So, is that true?

     TIA, stan

  • 04-11-2009, 7:32 PM In reply to

    Re: Selecting Server Event Log from Local machine

    Try select * from \\server\security assuming your account has permissions on the remote box.

    Steve Schofield
    Windows Server MVP - IIS
    http://weblogs.asp.net/steveschofield


    http://www.IISLogs.com
    Log archival solution
    Install, Configure, Forget
  • 04-12-2009, 7:06 AM In reply to

    • cci
    • Not Ranked
    • Joined on 04-11-2009, 10:03 AM
    • Posts 9

    Re: Selecting Server Event Log from Local machine

    Yeah, my bad...  actually the security log was so large the script was timing out. I did a little refining and all is well. Stan

  • 06-09-2009, 4:32 PM In reply to

    Re: Selecting Server Event Log from Local machine

     Perfect, just what I was looking for...

     How to do a From Remote Server \ Event.

    Thanks!

Page 1 of 1 (4 items)
Microsoft Communities