Custom Query for missing patches

Custom Query for missing patches

I am looking for a custom query that can do missing patches by computer.  Would be like the following columns

Column 1: Computer Name
Column 2: Patch ID
Column 3: Bulletin ID
Column 4: Patch Description
Column 5: Severity
Column 6: Patch Type

If anyone has this, or knows how to get this, I would greatly appreciate it.  We are using the PGSQL database.

                  New to ADSelfService Plus?