Re: howto create XP SP2 query

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Kim,

It's working now. I guess it just took overnight before everything got
'synched up'.

Thanks for all your help. One final question?

How would I rewrite the SQL syntax to create a Web Report?

Here's the 'code':

select distinct SMS_G_System_ADDREMPROGS.DisplayName from SMS_R_System
inner join SMS_G_System_OPERATING_SYSTEM on
SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId
inner join SMS_G_System_ADDREMPROGS on
SMS_G_System_ADDREMPROGS.ResourceID = SMS_R_System.ResourceId where
SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows XP
Professional" and SMS_G_System_OPERATING_SYSTEM.CSDVersion = "Service
Pack 2"

Thx,

J.

Kim Oppalfens wrote:
> Try forcing another hardware inventory on the client and see whether
> entries show up in Resource explorer. As long as they are not
available
> the query will most likely fail since the classes don't exist yet.
>
> Do you see a table in the sms database that contains addremprogs_data
&
> addremprogs_hist?
>
> Kim Oppalfens
> MVP SMS
> In article <1116452271.743778.130980@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
> lee.james@xxxxxxxxxxxxx says...
> > Hi Kim,
> >
> > I installed the Web Reporting tool (from the Admin feature pack)
and it
> > installed fine - I can run the web reports no problem. I also
verified
> > that it updated the sms_def.mof and I verified on a client that I
> > forced a hardware inventory on that it compiled the new mof file
> > successfully.
> >
> > I then entered your query again and it didn't give me a syntax
error.
> > However, now when I run the query I get a WBEM_E_INVALID_QUERY
pop-up.
> >
> > I also noticed that in going through the Hardware inventory for the
> > client I forced an update on, I don't see any new entries related
to
> > add/remove programs.
> >
> > Any ideas?
> >
> > J.
> >
> >
>
> --
> Kim Oppalfens
> SMS MVP

.

Relevant Pages

  • Re: Enable inventory of bitlocker drive status
    ... I'm interested in using SMS to monitor Bitlocker status for Vista ... the Hardware inventory cycle has gone missing again (locally on all ... notice a line regarding "Client Component item named Hardware Inventory ...
    (microsoft.public.sms.inventory)
  • Re: Renaming Clients with SMS Client
    ... I also initiated a hardware inventory request and the status did not ... Sms server doesn't have to know since almost everything in sms is poll ... know the PC with the new name has a client, ...
    (microsoft.public.sms.admin)
  • Re: Enable inventory of bitlocker drive status
    ... I need to find the SMS specific forum as it seems this is ... the Hardware inventory cycle has gone missing again (locally on all ... notice a line regarding "Client Component item named Hardware Inventory ...
    (microsoft.public.sms.inventory)
  • Re: Changed the Cache size of Clients
    ... "Kim Oppalfens" wrote: ... > systems collection, select sms tools, Choose change cache size. ... >> I have a new SMS2003 install. ... Everything is advance Client and advanced ...
    (microsoft.public.sms.setup)
  • Re: SMS remote tools issue
    ... Ping -a resolves to a proper FQDN and IP address, and in the SMS database ... "Kim Oppalfens" wrote: ... > dns, wins, lmhosts, host, whatever way the machine has to resolve the ... >> client machines. ...
    (microsoft.public.sms.admin)