how to search for mac address in sccm 2012

How to search for mac address in sccm 2012 how to#
How to search for mac address in sccm 2012 update#
How to search for mac address in sccm 2012 software#

SMS_R_System.ItemKey = _ystemSystem_MAC_Addres_ARR0.ItemKey where SMS_R_System.User_Name0,SMS_R_System.AD_Site_Name0 The SQL query statement I’ll be using is the following: select distinct When executing this in-console Query I’m able to get the SQL query statement from the SMSProv.log file. Since we’ll be creating a custom report where we’re able to enter an input parameter, I’ve created an in-console Query that prompts for the MAC address value. What I want to do is to list the Computer Name, Last Logged on User and Active Directory Site based upon the results. In this example, I’ll create a custom report that accepts an input parameter for a MAC address to identify a computer.

How to search for mac address in sccm 2012 how to#

I’ll assume that you know the basics of how to create a custom report from the ConfigMgr console. In this post we’ll be using the method of creating a custom report for ConfigMgr 2012 with Report Builder, so please read my other post about how to get your hands on the SQL query statement if you havn’t already.

Now that we’re familiar with this process, let’s create a custom report where we want to enter some input to search for. The lesson learned here is if you are filtering the optional components, ensure you read any warnings that are shown and manually check the other required components.In my previous post about how to create a custom report in ConfigMgr 2012, I showed you a nice trick where you can create an in-console Query, execute it and then grab the SQL query statement from the SMSProv.log file.

How to search for mac address in sccm 2012 update#

Again you will be prompted to update the distribution points.Īllow this to complete and you will be provided with a window saying your boot image has been successfully updated. Powershell should still be listed, so click on the yellow star and search for 'NetFx' and select this and Click OK three times. Right click on the boot image that you wish to modify, select Properties and Optional Components. So click on Close on the failed distribution wizard. NET (WinPE-NetFx)' component that is needed alongside Powershell. The problem is that when you filter the optional components it hasn't automatically enabled the 'Microsoft. The Wizard will fail and offer the following error message: Click YES and the update Distribution Points Wizard will display, let the wizard run. If you click OK three times you will be prompted that you have made a change and you need up update the distribution points. A prompt will come up telling you that you need to enable 'Microsoft. If you type Powershell into the filter it will display three options, select 'Windows Powershell (WinPE-Powershell)'. Then click on Optional Components.Ĭlick on the Yellow star to add a component Right click on the Boot Image you wish to modify and click Properties.

How to search for mac address in sccm 2012 software#

To add Powershell support to your Boot Image, launch your SCCM Console and browse to Software Library > Operating Systems > Boot Images Let me walk you through the process, the error message and solution. 1401) and was looking to add Powershell support to my Boot Images but was constantly coming up against an error message. I am currently running SCCM 2012 R1 CU3 (version.