SCCM SQL Query : To Enumerate ConfigMgr 2007 Boundaries

Select 

Value,

SiteCode,

‘Boundary Type’ = 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,

DisplayName,

‘Connection’ = Case

When BoundaryFlags = 0 Then ‘Fast’

When BoundaryFlags = 1 Then ‘Slow’

Else ‘UnKnown’

End,

‘Protected’ = Case

When Action = 0 Then ‘No’

When Action = 1 Then ‘Yes’

Else ‘UnKnown’

End

From Boundary