How can i create a report about: process time in Service Desk by sql command

How can i create a report about: process time in Service Desk by sql command

I want to create a report processtime in service desk by sql command!

This is report form i want:

- RequestID
- Description
- Processtime

by formula: processtime = resolved time - created time - onhold time

But i don't know how can i create it!

Please, help me!

Thank & best regards!

TuanLA10

















        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                        Related Products