computers - name-ip-ou custom inventory rule.sql

-- Custom inventory field pulls the registry value for machine OU
SELECT MACHINE.NAME, MACHINE.IP, ADOU.STR_FIELD_VALUE as "OU"
FROM ORG1.MACHINE
JOIN MACHINE_CUSTOM_INVENTORY ADOU on ADOU.ID = MACHINE.ID and ADOU.SOFTWARE_ID = 34958