how to find a mac address in sccm web tools

GM.InvHistor圜lassName, GAM.AttributeName,įROM v_GroupMap GM INNER JOIN v_GroupAttributeMap GAM The following query joins the v_GroupMap and v_GroupAttributeMap to generate the hardware inventory view schema, based on the specific settings for the site: SELECT DISTINCT GM.DisplayName, GM.InvClassName, Both views can be joined together by using the GroupID column and joined to the v_ResourceMap discovery schema view by using the ResourceType column.īecause hardware inventory can be extended, one Configuration Manager site's SQL Server database might have different hardware inventory views and schema when compared to another site. The v_GroupAttributeMap view contains all of the attributes that are inventoried for each of the groups. The v_GroupMap view contains a list of all the hardware inventory groups and the associated view for each of the groups. Most of the client data within Configuration Manager is contained in one of the two hardware inventory schema views: v_GroupMap and v_GroupAttributeMap. The hardware inventory schema is important to understand when creating queries for Configuration Manager reports. Because of this, it is likely that Configuration Manager sites collect different hardware inventory resulting in different hardware inventory views.įor more information about extending Configuration Manager hardware inventory, see How to extend hardware inventory in Configuration Manager.

Many hardware inventory views are created in Configuration Manager by default, and many more can be enabled or creating classes by using the hardware inventory classes dialog box, accessible from client settings.

The hardware inventory views contain information about the computer hardware scanned on Configuration Manager client computers.

How to find a mac address in sccm web tools