EGIIn SPIRE GGUS Report Generator Gnter Grein KIT

EGI-In. SPIRE GGUS Report Generator Günter Grein, KIT Helmut Dres, KIT Torsten Antoni, KIT Carsten Rogge, KIT EGI-In. SPIRE RI-261323 1 www. egi. eu

Outline • • • History Requirements Timescale Current status Outlook EGI-In. SPIRE RI-261323 2 www. egi. eu

History • Reports done by GGUS team – https: //ggus. eu/pages/metrics/download_escala tion_reports. php – https: //ggus. eu/pages/metrics/download_metric s_reports. php • Reports done in self-service – GGUS search engine: https: //ggus. eu/ws/ticket_search. php – GGUS report generator: https: //ggus. eu/stat. php EGI-In. SPIRE RI-261323 www. egi. eu

Requirements • Collected on a f 2 f meeting at KIT 2011 -1026/27 – https: //www. egi. eu/indico/conference. Display. py ? conf. Id=655 – Representatives from EGI, EMI, WLCG, GGUS team EGI-In. SPIRE RI-261323 www. egi. eu

Requirements Prio [1=highest] # Request 1 4 output aggregation: weeks, months, days, . . . 1 5 response time: status other than "assigned" and SU is kept or status assigned kept and SU changes 1 6 solution time (SU's view): assigning a ticket to an SU to ticket solving 1 10 pre-computed reports (EGI): frequency monthly, quarterly, yearly; based on calender and not project!! 1 11 ROC/NGI and site level 1 13 SLA reporting for EMI, IGE, SAGA TPs 2 8 SU topology (1 st, 2 nd, 3 rd)-> differentiate between 3 rd software, 3 rd service, . . 2 9 output xls, csv 3 2 status values selectable 3 3 priority values selectable 3 19 exclude waiting for reply state as option DMSU) 3 20 EMI: notifications for tickets soon violating SLA if 75% of time is over 3 21 Priority history for DMSU 4 14 ticket tags: introduce a separate field "keyword"? ? ? 4 15 ticket type: USER, TEAM, ALARM 4 16 possibility to aggregate values by criteria like status, priority, etc. 5 1 drilldown (-> ticket IDs) 5 7 ticket lifetime (user's view): creation date to ticket closing -> close (verify) all tickets after 2 weeks if user doesn't object 5 17 save queries -> my queries 5 18 automatic reports: select report template, select execution times, receive email notification -> related to #10 5 22 Reports by site and VO for WLCG EGI-In. SPIRE RI-261323 www. egi. eu

Timescale • First prototype available for the CF in Munich • First version online by end of June – Requests of priority 1 - 2 • Final version by end of 2012 EGI-In. SPIRE RI-261323 www. egi. eu

Current status • Live-Demo • https: //report. ggus. eu/report_view. ph p • System is under construction. • Don‘t use it for official reports! EGI-In. SPIRE RI-261323 www. egi. eu

Current status – home page EGI-In. SPIRE RI-261323 www. egi. eu

Current status - reports EGI-In. SPIRE RI-261323 www. egi. eu

Current status – data aggregation EGI-In. SPIRE RI-261323 www. egi. eu

Current status – responisble units EGI-In. SPIRE RI-261323 www. egi. eu

Current status - results list EGI-In. SPIRE RI-261323 www. egi. eu

Current status - results list details EGI-In. SPIRE RI-261323 www. egi. eu

Outlook • Implement more features according to requirements list (slide #5) – Report by topology (2 nd level, 3 rd level) – Report by ticket type, e. g. ALARM, TEAM – Ticket lifetime from user‘s point of view – Configuration -> saving queries – Automated reports – Reports by sites and VOs EGI-In. SPIRE RI-261323 www. egi. eu

Outlook • Bug fixing • Go life with a first version in time for EGIInspire review end of June • Implement missing features if any • Improving GUI • Go life with final version by end of 2012 EGI-In. SPIRE RI-261323 www. egi. eu