Identify and monitor the boundary configurations of your SCCM site. Alas, the boundary group Cmdlets just aren't there yet. Review Audit Status Messages with SCCM SSRS Reports. I'd need to run that report a couple hundred times and then group all the results by boundary group later. The canned report didn't fit my need exactly. 40503 User "INTUNE\anoop" created Boundary Group Relationships "16777218" "16777217" . This was the introduction of boundary group caching where clients cache the name of their current boundary group. Working with SCCM 2012 R2 and SCCM 2016, there are PowerShell cmdlets to export several types of objects from System Center Configuration Manager (SCCM). One of those is while upgrading the OS on all the Site Servers pre SCCM upgrade. ... . This query pulls a list of all boundaries within SCCM, then does a count of clients in each boundary. Rather than try to re-invent the wheel I thought I'd ask here. Boundary group changes started in the initial release of Current Branch, 1511. left join vSMS_Boundary as sys4 on sys3.BoundaryID=sys4.BoundaryID where sys1.GroupID=sys3.GroupID for XML path(”)) as ‘Boundary’, sys1.ModifiedOn, sys1.ModifiedBy from vSMS_BoundaryGroup as sys1. CommandType Name Version Source Cmdlet Export-CMAntimalwarePolicy 5.0.8373.1189 ConfigurationManager Cmdlet … There are four options to recover SCCM IP details of each boundary along with boundary groups details.Any one of these steps will help you to recover the list of SCCM boundary IPs and groups. A hierarchy can include any number of boundary groups. After some research It started to dawn on me that this would not be an easy task. This meant that the management point (MP) no longer needed to look up a client’s boundary or boundary group for client’s content requests. SCCM SQL Query to list IP Subnets of … 40501 User "INTUNE\anoop" modified Boundary Group "Test1". I went ahead and created this SSRS report that should show the relationship of a Boundary Group to Boundaries and the Boundary Group to […] Display all your boundaries and boundary groups in a single view. I wanted to know the total systems in each boundary group, each of which is made up of several subnet boundaries. As per Microsoft, a boundary is a network location on the intranet that can contain one or more devices that you want to manage. Boundaries can be either an IP subnet, Active Directory site name, IPv6 Prefix, or an IP address range. What are the options to recover the SCCM CB boundary and SCCM CB Boundary group details? Boundaries and Boundary Groups in SCCM. Boundary groups are logical groups of boundaries that you configure. With lots of tables and views in the DB, I'm trying to find a needle in a haystack. Has anyone tried creating a report which lists workstations by Boundary group? Each boundary group can contain any combination of the following boundary types: There are two ways to access SSRS reports. Here are a few examples of SCCM objects that support exporting. To use a boundary, you must add the boundary to one or more boundary groups. These locations include devices that you want to manage. Boundaries in Configuration Manager define network locations on your intranet. I have always found the need of good reports especially while upgrading or migrating environments. You'll notice that I've placed an additional JOIN statement to connect the v_GS_SYSTEM_ENCLOSURE table, which will help us in the next two reports. T his all started with a simple boundary review when I figured It might be handy to have a boundary report. This query just does all the work for me and spits out what I need. 40600 User "INTUNE\anoop" created Boundary "IPS". I'm trying to figure out if I can generate a report which would show PCs in a region - in effect listing assets by region. SCCM Report - Client count by boundary ... Group By R.AD_Site_Name0. Got to have this report for boundaries review :) Report release history.