Re: SMS 2003 Report question

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

Hi Garth,

It sort of works :-)

SELECT DISTINCT
CS.Name0,
(Case when SF.FileName='File.exe' then 'Yes' else ' ' end) as 'File'
FROM
dbo.v_GS_SoftwareFile SF
Right OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM CS ON SF.ResourceID = CS.ResourceID
ORDER BY CS.Name0

If the file does not exist then I get one record showing that the file does
not exist, but if the file does exist, then I get two records. One showing
the file does not exist, and one showing that the file does exist.

Name File
COMPUTER1
COMPUTER1 Yes
COMPUTER2
COMPUTER3
COMPUTER3 Yes


Also, even though I select a specific collection, the results show all
computers from all the collections.

We can certainly use this as a report, but it would be nice to tidy it up.

Cheers,

Anthony.

"Garth" wrote:

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: SMS 2003 Report question
    ... I should have said report not query. ... And that is a SQL query. ... > I am trying to create a report that will display all the computers in a ...
    (microsoft.public.sms.misc)
  • 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)