SMS inventory returns a large amount of information about your computers. Much of that information can be found in intuitively named classes. However, some commonly used data might be more difficult to find. Table 3.1 lists some commonly used data and where it can be found in SMS. For more information about commonly used data, see Chapter 3, "Advanced Inventory Collection."
|
Data
|
Inventory method
|
Property
|
Resource Explorer group
|
WMI class (for queries)
|
SQL Server view (for reports)
|
|---|
|
Computer Name
|
Hardware Inventory
|
Name
|
Computer System
|
SMS_G_System_COMPUTER_SYSTEM
|
v_GS_COMPUTER_SYSTEM
|
|
Computer role (server, for example)
|
Hardware inventory
|
SystemRole
|
System
|
SMS_G_System_SYSTEM
|
v_GS_SYSTEM
|
|
Any hardware details
(memory size, for example)
|
Hardware inventory
|
TotalPhysicalMemory
|
Memory
|
SMS_G_System_X86_PC_MEMORY
|
v_GS_X86_PC_MEMORY
|
|
Software configuration details (services, for example)
|
Hardware inventory
|
DisplayName
|
Services
|
SMS_G_System_SERVICE
|
v_GS_SERVICE
|
|
CPU type (such as Itanium)
|
Hardware inventory
|
ProcessorType
|
Processor
|
SMS_G_System_Processor
|
v_GS_PROCESSOR
|
|
CPU model (such as Pentium IV)
|
Hardware inventory
|
Name
|
Processor
|
SMS_G_System_Processor
|
v_GS_PROCESSOR
|
|
CPU speed
|
Hardware inventory
|
Current_Clock_Speed
|
Processor
|
SMS_G_System_Processor
|
v_GS_PROCESSOR
|
|
Operating system
|
Hardware inventory
|
Caption
|
Operating System
|
SMS_G_System_OPERATING_SYSTEM
|
v_GS_OPERATING_SYSTEM
|
|
SMS client type (Advanced Client vs. Legacy Client)
|
Discovery
|
ClientType
|
Not in the Resource Explorer. Available as a property of the resource.
|
SMS_R_System
|
v_R_System
|
|
Software installed via Add/Remove Programs
|
Hardware inventory
|
All
|
Add or Remove Programs
|
SMS_G_System_ADD_REMOVE_PROGRAMS
|
v_GS_ADD_REMOVE_PROGRAMS
|
|
Software inventory product details
|
Software inventory
|
All
|
Product Details
|
SMS_G_System_SoftwareProduct
|
v_GS_SoftwareProduct
|
|
Software inventory file details if product known
|
Software inventory
|
All
|
Product Details
|
SMS_G_System_SoftwareFile
|
v_GS_SoftwareFile
|
|
Software inventory file details if product not known
|
Software inventory
|
All
|
File Details
|
SMS_G_System_UnknownFile
|
v_GS_UnknownFile
|
|
Software inventory collected files
|
Software inventory
|
All
|
Collected Files
|
SMS_G_System_CollectedFile
|
v_GS_CollectedFile
|
|
Last software inventory collection date and time
|
Software inventory
|
LastScanDate
|
Last Software Scan
|
SMS_G_System_LastSoftwareScan
|
v_GS_LastSoftwareScan
|
|
Last file collection date and time
|
Software inventory
|
LastCollectedFileScanDate
|
Last Software Scan
|
SMS_G_System_LastSoftwareScan
|
v_GS_LastSoftwareScan
|
|
Last hardware inventory collection date and time
|
Hardware inventory
|
LastHardwareScan
|
Workstation Status
|
SMS_G_System_WORKSTATION_STATUS
|
v_GS_WORKSTATION_STATUS
|
|
Hardware history
|
Hardware inventory
|
All
|
Hardware History
|
SMS_GH_System_*
|
v_HS_*
|
|
NOIDMIF details
|
Hardware inventory
|
All
|
Group name from the MIF
|
SMS_G_System_ + the group class from the MIF
|
v_GS_ + the group class from the MIF
|
|
IDMIF details
|
Hardware inventory
|
All
|
Not applicable. Resource Explorer does not display non-system resources.
|
SMS_G_ + architecture name
|
v_Gn_ + the group class from the MIF, where n is the architecture number (as recorded in the ArchitectureMap table)
|
|
MOF details
|
Hardware inventory
|
All
|
SMS_Group_Name property in the reporting class definition
|
SMS_G_System_ + the second part of the SMS_Class_ID property in the reporting class definition
|
v_ GS_ + the second part of the SMS_Class_ID property in the reporting class definition
|
Any time included in inventory data is the local time at the client, without correction for differences in the time zones or daylight saving time between the server and the client.