SCCM client

[clelanje]

HI

I am wanting to pull a report to see which computers SCCM client is installed on and which computers the client is not installed.
What would be the correct query for this?

Thanks

[clelanje]

Thanks so much

[esr]

We chose to setup two custom scans, and have a simple report to view the results

Scans (for 32 and 64 bit installs):
%windir%\System32\CCM\CcmExec.exe
%windir%\SysWOW64\CCM\CcmExec.exe


Report (includes servers and workstations):

Select Top 1000000 tblAssets.AssetID,
  tsysOS.Image As icon,
  tblAssets.AssetUnique,
  tblAssets.Username,
  tblAssets.IPAddress,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblFileVersions.FilePathfull,
  tblFileVersions.FileVersion,
  tblADComputers.OU
From tblAssets
  Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where tblFileVersions.FilePathfull Like '%CcmExec.exe' And
  tblFileVersions.Found = 'True' And tblAssetCustom.State = 1
Order By tblAssets.AssetUnique,
  tblFileVersions.FilePathfull

[Susan_A · Accepted solution]

You can scan a registry value associated with the client and then report on that value. Machines with the client installed should have a ProductVersion entry in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Mobile Client or HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\SMS\Mobile Client, from what I can find. You can scan this registry value with custom registry scanning. More information on this and a sample registry report can be found here.