Query help (Full Version)

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager



Message

chiners_68 -> Query help (9/17/2008 7:57:24 AM)

want to produce a query to find out what machines have IE7 installed but cannot find the right catogories etc to query this.
Im deploying IE7 by Software updates & it tells me i have 700+ IE7's but i want a query so i can get a list of these machine names. Wsus/Software updates dosnet give you a list of host names.



Winston Smith -> RE: Query help (9/17/2008 8:49:29 AM)

This might work for you

select distinct SMS_R_System.Name from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Windows Internet Explorer 7"



chiners_68 -> RE: Query help (9/18/2008 4:50:32 AM)

Winston,
IE7 dosent apear in add remove programs as its integrated into the install on 60% of my machines.

need some other way of querying its installed.



evalasek -> RE: Query help (9/18/2008 9:48:20 AM)

Hi there,
My 2 cents worth.
I created a report to show the same thing:
select distinct(SF.FileDescription +' '+left(sf.fileversion,3)), count(SF.FileDescription +' '+left(sf.fileversion,3)) as 'Count'
from v_GS_SoftwareFile SF
inner join v_R_System sys on SF.ResourceID=sys.ResourceID
where FileName = 'iexplore.exe' AND sf.FilePath like '%prog%internet%'
Group By SF.FileDescription +' '+left(sf.fileversion,3)
Just copy and paste this into a new report and will give you a count of machine with a specific IE version.


Mike



chiners_68 -> RE: Query help (9/18/2008 10:00:00 AM)

mthaxter,
syntax error when pasting in that into the query statment properties & oking..



evalasek -> RE: Query help (9/18/2008 10:18:48 AM)

Chiners_68,
Sorry I'm using SCCM SP1, here is a MOF you can import.

Just rename the .txt to .MOF and it should import fine.


Mike



chiners_68 -> RE: Query help (9/18/2008 11:24:32 AM)

sorted.

it was a report not a query. I was trying to import into a query but reports & queries use slightly different language



evalasek -> RE: Query help (9/18/2008 11:42:12 AM)

Sorry,

Misread the help,

Here is a MOF for the QUERY you're looking for.

Again, remove the .txt to make it a MOF file.

Mike




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.1875