CREATE VIEW "eventview" ("eventid", "timestamp", "source", "fullname", "dept", "mscreenname", "cscreenname", "bscreenname") AS
SELECT "secure_event"."id", "secure_event"."timestamp", "secure_event"."source", "secure_person"."fullname", "secure_person"."department", "secure_machine"."screenname", "category"."screenname", "building"."screenname"
FROM "secure_event", "secure_person", "secure_machine", "category", "personalias", "machinealias", "building"
WHERE secure_event.personaliasid = personalias.id AND personalias.personid = secure_person.id AND secure_event.machinealiasid = machinealias.id AND machinealias.machineid = secure_machine.id AND (secure_machine.buildingid IS NULL OR secure_machine.buildingid = building.id) AND secure_event.categoryid = category.id
GO
[dbo].[eventview]