2 Replies Latest reply on Jun 26, 2018 9:53 AM by phoffmann

    List of software that appears in additions deleting programs

    IDOUDAOUD Rookie

      Hi All,

       

      Would it be possible to recover via a query only the list of software that appears on the added removal of programs from windows 7 and then 10.

      we need this list to export it to a fleet management logciel

      Thank you for your feedback

        • 1. Re: List of software that appears in additions deleting programs
          jean-alexandre.coulon SupportEmployee

          Hi IDOUDAOUD !

           

          Thank you for your message on the community.

          This information is stored on the AppSoftwareSuites table.

           

          You can export  it with the following SQL query (for Windows 7 OS) :

           

          Select DISTINCT SuiteName from AppSoftwareSuites a

          inner join Computer b

          on a.Computer_Idn = b.Computer_Idn

          inner join

          Operating_System c

          on b.computer_Idn = c.computer_Idn

          WHERE c.Version LIKE '6.1'

          and a.SuiteName NOT LIKE 'Update%'

           

          For Windows 10, it will require a bit more of customization as the "Version" value is the same for Windows 10 and Windows Server 2016 according to Microsoft documentation.

          Something like it should do the trick :

           

          Select DISTINCT SuiteName from AppSoftwareSuites a

          inner join Computer b

          on a.Computer_Idn = b.Computer_Idn

          inner join

          Operating_System c

          on b.computer_Idn = c.computer_Idn

          WHERE c.Version LIKE '10.0'

          and a.SuiteName NOT LIKE 'Update%'

          and  c.OSType NOT LIKE '%2016%'

           

          Any feedback is welcome as it could need a bit more of customization to match your needs.

           

          Have a good day !

          1 of 1 people found this helpful
          • 2. Re: List of software that appears in additions deleting programs
            phoffmann SupportEmployee

            Additional filters may be needed if you want it for "devices A, B and C" for instance.

             

            If you can give us a mock-up of "this is what I want", chances are we can make it a reality for you.

             

            We would just need a clearer understanding of what (/how much of that) you want/need is all.