Sunday, January 27, 2008

GoldMine Standard - E-mails in mailbox

If you want to find out who is not filing their e-mail into history you can run a SQL query to get e-mail inbox counts.

* Go to Lookup/SQL Queries and paste the following into the SQL Query box:

Select count (*),
UserID
From Mailbox
Where Folder = 'X-GM-INBOX'
Group by USERID
Order by USERID

*Click on Save and name the query
*Click on the Query button and it will return the name of all users and the number
of e-mails in their inbox


This will also work in GoldMine Premium Edition.

No comments: