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,