With the upcoming change to Microsoft Patching, I wanted the ability to examine the patch exclusions on servers (right click a server, "Exclude Patch List") but there wasn't an easy way to do this without clicking on each server.
Here is the process I created (*I am not to be held responsible if this breaks anything*):
|Command / Script *|
|nexec MSSQLSERVER cmd /c sqlcmd -s "," -h -1 -W -Q "set nocount on;SELECT [value],[bulletin_id],[kburl] FROM [bladelogic].[dbo].[ServerPatchExcludes] WHERE name='??TARGET.NAME??'"|
This creates an extended object that resembles the following:
I found it useful and thought I would share. Let me know if you have any questions, comments or suggestions.