Provided here is a list of the SQL Views available for ConfigMgr 2007 to allow you to review your site(s) local and roaming boundaries information from SQL rather than viewing the Control file.
I have also listed the column names for each of the views as well for your reference and mine.
v_BoundaryInfo
Returns the BoundaryId, SiteCode, BoundaryType, Value, BoundaryFlags, DisplayName and Action
v_SiteBoundary_ADSite
Returns the SiteCode and ADSiteName
v_SiteBoundary_IPSubnet
Returns the SiteCode and IPSubnet
v_SiteRoamingBoundary_ADSite
Returns the SiteCode, ADSiteName, DownloadExecute and DisplayName
v_SiteRoamingBoundary_IPRange
Returns the SiteCode, StartingIP, EndingIP, DownloadExecute and the DisplayName
v_SiteRoamingBoundary_IPSubnet
Returns the SiteCode, IPSubnet, DownloadExecute and DisplayName
v_SiteRoamingBoundary_IPv6Prefix
Returns the SiteCode, IPv6Prefix, DownloadExecute and DisplayName
vSMS_CurrentBoundary
Returns the SiteCode, Value, BoundaryFlags, DisplayName and BoundaryType
Notes:
A DownloadExecute value of 0 is local and a value of 1 is remote.
The following simple SQL query syntax can be used to retrieve information form the views listed above: Select * From View_Name
The views v_SiteRoamingBoundary_IPv6Prefix and vSMS_CurrentBoundary are new to ConfigMgr 2007.
No Comments