¬ísrjava.util.VectorÙ—}[€;¯IcapacityIncrementI elementCount[ elementDatat[Ljava/lang/Object;xp ur[Ljava.lang.Object;ÎXŸs)lxp(srInfoPurple.Qlet à¶³§cÙTL colDetailstLjava/util/Vector;L qletLocationtLjava/awt/Point;LqletSizetLjava/awt/Dimension;LqpValuesq~LqueryStrtLjava/lang/String;xppppsq~uq~(tDiscoverer AdmintSelectt100tManualt1440t 1-JAN-1990tYsrjava.awt.Color¥ƒ3uFfalphaIvalueLcstLjava/awt/color/ColorSpace;[ frgbvaluet[F[fvalueq~xpÿ™fpppsq~ÿÛÑÆpppsq~ÿÿÿÿpppt1sr java.awt.FontÅ¡5æÌÞVsIfontSerializedDataVersionF pointSizeIsizeIstyleLfRequestedAttributestLjava/util/Hashtable;Lnameq~ xpA@ ptArialxsq~ÿpppt18q~sq~ÿ™3pppsq~A@ ptArialxq~t dd-MMM-yyyyt #########tq0q~sq~A@ pq~xq~tappst No_PatterntVLETsq~ÿÿÿÿpppq~tXXDISCOVERER_ADMINsrInfoPurple.DashboardSettings à¶³§cÛ¬I currPletIdxI currQletIdxxp!+pppppppppxpsrInfoPurple.Plet à¶³§cÚäL pletLocationq~LpletSizeq~LppValuesq~LqueryStrq~ xpsrjava.awt.Point¶ÄŠr4~È&IxIyxp–srjava.awt.DimensionAŽÙ׬_DIheightIwidthxp2dsq~uq~tVersionsrdbUtil.dbInstance à¶³§cØðLdbDriverq~ L dbPasswordq~ LdbURLq~ LdbUserq~ xptoracle.jdbc.driver.OracleDrivertapps_dbatlink-horde.cisco.com:1529:dbatappstALLtdistinct substr(table_name,1,4)t'ID1't'ID2't'ID3't'ID4't'ID5'srInfoPurple.PletValue à¶³§cÛHL descriptionq~ L displayValueq~ Lid1q~ Lid2q~ Lid3q~ Lid4q~ Lid5q~ L internalValueq~ xpptEUL5tID1tID2tID3tID4tID5psq~ÿøú¬pppsq~ÿpppsq~A@ ptArialxtappstNONEtPLETtp33tNq~Upxtqfrom all_tables where table_name like 'EUL%' and owner = 'G_PARAM' /*distinctowner*/ sq~/sq~1sq~32dsq~uq~t EUL Ownerq~9tALLtdistinct ownert'ID1't'ID2't'ID3't'ID4't'ID5'sq~EptEUL5_UStID1tID2tID3tID4tID5psq~ÿøú¬pppsq~ÿpppsq~A@ ptArialxtappstNONEtPLETtp32tNq~spxt-from all_tables where table_name like 'EUL%' sq~sq~uq~ ppppppppppxsq~1Fúsq~3‰sq~uq~(t Meta Dataq~9t100tManualt1440t 1-JAN-1990tYsq~ÿ™fpppq~q~t1sq~A@ ptArialxsq~ÿpppt18q~q~!q~"q~t dd-MMM-yyyyt #########tq42q~†sq~A@ pq~…xtNtappst No_PatterntQLETsq~ÿÿÿÿpppq~†tXXDBNAMEt30:30pppppppppxt=select * from G_PARAM.paramsq~sq~uq~ srInfoPurple.ColumnPropertyValues à¶³§cÙ¸L colPropValuesq~L drillValuesq~L parentQlettLInfoPurple/Qlet;xpsq~uq~tInfoCaptor Messaget450sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~Ÿsq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyytYsq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~”sq~—sq~uq~t TABLE_NAMEt252q~žq~Ÿq~ t1q~Ÿq~¢tNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxt Table Name pppppxsq~uq~ srInfoPurple.DrillSettings à¶³§cÚL drillColumnsq~L drillNameq~ L drillQletIDq~ xpsq~uq~ q~±pppppppppxt Meta Dataq~Špppppppppxq~”ppppppppxsq~1ûsq~3sq~uq~(tDisco Meta Tablesq~9t100tManualt1440t 1-JAN-1990tYsq~ÿ™fpppq~q~t1q~¢q~Ÿt18q~Ëq~!q~"q~t dd-MMM-yyyyt #########tq41q~Ÿsq~A@ pq~£xtNtappst No_PatterntQLETsq~ÿÿÿÿpppq~ŸtXXDBNAMEt pppppppppxtcselect table_name from all_tables where owner = 'G_PARAM' /*distinctowner*/ sq~sq~uq~ sq~—sq~uq~q~œt450sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~ãsq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~Ûsq~—sq~uq~t Business Areat269q~âq~ãq~ät1q~ãq~ætNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxtBusiness Area pppppxsq~uq~ sq~½sq~uq~ q~ôt%ppppppppxtGet Folder Detailstq34pppppppppxq~Ûppppppppxsq~1,dsq~3£sq~uq~(tBusiness Areasq~9t100tManualt1440t 1-JAN-1990tYsq~ÿ™fpppq~q~t1q~æq~ãt18q~q~!q~"q~t dd-MMM-yyyyt #########tq32q~ãsq~A@ pq~çxq~¨tappst No_PatterntQLETsq~ÿÿÿÿpppq~ãtXXDBNAMEq~ÙpppppppppxtÖselect ba_name "Business Area" ,ba_created_by "Creator" ,ba_created_date "Creation Date" ,ba_updated_by "Updated By " ,ba_updated_date "Last Update Date" ,ba_id from G_PARAM.G_PARAM_bassq~sq~uq~ sq~—sq~uq~q~œt450sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~%sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~sq~—sq~uq~t ITEM_NAMEt173q~$q~%q~&t1q~%q~(tNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxt Item Name pppppxsq~uq~ ppppppppppxq~ppppppppxsq~1©sq~3@sq~uq~(t Folder Itemsq~9t100tManualt1440t 1-JAN-1990tYsq~ÿ™fpppq~q~t1q~(q~%t18q~Kq~!q~"q~t dd-MMM-yyyyt #########tq35q~%sq~A@ pq~)xtNtappst No_PatterntQLETsq~ÿÿÿÿpppq~%tXXDBNAMEt30:30pppppppppxt~select i.exp_name item_name,i.exp_id,i.it_ext_column ,f.obj_name folder_name ,b.ba_name, i.* from G_PARAM.G_PARAM_expressions i , G_PARAM.G_PARAM_objs f , G_PARAM.G_PARAM_ba_obj_links l , G_PARAM.G_PARAM_bas b where f.obj_id= i.it_obj_id --and f.obj_name like and f.obj_id= l.bol_obj_id and b.ba_id= l.bol_ba_id and upper(i.exp_name) like upper('param') and upper(b.ba_name) like upper('param') and upper(f.obj_name) like upper('param') order by b.ba_name,f.obj_name,i.exp_namesq~sq~uq~ sq~—sq~uq~tBA_NAMEt40sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~dsq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxtBa Name pppppxsq~uq~ ppppppppppxq~[sq~—sq~uq~t FOLDER_NAMEt246q~cq~dq~et1q~dq~gtNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxt Folder Name pppppxsq~uq~ sq~½sq~uq~ t%q~aq~upppppppxtGet Folder Itemsq~Qsq~½sq~uq~ tOBJ_IDq~‰ppppppppxtGet Folder Joinstq37ppppppppxq~[ppppppppxsq~1©sq~3_sq~uq~(tFoldersq~9t100tManualt1440t 1-JAN-1990tYsq~ÿ™fpppq~q~t1q~gq~dt18q~•q~!q~"q~t dd-MMM-yyyyt #########q~q~dsq~A@ pq~hxtNtappst No_PatterntQLETsq~ÿÿÿÿpppq~dtXXDBNAMEt30:30pppppppppxt¹select b.ba_name,f.obj_name folder_name,f.obj_id,f.obj_ext_owner Owner from G_PARAM.G_PARAM_objs f , G_PARAM.G_PARAM_ba_obj_links l , G_PARAM.G_PARAM_bas b where 1=1 and f.obj_id= l.bol_obj_id and b.ba_id= l.bol_ba_id and upper(b.ba_name) like upper('param') and upper(f.obj_name) like upper('param') order by b.ba_name,f.obj_namesq~sq~uq~ sq~—sq~uq~tKEY_DESCRIPTIONt711sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~­sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxtKey Description pppppxsq~uq~ ppppppppppxq~¤pppppppppxsq~1Õsq~3È·sq~uq~(t Folder Joinsq~9t100tManualt1440t 1-JAN-1990tYsq~ÿ™fpppq~q~t1q~°q~­t18q~Äq~!q~"q~t dd-MMM-yyyyt #########q~‹q~­sq~A@ pq~±xtNtappst No_PatterntQLETsq~ÿÿÿÿpppq~­tXXDBNAMEt30:30pppppppppxt—select key_description from G_PARAM.G_PARAM_key_cons where fk_obj_id_remote=param or key_obj_id=paramsq~sq~uq~ sq~—sq~uq~q~œt450sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~Ûsq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~Ósq~—sq~uq~tWorkbook (Worksheet)t223q~Úq~Ûq~Üt1q~Ûq~ÞtNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxtWorkbook (worksheet) pppppxsq~uq~ ppppppppppxq~Ósq~—sq~uq~tRUN_DATEt79q~Úq~Ûq~Üt1q~Ûq~ÞtNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxt Run Date pppppxsq~uq~ ppppppppppxq~Ópppppppxsq~1õÏsq~3Ýsq~uq~(tReport Run Timeq~9t100tManualt1440t 1-JAN-1990tYsq~ÿ™fpppq~q~t1q~Þq~Ût18q~q~!q~"q~t dd-MMM-yyyyt #########tq40q~Ûsq~A@ pq~ßxtNtappst No_PatterntQLETsq~ÿÿÿÿpppq~ÛtXXDBNAMEq~Ùpppppppppxt]select to_char(qs_created_date,'DD-MON-YYYY') Run_Date, qs_doc_name ||' ('|| qs_doc_details||')' "Workbook (Worksheet)", round(qs_act_cpu_time/60,2) cpu_time, round(qs_act_elap_time/60,2) total_time from G_PARAM.G_PARAM_qpp_stats where upper(qs_doc_name) like upper('param< Workbook Name, %>') --and qs_created_date between sysdate - 7 and sysdate /*and qs_created_date between to_date( 'aram','DD-MON-YYYY') and to_date( 'aram','DD-MON-YYYY') */ order by qs_doc_name,qs_doc_details,qs_act_elap_time descsq~sq~uq~ sq~—sq~uq~tMETRICt185sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~(sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxtMetric pppppxsq~uq~ ppppppppppxq~sq~—sq~uq~tTotalt55q~'q~(q~)t1q~(q~+tNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxtTotal pppppxsq~uq~ ppppppppppxq~ppppppppxsq~1dsq~3Šûsq~uq~(t BA Metricsq~9t100tManualt1440t 1-JAN-1990tYsq~ÿ™fpppq~q~t1q~+q~(t18q~Nq~!q~"q~t dd-MMM-yyyyt #########tq31q~(sq~A@ pq~,xq~Ntappst No_PatterntQLETsq~ÿÿÿÿpppq~(tXXDBNAMEq~ÙpppppppppxtUselect 'Business Areas' Metric,count(*) "Total" from G_PARAM.G_PARAM_bas union all select 'Workbooks' , count(*) from G_PARAM.G_PARAM_documents a union all select 'Modified Folder Items this Week' , count(*) from G_PARAM.G_PARAM_expressions i , G_PARAM.G_PARAM_objs f , G_PARAM.G_PARAM_ba_obj_links l , G_PARAM.G_PARAM_bas b where f.obj_id= i.it_obj_id and f.obj_id= l.bol_obj_id and b.ba_id= l.bol_ba_id and i.exp_updated_date between trunc(next_day(sysdate-7,'SUNDAY')) and sysdate union all select 'Modified Folders this Week' , count(*) from G_PARAM.G_PARAM_objs f , G_PARAM.G_PARAM_ba_obj_links l , G_PARAM.G_PARAM_bas b where 1=1 and f.obj_id= l.bol_obj_id and b.ba_id= l.bol_ba_id and f.obj_updated_date between trunc(next_day(sysdate-7,'SUNDAY')) and sysdate union all select 'Reports Run', count(*) from G_PARAM.G_PARAM_qpp_stats sq~sq~uq~ sq~—sq~uq~q~œt450sq~ÿÛÑÆpppsq~ÿpppsq~ÿÿÿÌpppt1q~dsq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxt Display Namepppppxsq~uq~ ppppppppppxq~\sq~—sq~uq~tWorkbook (Worksheet)t275q~cq~dq~et1q~dq~gtNAtNt ##########t dd-MMM-yyyyq~¨sq~A@ ptArialxtWorkbook (worksheet) pppppxsq~uq~ ppppppppppxq~\ppppppppxsq~1Ðsq~3Âsq~uq~(tAverage Run Timeq~9t100tManualt1440t 1-JAN-1990tYsq~ÿ™fpppq~q~t1q~gq~dt18q~Šq~!q~"q~t dd-MMM-yyyyt #########tq39q~dsq~A@ pq~hxtNtappst No_PatterntQLETsq~ÿÿÿÿpppq~dtXXDBNAMEq~ÙpppppppppxtKselect replace(qs_doc_name,'LINKSYS','') ||' ('|| qs_doc_details||')' "Workbook (Worksheet)", round(avg(qs_act_cpu_time)/60,2) cpu_time, round(avg(qs_act_elap_time)/60,2) total_time from G_PARAM.G_PARAM_qpp_stats where upper(qs_doc_name) like upper('param< Workbook Name, %>') --and qs_created_date between sysdate - 7 and sysdate /*and qs_created_date between to_date( 'aram','DD-MON-YYYY') and to_date( 'aram','DD-MON-YYYY') */ group by qs_doc_name, qs_doc_details order by 3,1 desc ppppppppppppppppppppppppppppx