→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
clelanje
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
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.

View solution in original post

3 REPLIES 3
clelanje
Engaged Sweeper
Thanks so much
esr
Champion Sweeper
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
Lansweeper Alumni
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.