where to look up mac address in sccm properties

WHERE (SYS.Client0 = 1) AND (NOT (NETW.DefaultIPGateway0 = 'NULL')) AND (NOT (IP.IP_Addresses0 = 'NULL')) AND (NOT (IP.IP_Addresses0 = '0.0.0.0')) and (NET.AdapterType0 = 'Ethernet 802.

INNER JOIN dbo.v_RA_System_SystemOUName ON IP.ResourceID = dbo.v_RA_System_SystemOUName.ResourceID INNER JOIN dbo.v_RA_System_IPAddresses IP ON IPSUB.ResourceID = IP.ResourceID INNER JOIN dbo.v_GS_NETWORK_ADAPTER NET ON SYS.ResourceID = NET.ResourceID

INNER JOIN dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NETW ON SYS.ResourceID = NETW.ResourceID INNER JOIN dbo.v_GS_WORKSTATION_STATUS WS ON WS.ResourceID = SYS.ResourceID INNER JOIN dbo.v_R_System SYS ON IPSUB.ResourceID = SYS.ResourceID TOP 100 PERCENT SYS.Name0, IP.IP_Addresses0, NET.MACAddress0,WS.LastHWScan,NET.Description0 If you are looking for other articles on ConfigMgr I have a useful guide here, that will help you uninstall Visio 2013 using ConfigMgr.Try something like this as your SQL Query: The above query will find any clients that have laptop as the first part of their name. You should see the management network mac address displayed on the right hand side. Under the network configuration go to the properties of the vswitch that contains the managment network. You can modify the ConfigMgr query to pull back the information from specific clients by using: Using the vsphere client navigate to the network configuration for your host. I've put together a wee guide on how I implemented the query below:ġ - First of all I opened up my ConfigMgr console and navigated to the Monitoring tab and expanded 'Overview'.Ģ - Next I right clicked on Queries and selected 'Create Query'ģ - Selecting 'Edit Query Statement' nextĤ - Then I clicked on 'Show Query Language'ĥ - Within the dialogue box that appeared I typedĦ - I then clicked OK and named my Query, then completed the wizardħ - My query appeared within the Query list and I was able to Run it. I recently had to find the MAC Addresses of a bunch of servers that were managed by Configuration Manager (ConfigMgr) so I pulled together a simple query that would pull the information out of the database for me. These queries were last tested with Configuration Manager version 2006

Where to look up mac address in sccm properties