IDC说明文档

（一）系统前期建设已有功能ok1．基础数据管理(需求重新规划)经营单位信息添加IDC/ISP经营单位信息，并查询添加结果selectt1.idc_idIDC/ISP经营者ID,t1.idc_nameIDC/ISP经营者名称,t1.idc_addIDC/ISP经营者地址,t1.idc_zip邮编,t1.corp企业法人,t2.officer_name网络信息责任人姓名,t1.officer_id,t3.officer_name应急联系人姓名,t1.emergcontact_offerid,(selectcount(*)fromct_d_house_infowhereidc_id=t1.idc_idandoperat_flag3)机房数,(selectcount(*)fromct_d_user_infowhereidc_id=t1.idc_idandoperat_flag3)用户数,(selectsum(built_bandwidth)fromct_d_house_infowhereidc_id=t1.idc_idandoperat_flag3)建设带宽,''操作fromct_d_idc_infot1leftjoinct_d_officer_infot2ont1.officer_id=t2.officer_idleftjoinct_d_officer_infot3ont1.emergcontact_offerid=t3.officer_idwheret1.OPERAT_FLAG3andt1.idc_idlike'%%'用户数据selectt.user_id用户ID,t.idc_id所属IDCISP经营者ID,(selectidc_namefromct_d_idc_infowhereidc_id=t.idc_id)所属IDCISP经营者名称,casewhent.user_nature=1then'提供互联网应用服务的用户'whent.user_nature=2then'其他用户'endas用户属性,t.user_unitname单位名称,t4.unitnature_desc单位属性,t3.idtype_desc证件类型,t.user_idnumber证件号码,t2.officer_name安全责任人姓名,t.user_add单位地址,t.user_zipcode邮政编码,t.register_time注册时间,(selectcount(*)fromCT_D_USER_SERVICEINFOwhereidc_id=t.idc_idanduser_id=t.user_id)服务信息数,(selectcount(*)fromct_d_house_user_infowhereidc_id=t.idc_idanduser_id=t.user_id)占用机房数,''操作,t.officer_idfromCT_D_USER_INFOt,CT_D_OFFICER_INFOt2,CT_D_IDTYPEt3,CT_D_UNITNATUREt4wheret.officer_id=t2.officer_id(+)andt.user_idtype=t3.idtype(+)andt.user_unitnature=t4.unitnature(+)andOPERAT_FLAG!=3机房数据selectt.HOUSE_ID机房ID,t.IDC_ID所属IDCISP经营者ID,(selectidc_namefromct_d_idc_infowhereidc_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_idUserID,(selectcount(*)fromct_d_house_ipseginfowhereidc_id=t.idc_idandhouse_id=t.house_id)IP地址段数量,(selectcount(*)fromct_d_house_gatewayinfowhereidc_id=t.idc_idandhouse_id=t.house_id)互联网出入口数量,(selectcount(*)fromct_d_house_frameinfowhereidc_id=t.idc_idandhouse_id=t.house_id)机架数量,built_bandwidth建设带宽,''操作fromct_d_house_infotleftjoinCT_D_HOUSE_TYPEhont.house_type=h.house_typeleftjoinCT_D_OFFICER_INFOoont.officer_id=o.officer_idleftjoincm_d_geo_provincepont.house_province=p.province_idleftjoincm_d_geo_regionronr.region_id=t.house_cityleftjoincm_d_geo_citycionto_char(ci.city_id)=t.house_countywhere(t.operat_flag=1ort.operat_flag=2)andhouse_idin(selectlist_idfromrole_user_ip_rightwhereid='390')互联网用户selecta.idc_idIDC/ISP经营者ID,(selectidc_namefromct_d_idc_infowhereidc_id=a.idc_id)IDC/ISP经营者,a.user_id用户ID,a.service_id服务ID,decode(a.user_nature,1,'提供互联网应用服务的用户','其他用户')用户属性,(SELECTuser_unitnameFROMCT_D_USER_INFOWHEREuser_id=a.user_idandidc_id=a.idc_id)用户单位,a.hhid占用机房信息ID,a.house_idIDC/ISP机房ID,(selecthouse_namefromct_d_house_infowhereidc_id=a.idc_idandhouse_id=a.house_id)IDC机房名称,a.distribute_time资源分配时间,a.band_width网络带宽(M),a.VIRTUALHOST_ID虚拟主机ID,a.VIRTUALHOST_NAME虚拟主机名称,a.VIRTUALHOST_STATE虚拟主机状态,decode(a.VIRTUALHOST_TYPE,1,'共享式',2,'专用式',3,'云虚拟','无')虚拟主机类型,a.VIRTUALHOST_ADDRESS虚拟主机网络地址,a.VIRTUALHOST_MANAGEMENTADDRESS虚拟主机管理地址,(selectcount(*)fromct_d_house_user_ipseginfowhereidc_id=a.idc_idanduser_id=a.user_idandhouse_id=a.house_idandservice_id=a.service_idandhhid=a.hhidanduser_nature=1)IP地址转换信息组,a.FRAME_ID机架信息ID,f.FRAMEINFO_FRAMENAME机架信息名称,''as操作fromCT_D_HOUSE_USER_INFOaleftjoinCT_D_HOUSE_FRAMEINFOfonA.FRAME_ID=f.FRAMEINFO_ID,ct_d_user_infobwherea.user_id=b.user_idanda.idc_id=b.idc_idandb.operat_flag!=3anda.user_nature=1anda.house_idin(selectlist_idfromrole_user_ip_rightwhereid='390')选择多条基础数据，导出相关数据为XML、XLS等常见格式文件选择多条基础数据，批量删除相关基础数据信息其他用户selectdistincta.idc_idIDC/ISP经营者ID,(selectidc_namefromct_d_idc_infowhereidc_id=a.idc_id)IDC/ISP经营者,A.user_id用户ID,decode(a.user_nature,1,'提供互联网应用服务的用户','其他用户')用户属性,(SELECTuser_unitnameFROMCT_D_USER_INFOWHEREuser_id=a.user_idandidc_id=a.idc_id)用户单位,A.hhid占用机房信息ID,A.house_idIDC/ISP机房ID,(selecthouse_namefromct_d_house_infowhereidc_id=a.idc_idandhouse_id=a.house_id)IDC机房名称,to_char(distribute_time,'yyyy-mm-dd')资源分配时间,A.band_width网络带宽(M),(selectcount(*)fromct_d_house_user_ipseginfowhereidc_id=a.idc_idanduser_id=a.user_idandhouse_id=a.house_idandhhid=a.hhidanduser_nature=2)IP地址转换信息组,A.FRAME_ID机架信息ID,f.FRAMEINFO_FRAMENAME机架信息名称,''as操作fromCT_D_HOUSE_USER_INFOaleftjoinCT_D_HOUSE_FRAMEINFOfonA.FRAME_ID=f.FRAMEINFO_ID,ct_d_user_infobwherea.user_id=b.user_idanda.idc_id=b.idc_idandb.operat_flag!=3anda.user_nature=2anda.house_idin(selectlist_idfromrole_user_ip_rightwhereid='390')基础数据管理指令selectt1.command_id指令ID,(CASEwhent1.command_type=0then'查询基础数据'whent1.command_type=1then'打开基础数据监测功能'whent1.command_type=2then'关闭基础数据监测功能'whent1.command_type=3then'查询基础数据的监测数据'end)指令类型,t1.start_time监测数据起始日期,t1.end_day监测数据结束日期,t1.idc_idIDC/ISP经营者ID,decode(t2.house_cnt,0,'IDC全部机房',t2.house_cnt)机房数,t1.time_stamp生成时间,t3.result_desc指令执行情况fromp_frsmms_idcinfo_managet1join(selectidc_id,command_id,count(1)house_cntfromp_frsmms_idcinfo_housegroupbyidc_id,command_id)t2ont1.command_id=t2.command_idandt1.idc_id=t2.idc_idleftjoinct_d_command_ackt3ont1.command_id=t3.command_idwheret1.t