Generate a K1000 report of computers containing unapproved software.
New to SQL, We are running Microsoft SQL for the server. I would like to write a script that will list software and the pc's they are installed on, excluding software that is installed on no machines, nor is the software labeled 'Approved Software' or 'Drivers and System Software'. The ideal is basically to generate a report of computers containing unapproved software. Near as I can tell I will have to do some joins on machine_software, software, software_label_jt, and label