Would it work if you look for any change that has the approval or rejection in the process? I believe you can create a query and then set criteria that it was approved
cgodden has the correct answer, since you will not be able to query on the entry into a status, unless you have an automated action that records this, you would need to build your query on the available actions from the CAB Approval status. This seems good in theory, unless you have these exact same actions being used elsewhere in the process. You might also want to look at the actions required to be used to enter the status.
Assume the approval action itself is a regular action, then you should be able to write a query against Change/Approval (or whatever the action was called). That will give you every single approval action, date, time,person group etc. However if this action was a windowless one, then I think you are a bit stuck
I'd have a boolean called 'Entered CAB Approval' and each time the action to move the ticket to this status was selected, you'd mark this boolean as true with an automatic action. The same way the Incidents have a 'Reopened' boolean to mark off whether they've been reopened or not.
This would flag any changes that have passed through that status previously, regardless of the status their at now.
Long time no see!
Can you add a screenshot of the section of your process this takes place in? IE How a change goes to the status and how it leaves.
Just want to make sure you get the right answer first time!
Does anyone have a SQL QRY to find out the Reports for the Change By CAB Approval Group