...
| Code Block |
|---|
WHERE @filter AND (user_group.name = 'Administrators' OR user_group.name = 'Power Users' OR user_group.name = 'Remote Desktop Users' OR user_group.name = 'wheel' OR user_group.name = 'sudo') AND user_group.members > '' GROUP BY system.id, user_group.name ORDER BY system.name |
Refining the Query
Using the web GUI, you can select items to be included or excluded. You can also select a group of devices, then run the query upon that group.
...