Query report about pending approval for more than 10 days ago

Query report about pending approval for more than 10 days ago

Hi,

I want to get requests that status is "pending approval" and create time is more than 10 days or two weeks ago. I want to get a report every week without a change query. I want to have a query report with these columns:

  • Request ID
  • Requester ID
  • Subject
  • Created Time
  • Approval Status
  • Request Status
  • Approvers

 

Build No: 11.1.21

DB: MS SQL


Thanks for helping

                  New to ADSelfService Plus?