Re: howto create XP SP2 query
- From: lee.james@xxxxxxxxxxxxx
- Date: 10 May 2005 10:18:53 -0700
Hi Kim,
When I try and put it in it says there's a syntax error....
J.
Kim Oppalfens wrote:
> select SMS_R_System.Name,
SMS_G_System_ADD_REMOVE_PROGRAMS.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_ADD_REMOVE_PROGRAMS on
> SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId
> where SMS_G_System_OPERATING_SYSTEM.CSDVersion = "Service Pack 2" and
> SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows XP
> Professional" order by SMS_R_System.Name
>
> This should do it, I don't know what query you used.
>
> Kim Oppalfens
> MVP SMS
>
> In article <17084052.0504210636.1e57eab9@xxxxxxxxxxxxxxxxxx>,
> lee.james@xxxxxxxxxxxxx says...
> > Looking to create a query in SMS 2.0 to get a list of product names
> > installed on systems running XP SP2.
> >
> > I tried creating the query to find SP2 systems and display the
product
> > names, but it just returns a list of everything (IE 5.5? I don't
think
> > so).
> >
> > Any help appreciated.
> >
> > J.
> >
>
> --
> Kim Oppalfens
> SMS MVP
.
- Follow-Ups:
- Re: howto create XP SP2 query
- From: Kim Oppalfens
- Re: howto create XP SP2 query
- Prev by Date: RE: Reporting site ASP Error
- Next by Date: Re: SMS Site Component Manager failed to reinstall SMS_SQL_Monitor
- Previous by thread: Cannot see advertisement status
- Next by thread: Re: howto create XP SP2 query
- Index(es):
Relevant Pages
|
