I am about to replace our single unconstrained package server and need to know which packages are setup without All Package Servers selected.
I need this so I can go into these packages and assign them to the new unconstrained server.
Here you go:
SELECT Name,[Description] FROM vSWDPackage WHERE [State] NOT LIKE '%method="all"%'