SQl query to find details about boundaries

Posted on Posted in SQL Query

SQL query to find details about boundaries

Today i am sharing the SQL query to find details about boundaries in SCCM. This query will help you to get the list of all boundaries with their details like its slow or fast.

select Name,Value,
Case
When Flags = 0 Then 'Fast'
When Flags = 1 Then 'Slow'
Else 'Unknown'
End
Connection,
Case
When BoundaryType = 0 Then 'IP Subnet'
When BoundaryType = 1 Then 'Active Directory Site'
When BoundaryType = 2 Then 'IPv6 Prefix'
When BoundaryType = 3 Then 'IP Address Range'
Else 'Unknown'
End
BoundaryType
from BoundaryEx order by Name

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *