Creating an SMS 2003 CCR within Excel

This post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author.

I created the following function to create Microsoft SMS 2003 Client Configuration Requests from within Excel and dump them all out into a temporary directory for me to copy to the SMS inbox. For those that are unaware, you can “ask” SMS 2003 to remotely install the client by putting a CCR file into the INBOXES\CCR.BOX folder on the SMS Site server.

Basically you just select your range of computer names, execute this sub, and it’ll let you know where the CCRs were generated (in a temporary folder). Just take a peek, copy them out to the CCR.BOX folder and (if SMS is setup correctly) you’re good to go!


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.