Re: SMS 2003 Report question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I should have said report not query.

Report use SQL
Collection/query use WQL

And that is a SQL query.


"ant_techie" <anttechie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:8B7AB69F-C3D9-4F60-9CD4-AE8D1E2449A2@xxxxxxxxxxxxxxxx
Hi Garth,

Thanks for the reply, but I get an error with that query

WBEM_E_INVALID_QUERY

Is it syntax or something else?

Anthony.

"Garth" wrote:

This query might help you..
http://smsug.ca/blogs/garth_jones/archive/2007/11/09/748.aspx


"ant_techie" <anttechie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B4446D44-46D1-4830-815B-899FCFD6EC96@xxxxxxxxxxxxxxxx
> Hi,
>
> I am trying to create a report that will display all the computers in a
> collection and if they have a specific file (as per the inventory > info).
>
> I have managed to create 2 queries, one that will display ONLY the
> computers
> in a collection that have the specific file in question, and another > query
> that will display ONLY the computers that don't have the file.
>
> However, I need a query or report that will show all the computers > whether
> or not they have the file and if they have the file or not.
>
> ie
>
> COMPUTER1 Yes
> COMPUTER2 Yes
> COMPUTER3 No etc, etc...
>
> Any Ideas as to the best way to approach this one?
>
> Cheers,
>
> Anthony.
>


.

Relevant Pages

  • Re: Print report based on value of 2 combo boxes
    ... What I need is the syntax for the rest of the DoCmd.Openreport..... ... The report "AllComputers" will be used for many different queries, ... the computers in the table" to a "particular computer" ... > boxes on the form to filter the query behind your report. ...
    (microsoft.public.access.reports)
  • Re: Report problem - Access 2003
    ... "tina" wrote: ... a basic report bound to that query. ... Yes I have a table that links staff to computers. ...
    (microsoft.public.access.reports)
  • Re: Query to .rtf problem.
    ... certain information" without any hint as to what is missing. ... Does the query (or report) work differently on the two computers if you ...
    (microsoft.public.access.externaldata)
  • Re: Inventory Report
    ... Another typical subselect or "Not In" query. ... the syntax into a report. ... > computers that are in any OU which name ends as '%WORKSTATIONS' by putting ...
    (microsoft.public.sms.inventory)
  • Re: sql query help
    ... I'm afraid I can't get the sql query to work. ... > Create collection C containing all computers "with" winword.exe. ... > Collection B would have a membership query with one subselect statement ...
    (microsoft.public.sms.admin)