sms2003

This script will change the sms cache size.Usage Example: cscript change-sms-cache.vbs 1000 d:Note: size is in MB

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

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:

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.