Re: Reporting problem

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

There is no fix for this, except to update each query. In most cases you
need to add "EX" to a few of the views. If I remember right these are the
only views you need to update to add the "EX" to the end.



v_ApplicableUpdatesSummary

v_GS_PATCHSTATE

v_GS_PatchStatus

vSMS_G_System_PatchStatus




"Bryan" <Bryan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A5EDF510-EB7A-45FD-AB53-B65D34A45C69@xxxxxxxxxxxxxxxx
Garth... you are the man! That query is working just fine now. One more
question... most of the other "software update - compliance" queries arent
working either, I looked for an "updatessummary" in them but couldn't find
it. Does MS have a fix that I can apply to fix the rest of the queries? We
have 2 SMS environments and I would like to get all the queries to work.
We're running the latest SP3.
Thanks!!

"Garth" wrote:

It is not a old cab that is causing this issue, it is the query is using
the
old views. MS updated their views but didn't update the query.
Add and "EX" to the end of "v_ApplicableUpdatesSummary" so that it looks
like this "from v_ApplicableUpdatesSummaryEx"

That should do the trick.


"Bryan" <Bryan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3C7685B2-4D1C-48B3-BBAE-B7181996B85C@xxxxxxxxxxxxxxxx
I'm not sure if it changed from the original statement, if it did, we
didn't
change it. It seems to work but like I mentioned it pulls real old
data...
here's the statement. Is it possible that there is an old cab file
somwhere
that could be throwing this off?

set @Product = (case when IsNULL(@Product,'')='' then '%' else @Product
end)

select ID, QNumbers, Type, Product, Title, LocaleID, Language,
InfoPath,
Counts as 'Missing', InstalledCounts as 'Installed', TimeAuthorized
from v_ApplicableUpdatesSummary
where Product like @Product
order by Counts desc

"Kim Oppalfens [MVP]" <""Kim dot Oppalfen" wrote:


It definitely has me stumped, but then again Garth nows a fair deal
more
about querying and reporting than I do.
Garth wrote:
Have you looked at the SQL query? Has it been chanced from default
query?


"Bryan" <Bryan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8C593F2A-E334-4076-B88D-670D5BBD977A@xxxxxxxxxxxxxxxx
Is it possible that this question stumped everyone?
Even the all knowing Kim?? :-)

"Bryan" wrote:

does anyone out there have any ideas??

"Bryan" wrote:

Hello,
Several reports seem to be pulling old info... for example when
running
"computers where a specific update is applicable" if you go to
"update
identifier" the only available choices are updates from years
ago...
2002 and
earlier. Is it possible that the report is pointing towards an
old
cab
file??
Some are fine and these are all the standard reports. We have sms
2003
with
SP3.
any ideas?
Thanks!
Bryan




--
"Everyone is an expert at something"
Kim Oppalfens - Sms Expert for lack of any other expertise
Windows Server System MVP - SMS
http://www.blogcastrepository.com/blogs/kim_oppalfenss_systems_management_ideas/default.aspx






.

Relevant Pages

  • Re: Reporting problem
    ... It is not a old cab that is causing this issue, it is the query is using the ... MS updated their views but didn't update the query. ... Some are fine and these are all the standard reports. ... Kim Oppalfens - Sms Expert for lack of any other expertise ...
    (microsoft.public.sms.admin)
  • Re: Reporting problem
    ... have 2 SMS environments and I would like to get all the queries to work. ... "Garth" wrote: ... MS updated their views but didn't update the query. ... Some are fine and these are all the standard reports. ...
    (microsoft.public.sms.admin)
  • Re: Reports are only totaling the fields for the first record
    ... How do I fix this? ... The information for the queries and reports are entered on subforms. ... Here is my query behind the report Life Smart For Women: ...
    (comp.databases.ms-access)
  • Re: Stop the negativism!
    ... I, for one, have seen concrete demonstration of the efforts to fix the quality issues in BDS 2006. ... none of the reports I have been interested in have ever been fixed. ... Near the top of this page they have a section "Higher Performance and Better Quality" that says "Over 500 bug reports tracked by our internal system have been fixed in this release. ... Furthermore, the user who reported the problem was still using BCB 6, and he didn't get an update or hotfix, so this issue is not resolved for him unless he pays for an update to BDS 2006 and installs update 2. ...
    (borland.public.delphi.non-technical)
  • Re: Newbie? Do I use Report or Query
    ... <<what I really want is a conceptual model of how forms, queries and reports ... Reports are the counterpart of Forms. ... If based on a query, ... JobCard and JobDetails tables showing the fields in each for further ...
    (microsoft.public.access.gettingstarted)