I've been banging my head against this but I have to provide a list of patches missing on each server to look like

Computer Name, Bulletin, PatchReleaseDate, Status, Severity

 

where the patch may not have been deployed yet but should be deployed in the future.

 

Does somebody have any sql for this?