custom query

custom query

Is there a way to add to my custom query to see what configuration applied the patch.
 
If i create custom query like:
Select b.RESOURCE_ID, b.NAME, a.Patch_ID, LONG_TO_DATE(Installed_TIME)
from InstallPatchStatus a, resource b
where a.Installed_Time >= DATE_TO_LONG(04/04/2013 00:00:00) and a.Installed_Time < DATE_TO_LONG(04/05/2013 00:00:00) and a.resource_ID=b.resource_ID and b.name like '%MWR????33%'
 
It will return:
RESOURCE_ID
NAME
PATCH_ID
INSTALLED_TIME
22811
MWR????33
10046
Apr 04,2013 02:47:09 PM
22811
MWR????33
98412
Apr 04,2013 02:48:23 PM
22811
MWR????33
13344
Apr 04,2013 02:52:50 PM
22811
MWR????33
98490
Apr 04,2013 02:48:24 PM
22811
MWR????33
98317
Apr 04,2013 02:47:18 PM
22811
MWR????33
98562
Apr 04,2013 02:53:06 PM
22811
MWR????33
98320
Apr 04,2013 02:47:45 PM
 
 
How can I see what Collection_ID / Config_ID caused each patch to be installed?
 
Thanks,

                  New to ADSelfService Plus?