Scenario: In my organisation I want to identify the PCs having only authorised software installed.
To do this I could compare the applications installed on each PC with my list of authorised applications. Using set theory / notation the solution is easy to express i.e. a PC is considered authorised if its applications are a subset of the authorised list.
What I’m trying to get my head around is how this ‘solution’ could be implemented using SQL? I’m after some sound pointers or approaches.