I'm using  ServiceDesk Plus 8.2.0. I've searched the posts and found some great responses on the status of change approvers that help me towards my reporting requirement.  An example of one of these SQL query is

 

Select ChangeDetails.ChangeID "Change ID", ctdef.NAME "Change Type" , AaaUser.first_name "Cab Approver", ApprovalDetails .email "Email",  LONGTODATE(ApprovalHistory.action_date) "Acted On", ApprovalStatusDefinition.StatusName "Status", ApprovalHistory.comments "Comments", asd.StatusName "Change Status", aaa.FIRST_NAME "Change Approved by" , LONGTODATE(Changeapprovaldetails.action_date) "Change Approved On",Changeapprovaldetails.comments "Change Comments"  from ApprovalHistory left join ApprovalStatusDefinition on ApprovalHistory.statusid=ApprovalStatusDefinition.statusid Right join ApprovalDetails ON ApprovalHistory.APPROVALID=ApprovalDetails.APPROVALID left join SdUser ON ApprovalDetails.approverid=sduser.userid left join AaaUser ON sduser.USERID=aaauser.USER_ID left join ApprStageToChange on ApprovalDetails.Approval_StageID=ApprStageToChange.Approval_stageid left join Changedetails on ApprStageToChange.changeid=changedetails.changeid left join Changeapprovaldetails ON ChangeDetails.changeid=Changeapprovaldetails.changeid left join ApprovalStatusDefinition asd on Changeapprovaldetails.STATUSID=asd.STATUSID left join sduser sd on Changeapprovaldetails.approverid=sd.userid left join aaauser aaa on sd.userid=aaa.user_id LEFT JOIN ChangeTypeDefinition ctdef ON ChangeDetails.CHANGETYPEID=ctdef.CHANGETYPEID where ChangeDetails.ChangeID is not null

 

 

However - what I would really like to see is all change approvals including the field "Sent for recommendation on", as I want to see the time period for any approval request, bertween when it was sent and when it was actioned  by the approver (or not as the case may be).

 

Can anyone help me with the query to do this?

 

Many thanks

Julie