SCCM Configmgr Report for Boundary group relationships with Fallback Sites

Beginning with Configmgr Version 1702, clients use boundary groups to find a new software update point. You can add individual software update points to different boundary groups to control which servers a client can find.

More information about boundary groups and its relation with  software update point changes in 1702 and 1706 ,please refer TechNet link  https://docs.microsoft.com/en-us/sccm/core/servers/deploy/configure/boundary-groups ,it has lot of information than i explain.

Few weeks ago ,i was looking at the boundaries and boundary groups that are configured for my environment with its fallback information (distribution point and software update point).

I find it hard to locate the boundaries that are configured with fallback distribution points and fallback software update point.Incase you want to know the list of boundaries/boundary groups that are configured with fallback options,there is no default report.

I have created SSRS report that will help to pull information from SQL database into nice reporting .

 

SNAGHTMLd278da3

 

References:

SNAGHTMLd2a7208

Relationships:

SNAGHTMLd296e8f

 

How does the report work ?

Download the report from Technet Gallary , upload the report into Configmgr SSRS reports folder,change the data source and run the report.

When you run the report, it prompt for Site Code since all the boundary groups that you created must have assigned to specific Site Code for site assignment. If you have not assigned the boundary groups to any specific site code, they will not be listed here .

So choose the Site Code (Primary or Secondary) or select All

SNAGHTMLd3ef980

Boundary groups that are assigned with specific Site Code will be listed with following information.

Boundary Group Name ,Site system Role,Site Code,Fallback Boundary Group,Fallback Site System,Fallback DP,Fallback SUP.

 

SNAGHTMLd48018b

4 Responses to "SCCM Configmgr Report for Boundary group relationships with Fallback Sites"

  1. Hi Eswar.

    Thanks for the report!
    I imported it with success to our Reporting Services but I'm getting this error after selecting the Site and click on run:

    The SELECT permission was denied on the object 'vSMS_BoundaryGroupRelationships', database 'CM_PT1', schema 'dbo'.

    Any ideas? I saw this similar post but not sure what to do...
    http://eskonr.com/2016/12/sccm-configmgr-how-to-find-applications-with-no-deployments-as-part-of-maintenance-tasks/

    Thanks for your help!

    Cheers,
    Pedro

    Reply
    1. Fallback SUP,fallback DP information do exist only in SQL view vSMS_BoundaryGroupRelationships .The report is created to pull the information from vSMS_BoundaryGroupRelationships. Bring this your SCCM admin or SQL admin who can provide read access to schema dbo .

      Regards,
      Eswar

      Reply
  2. Thanks Eswar for the report. The timing is great.
    The environment I'm working in at the moment has a single site. I had to modify the DataSet1 t-SQL a bit to get any results

    select A.[Boundary GroupName], A.[Site System Role], A.[Site Code]
    , A.DestinationGroupName [Fallback Boundary Group]
    , UPPER(SUBSTRING(bgss.ServerNALPath,13,CHARINDEX('.', bgss.ServerNALPath) -13)) [Fallback Site System]
    , A.[Fallback DP], A.[Fallback SUP]
    from (
    select bg.GroupID,bg.Name [Boundary GroupName] --, bg.DefaultSiteCode [Site Code]
    , case bg.DefaultSiteCode when '' then bgss.SiteCode else bg.DefaultSiteCode end AS [Site Code]
    , UPPER(SUBSTRING(BGSS.ServerNALPath,13,CHARINDEX('.', BGSS.ServerNALPath) -13)) [Site System Role]
    , bgrs.DestinationGroupName, bgrs.DestinationGroupID
    , case BGRS.FallbackDP when '-1' then 'No' when '120' then 'Yes' else NULL end as [Fallback DP]
    , case BGRS.FallbackSUP when '-1' then 'No' when '120' then 'Yes' else NULL end as [Fallback SUP]
    from vSMS_BoundaryGroup BG
    left join vSMS_BoundaryGroupSiteSystems BGSS on BG.GroupID=BGSS.GroupID
    left join vSMS_BoundaryGroupRelationships BGRS on bgrs.SourceGroupID=BG.GroupID
    where bg.DefaultSiteCode in (@Site) or bgss.SiteCode in (@Site)
    ) as A
    left join vSMS_BoundaryGroupSiteSystems BGSS on bgss.GroupID=A.DestinationGroupID
    order by 1

    Reply
    1. so you added defaultsitecode ? is that only change you did ? we dont use default sitecode for anything so i did not focus on this 🙂

      Regards,
      Eswar

      Reply

Leave a Reply