Jump to content


loon

Collection Query of Multiple Items

Recommended Posts

Hello,

 

I need some collection help lease. I am trying to make a collection of machines that have a specific software product and all three of the hotfixes. The result is zero which I know is not true since I have a couple test VM's with all 4 items.

 

 

 

 

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_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceId = SMS_R_System.ResourceId inner join SMS_G_System_QUICK_FIX_ENGINEERING on SMS_G_System_QUICK_FIX_ENGINEERING.ResourceId = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName like "Software Name%" and SMS_G_System_QUICK_FIX_ENGINEERING.HotFixID = "KB123456" and SMS_G_System_QUICK_FIX_ENGINEERING.HotFixID = "KB234567" and SMS_G_System_QUICK_FIX_ENGINEERING.HotFixID = "KB3456789"

 

 

Thank you.

Share this post


Link to post
Share on other sites


Or would result in any of the search criteria being listed. It seems Op is looking for machines with all 4 of those installed.

 

Have you confirmed the quickfixengineering class has entries populating? Not bad the need to create a collection like this but double check. Try software + 1kb to verify it works befre adding the other 3kbs

Share this post


Link to post
Share on other sites

Or would result in any of the search criteria being listed. It seems Op is looking for machines with all 4 of those installed.

 

Have you confirmed the quickfixengineering class has entries populating? Not bad the need to create a collection like this but double check. Try software + 1kb to verify it works befre adding the other 3kbs

Then you will need to use subselect queries http://www.enhansoft.com/?s=subselect

 

Remember that QFE does not have all SU listed within (most but not all).

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
Reply to this topic...

×   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...