2 Replies Latest reply on Aug 6, 2009 2:54 PM by DaveE

    Conditional Query - Application list excluding specific name

    Rookie

      I want to find out all applications installed except application which starts or contains words such as “Microsoft”, “windows”, “Adobe” etc. Query which I am running shows all applications including these words. Query expression snapshot is attached. I think that there is some mistake in query operators. Can anyone give me suggestion on how I can achieve this?

        • 1. Re: Conditional Query - Application list excluding specific name
          zman Master

          Here is something I use in SQL to list all apps except common items like patches, etc... it may help. Also this http://community.landesk.com/support/message/9347#9347

           

          SELECT Distinct SUITENAME, Count (SUITENAME), 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%'
          
          
          Group By SUITENAME, Version, Publisher
          Order By SUITENAME
          
          • 2. Re: Conditional Query - Application list excluding specific name
            SupportEmployee

            You could also look at Managed Planet's Executive Report Pack.  One of its features is designed to do exactly this sort of thing, but without having to create queries or work with SQL.  You get a saveable list (called an Include list) where you pick just the ones you want (or don't want).  You could save an unlimited number of these lists, so one might be for Microsoft apps, another for Adobe and another for apps the manager of engineering cares about.