/
bgroups.asp
36 lines (31 loc) · 974 Bytes
/
bgroups.asp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
<!-- #include file=_core.asp -->
<%
'-----------------------------------------------------------------------------
' filename....... bgroups.asp
' lastupdate..... 11/30/2016
' description.... site boundary groups
'-----------------------------------------------------------------------------
time1 = Timer
PageTitle = "Boundary Groups"
PageBackLink = "cmsite.asp"
PageBackName = "Site Hierarchy"
SortBy = CMWT_GET("s", "BoundaryGroup")
QueryOn = CMWT_GET("qq", "")
CMWT_NewPage "", "", ""
%>
<!-- #include file="_sm.asp" -->
<!-- #include file="_banner.asp" -->
<%
query = "SELECT Name AS BoundaryGroup,GroupID,Description,DefaultSiteCode," & _
"MemberCount,SiteSystemCount,Shared " & _
"FROM dbo.vSMS_BoundaryGroup " & _
"ORDER BY " & SortBy
Dim conn, cmd, rs
CMWT_DB_QUERY Application("DSN_CMDB"), query
CMWT_DB_TABLEGRID rs, "", "bgroups.asp", "NAME^bdp.asp?gn="
CMWT_DB_CLOSE()
CMWT_SHOW_Query()
CMWT_Footer()
%>
</body>
</html>