Re: Custom Report ? - Computers WITHOUT a Specific Product

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



investigate the 'subselected values' option when you create your query in
SMS.

"NathanC" <NathanC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AC3EDB46-DBDD-4125-9BC0-79522A4EC184@xxxxxxxxxxxxxxxx
How can I customize the report "Computers with a specific product" to
instead
return a list of computers without the specific product?

I guess I am really asking for SQL help, because I do know how to go
through
the Admin console and see the SQL statements for the report. I just am not
sure how to properly edit it. My recent attempts have returned unwanted
data.

I think that I just need to edit the first SQL statement, not the prompt
statement, but please correct me if I am wrong. I'll keep attempting on my
own, but hopefully, someone will hook me up.

Thanks!


.



Relevant Pages

  • Re: Report Question about Groups
    ... > book that shows how to write SQL statements for SMS? ... Unfortunately I have yet to find a good reference on sms's sql views. ... documented in the sms sdk: ...
    (microsoft.public.sms.misc)
  • Re: Report Question about Groups
    ... book that shows how to write SQL statements for SMS? ... "Kim Oppalfens" wrote: ... > MVP SMS ...
    (microsoft.public.sms.misc)