Setup was unable to compile Sql CE script file CIStateDBUpgrade.sqlce during CCM Setup

Recently I was troubleshooting a Windows 7 Service Pack 1 system where the CCM Client would not install manually or via push. The following was reported in the CCMSETUP.LOG:

I tried all my standard troubleshooting steps to resolve the issue, which included making sure all versions of the client were removed, attempting to repair …

SCCM Query to Get Screen Resolutions

I wrote the following queries to find the video resolutions used by clients reporting into SCCM. They currently only look at Windows Workstations 6.x (excludes servers, and also anything older than Windows Vista or whatever v7 ends up being), and only those who have submitted a hardware inventory in the last 30 days. Feel free …

Creating an SMS 2003 CCR within Excel

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.