This is an old revision of the document!
Archi
SELECT name FROM Elements e INNER JOIN Properties p ON e.id = p.conceptid WHERE e.type = 'Node' AND p.propkey = 'env' AND p.propvalue = 'DEV'
SELECT name FROM Elements e INNER JOIN Properties p ON e.id = p.conceptid WHERE e.type = 'SystemSoftware' AND p.propkey = 'env' AND p.propvalue = 'DEV'