性能开发的时候注册数据验证

性能开发的时候注册数据

1.需要ems注册的性能数据

SELECT * from pm_metric where metric_id in (SELECT metric_id from pm_metric_pair where metric_pair_id in (SELECT metric_pair_id from pm_metric_group_pair_relation where base_group_id =150));

2.性能界面指标组下指标数据的验证

select t1.metric_group_id, t1.base_group_id, t1.metric_group_name, t3.metric_pair_id,
        t3.metric_pair_name, t3.metric_unit from pm_metric_group t1
        left join pm_metric_group_pair_relation t2 on t1.base_group_id = t2.base_group_id
        left join pm_metric_pair_name t3 on t2.metric_pair_id = t3.metric_pair_id
        left join pm_metric_pair t4 on t2.metric_pair_id = t4.metric_pair_id 
 where t1.metric_group_id in
        (
            select distinct(metric_group_id) from pm_cardtype_porttype where fixed_netype_id = 817
            union all select distinct(metric_group_id) from pm_netype_metype where fixed_netype_id = 817
        )
 and t4.metric_id in  #list