I have got multiple CAB Definations for our CAB's in our organization . We do have sometimes a single change which can appear in multiple CAB's.
My requirement is, I need to generate a report every week to check how many similar changes have gone to multiple CAB's. We do not have approval policy yet defined. but use the CAB Workbench to discuss our Changes.
I tried to create a report by using CAB Agenda table where the decision field is Approved AND Meeting .CAB definition name is < FIRSTCAB Name> AND Meeting .CAB Definition Name is <Second CAB Name> , but not getting any results though I know that the change has gone to multiple CABs,
Any help would be highly appreciated as this is an urgent requirement.
