SCCM Report: Site Boundaries

I wrote this simple report yesterday to list and search site boundaries: Report Name: SCCM Site Boundaries SQL Query: [sourcecode language=”SQL”] SELECT distinct v_BoundaryInfo.DisplayName AS [Boundary Name], Case v_BoundaryInfo.BoundaryType When 0 then ‘IP Subnet’ When 1 then ‘AD Site’ When 2 then ‘IPV6 Prefix’ When 3 then ‘IP Range’ End As ‘Type’, v_BoundaryInfo.Value AS [Value], v_BoundaryInfo.SiteCode AS [Site Code] From v_BoundaryInfo WHERE DisplayName LIKE @BoundaryName [/sourcecode]   Prompts: Name: BoundaryName Prompt Text: Boundary Name Prompt SQL Statement: [sourcecode language=”SQL”] begin if (@__filterwildcard = ”) Select DisplayName from v_BoundaryInfo order by DisplayName else Select DisplayName from v_BoundaryInfo where DisplayName LIKE @__filterwildcard

Continue reading
%d bloggers like this: