Re: howto create XP SP2 query


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: Printing earliest report of name selected
    ... recent date for each client. ... Use this query as the source for your report. ... Ok I used my location table to SELECT RigNameID, ... Since one "name" can have many entries here, I assume you have set up a ...
    (microsoft.public.access.reports)
  • Re: Printing earliest report of name selected
    ... You can then use that query to limit another query to only the most recent call per rig. ... here's an example using the Orders table from the old Northwind sample database to show details of the most recent order per client: ... Ok I used my location table to SELECT RigNameID, ... Since one "name" can have many entries here, I assume you have set up a ...
    (microsoft.public.access.reports)
  • Re: Querying off multiple columns
    ... The main query will show ... > all entries with the same CUSIP number and the person will go off the ... One would be the key (client number?) and the ... >> I have a form that provides 10 entries for fund numbers. ...
    (microsoft.public.access.forms)
  • Re: Querying off multiple columns
    ... The main query will show ... all entries with the same CUSIP number and the person will go off the ... One would be the key (client number?) and the ... > I have a form that provides 10 entries for fund numbers. ...
    (microsoft.public.access.forms)
  • RE: Collection not showing ALL of the clients correctly
    ... If I'm not getting hardware inventory then the client is not ... through the query to create a new collection and that seemed to work. ... added the other machines that have not been showing up as "Direct" and I now ...
    (microsoft.public.sms.admin)