We help IT Professionals succeed at work.

How do I create SMS collections for workstations installed with IE5.5 and IE 6.0

terencesong
terencesong asked
on
174 Views
Last Modified: 2010-04-14
Hi all,

I've tried creating the above but I can't seem to figure it out. I need to create SMS collections for my company, one collection for all workstations installed with IE 5.5 (any SP) and one for all workstations installed with IE 6.0 .

Any help would be appreciated. Thanks!
Comment
Watch Question

SMS collections??? What are you actually wanting to know.

Do you want to know how to create a database with a collection of client information on so that it's easily extracted.

Please be a little more specific here.

Thanks
Stevengreen

Author

Commented:
Hi all,
I've found the answer to my question.

Stevengreen: I do know how SMS collections are created but I was having problems creating collections that look for PCs containing a particular software.

Here's how I did it:

1. Create new collection
2. Set Criteria to be as follows:
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 inner join SMS_G_System_ADDREMPROGS on SMS_G_System_ADDREMPROGS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADDREMPROGS.DisplayName like "%Internet Explorer 6 SP1%"
3. After that I did the same for IE 5.5

This question will be closed.

Thank you for your time.
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.