2 Replies Latest reply on Mar 23, 2010 2:22 PM by mturk

    How to create a query for Office 2000

    Rookie

      I am trying to create a query for machines that have office 2000 but not 2003 or 2007. We have some machines that have for example Office 2003 but Office 2000 was not uninstalled prior so there is both. Any help would be appreciated.

        • 1. Re: How to create a query for Office 2000
          Expert

          This should be a pretty straight forwards query to generate. Easy way to start is to look in 1 machine's inventory that you know has it installed. Drill in to Software \ Application Suites \ Application Suite and then locate the application name. These will be the items that are displayed in Add\Rem Programs for that machine with the exception of patches. (see pic 1)

           

          Create a new query and repeat the above process and select Name, then at the top select "=" and then in the right, select what you found in the previous step. Then, click Insert. If you want to find multiples, change the "And" to "Or" and then click the ones you want to add followed by Insert for each one. Lastly, in the bottom right, click "Select columns" and then on the bottom left, drill down to Software \ Application Suites \ Application Suite, select Name and then click the >> button to add the column to the query output. (see pic 2)

           

          HTH

          • 2. Re: How to create a query for Office 2000
            Rookie

            Thanks jmac!