MMS 2012– Simplify your Deployments

24th April 2012 13:03
Print Friendly

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

Tags:
Category: Configuration Manager, MMS 2012  |  Comment (RSS)

Comments (8):

  1. MMS 2012: CD-B351 Configuration Manager 2007 R3: Simplify Your Deployments Demo Content « « Chris Nackers BlogChris Nackers Blog says:
    24th April 2012 at 16:54

    [...] 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. [...]

    Reply
  2. MMS 2012: CD-B351 Configuration Manager 2007 R3: Simplify Your Deployments Demo Content « Nackers Consulting Services, LLC says:
    24th April 2012 at 16:54

    [...] 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. [...]

    Reply
  3. Rico Rosenlund says:
    27th April 2012 at 10:19

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

    Reply
  4. Kent Agerlund Kent Agerlund says:
    28th April 2012 at 06:35

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

    Reply
  5. Johan says:
    16th July 2012 at 08:23

    Hi Kent,

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

    Thanks!

    Johan

    Reply
  6. Stefanie says:
    7th August 2012 at 03:30

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

    Reply
  7. Eswar Koneti's Blog » Blog Archive » #SCCM / #Configmgr Script to Delete Expired Updates says:
    7th August 2012 at 14:27

    [...] 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/ [...]

    Reply
  8. Kent Agerlund Kent Agerlund says:
    10th August 2012 at 14:49

    The link has been updated, thanks for notifying me

    Reply

Leave a Reply

CAPTCHA Image
(required)