(An Untitled Masterwork)
ActivePublic
Actions

Authored by stwalkerster on Oct 30 2017, 10:41 PM.

Tags

None

Referenced Files

	F37372:
	Oct 30 2017, 10:41 PM

Subscribers

None

	select concat(a.username, '@', d.domain) source, a.destination
	from virtualalias a
	inner join virtualdomain d on d.enabled = 1 and d.id = a.domain
	where coalesce(a.destination, '') <> ''
	and a.action not in ('reject', 'discard')
	and not exists (
	select 1 from virtualuser u
	where u.enabled = 1 and u.alias = a.id
	)
	union all
	select concat(r.mailbox, '@', dr.domain), r.destination
	from rfc2142 r
	cross join virtualdomain dr
	where dr.enabled = 1
	and not exists (
	select 1
	from virtualalias ar
	where coalesce(ar.destination, '') <> ''
	and ar.action not in ('reject', 'discard')
	and ar.domain = dr.id
	and ar.username = r.mailbox
	)

stwalkerster created this object with visibility "Public (No Login Required)".

(An Untitled Masterwork)ActivePublicActions