Need query to show all support groups that have a group e-mail address

Need query to show all support groups that have a group e-mail address

I currently have this query but it brings up a report that is 342 pages long. I only have 20 support groups so the report shouldn't be this long

SELECT qd.QUEUENAME as 'Support Group',qe.EMAIL as 'Support Group E-mail',qd.SENDERNAME as ' Support Group NAme', qd.REPLYADDRESS as 'Support Group Reply E-mail' FROM QueueDefinition as QD LEFT JOIN Queue_Email AS qe on qd.QUEUEID=qe.QUEUEID


Can the query be modified to show all support groups that use a group e-mail address? I am using SDP 9.3 build 9309 with MSSQL Windows Server 2012 R2


        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?

                  New to ADSelfService Plus?

                  Start your free trial





                            Related Products