I am working on a SQL query to list the device name, description, model, class type ,product, pool name and the associated DN if any using the following query:
select a.name as device, a.description, b.name as pool, typemodel.name as model,p.name as ...