In a previous post I listed SQL code that would list the GUIDs of SharePoint web applications. This is useful when tracking down Usage Analysis issues so you can easily match the folder GUIDs with the rows returned from the SQL query.

Well, hopefully now that there is a new update with fixes for URLs that are over 260 characters being processed by the Usage Analysis engine less troubleshooting will need to be done by SharePoint admins.

Anyway, here are the links the SharePoint Joel's blog post on the update, the link to the August 26 2008 MOSS update that addresses the issue and my previous post on how to query the web application GUIDs in the farm configuration database.