C5 Report of ETICS service

Every thursday it must be sent a report of ETICS Services to it-dep-gt-reports@cernNOSPAMPLEASE.ch. The content is described below.

Incident

---

Downtimes, indicents, etc.

Performed Change

---

Things done. For example, a new release or some bugfix applied to the Service.

Future Change

---

Changes that are comming, like a new Release.

Service Level Report

---

Registered projects: select count (*) from project in etics DB
Active projects: It is in Etics Web Portal - Repository Tab
Packages available in the repository: It is in Etics Web Portal - Repository Tab
Build/test reports total: It is in Etics Web Portal - Repository Tab. Main Reports + Module Reports.
Builds/tests executed this week: select count(*) from Task where name='remote_task' and start>='DATE thursday past week' in nmi_history DB

Bulds/tests per platform

---

Execute select t.platform, count(*) as runs from Run as r, Task as t where r.runid=t.runid and t.name='remote_task' and t.start>='DATE thursday past week' group by t.platform order by runs desc; in nmi_history DB

It should match with builds/tests executed this week.

Platform: Number of builds.

Platform mapping

Text in Report	Name in database
CERN Scientific Linux 4 i386	nmi:x86_slc_4
CERN Scientific Linux 4 x86_64	nmi:x86_64_slc_4
Scientific Linux 5 i386	nmi:x86_sl_5.1
Scientific Linux 5 x86_64	nmi:x86_64_sl_5.4
Scientific Linux 5 x86_64 for Mock	nmi:x86_64_sl_5.4_mock
Debian 5 x86_64	nmi:x86_64_deb_5.0
Fedora Core 12 x86_64	nmi:x86_64_fc_12
Red Hat Enterprise 4 i386	nmi:x86_rhes_4
Mac OSX 10.5	nmi:x86_macos_10.5
Mac OSX 10.6	nmi:x86_macos_10.6

-- AlbertoRescoPerez - 06-May-2010