-- 小型机分区资源列表指标数据验证
select r.resId,resName,ip,os,resType,admin,KPIF74D9D2B,KPIE13DD9A3,KPIBDB60856,KPI7054BC34,KPI1584BE1C,KPI31CB8D97,KPI20352505,KPI1503B2E0,KPI1503B2E0NAME,KPI449F5365,KPI449F5365NAME,KPI41A1D9E9,KPID339D51B,KPID339D51BNAME,KPI02062F43,KPI02062F43NAME
from b_resource r left join b_result_realtime_base rb on r.resId = rb.resId where resType like '%MINI%';
-- X86服务器资源列表指标数据验证
select r.resId,resName,ip,os,resType,admin,KPIF74D9D2B,KPIE13DD9A3,KPIBDB60856,KPI7054BC34,KPI1584BE1C,KPI31CB8D97,KPI20352505,KPI98183B26,KPI98183B26NAME,KPI449F5365,KPI449F5365NAME,KPI2C8A6D17,KPI2C8A6D17NAME,KPID339D51B,KPID339D51BNAME,KPI02062F43,KPI02062F43NAME
from b_resource r left join b_result_realtime_base rb on r.resId = rb.resId where resType like '%X86%';
-- VMWARE虚拟化
-- VMWARE虚拟化平台资源列表指标数据验证
select r.resId,resName,ip,os,resType,admin,KPIF74D9D2B,KPIE13DD9A3,KPI9E5E1B3E,KPIBFA3F5CD,KPI1584BE1C,KPI4A216352,KPIC40A80AC,KPI5B7998C9,KPI33D6E74B,KPI46BAA9BE
from b_resource r left join b_result_realtime_base rb on r.resId = rb.resId where resType like '%VMWARE';
-- VMWARE虚拟化资源池资源列表指标数据验证
select r.resId,resName,os,resType,admin,KPIF74D9D2B,KPIEE008133,KPI63916615,KPIBDB60856,KPI7054BC34,KPI1584BE1C,KPI31CB8D97,KPI5E148DBE,KPI02EA188F,KPI9597B203,KPI4EFF9873
from b_resource r left join b_result_realtime_base rb on r.resId = rb.resId where resType like '%VMWARE_CL%';
-- VMWARE虚拟化物理机资源列表指标数据验证
select r.resId,resName,os,resType,admin,KPIF74D9D2B,KPI1635BB9B,KPI8BCBCA98,KPIBDB60856,KPI7054BC34,KPI1584BE1C,KPI31CB8D97,KPI9597B203,KPI4EFF9873,KPI82EE61DF
from b_resource r left join b_result_realtime_base rb on r.resId = rb.resId where resType like '%VMWARE_P%';
-- VMWARE虚拟化虚拟机资源列表指标数据验证
select r.resId,resName,os,resType,admin,KPIF74D9D2B,KPI1635BB9B,KPI8BCBCA98,KPIFB844B8B,KPIE4B51D5C,KPIBDB60856,KPI7054BC34,KPI1584BE1C,KPI31CB8D97,KPI449F5365,KPI449F5365NAME,KPI2C8A6D17,KPI2C8A6D17NAME,KPI4EFF9873,KPI82EE61DF,KPIC70A1E3D
from b_resource r left join b_result_realtime_base rb on r.resId = rb.resId where resType like '%VMWARE_V%';
-- HUAWEI虚拟化
-- VMWARE虚拟化平台资源列表指标数据验证
select r.resId,resName,ip,os,resType,admin,KPIF74D9D2B,KPIE13DD9A3
from b_resource r left join b_result_realtime_base rb on r.resId = rb.resId where resType like '%HUAWEI';
-- VMWARE虚拟化资源池资源列表指标数据验证
select r.resId,resName,os,resType,admin,KPIF74D9D2B,KPI7054BC34,KPI1584BE1C,KPI31CB8D97,KPI02EA188F,KPI9597B203,KPI4EFF9873
from b_resource r left join b_result_realtime_base rb on r.resId = rb.resId where resType like '%HUAWEI_CL%';
-- VMWARE虚拟化物理机资源列表指标数据验证
select r.resId,resName,os,resType,admin,KPIF74D9D2B,KPI1635BB9B,KPIBDB60856,KPI7054BC34,KPI1584BE1C,KPI31CB8D97,KPI9597B203,KPI4EFF9873,KPI82EE61DF
from b_resource r left join b_result_realtime_base rb on r.resId = rb.resId where resType like '%HUAWEI_P%';
-- VMWARE虚拟化虚拟机资源列表指标数据验证
select r.resId,resName,os,resType,admin,KPIF74D9D2B,KPI1635BB9B,KPI8BCBCA98,KPIBDB60856,KPI7054BC34,KPI1584BE1C,KPI31CB8D97,KPI449F5365,KPI449F5365NAME,KPI2C8A6D17,KPI2C8A6D17NAME,KPI4EFF9873,KPI82EE61DF,KPIC70A1E3D
from b_resource r left join b_result_realtime_base rb on r.resId = rb.resId where resType like '%HUAWEI_V%';
-- 系统软件
-- oralce资源列表指标数据验证
select r.resId,resName,ip,os,resType,admin,KPIF74D9D2B,KPIE13DD9A3,KPIA55F9590,KPICFA785F5,KPI64B1610A,KPI64B1610ANAME,KPI922F8FF7,KPI922F8FF7NAME,KPI18F18278,KPI69E67C68,KPIDF0E1A44
from b_resource r left join b_result_realtime_base rb on r.resId = rb.resId where resType like '%ORA%';
-- mysql资源列表指标数据验证
select r.resId,resName,ip,os,resType,admin,KPIF74D9D2B,KPIE13DD9A3,KPI8914AC3B,KPI4FA6C9E5,KPI474A7DD3,KPI54855B9D,KPI1F9DB62C
from b_resource r left join b_result_realtime_base rb on r.resId = rb.resId where resType like '%MYAQL%';
-- weblogic资源列表指标数据验证
select r.resId,resName,ip,os,resType,admin,KPIF74D9D2B,KPIE13DD9A3,KPI4DA976AF,KPI6D99C9E0,KPI98F4266F,KPIC18DC28A
from b_resource r left join b_result_realtime_base rb on r.resId = rb.resId where resType like '%WEB%';
-- 网络设备
-- 网络及安全资源列表指标数据验证
select r.resId,resName,ip,os,resType,admin,KPIF74D9D2B,KPIE13DD9A3,KPI7054BC34,KPI31CB8D97
from b_resource r left join b_result_realtime_base rb on r.resId = rb.resId where resType like 'NET%';
