Here you go...
SELECT DISTINCT tbComputerTarget.FullDomainName, tbComputerTarget.IPAddress,
FROM SUSDB.dbo.tbComputerTarget tbComputerTarget, SUSDB.dbo.tbTargetGroup
tbTargetGroup, SUSDB.dbo.tbTargetInTargetGroup tbTargetInTargetGroup
WHERE tbTargetInTargetGroup.TargetGroupID = tbTargetGroup.TargetGroupID AND
tbTargetInTargetGroup.TargetID = tbComputerTarget.TargetID
ORDER BY tbComputerTarget.FullDomainName
Post by Paul Jenkins
I'd like to query the WSUS database to dump a list of computers in the
various WSUS Computer Groups. Can anyone help me produce such a listing,
using SQL query or other means? Thanks.