As per the title, this is for IIS7 and rather than manually trawling through the IIS Manager to find all the site ID numbers so that I can get to the log files, this command exports them to a spreadsheet / text file.

At the command prompt on the Windows Server – noting that you will probably need to run the Command Prompt As Administrator

[bash]

%windir%system32inetsrvappcmd list site > c:sites.xls

[/bash]

Then get the file by copying or whatever to a machine with Excel on it and open it up.