SCCM tips and tools

SCCM drivers injector - nice tool to grap drivers from specific computer


Cireson Remote Manage App - free application used to get information about sccm client information, display useful output at the bottom of window with WMI commands


Configrutaion Manager Support center - allows You to gather all sccm client logs, zip it, then You are able to open all of them (bundle) using support center viewer


CCM clean - nice old tool (link here)  to remove\repair sccm client

WMI query for computer model name and battery

wmic path win32_computersystemproduct get version

 wmic path win32_battery get status

SCCM database views

BIOS\wmi problems with  computer model name:

Version like ThinPad T540p or Lenovo product can be found:
v_GS_COMPUTER_SYSTEM_PRODUCT

Sample query to display also computer name from v_R_System view:
SELECT csp.ResourceID, csp.Version0, rs.Name0
  FROM [CM_KR1].[dbo].[v_GS_COMPUTER_SYSTEM_PRODUCT] csp inner join [CM_KR1].[dbo].[v_R_System]  rs on
  csp.ResourceID = rs.ResourceID

or WQL query for SCCM console:

select csp.Version, csp.ResourceID, rs.Name
from  SMS_R_System as rs inner join SMS_G_System_COMPUTER_SYSTEM_PRODUCT as csp
on csp.ResourceID = rs.ResourceId
where csp.Version = 'Lenovo Product'

hjhj