external.conf

pillar:
  sqlite3:
    database: '/srv/salt/external/sqlite/pillar.db'
    timeout: 5.0

ext_pillar:
  - sqlite3:
      common:
        query:  "SELECT DISTINCT 'users', 'accounts', u.name, full_name, uid, shell, home, autofs_location
                   FROM person p
             INNER JOIN user u on p.id = u.person_id
             INNER JOIN user_role ur ON u.id = ur.user_id
             INNER JOIN role r ON ur.role_id = r.id
              LEFT JOIN nodegroup_role nr ON r.id = nr.role_id
              LEFT JOIN nodegroup n ON nr.nodegroup_id = n.id
                  WHERE n.name IN ?
               ORDER BY u.name"
        depth: 3
        by_nodegroups: True