I am trying to link Icinga Director our CRM - we are storing a list of clients and a unique ID.
I have a second table with the sites for each customer (siteID, CustomerID).
If I set a custom attribute of ‘customerID’ on a host object, and then wanted to set a second attribute of site — I am wondering if it is possible to expand Icinga macros in these SQL queries - e.g
SELECT * from sites where customer = $host.vars.customer$;.
I am assuming the macros aren’t expanded in the PHP, but just wondering if anyone has been able to achieve something like this?