GarthMJ,
I may be more of a NOOB than the person who posted this question. All day today I have been trying to figure out how to be prompted for a collection. I understand created the extra dataset and adding a parameter to point to that dataset. What I am not understanding is how to tie all this in to the Original Query. My original Query basically looks at "All Systems" and tells me the OS that is installed. I have 42 different collections I would like to be able to select from instead of getting a report of All Systems. Here is my query:
select all SMS_R_SYSTEM.ItemKey,SMS_R_SYSTEM.DiscArchKey,SMS_R_SYSTEM.Name0,SMS_R_SYSTEM.SMS_Unique_Identifier0,SMS_R_SYSTEM.Resource_Domain_OR_Workgr0,SMS_R_SYSTEM.Client0 from vSMS_R_System AS SMS_R_System INNER JOIN Operating_System_DATA AS SMS_G_System_OPERATING_SYSTEM ON SMS_G_System_OPERATING_SYSTEM.MachineID = SMS_R_System.ItemKey INNER JOIN _RES_COLL_SCS00235 AS SMS_CM_RES_COLL_SCS00235 ON SMS_CM_RES_COLL_SCS00235.MachineID = SMS_R_System.ItemKey where SMS_G_System_OPERATING_SYSTEM.Caption00 = N'Microsoft Windows 7 Professional'
How do I join the other dataset to this to prompt me to choose a collection? I apologize for the dumb question. I have spent all day on google and tried so many different things with no luck. I know this can't be that difficult. Would appreciate any assistance.
Rich