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

By | 2012-04-24T13:03:14+00:00 April 24th, 2012|Configuration Manager (SCCM), Events|12 Comments

About the Author:

Kent Agerlund

Microsoft Regional Director, Enterprise Mobility MVP. Microsoft Certified Trainer and Principal consultant. I have been working with Enterprise client management since 1992. Co-founder of System Center User Group Denmark in 2009.

Certified MCITP: Enterprise Administrator, MCSA+Messaing, and much more.

Member of: Microsoft Denmark System Center Partner Expert Team The Danish Technet Influencers program System Center Influencers Program.

12 Comments

  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. Rico Rosenlund April 27, 2012 at 10:19 - Reply

    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..??

    • Wood December 23, 2016 at 7:18 - Reply

      Ã…h, har aldrig bekantat mig med nÃ¥gon tagrygggad frosso, ser fram emot detta. Själv har jag precis börjat virka pÃ¥ en liten elefant, mönstret kommer frÃ¥n en väldigt fin blogg….

    • pokemon go gps hack for android February 24, 2017 at 18:57 - Reply

      salam kenal bro, kebetulan lampu depan gue dah kusam dan pecah, kalau ingin seperti diatas, kira2 dimana benerinnya dan harganya berapa ya? saya di tangerang…

  4. Kent Agerlund April 28, 2012 at 6:35 - Reply

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

  5. Johan July 16, 2012 at 8:23 - Reply

    Hi Kent,

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

    Thanks!

    Johan

  6. Stefanie August 7, 2012 at 3:30 - Reply

    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 August 10, 2012 at 14:49 - Reply

    The link has been updated, thanks for notifying me

  9. Rahul Jain March 3, 2016 at 10:46 - Reply

    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.

  10. hent mms | mobile-danmark September 29, 2016 at 15:57 - Reply

    […] Coretech Blog » Blog Archive » MMS 2012– Simplify your …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 …Kan du besøge hjemmesiden […]

Leave A Comment