SCCM’s Resource Explorer to SQL table mapping

System Center Configuration Manager collects a surprising amount of data from both Linux and Windows based client machines. Normally the collected data may be viewed through the SCCM utility Resource Explorer but the data exists within the SCCM database and may be queried against with SQL Reporting by directly. To create custom SQL reports, knowledge of which table holds related data is a requirement.

Note that mapping Machine Name to SCCM Resource Id occurs in the “System_Resource_N_ARR“ table.

HARDWARE (Linux)

Resource Explorer Category	SCCM SQL Table
Computer System	Computer_System_Data
Disk Drives	Disk_Data
Disk Partitions	Partition_Data
Installed Applications	Add_Remove_Programs_DATA
Logical Disk	Logical_Disk_DATA
Network Adapter	Netcard_DATA
Network Adapter Configuration	Network_DATA
Operating System	Operating_System_DATA
PC BIOS	PC_BIOS_DATA
Processor	Processor_Data
Services	Services_DATA
System	System_DATA
Workstation Status	WorkStationStatus_DATA

HARDWARE (Windows)

CD Rom Drive	CD_ROM_DATA
Computer System	Computer_System_Data
Configuration Manager Client SSL Configurations	SSL_Configuraions_Data
Configuration Manager Client State	SMS_Advanced_Client_State_Data
Desktop Monitor	Desktop_Monitor_Data
Disk Drives	Disk_Data
Disk Partitions	Partition_Data
IDE Controller	IDE_Controller_Data
Installed Applications	Add_Remove_Programs_DATA
Installed Applications (64)	Add_Remove_Programs_64_DATA
Logical Disk	Logical_Disk_DATA
Memory	PC_Memory_Data
Motherboard	Motherboard_DATA
NAP Client	NAP_Client_DATA
NAP System Health Agent	SYSTEMHEALTHAGENT_DATA
Network Adapter	Netcard_DATA
Network Adapter Configuration	Network_DATA
Network Client	Network_Client_Data
Operating System	Operating_System_DATA
Parallel Port	Parallel_Port_data
PC BIOS	PC_BIOS_DATA
Physical Memory	Physical_Memory_Data
PNP Device Driver	PNP_Device_Driver
Power Capabilities	Power_Management_Capabilities_Data
Power Management Exclusion Settings	?
Power Settings	Power_Management_Settings_Data
Processor	Processor_Data
Recently Used Applications	RecentlyUsedApps_data
SCSI Controller	SCSI_Controller_Data
Server Feature	server_feature_data
Services	Services_DATA
Sound_Devices	Sound_Devices_Data
System	System_DATA
System Console Usage	System_Console_Usage_Data
System Console User	System_Console_User_Data
System Devices	System_Devices_Data
System Enclosure	system_enclosure_data
USB Controller	USB_Controller_Data
User Profile Health	User_Profile_Data
Video Controller	Video_Controller_Data
Virtual Machine (64)	Virtual_Machine_64_Data
Workstation Status	WorkStationStatus_DATA