IDC说明文档
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
（一）系统前期建设已有功能ok 1．基础数据管理(需求重新规划)
经营单位信息
添加IDC/ISP经营单位信息，并查询添加结果
select t1.idc_id "IDC/ISP经营者ID",
t1.idc_name "IDC/ISP经营者名称",
t1.idc_add "IDC/ISP经营者地址",
t1.idc_zip 邮编,
t1.corp 企业法人,
t2.officer_name 网络信息责任人姓名,
t1.officer_id,
t3.officer_name 应急联系人姓名,
t1.emergcontact_offerid,
(selectcount(*)
from ct_d_house_info
where idc_id = t1.idc_id
and operat_flag <>3)机房数,
(selectcount(*)
from ct_d_user_info
where idc_id = t1.idc_id
and operat_flag <>3)用户数,
(selectsum(built_bandwidth)
from ct_d_house_info
where idc_id = t1.idc_id
and operat_flag <>3)建设带宽,
''操作
from ct_d_idc_info t1
leftjoin ct_d_officer_info t2
on t1.officer_id = t2.officer_id
leftjoin ct_d_officer_info t3
on t1.emergcontact_offerid = t3.officer_id
where t1.OPERAT_FLAG <>3
and t1.idc_id like'%%'
用户数据
select er_id 用户ID,
t.idc_id 所属IDCISP经营者ID,
(select idc_name from ct_d_idc_info where idc_id = t.idc_id)所属IDCISP经营者名称, case
when er_nature =1then
'提供互联网应用服务的用户'
when er_nature =2then
'其他用户'
endas用户属性,
er_unitname 单位名称,
t4.unitnature_desc 单位属性,
t3.idtype_desc 证件类型,
er_idnumber 证件号码,
t2.officer_name 安全责任人姓名,
er_add 单位地址,
er_zipcode 邮政编码,
t.register_time 注册时间,
(selectcount(*)
from CT_D_USER_SERVICEINFO
where idc_id = t.idc_id
and user_id = er_id)服务信息数,
(selectcount(*)
from ct_d_house_user_info
where idc_id = t.idc_id
and user_id = er_id)占用机房数,
''操作,
t.officer_id
from CT_D_USER_INFO t,
CT_D_OFFICER_INFO t2,
CT_D_IDTYPE t3,
CT_D_UNITNATURE t4
where t.officer_id = t2.officer_id(+)
and er_idtype = t3.idtype(+)
and er_unitnature = t4.unitnature(+)
and OPERAT_FLAG !=3
机房数据
select t.HOUSE_ID 机房ID,
t.IDC_ID 所属IDCISP经营者ID,
(select idc_name from ct_d_idc_info where idc_id = t.idc_id)所属IDCISP经营者名称, t.HOUSE_NAME 机房名称,
h.house_type_desc 机房性质,
p.province_desc 机房所在省或直辖市,
r.region_desc 机房所在市或区县,
ci.city_desc 机房所在县,
t.HOUSE_ADD 机房地址,
t.HOUSE_ZIP 邮编,
o.officer_name 信息安全责任人姓名,
o.officer_id UserID,
(selectcount(*)
from ct_d_house_ipseginfo
where idc_id = t.idc_id
and house_id = t.house_id) IP地址段数量,
(selectcount(*)
from ct_d_house_gatewayinfo
where idc_id = t.idc_id
and house_id = t.house_id)互联网出入口数量,
(selectcount(*)
from ct_d_house_frameinfo
where idc_id = t.idc_id
and house_id = t.house_id)机架数量,
built_bandwidth 建设带宽,
''操作
from ct_d_house_info t
leftjoin CT_D_HOUSE_TYPE h
on t.house_type = h.house_type
leftjoin CT_D_OFFICER_INFO o
on t.officer_id = o.officer_id
leftjoin cm_d_geo_province p
on t.house_province = p.province_id
leftjoin cm_d_geo_region r
on r.region_id = t.house_city
leftjoin cm_d_geo_city ci
on to_char(ci.city_id)= t.house_county
where(t.operat_flag =1or t.operat_flag =2)
and house_id in
(select list_id from role_user_ip_right whereid='390')
互联网用户
select a.idc_id "IDC/ISP经营者ID",
(select idc_name from ct_d_idc_info where idc_id = a.idc_id) "IDC/ISP经营者", er_id "用户ID",
a.service_id "服务ID",
decode(er_nature,1,'提供互联网应用服务的用户','其他用户') "用户属性", (SELECT user_unitname