nicht angemeldet
Ok hier nochmal eine Beispieltabelle (hoffe halbwegs vollständig):
host_name | service_description
+-----------------------+------------------------+
| host1 | "service1"
| host1 | "service2"
| host1 | "service3"
| host1 | "service1"
| host2 | "service1"
| host2 | "service1"
| host2 | "service1"
| host2 | "service3"
| host3 | "service3"
| host3 | "service2"
| host3 | "service2"
+-----------------------+-------------------------+
Ergebnis:
| host_name | service_description | count
+-----------------------+------------------------+--------------
| host1 | "service1" | 2
| host1 | "service2" | 1
| host1 | "service3" | 1
| host2 | "service1" | 3
| host2 | "service3" | 1
| host3 | "service3" | 1
| host3 | "service2" | 2
+-----------------------+------------------------+--------------