1 Reply Latest reply on Sep 12, 2008 3:07 PM by MarXtar

    Creating a simple software title 'population' dump

    Rookie

      I'm attempting to create a list of the counts of installed software titles, their versions and their publishers, by doing query on the AppSoftwareSuites table.

       

      I'm going to use this query:

       

      SELECT COUNT( Computer_Idn) AS ‘SWINSTALLCOUNT’, SuiteName AS ‘Software Title’, Version AS ‘Software Version’, Publisher AS ‘ Vendor’ 

      FROM AppSoftwareSuites 

      Group by SuiteName,  Version, Publisher

       

      Does this look correct?  Has anyone ever done this before??

       

      Thanx in advance

        • 1. Re: Creating a simple software title 'population' dump
          MarXtar ITSMMVPGroup

          Try creating a view with this instead:

           

          SELECT     TOP (100) PERCENT Publisher, SuiteName AS , Version, COUNT(SuiteName) AS

          FROM         dbo.AppSoftwareSuites

          GROUP BY Publisher, Version, SuiteName

          ORDER BY Publisher, SuiteName, Version

           

          This should do what you need.

           

          Also, you can do this in the webconsole quite easily, just write a query that finds any machine where the device name exists, and then set the output columns to the ones you want to see and add a count on the appropriate field.  As long as you don't include the device name in the columns to display you will get a very similar result.

           

          The query doesn't display well so i attached it as a text file.

           

          Mark Star -

          MarXtar LANDesk Enhancements

          Home of Power State Notifier & Wake-On-WAN for LANDesk