Creating Query

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Yh" <no@xxxxxx>
Date: Wed, 27 Apr 2005 09:18:12 -0500

I would like to create a query for machines that have both Acrobat.exe and
AcroRd32.exe on them. When i go into the query and create the query with
the following syntax it doesn't produce any results. I do have several
machines with both these programs installed. Is there a something i am
missing on creating this query?

select * from SMS_R_System inner join SMS_G_System_SoftwareFile on
SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where
SMS_G_System_SoftwareFile.FileName = "acrobat.exe" and
SMS_G_System_SoftwareFile.FileName = "AcroRd32.exe"

Thanks.

.

Follow-Ups:
- RE: Creating Query
  - From: kiemer

Prev by Date: Re: SMS Advanced Client Setup Errors / WMI, DCOM, BITS
Next by Date: SMS_LAN_SENDER Error
Previous by thread: RE: SMS Advanced Client Setup Errors / WMI, DCOM, BITS
Next by thread: RE: Creating Query
Index(es):
- Date
- Thread

Relevant Pages

Re: Excel "Web Query"
... write a macro to find a reliable source. ... .....I've been using Excel's "Web Query" for a while now but I've ... on "some" machines and not others. ... So, upon further investigation, it appears when you "Edit Web Query" ...
(microsoft.public.excel)
Re: Excel "Web Query"
... .....I've been using Excel's "Web Query" for a while now but I've ... on "some" machines and not others. ... I know.....aren't pretty much ALL web queries used to do this :-) ... So, upon further investigation, it appears when you "Edit Web Query" ...
(microsoft.public.excel)
Re: Design view (select query with link table issues)
... but they do not work on some user's machines? ... you try to open the table directly in the database window, ... you are talking about a query that draws from tables that are not ... >> permissions, Windows user permissions, or file-share permissions. ...
(microsoft.public.access.queries)
Re: Union Query works on my PCs but not on clients machines
... will check all that out next time I visit the client. ... > To check the file versions between the two machines, ... The query contains undeclared parameters, ... >> office machines and updated it in the same way I updated my home PC. ...
(microsoft.public.access.queries)
RE: Collection not showing ALL of the clients correctly
... I created the new Collection and Query but ... Is there any troubleshooting to do at the client level? ... with all the machines that met that criteria, I selected all of them and it ... the machines I am still missing 3 machines. ...
(microsoft.public.sms.admin)