6 Replies Latest reply on Apr 4, 2013 9:38 AM by xsfbx

    Query: Software Installed, exluding "trash"

    Rookie

      LANDesk Management Suite v9.0.3.1

       

      Hello, I am pretty new to LANDesk and I am kind of stuck.  I created a query to show me software installed on machines (software inventory) in a location, but I want to exlude some items that I just dont care about.  My query is put together like this:

       

      "Computer"."Computer Location" LIKE "my location"

      AND ("Computer"."Software"."Add or Remove Programs"."Programs"."Name" NOT LIKE "Update for"

      OR "Computer"."Software"."Add or Remove Programs"."Programs"."Name" NOT LIKE "Security Update"

      OR "Computer"."Software"."Add or Remove Programs"."Programs"."Name" NOT LIKE "Flash Player"

      ...

      the list goes on

      ...

      )

       

      The problem that I am having is that it will run and still give me results containing "Update for", "Security Update", "Flash Player", and so on.  I found the following KB and if I am reading this correctly, then LANDesk is behing as expected.  http://kb.landesk.com/support/thread/17154.  They list a SQL query as a solution, but I am not quite sure how use that in LANDesk and probably don't have access to that part of it.

       

      Is what I am trying to do possible?  Any advise woulbe be appreciated!

      -Jason

        • 1. Re: Query: Software Installed, exluding "trash"
          mrspike SSMMVPGroup

          Just looking at this quickly, have you tried changing your "Or" to "and"

          • 2. Re: Query: Software Installed, exluding "trash"
            zman Master

            If you have a lot of excludes, it may be easier to use SQL - sample below:

             

            SELECT Distinct SUITENAME, Count (SUITENAME)AS Installs, Version, Publisher
            FROM AppSoftwareSuites 
            
            
            WHERE SUITENAME = SUITENAME
            AND SUITENAME NOT LIKE 'Security Update%'
            AND SUITENAME NOT LIKE 'Hotfix for Windows XP%'
            AND SUITENAME NOT LIKE 'Intel(R) PRO%'
            AND SUITENAME NOT LIKE 'Windows XP Hotfix%'
            AND SUITENAME NOT LIKE 'Update for Windows XP%'
            AND SUITENAME NOT LIKE 'CEG-CoreIcon-Install%'
            AND SUITENAME NOT LIKE 'ATI Display%'
            AND SUITENAME NOT LIKE 'Broadcom%'
            AND SUITENAME NOT LIKE 'HP Client Management Interface%'
            AND SUITENAME NOT LIKE 'WinPcap%'
            AND SUITENAME NOT LIKE 'Shockwave10%'
            AND SUITENAME NOT LIKE 'User Profile Hive Cleanup Service%'
            AND SUITENAME NOT LIKE 'OfficeScanCPS%'
            AND SUITENAME NOT LIKE 'NVIDIA Drivers%'
            AND SUITENAME NOT LIKE 'Office2003%'
            AND SUITENAME NOT LIKE 'MSXML%'
            AND SUITENAME NOT LIKE 'Windows Installer%'
            AND SUITENAME NOT LIKE 'WebFldrs XP%'
            AND SUITENAME NOT LIKE 'Time Zone%'
            AND SUITENAME NOT LIKE 'Synaptics%'
            AND SUITENAME NOT LIKE 'Realtek%'
            AND SUITENAME NOT LIKE 'OEMInfoFix%'
            AND SUITENAME NOT LIKE 'Microsoft XML%'
            AND SUITENAME NOT LIKE 'LANDesk%'
            AND SUITENAME NOT LIKE 'High Definition%'
            AND SUITENAME NOT LIKE 'CEG_%'
            AND SUITENAME NOT LIKE 'Windows Imaging%'
            AND SUITENAME NOT LIKE 'Internet Explorer Q903235%'
            AND SUITENAME NOT LIKE 'Matrox Graphics Software%'
            AND SUITENAME NOT LIKE 'MSOffice 2003 SP2 UpdateCK%'
            AND SUITENAME NOT LIKE 'Bluetooth by hp%'
            AND SUITENAME NOT LIKE 'Bluetooth Stack for Windows by Toshiba%'
            AND SUITENAME NOT LIKE 'Business%20Objects%205.1.4%'
            AND SUITENAME NOT LIKE 'BusObj651%'
            AND SUITENAME NOT LIKE 'Windows XP Service Pack%'
            AND SUITENAME NOT LIKE 'Windows Support Tools%'
            AND SUITENAME NOT LIKE 'Windows Resource Kit Tools%'
            AND SUITENAME NOT LIKE 'Windows PowerShell%'
            AND SUITENAME NOT LIKE 'Windows Driver Package%'
            AND SUITENAME NOT LIKE 'Update for Microsoft%'
            AND SUITENAME NOT LIKE 'Status'
            AND SUITENAME NOT LIKE 'Intel(R) Graphics Media Accelerator Driver%'
            AND SUITENAME NOT LIKE 'Intel(R) Extreme Graphics%'
            AND SUITENAME NOT LIKE 'hpzTLBXFX%'
            AND SUITENAME NOT LIKE 'HP Quick Launch Buttons%'
            AND SUITENAME NOT LIKE 'hp officejet%'
            AND SUITENAME NOT LIKE 'hp Laserjet%'
            AND SUITENAME NOT LIKE 'hp Deskjet%'
            AND SUITENAME NOT LIKE 'Hotfix for%'
            AND SUITENAME NOT LIKE 'Microsoft Compression Client Pack%'
            AND SUITENAME NOT LIKE 'NVIDIA%'
            AND SUITENAME NOT LIKE 'acrobat.com%'
            AND SUITENAME NOT LIKE '_help%'
            AND SUITENAME NOT LIKE '?%'
            AND SUITENAME NOT LIKE '32 Bit HP%'
            AND SUITENAME NOT LIKE 'Work%20%'
            AND SUITENAME NOT LIKE 'Windows System Updates%'
            AND SUITENAME NOT LIKE 'Windows Mobile Update%'
            AND SUITENAME NOT LIKE 'Windows 2000 Hotfix%'
            AND SUITENAME NOT LIKE 'Update for Windows Server%'
            AND SUITENAME NOT LIKE 'Update Rollup%'
            AND SUITENAME NOT LIKE 'Service Pack 3%'
            AND SUITENAME NOT LIKE 'Program Files%'
            AND SUITENAME NOT LIKE 'PCTran Calvert Cliffs (%'
            AND SUITENAME NOT LIKE 'Optimain DS (%'
            AND SUITENAME NOT LIKE 'Microsoft Visual C++ 2%'
            AND SUITENAME NOT LIKE 'Windows Software Update%'
            AND SUITENAME NOT LIKE 'MUI (English) 2007%'
            AND SUITENAME NOT LIKE 'Mercury Alarm Agent (%'
            AND SUITENAME NOT LIKE 'HP Update%'
            AND SUITENAME NOT LIKE 'Java(TM)%'
            AND SUITENAME NOT LIKE '2007 Microsoft Office Suite Service Pack %'
            AND SUITENAME NOT LIKE 'Acrobat Uninstaller%'
            AND SUITENAME NOT LIKE 'Adobe Air Application%'
            AND SUITENAME NOT LIKE 'Adobe Air Uninstaller%'
            AND SUITENAME NOT LIKE 'Adobe Flash Player Install%'
            AND SUITENAME NOT LIKE 'Adobe Help%'
            AND SUITENAME NOT LIKE 'Agere Systems%'
            AND SUITENAME NOT LIKE 'Apple Application Support%'
            AND SUITENAME NOT LIKE 'Battery Calibration%'
            AND SUITENAME NOT LIKE 'Wireless Switch%'
            AND SUITENAME NOT LIKE 'Wireless Connection%'
            AND SUITENAME NOT LIKE 'Update For%'
            AND SUITENAME NOT LIKE 'Uninstall%'
            AND SUITENAME NOT LIKE 'Sierra Wireless%'
            AND SUITENAME NOT LIKE 'SigmaTel Audio%'
            AND SUITENAME NOT LIKE 'Remove Office%'
            AND SUITENAME NOT LIKE 'Qualcomm%'
            AND SUITENAME NOT LIKE 'Panasonic Common%'
            
            
            Group By SUITENAME, Version, Publisher
            Order By SUITENAME ASC
            
            
            • 3. Re: Query: Software Installed, exluding "trash"
              Rookie

              @James: I tried using AND instead of OR initially without any luck.

               

              @Zman: That is exactly what I am looking for and what I have done using other Inventory/Management packages.  I guess I am lost because either I don't know where to do that in LanDesk, or I don't have access to do that.  Can you point me in the right direction?

              • 4. Re: Query: Software Installed, exluding "trash"
                zman Master

                You have to do this via a SQL query not within LANDesk. I find it easier to accomplish in SQl rather than LANDesk.

                • 5. Re: Query: Software Installed, exluding "trash"
                  Rookie

                  Got it.  Thanks for your help!

                  • 6. Re: Query: Software Installed, exluding "trash"
                    Rookie

                    I'm new to LANDesk. How do I launch a SQL query from within LANDesk?