Today's tidbit is another very easy one to implement and is something I change on all of my new Community Server installations. One of the great tools for site admins to use to troubleshoot issues is the Exception Report (Control Panel/Administration/expand Reports) should anything on your CS site start acting up...you can use the data in this report to help narrow down what's going wrong and why. By default, exceptions are ordered by the frequency of the exception which isn't all that useful in my opinion. A more useful order is newest on top, and to get this behavior a simple edit to a stored procedure is needed: Fire up your favorite SQL Server management tool and find the cs_Exceptions_Get sproc and change the following line
ORDER BY
E.Frequency DESCTo
ORDER BY
E.DateLastOccurred DESCYour Exception Report will now show exceptions in chronological order. If you aren't comfortable manually editing SQL, I've attached a file you can run from Query Analyzer to alter the sproc.



No comments yet