The data in SCCM is from the various inventory and discovery options that you have set up. When you PXE, you should see the LAN MAC. Unless you’ve done something special in PXE, you can’t natively PXE using WiFi. You have option to get more details to pick from sms_r_system table or you can even join it with other tables to get more complex results.PXE and SCCM Inventory aren’t related. This is a pretty simple query which is pulling few properties. Input Query Value Window will appear and is prompting to enter Mac Address, provide the value and hit OK.Īnd here you can see the results of one of the most important information related to device. Right click the Query “ Find Mac Address of Device” and click on Run. This is the logic used to prompt for Macaddress which means it will ask you to end the value to get the results. You can see the “where” query is using #PRM: and ending with #.
Macaddresses #Ĭlick Next and complete the Create Query Wizard. Under Query Language, provide the following WQL Query Statement: select SMS_R_System.Name, SMS_R_System.Macaddresses, SMS_R_System.Build, SMS_R_System.BuildExt, SMS_R_System.OperatingSystemNameandVersion This will open the General Property of the Query Statement, click on Show Query Language. This will open Create Query Wizard, provide the name as “ Find Mac Address of Device”and click on Edit Query Statement. Under \Monitoring\Overview\Queries, right click the Queries and select Create Query. The query could be very simple to get the report displayed or we can also create a prompt to enter the value and get the report based upon the value provided. This is a powerful feature to create your own query. Navigate to \Monitoring\Overview\Queries, this is the place where you will find list of all inbuilt queries created as part of Configuration Manager installation. Create Query to find Mac Address in SCCM console I like this approach and uses this quite often. However, we have another approach as well by creating the query inside the SCCM console and get the results. Though this looks like a good way to find the Mac address. Once done, search for the Mac Address of the computer name by entering it under Search window. Just right click the column displaying properties and select MAC Address.
Usually it’s a simple process to find the Mac address of the device which can be done by opening Configuration Manager console and navigating to \Assets and Compliance\Overview\Devices. In this post I will show you how to create SCCM Query to find Mac Address of device.
0 kommentar(er)
