Re: Query machine with Office 2000 w/o Office 2003

Another typical "not in" query.

You basicly first create a query for all machines that have office 2003
installed.
You then create a query for all machines that office 2000 but are "not in"
the result set of the first query.

The following articles explains this quite nicely, if you can't make it work
than just post back here.
http://myitforum.techtarget.com/articles/1/view.asp?id=179

--
Kim Oppalfens
Telindus Belgium
MVP Windows Server System - SMS
"Bryan McDaniel" <bmcdaniel@xxxxxxxxxxx> wrote in message
news:uAMPWoK2FHA.820@xxxxxxxxxxxxxxxxxxxxxxx
>I am trying to create a query that will tell me which machines have Office
>2000 installed and NOT Office 2003. Reason being is we have one
>application that requires Excel 2000. So if I create a collection based on
>a query that has Office 2000 installed, it sees Excel 2000 and thinks that
>it need to install office 2003, when in fact, it may already have 2003, and
>excel 2000. My current query is based on add/remove programs....If
>Add/remove includes;Office 2000.....and NOT add/remove Office 2003.....But
>I am still getting all machines as if I have not included the not
>statement....
>
> Please advise
>


.

Relevant Pages

  • Re: Query Help: How can I get X but with out Y?
    ... Create a collection with all machines you ... Create a query that querries for all machines that have installed ... > package and the advertisement and pushed the install out with success. ...
    (microsoft.public.sms.admin)
  • RE: Problem creating query with exe files of different versions
    ... Try using a subselect query to include systems that have version less than ... > I am upgrading an application x on machines across network. ... > trying to install is 9 ... > Now the problem is that for few machines my software inventory has ...
    (microsoft.public.sms.swdist)
  • Re: Query Help: How can I get X but with out Y?
    ... subselect I browse to the query in step two, click ok and I get "Please ... > successfully installed machines & the failed ones. ... >> package and the advertisement and pushed the install out with success. ...
    (microsoft.public.sms.admin)
  • Re: Error querying Access text fields if dash or minus sign in middle of text
    ... MDAC 2.7 SPI REFRESH ... Should I install a later version if there is one? ... > I am getting all results displayed in the query, ... > I do have the latest service packs and critical updates installed: ...
    (microsoft.public.access.queries)
  • Microsoft Query could not be started because it isnt installed
    ... Excel worksheet. ... When I go to Data | Get External Data | New Database Query ... install Query by running the installation program you "used to install ... that refers to this problem but in Microsoft Excel 98 Macintosh Edition. ...
    (microsoft.public.office.setup)
Loading