Ad Widget

Collapse

Symbol $ in eventlog Item

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • M. Tumenas
    Junior Member
    • Nov 2014
    • 5

    #1

    Symbol $ in eventlog Item

    I am trying to configure Item eventlog to monitor SQL server instances in event viewer. The key is like this:
    eventlog[Application,,"|Error|Critical","MSSQLSERVER",,,all]
    and it works just fine. But if I try to use a named instance for source it fails to retrieve any data. Example of named instance is like this:
    eventlog[Application,,"|Error|Critical","MSSQLSERVER$NAMED",,,all]
    I believe the issue is symbol $ . How do you handle it?
  • steveboyson
    Senior Member
    • Jul 2013
    • 582

    #2
    You could try to escape it, like "MSSQLSERVER\$NAMED". Don't know if that works.

    Comment

    • M. Tumenas
      Junior Member
      • Nov 2014
      • 5

      #3
      Originally posted by steveboyson
      You could try to escape it, like "MSSQLSERVER\$NAMED". Don't know if that works.
      Thank you, it works. How do you know about this escape character? I have not found it in a manual. Or maybe I was looking in a wrong direction?

      Comment

      • steveboyson
        Senior Member
        • Jul 2013
        • 582

        #4
        Backslash is always a common escape sequence.

        Comment

        Working...