Find the top 100 installed software applications and sort them by most-to-least install counts.

SELECT DISTINCT TOP 100
  NormalizedName,
  NormalizedPublisher,
  NormalizedVersion,
  COUNT(DISTINCT ResourceID) AS QTY
FROM 
  dbo.v_GS_INSTALLED_SOFTWARE_CATEGORIZED
GROUP BY
  NormalizedName,
  NormalizedPublisher,
  NormalizedVersion
ORDER BY QTY DESC
Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s