Jump to content


  • 0
Dust

Collection based upon products name and file version

Question

hey guys. without this site there is now way i could have made it this far into SCCM... now, iv hit a wall..

 

 

i have a application, java, that i need to install on all desktops. i have found a script that i thought would work, but something is missing. every time i update the collection i get no computers returned.

 

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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Java(TM) 6 Update" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version <= "1.6.0.70"

 

am i doing something wrong or am i just being impatient? i tired % symbols on the display name, still nothing...

 

Help please!

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Try to use like "%Java™ 6 Update%" and see the query.----this will check the application with word Java™ 6 Update

 

 

% End----look for comuters that start with word ,% Start----search for computers that ends with word.

 

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_ADD_REMOVE_PROGRAMS 
on 
SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId 
where 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Java(TM) 6 Update%" 
and 
SMS_G_System_ADD_REMOVE_PROGRAMS.Version <= "1.6.0.70"

 

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.