myITforum.com Community Forum 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:


  


Can someone please help me create a query on pcs without Windows Internet Explorer 7.

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

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Can someone please help me create a query on pcs without Windows Internet Explorer 7. Page: [1]
Login
Message << Older Topic   Newer Topic >>
Can someone please help me create a query on pcs withou... - 9/2/2008 1:44:15 AM   
nkobas

 

Posts: 14
Score: 0
Joined: 6/24/2008
Status: offline 		Can someone please help me create a query on pcs without Windows Internet Explorer 7.

Using SMS 2003 SP3

I've created a query on PCs with Windows Internet Explorer 7 which works.

select SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_R_System.IPAddresses, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Name not like "%server%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Windows Internet Explorer 7"

Query created on PCs without Windows Internet Explorer 7 which doesn't work.

select SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_R_System.IPAddresses, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Name not like "%server%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName != "Windows Internet Explorer 7"

Thanks heaps
Post #: 1
RE: Can someone please help me create a query on pcs wi... - 9/2/2008 2:14:53 AM   
nkobas

 

Posts: 14
Score: 0
Joined: 6/24/2008
Status: offline 		CORRECTION -

Query created on PCs without Windows Internet Explorer 7 which DOES WORK but also gives all the other apps in Add/Rmove programs.

Just need PCs without Windows Internet Explorer 7

select SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_R_System.IPAddresses, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Name not like "%server%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName != "Windows Internet Explorer 7"

(in reply to nkobas)
Post #: 2
RE: Can someone please help me create a query on pcs wi... - 9/2/2008 5:37:01 AM  1 votes
fault

 

Posts: 32
Score: 2
Joined: 7/21/2008
Status: offline 		You can do this with a sub-select query. See http://myitforum.com/cs2/blogs/jgilbert/archive/2008/07/22/subselect-queries-the-easy-way.aspx ... Something like this should get you going:

quote:

select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System where SMS_R_System.ResourceId not in (select SMS_R_System.ResourceId 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") and SMS_R_System.Client = 1


Edit: WQL was copied from that URL. You should be able to remove that INNER JOIN from the sub-query to further optimise it.


< Message edited by fault -- 9/2/2008 6:17:20 AM >

(in reply to nkobas)
Post #: 3
RE: Can someone please help me create a query on pcs wi... - 9/2/2008 10:30:13 AM   
ctour

 

Posts: 21
Score: 0
Joined: 8/8/2008
Status: offline 		select SMS_R_System.ResourceID,
SMS_R_System.ResourceType,
SMS_R_System.Name,
SMS_R_System.SMSUniqueIdentifier,
SMS_R_System.ResourceDomainORWorkgroup,
SMS_R_System.Client from SMS_R_System
where SMS_R_System.ResourceID not in (Select ResourceID from SMS_CM_RES_COLL_C00001A1)
C00001A1 is the collection ID for your IE7 collection

(in reply to fault)
Post #: 4
RE: Can someone please help me create a query on pcs wi... - 9/2/2008 10:38:53 PM   
nkobas

 

Posts: 14
Score: 0
Joined: 6/24/2008
Status: offline 		Worked perfectly!!!

Thanks fault and ctour

(in reply to ctour)
Post #: 5
Page:   [1]
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Can someone please help me create a query on pcs without Windows Internet Explorer 7. 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



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.188