Page History

...

crm.query.mailbox.dashboard

SELECT distinct
	CRM_MAILBOX.id_mailbox,
	CRM_MAILBOX.ds_mailbox,
	(select count(CRM_TEAMUSERS.ID_TEAMUSERS) from CRM_TEAMUSERS (nolock) 
	 where CRM_MAILBOX.id_mailbox = CRM_MAILBOXTEAM.id_mailbox  and CRM_MAILBOXTEAM.id_team = CRM_TEAMUSERS.id_team) AS nr_vinculado,
	 (select count(CRM_USER.ID_CRMUSER)from CRM_USER (nolock) 
		where CRM_USER.do_authenticationtype = 'C' and CRM_USER.id_crmuser = CRM_TEAMUSERS.id_crmuser
	 	and CRM_MAILBOX.id_mailbox = CRM_MAILBOXTEAM.id_mailbox  and CRM_MAILBOXTEAM.id_team = CRM_TEAMUSERS.id_team) AS nr_logados
FROM 
CRM_MAILBOX (nolock) 
		inner join CRM_MAILBOXTEAM (nolock)  on CRM_MAILBOX.id_mailbox = CRM_MAILBOXTEAM.id_mailbox  
		inner join CRM_TEAMUSERS (nolock)  on CRM_MAILBOXTEAM.id_team = CRM_TEAMUSERS.id_team
		inner join CRM_USER (nolock)  on CRM_USER.id_crmuser = CRM_TEAMUSERS.id_crmuser
GROUP BY 
CRM_MAILBOX.id_mailbox,
CRM_MAILBOX.ds_mailbox,
CRM_MAILBOXTEAM.id_mailbox,
CRM_MAILBOXTEAM.id_team,
CRM_TEAMUSERS.id_team,
CRM_USER.id_crmuser,
CRM_USER.do_authenticationtype,
CRM_TEAMUSERS.id_crmuser

2. crm.query.mailfile.list da CRM_MAILFILE - Modificação de Query

...