Re: Need help creating a new Report

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



"Dan Brierley" <DanBrierley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AC9C4A7A-69E9-4481-ACF2-D962BF4FE76F@xxxxxxxxxxxxxxxx
Thank you Kim.

I added the Report. Ran it, only to find that this is not the Report I was
looking for. My original question follows:

The old SMS web reporting tools canned queries had a query that I used
daily.
In perticular,
"Machines with greater than or equal to number of applicable updates"

Does anyone have a sql statement that can give me all computer names with
X
being Equal to or greater than a number I select, of patches that are
applicable?

Do you still have access to the SMS 2.0 web reports? If you can post the SQL
that made the report maybe we can make that work in SMS 2003.

Steve


.



Relevant Pages

  • Re: Report Error
    ... Looking to get more involved in the SMS community? ... > It shows OK in reportinstall.log when Report is enable. ... > the IIS service manager and browse that web folder? ... installing. ...
    (microsoft.public.sms.admin)
  • Re: SMS Query for Registry Key?
    ... outputting the the desired data. ... you're right.....It would be good if I could match the output data to the system names =). ... to start a new thread mentioning the word report in the subject :-) ... I forgot to add that my focus point in these newsgroups is "sms 2003" and clustering. ...
    (microsoft.public.sms.admin)
  • Using Reports/Dashboards to import another ODBC connection
    ... We are using SMS 2003 in our infrastructure. ... of the things I was curious about was creating a custom report. ... database. ...
    (microsoft.public.sms.inventory)
  • RE: SMS 2003 Web Reporting
    ... Automate. ... "Brent Waddell" wrote: ... not show up in SMS web reporting. ... the report has additional criteria which will only be available ...
    (microsoft.public.sms.admin)
  • Re: Alarm if change or rob hardware success
    ... what I would do is create a report like this (this one is for memory ... Then schedule the report to run with an export to option ... > I like to monitor all me company, around 600 sms clients. ... >> Kim Oppalfens ...
    (microsoft.public.sms.admin)