Right clicking the device and going to Properties on the General tab there is a MAC Address listed. Sometimes those help when machines get stuck. I only want to get the LAN-adapters MAC-addresses in the report. You can also right click on the device in SCCM an clear PXE requests or even see if the Approve option is available. I'm gonna use the report for filling up my MDT database in Deployment Workbench, with system names and mac-adresses, that later will be used in OSD-tasksequence( in SCCM 2007) to assosiate Computers with Roles and Applications.
How to query a mac address in sccm serial#
This query will pull out the Computer Name, Serial Number, BIOS Version, IP and MAC Address. Below is the ConfigMgr Query that I used and also it's SQL equivalent. WHERE Sys.ResourceID = MAC.ResourceID AND Sys.ResourceID = IP.ResourceID AND MAC.MAC_Addresses0 LIKE BY MAC.MAC_Addresses0 I recently had to pull together some information on several servers and I made used of ConfigMgr in order to collate the information. SELECT Sys.Netbios_Name0,MAC.MAC_Addresses0, IP.IP_Addresses0 FROM v_R_System Sys, v_RA_System_MACAddresses MAC, v_RA_System_IPAddresses IP I know that the IP-address comes from the Wifi-card (in case the computer is only connected to Wifi) but it is the LAN-cards MAC I want. If you want to import an existing query to use as a basis for the new. On the General tab of the Create Query Wizard, specify a unique name and, optionally, a comment for the query. On the Home tab, in the Create group, select Create Query. In the Monitoring workspace, select Queries. In SCCM 2007 there is a report (ID 37-Network) named, "MAC - Computers for a specific MAC address.ĭepending on the type of network, it sometimes shows the Wifi-cards MAC-address and sometimes the LAN-cards MAC-address. In the Configuration Manager console, select Monitoring.
0 kommentar(er)
