« Previous Next »

Thread: Compare fs listing against IIS listing

Last post 01-26-2007 12:30 PM by LogParser User : justSteve. 3 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (4 items)

Sort Posts:

  • 01-26-2007, 7:29 AM

    Compare fs listing against IIS listing

    I'm inheriting a very old IIS box...it's been thru a number of different masters and has lots of files no longer in use intermixed with active files.

    I can produce a listing of pages served by IIS and files found via FS...I bet there's a drop dead easy way  to do something like 'select name where [FSFiles] NOT IN [IISFiles] directly instead of importing both lists to tables and running from there.

    I'll bet a beer there's a drop dead easy way.

    [thankx for the tool...already owe the auther a 6pack.]

    --steve...

  • 01-26-2007, 8:01 AM In reply to

    RE: Compare fs listing against IIS listing

    I can't say as there is actually a drop dead easy way.
    Let me see if I understand exactly what you want.
    You want to run an LP query against the IIS log files to find out "active" pages, then you want to run another LP query against the FS input format to find files that are not in that "active" pages list?

    Because of the limitations in the current version of LP of not being about to do subqueries against different input formats (e.g. can't query FROM FS with a subquery that queries FROM IIS), you'll have to do some magic to get the list of active pages into your second query.

    I'd suggest using the TPL query generation method I documented in the General Discussion forum a while back. The first IIS query will output a list of the file names into a TPL format that is actually writing a new query that contains a where clause along the lines of:
    WHERE FileName NOT IN (
    'fn1.asp';
    'fn2.asp';
    'fn3.asp';
    )

    And then you run LP on that generated query.
  • 01-26-2007, 8:12 AM In reply to

    RE: Compare fs listing against IIS listing

    LogParser User : justSteve:
    Quote: I can't say as there is actually a drop dead easy way. Let me see if I understand exactly what you want. You want to run an LP query against the IIS log files to find out "active" pages, then you wa...

    Thanks for the quick reply...given this is a one off situation i'm probably best off importing to a couple sql tables. But it would be interesting to see real-world TPL samples.
  • 01-26-2007, 12:30 PM In reply to

    RE: Compare fs listing against IIS listing

    by "documented" I mean I made a post where I gave an example of using the TPL output format to create a SQL query file that is then run by LP. It's in the General Discussion forums
Page 1 of 1 (4 items)
Microsoft Communities