MMS 2012– Simplify your Deployments

Last week @MMS 2012 Chris Nackers and I had a session on how to review and simplify ConfigMgr 2007 deployments. We have received a lot of positive feedback after the session – thanks for that.

Scripts and utilities that we demonstrated

Script to remove expired updates from you distribution points and update packages
Example used in the session:
cscript.exe DeleteExpiredUpdates.vbs /SMSProvider:CM01 /PkgID:"A010000E" /AssignmentID:"1;2;3;4;5;6;7;

Coretech Shutdown Utility to control computer restarts after patching
Example used in the session:
/t:300 /m:60 /d: “You computer has not been restarted for a week\” /f /c /ebM:168

Script (ConfigMgr package) to uninstall software updates
Example used in the session:
cscript.exe UninstallUpdates.vbs 976902

Coretech Application Creator:
Example used in the session: Created a pacakge, collection, 2 programs, 2 collections and 2 Active Directory security groups

Change source location:
Example used in the session: Modified source location for packages prior to migrating packages to ConfigMgr 2012

Reports:

Reports to list last computer restart for Windows 7 clients:

SELECT os.Caption0 AS ‘Operating System’, cs.Name0 AS Name, DATEDIFF(hour, os.LastBootUpTime0, ws.LastHWScan) AS ‘Uptime (in Hours)’, CONVERT(varchar(20),
os.LastBootUpTime0, 100) AS ‘Last Reboot Date/Time’, CONVERT(varchar(20), ws.LastHWScan, 100) AS ‘Last Hardware Inventory’
FROM v_GS_WORKSTATION_STATUS AS ws LEFT OUTER JOIN
v_GS_OPERATING_SYSTEM AS os ON ws.ResourceID = os.ResourceID INNER JOIN
v_GS_COMPUTER_SYSTEM AS cs ON cs.ResourceID = os.ResourceID
WHERE (os.Caption0 LIKE ‘%Windows 7%’) AND (ws.LastHWScan <> 0) AND (cs.Name0 IS NOT NULL)
ORDER BY Name


Comments (8):

  1. [...] Kent posted all the content we demo’d in our session. In addition I’ve also linked everything below. Please let us know if we missed anything that we demo’d. [...]

  2. [...] Kent posted all the content we demo’d in our session. In addition I’ve also linked everything below. Please let us know if we missed anything that we demo’d. [...]

  3. Hi Kent

    First of all…great session in Vegas :-)
    I was there to experience it in person.

    In the session you also mentioned SCCMAutoDoc, but I can’t seem to find the tool anywhere.

    Can you help me out..??

  4. Kent Agerlund Kent Agerlund says:

    For information about SMSautodoc send a mail to the author – sccmautodoc@oscc.be

  5. Johan says:

    Hi Kent,

    Any other working link for the deleteexpiredupdates script…? The one provided doesn’t give it..

    Thanks!

    Johan

  6. Stefanie says:

    Your link for expired updates is no longer can you please repost.

  7. [...] This script is intended to remove all expired updates from a package or Deployment and was showed by the MVP Kent Agerlund on his presentation at MMS 2012 http://blog.coretech.dk/kea/mms-2012-simplify-your-deployments/ [...]

  8. Kent Agerlund Kent Agerlund says:

    The link has been updated, thanks for notifying me

Leave a Reply

CAPTCHA Image
(required)