A bit of code from MyITForum.com with a report that lists all collections for a specific machine. http://www.myitforum.com/forums/All_Collections_for_a_specific_computer/m_163312/tm.htm

A quick way to check and see all databases for your MS SQL server is to run the following...

I’m sure you’ve seen this error in your travels, here’s how to fix it: MSI: Setup failed due to...

Ever get this error: Response object error 'ASP 0251 : 80004005' Response Buffer Limit Exceeded Here’s the fix:

This vbscript pings machines from a text file: change the two variables for your input and output txt files:...

SELECT ProductName0 AS Product, VersionMajor0 AS Version, COUNT(*) AS Count FROM dbo.v_GS_INSTALLED_SOFTWARE GROUP BY ProductName0, VersionMajor0 HAVING (ProductName0 =...

Garth writes some very useful SMS web reports so I copy them here sometimes: http://smsug.ca/blogs/garth_jones/archive/2007/08/01/528.aspx

This is a “dashboard” report that shows the current SMS site status.

This report shows you the number of updates that were released each month for each product.