Query help

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Query help

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

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

Page: [1]

Message

<< Older Topic Newer Topic >>

Query help - 9/17/2008 7:57:24 AM

chiners_68

Posts: 208
Score: 3
Joined: 10/31/2007
Status: offline

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.

Post #: 1

RE: Query help - 9/17/2008 8:49:29 AM

Winston Smith

Posts: 53
Score: 0
Joined: 12/18/2007
Status: offline

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"

(in reply to chiners_68)

Post #: 2

RE: Query help - 9/18/2008 4:50:32 AM

chiners_68

Posts: 208
Score: 3
Joined: 10/31/2007
Status: offline

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.

(in reply to Winston Smith)

Post #: 3

RE: Query help - 9/18/2008 9:48:20 AM

evalasek

Posts: 22
Score: 0
Joined: 11/16/2007
Status: offline

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

_____________________________

Remember!
No matter where you go.
There you are!
Work Blog

(in reply to chiners_68)

Post #: 4

RE: Query help - 9/18/2008 10:00:00 AM

chiners_68

Posts: 208
Score: 3
Joined: 10/31/2007
Status: offline

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

(in reply to evalasek)

Post #: 5

RE: Query help - 9/18/2008 10:18:48 AM

evalasek

Posts: 22
Score: 0
Joined: 11/16/2007
Status: offline

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

Attachment (1)

_____________________________

Remember!
No matter where you go.
There you are!
Work Blog

(in reply to chiners_68)

Post #: 6

RE: Query help - 9/18/2008 11:24:32 AM

chiners_68

Posts: 208
Score: 3
Joined: 10/31/2007
Status: offline

sorted.

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

(in reply to evalasek)

Post #: 7

RE: Query help - 9/18/2008 11:42:12 AM

evalasek

Posts: 22
Score: 0
Joined: 11/16/2007
Status: offline

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

Attachment (1)

_____________________________

Remember!
No matter where you go.
There you are!
Work Blog

(in reply to chiners_68)

Post #: 8

Page: [1]

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

Page: [1]

Jump to:

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts

0.250