Logparser 2.2 from IIS://localhost/ on remote IIS server possible?

Posted on 2005-04-06
Last Modified: 2008-02-01
Is it possible to use logparser 2.2 from a jobmachine to run on remote IIS servers?

Normally we use the

SELECT .... FROM IIS://LOCALHOST/  syntax but we want to query an remote IIS server:   FROM IIS://[ip address] for example does not work

The error message:

Error retrieving object: "IIS://localhost/\\\": INVALID SYNTAX

is displayed

Is it possible to use logparser remote for this or must it be run on each IIS server locally?
Question by:petermolit
    LVL 13

    Accepted Solution

    Just checking, you aren't using "IIS://localhost/\\\" are you? You probably entered ""IIS://", correct? (strange error message :))

    Copied from "":
    You can do remoting in two different ways:

    a) Run Log Parser on box A and tell it to parse the logs on boxes B, C, and D: the way you do this depends on the input format that you'll be using, but basically it's only a matter of specifying the right FROM clause. For example, to parse remote IISW3C log files it would look like this:

    SELECT * FROM \\COMPUTERB\Logs\*.log,\\COMPUTERC\Logs\*.log,\\COMPUTERD\Logs\*.log

    The advantage here is that you run LP once and you get all the query results in a single place.

    b) Write a script that runs on box A and uses DCOM to instantiate the Log Parser objects on boxes B, C, and D: this way, the FROM clause needs to specify a local path, since LP will be running remotely. For example:

    var objLogQuery = new ActiveXObject("MSUtil.LogQuery", "COMPUTERB");

    var objRS = objLogQuery.Execute("SELECT * FROM C:\MyLogs\*.log")

    With this approach, you'll need to instantiate Log Parser for each remote box, and you'll have to run queries multiple times for each remote box.

    Hope this helps.
    LVL 13

    Expert Comment

    How'd it work out? :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    no14 challenge 14 46
    Simple (?) problem getting Rainbow Folders to run 6 73
    Excel object stays open 19 56
    powerN  challenge 3 35
    Purpose To explain how to place a textual stamp on a PDF document.  This is commonly referred to as an annotation, or possibly a watermark, but a watermark is generally different in that it is somewhat translucent.  Watermark’s may be text or graph…
    If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
    An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now