SELECT DISTINCT
AUS.ID as ‘Bulletin’,
AUS.QNumbers as ‘KB’,
AUS.Title as ‘Title’,
AUS.Product as ‘Product’,
AUS.Language as ‘Language’,
AUS.TimeAuthorized as ‘Time Authorized’,
AUS.Counts as ‘Count’,
AUS.InstalledCounts as ‘Installed’
FROM    v_ApplicableUpdatesSummaryEx AUS
WHERE   (TimeAuthorized IS NOT NULL)
AND (Type = ‘Microsoft Update’)
ORDER BY
AUS.ID,
AUS.QNumbers,
AUS.Product,
AUS.Language