Archive for August, 2007

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
call checkpendingstatus sub CheckPendingStatus Set ComputerStatus = CreateObject("Microsoft.Update.SystemInfo") If ComputerStatus.RebootRequired Then wscript.echo "This computer has a pending reboot." Else wscript.echo "this computer does not have a pending reboot." End If End sub
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: strPATHout = "C:\pingstatus.txt" strPATHin = "C:\pinglist.txt"
SELECT ProductName0 AS Product, VersionMajor0 AS Version, COUNT(*) AS Count FROM dbo.v_GS_INSTALLED_SOFTWARE GROUP BY ProductName0, VersionMajor0 HAVING (ProductName0 = 'winzip')
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.