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 …