We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

View Complete Thread
  • Re: New GUI tool for MS Log Parser, Log Parser Lizard

    Jul 15, 2010 03:25 PM|skibo|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) DESC