Archive for August, 2014

Aug 13 2014

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 WMI, and even going as far as deleting the WMI repository, which is strongly discouraged by Microsoft, but is often a last resort. I also tried toying around with SQL Server Compact Edition, doing things like re-registering all the associated DLLs, but still no luck.


Aug 4 2014

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 to steal & modify.