Oct/070
Change SMS Cache Size
This script will change the sms cache size.
Usage Example: cscript change-sms-cache.vbs 1000 d:\
Note: size is in MB
Sep/070
All collections for specific machine
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
Aug/070
error code is 80070005
I’m sure you’ve seen this error in your travels, here’s how to fix it:
MSI: Setup failed due to unexpected circumstances The error code is 80070005
Aug/071
Response Buffer Limit Exceeded
Ever get this error:
Response object error 'ASP 0251 : 80004005'
Response Buffer Limit Exceeded
Here’s the fix:
Aug/070
WinZip count with version
SELECT ProductName0 AS Product, VersionMajor0 AS Version, COUNT(*) AS Count
FROM dbo.v_GS_INSTALLED_SOFTWARE
GROUP BY ProductName0, VersionMajor0
HAVING (ProductName0 = 'winzip')
Aug/070
VMware / MS VM / Real / Total Count
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
Aug/070
# of updates per month
This report shows you the number of updates that were released each month for each product.
