Query to list the pending approvals of a Service Approver

Query to list the pending approvals of a Service Approver

I'v found query to list pending approvals, but it is related to Servicedesk MSP: https://pitstop.manageengine.com/portal/en/kb/articles/query-that-lists-pending-approvals-of-a-particular-service-approver

Can anyone share a version for on-premises Servicedesk? I have had one, but it looks like it broken after upgrade to last version due to database changes. Thanks.

                  New to ADSelfService Plus?