Reviewing the Inventory Data
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."
Table 3.1 Inventory Data Type and Classification in SMS
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.
The Add or Remove Programs class or view can contain more items than Add or Remove Programs in Control Panel. This is because some items are marked as not being able to be removed with Add or Remove Programs, so they are not displayed to the users.
Note
- In some unusual cases, SMS might report values for properties, such as CPU type, that are not accurate. In most cases, SMS obtains the values from WMI. So in the case of CPU type, this might be due to the fact that the CPU type is newer than the version of WMI that you are running. Updating WMI (by updating the operating system, possibly with a service pack) might correct the inaccuracy. When first developing a report or other feature that depends on inventory data, you should review the data closely to ensure that no such issues apply to the data you are using.
For More Information
Did you find this information useful? Please send your suggestions and comments about the documentation to smsdocs@microsoft.com.