The report file ( Computers with IP SkipAsSource Info.rdl) can be found on my public OneDrive. I did this the easy way by using another report as a starting point, opening the report in Report Builder, save it as a new name, replace the existing Dataset T-SQL and drag the new columns into the Tablix. This will show all of the related data in the database and the same query can be used in SQL Server Reporting Services.Ĭreate a new SQL Reporting Service report with the T-SQL above. Select ResourceID, InterfaceAlias0, IPAddress0, Name0, SkipAsSource0 from CM_GS_MSFT_NETIPADDRESS
Most F5 VPN Edge clients receive an IP address with a mask 255. In Microsoft SQL Server Management Studio, connect to the CM_ database and run the query: Enter the servers name and then click on the Check Names button. Notice the values for Skip As Source, the IP Address, and the Interface Alias. If the inventory has completed processing, there will be a new node named MSFT_NetIPAddress which contains the new WMI properties. Right-Click the SCCM client used in testing and select Start \ Resource Explorer
On a SCCM client, run the Machine Policy Retrieval & Evaluation Cycle, wait about 2 minutes, then run a Hardware Inventory Cycle.īack on the SCCM Console, navigate to Assets and Compliance \ Overview \ Devices Select OK.Įnable / select the following properties: CreationClassName, Name, SystemCreationClassName, SystemName, Caption, Description, EnabledState, InterfaceAlias, IPAddress, IPv4Address, IPv6Adress, SkipAsSource (those in bold are required) Select the MSFT_NetIPAddress class by browsing for it or entering MSFT_NETIPAddress in the inventory class. Select Hardware Inventory, Set Classes, Add, enter root\StandardCIMv2 for the WMI namespace, enable Recursive, and select Connect Right-Click Default Settings and select properties In the ConfigMgr console, navigate to Administration \ Overview \ Client Settings To enable the custom inventory modify the Default Client Settings. It is also not populated in the root\CIMv2 namespace however, with a bit of help from MSDN, James Kehr, and I found the WMI Namespace, Class, and Property ( root\StandardCIMv\MSFT_NETIPAddress\SkipAsSource)īelow is a step-by-step configuring guide to capture and report SkipAsSource in ConfigMgr 2012 Enable Inventory This property is not available out-of-the-box in ConfigMgr 2012 R2. Here is where you add new hardware identifiers. On the Client Approval and Conflicting Records tab, under Duplicate hardware identifiers section, click Add button. On the Home tab, select the site and choose Hierarchy Settings.
SkipAsSource is a Boolean flag which allows adding new IP Addresses that should not be used for outgoing packages unless explicitly set for use by outgoing packets. In the Configuration Manager console, go to Administration > Overview > Site Configuration > Sites. A customer of mine was looking for a way to verify that servers with multiple IP Addresses (mostly web severs) were configured to use a specific IP for all default communications.
0 kommentar(er)
