OEM : Netapps custom reports

1. Grant additional perms Need following perms on OEM repos as query is reliant on base tables not oem application views - could rework later perhaps grant select on MGMT_METRICS_RAW to mgmt_view; grant select on MGMT_METRICS to mgmt_view; grant select on MGMT_TARGETS to mgmt_view; 2. Create first Report 2.1 Create Report Navigate to Reports->Create Title : NTAP001 - Netapps Raw IO-Rate Category : Custom Reports (may have to add) Subcategory : Development (may have to add) Target : Target Type=Network Appliance Filer Time Period : This reoport has a time period = ticked. Time Period = This Year, Allow the report viewer... = ticked 2.2 Create chart element Navigate to tab Elements->Add Select     Chart from SQL Navigate to Set Parameters Header : Io Rate Statment :     select     mt.TARGET_NAME,     mrw.COLLECTION_TIMESTAMP,     --mm.column_label,     mrw.VALUE     /*-- DEBUG     ,mm.COLUMN_LABEL_NLSID     ,'MRW->'     ,mrw.*     ,',MT->'     ,mt.*     ,'MM->'     ,mm.*     */     from     MGMT_METRICS_RAW mrw,     MGMT_METRICS mm,     MGMT_TARGETS mt     where 1=1     and mrw.metric_guid    = mm.metric_guid     and mrw.TARGET_GUID    = mt.TARGET_GUID     and mt.TARGET_TYPE     = mm.TARGET_TYPE     and mt.type_meta_ver   = mm.type_meta_ver     and (mt.TARGET_TYPE = 'netapp_filer' )     AND mrw.collection_timestamp >=      ??EMIP_BIND_START_DATE??     and mrw.collection_timestamp <=       ??EMIP_BIND_END_DATE??     and mt.TARGET_GUID          = ??EMIP_BIND_TARGET_GUID??     and column_label_nlsid in (      'netapp_filer_total_disk_io_rate'     --,'netapp_filer_pct_busy'     --,'netapp_filer_nfs_calls_rate'     --,'netapp_filer_total_network_io_rate'     )     ORDER BY     mt.TARGET_NAME,     mrw.COLLECTION_TIMESTAMP,     mm.column_label Statement type : SQL Legent Position : Right Width : 1000 Height : 400 2.3 Create Table element Navigate to tab Elements->Add Select     Table from SQL Repeat settings for Chart from SQL element above 3. Clone to create other reports Repeat altering Sql in each case for     NTAP001 - Netapps Raw IO-Rate = netapp_filer_total_disk_io_rate     NTAP002 - Netapps Raw CPU %Busy = netapp_filer_pct_busy     NTAP003 - Netapps Raw NFS Call Rate = netapp_filer_nfs_calls_rate     NTAP004 - Netapps Raw Network IO Rate = netapp_filer_total_network_io_rate