Serviceset CSV export

Icinga 2
1

Hello all,

does anyone know a way how I can generate a CSV report that lists all service sets for me?

Best wishes

:slight_smile:

2

If you use icinga director you can get the query by:

https://your-icinga/icingaweb2/director/services/sets?format=sql

and you can export csv files via mysql:

SELECT 
    orderNumber, status, orderDate, requiredDate, comments
FROM
    orders
WHERE
    status = 'Cancelled' 
INTO OUTFILE 'C:/tmp/cancelled_orders.csv' 
FIELDS ENCLOSED BY '"' 
TERMINATED BY ';' 
ESCAPED BY '"' 
LINES TERMINATED BY '\r\n';

source : https://www.mysqltutorial.org/mysql-export-table-to-csv…

3

Did that help solving your issue?

1 Like