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.
Well, I lost everything on the site, so here we go with creating a new one. Hopefully I can start filling with some content pretty quickly, however I know that that’s not going to happen.
It really sucks I lost what I had…