#Ms report builder 2012 how to
#Ms report builder 2012 mac

Click on Table or Matrix in the middle of the main window.Д©.

Leave the default values on the rest of the settings on the Available Values, Default Values and Advanced pages.ДЁ. On the General page, give the parameter a name. Right click on Parameters and select Add Parameter.Д¦. Expand Data Sources and make sure that you have a dataset called AutoGet_xxxx_xxxx_xxxx_ (what replaced here by X is different for every setup).ДҐ. Click Next on the Summary page and complete the wizard.Д¤. Select SQL-based Report, give it a name and choose the Path to store the report in. Select the Reports node, right click and select Create Report.Дў. WeвЂ™re now going to create the custom report, and for this example IвЂ™ve chosen to create the report in the Hardware вЂ“ Network Adapter folder under Monitoring вЂ“ Reporting вЂ“ Reports.ДЎ. To this: _ystemSystem_MAC_Addres_ARR0.MAC_Addresses0 = changing this, weвЂ™ll get the value of a parameter called Create a custom report with parameters So IвЂ™ve changed the last part from: _ystemSystem_MAC_Addres_ARR0.MAC_Addresses0 = N'00:00:15:3D:44:01'

#Ms report builder 2012 mac

_ystemSystem_MAC_Addres_ARR0.MAC_Addresses0 = made a small change to the statement based on that we want to able to input a value for a MAC address in the report that we will create in a bit. 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.

#Ms report builder 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. 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.