Hey Nation!
I'm hoping you lovely people can help prevent me from reinventing the wheel/spending too much time on research and/or trial and error...
I need to figure out the appropriate MySQL syntax to extract the following from my database...
Policies
- with no scope targets
- scoped to All Computers
- A separate list of policies for each unique trigger
Computer configuration profiles
- with no scope targets
- scoped to All Computers
Mac App Store Apps
- with no scope targets
- scoped to All Computers
Restricted Software
- with no scope targets
- scoped to All Computers
Groups
- Computer groups with no relationship to other objects (not in any scopes)
- Return all polices for which a given group is a scope target
- Return all polices for which a given group is a scope exclusion
- Return all profiles for which a given group is a scope target
- Return all profiles for which a given group is a scope exclusion
- Return all restricted software for which a given group is a scope target
- Return all restricted software for which a given group is a scope exclusion
- Return all Mac App Store apps for which a given group is a scope target
- Return all Mac App Store apps for which a given group is a scope exclusion