Two emails being sent

[eboykin]

I have setup the Vault to email me when anything is checked in on a certain tree. I am received duplicate emails now. I only entered one address.

[jclausius]

Can you run this query in a query tool?

Code: Select all

SELECT u.userid, u.login, u.email, r.name + N' / ' + n.name
	FROM sgvault.dbo.tblusers u
	INNER JOIN sgvault.dbo.tblwatchers w ON w.userid = u.userid
	INNER JOIN sgvault.dbo.tblfsobjects o ON o.objid = w.objid
	INNER JOIN sgvault.dbo.tblrepositories r ON o.repid = r.repid
	INNER JOIN sgvault.dbo.tblfsobjectversions v ON v.objid = o.objid AND v.objversion = o.lastobjversion
	INNER JOIN sgvault.dbo.tblfsobjectversionnames n ON n.vernameid = v.vernameid WHERE u.login = N'<ENTERY_YOUR_LOGIN_HERE>'

Do you see any overlap of email addresses?

[eboykin]

there is only 1 record:
5 eb eboykin@youngconsulting.com Delphi_50 / Delphi_50

Any ideas?

[jclausius]

What about the following:

Code: Select all

SELECT u.userid, u.login, u.email, r.name + N' / ' + n.name
   FROM sgvault.dbo.tblusers u
   INNER JOIN sgvault.dbo.tblwatchers w ON w.userid = u.userid
   INNER JOIN sgvault.dbo.tblfsobjects o ON o.objid = w.objid
   INNER JOIN sgvault.dbo.tblrepositories r ON o.repid = r.repid
   INNER JOIN sgvault.dbo.tblfsobjectversions v ON v.objid = o.objid AND v.objversion = o.lastobjversion
   INNER JOIN sgvault.dbo.tblfsobjectversionnames n ON n.vernameid = v.vernameid WHERE u.email = N'eboykin@youngconsulting.com'

Still one row?

[eboykin]

Yes,
again only 1 row. Could this be somethign unrelated to the vault and perhaps on my mail server?

[jclausius]

Possibly. If there is only one row, the Vault server would only attempt one email message.