need Custom query report to find out total request submitted by organizational user and external user
I'm looking for a custom report SQL query that can help us find out the monthly request submitted by internal user and external user based on their primary email address. and the request need to be grouped by their email domain, like @abc.com
The field requires request ID, subject, requester, request status.
Thank you for your support.
Build Information
| Your Version | : 11.1 Build 11101 |
PostgreSQL Server
Database version: 10.5