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 (9):

  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

  9. Rahul Jain says:

    Hi,

    I had downloaded your VB script which deletes all expired updates from the
    deployment package as per the package ID and then update the DP.

    So could you share the same script which do the below steps :

    For expired Updates and Superseded Updates Both

    1. clean update group (only the selected one)
    2. clean the deployment package (only the selected one)
    3. Update DP

    ​Thanks in advance for the same.

Leave a Reply