select 'Events Version'  as Type, Null as KeyID, Version as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}DesktopModules where ModuleName='DNN_Events'
union select 'TableCount - Events' as Type, Count(*) as KeyID, cast(getdate() as varchar) as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events
Union select 'TableCount - EventsLocation' as Type, Count(*) as KeyID, cast(getdate() as varchar) as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsLocation
Union select 'TableCount - EventsCategory' as Type, Count(*) as KeyID, cast(getdate() as varchar) as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsCategory
Union select 'TableCount - EventsMasters' as Type, Count(*) as KeyID, cast(getdate() as varchar) as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsMaster
Union select 'TableCount - EventsNotifications' as Type, Count(*) as KeyID, cast(getdate() as varchar) as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsNotification
Union select 'TableCount - EventsPPErrorLog' as Type, Count(*) as KeyID, cast(getdate() as varchar) as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsPPErrorLog
Union select 'TableCount - EventsSignups' as Type, Count(*) as KeyID, cast(getdate() as varchar) as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsSignups
Union select 'FK Error - Events-->EventsLocation' as Type, EventID as KeyID, 'Event Name: ' + EventName as KeyName, Location as [Missing Key] from {databaseOwner}{objectQualifier}Events where Location not in (Select Location from {databaseOwner}{objectQualifier}EventsLocation) and Location > 0
Union select 'FK Error - Events-->EventsCategory' as Type, EventID as KeyID, 'Event Name: ' + EventName as KeyName, Category as [Missing Key] from {databaseOwner}{objectQualifier}Events where Category not in (Select Category from {databaseOwner}{objectQualifier}EventsCategory) and Category > 0
Union select 'FK Error - Events-->Portals' as Type, EventID as KeyID, 'Event Name: ' + EventName as KeyName, PortalID as [Missing Key] from {databaseOwner}{objectQualifier}Events where PortalID not in (Select PortalID from {databaseOwner}{objectQualifier}Portals)
Union select 'FK Error - EventsMaster-->Modules' as Type, {databaseOwner}{objectQualifier}EventsMaster.MasterID as KeyID, 'Module Name: ' + {databaseOwner}{objectQualifier}Modules.ModuleTitle as KeyName, {databaseOwner}{objectQualifier}EventsMaster.SubEventID as [Missing Key] from {databaseOwner}{objectQualifier}EventsMaster INNER JOIN {databaseOwner}{objectQualifier}Modules ON {databaseOwner}{objectQualifier}EventsMaster.ModuleID = {databaseOwner}{objectQualifier}Modules.ModuleID where {databaseOwner}{objectQualifier}EventsMaster.SubEventID NOT IN (Select ModuleID from {databaseOwner}{objectQualifier}Modules)
Union select 'FK Error - EventsSignups-->Users' as Type, SignupID as KeyID, 'Event Name: ' + {databaseOwner}{objectQualifier}Events.EventName as KeyName, UserID as [Missing Key] from {databaseOwner}{objectQualifier}EventsSignups INNER JOIN {databaseOwner}{objectQualifier}Events ON {databaseOwner}{objectQualifier}EventsSignups.EventID = {databaseOwner}{objectQualifier}Events.EventID where UserID not in (Select UserID from {databaseOwner}{objectQualifier}Users)
Union select 'FK Error - EventsPPErrorLog-->EventsSignups' as Type, PayPalID as KeyID, 'User Email: ' + PayPalUserEmail COLLATE Latin1_General_CI_AS as KeyName, SignupID as [Missing Key] from {databaseOwner}{objectQualifier}EventsPPErrorLog where SignupID not in (Select SignupID from {databaseOwner}{objectQualifier}EventsSignups)
Union select 'FK Error - EventsNotification-->PortalAlias' as Type, NotificationID as KeyID, 'User Email: ' + UserEmail COLLATE Latin1_General_CI_AS as KeyName, PortalAliasID as [Missing Key] from {databaseOwner}{objectQualifier}EventsNotification where PortalAliasID not in (Select PortalAliasID from {databaseOwner}{objectQualifier}PortalAlias)
Union select 'Null Error - Events-->ModuleID' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where ModuleID is null
Union select 'Null Error - Events-->EventDateBegin' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where EventDateBegin is null
Union select 'Null Error - Events-->EventDateEnd' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where EventDateEnd is null
Union select 'Null Error - Events-->EventTimeBegin' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where EventTimeBegin is null
Union select 'Null Error - Events-->Duration' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where Duration is null
Union select 'Null Error - Events-->EventName' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where Eventname is null
Union select 'Null Error - Events-->Importance' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where Importance is null
Union select 'Null Error - Events-->RepeatType' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where RepeatType is null
Union select 'Null Error - Events-->Every' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where Every is null
Union select 'Null Error - Events-->Reminder' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where Reminder is null and SendReminder <> 0
Union select 'Null Error - Events-->Notify' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where Notify is null and SendReminder <> 0
Union select 'Null Error - Events-->CreatedBy' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where CreatedBy is null
Union select 'Null Error - Events-->CreatedDate' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where CreatedDate is null
Union select 'Null Error - Events-->Approved' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where Approved is null
Union select 'Null Error - Events-->PortalID' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where PortalID is null
Union select 'Null Error - Events-->Signups' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where Signups is null
Union select 'Null Error - Events-->MaxEnrollment' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where MaxEnrollment is null and Signups <> 0
Union select 'Null Error - Events-->EnrollFee' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where EnrollFee is null and Signups <> 0
Union select 'Null Error - Events-->EnrollType' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where EnrollType is null and Signups <> 0
Union select 'Null Error - Events-->Cancelled' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where Cancelled is null
Union select 'Null Error - Events-->ImageURL' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where ImageURL is null and ImageDisplay <> 0
Union select 'Null Error - Events-->ImageType' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where ImageType is null and ImageDisplay <> 0
Union select 'Null Error - Events-->ImageWidth' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where ImageWidth is null and ImageDisplay <> 0
Union select 'Null Error - Events-->ImageHeight' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where ImageHeight is null and ImageDisplay <> 0
Union select 'Null Error - Events-->ImageDisplay' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where ImageDisplay is null
Union select 'Null Error - Events-->Location' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where Location is null
Union select 'Null Error - Events-->Category' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where Category is null
Union select 'Null Error - Events-->TimezoneOffset' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where TimezoneOffset is null
Union select 'Null Error - Events-->SendReminder' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where SendReminder is null
Union select 'Null Error - Events-->ReminderTime' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where ReminderTime is null and SendReminder <> 0
Union select 'Null Error - Events-->ReminderTimeMeasurement' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where ReminderTimeMeasurement is null and SendReminder <> 0
Union select 'Null Error - Events-->ReminderFrom' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where ReminderFrom is null and SendReminder <> 0
Union select 'Null Error - Events-->SearchSubmitted' as Type, EventID as KeyID, 'EventName: ' + Eventname as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}Events where SearchSubmitted is null
Union select 'Null Error - EventsNotification-->NotifyByDateTime' as Type, NotificationID as KeyID, 'User Email: ' + UserEmail as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsNotification where NotifyByDateTime is null
Union select 'Null Error - EventsNotification-->EventTimeBegin' as Type, NotificationID as KeyID, 'User Email: ' + UserEmail as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsNotification where EventTimeBegin is null
Union select 'Null Error - EventsNotification-->NotifyLanguage' as Type, NotificationID as KeyID, 'User Email: ' + UserEmail as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsNotification where NotifyLanguage is null
Union select 'Null Error - EventsMaster-->ModuleID' as Type, MasterID as KeyID, 'No Other Data' as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsMaster where ModuleID is null
Union select 'Null Error - EventsMaster-->SubEventID' as Type, MasterID as KeyID, 'No Other Data' as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsMaster where SubEventID is null
Union select 'Null Error - EventsSignups-->CreateDate' as Type, SignupID as KeyID, 'EventName: ' + {databaseOwner}{objectQualifier}Events.EventName as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsSignups INNER JOIN {databaseOwner}{objectQualifier}Events ON {databaseOwner}{objectQualifier}EventsSignups.EventID = {databaseOwner}{objectQualifier}Events.EventID where CreateDate is null
Union select 'Null Error - EventsSignups-->Approved' as Type, SignupID as KeyID, 'EventName: ' + {databaseOwner}{objectQualifier}Events.EventName as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsSignups INNER JOIN {databaseOwner}{objectQualifier}Events ON {databaseOwner}{objectQualifier}EventsSignups.EventID = {databaseOwner}{objectQualifier}Events.EventID where {databaseOwner}{objectQualifier}EventsSignups.Approved is null
Union select 'Null Error - EventsSignups-->PayPalPaymentDate' as Type, SignupID as KeyID, 'EventName: ' + {databaseOwner}{objectQualifier}Events.EventName as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsSignups INNER JOIN {databaseOwner}{objectQualifier}Events ON {databaseOwner}{objectQualifier}EventsSignups.EventID = {databaseOwner}{objectQualifier}Events.EventID where PayPalPaymentDate is null
Union select 'Null Error - EventsSignups-->PayPalAmount' as Type, SignupID as KeyID, 'EventName: ' + {databaseOwner}{objectQualifier}Events.EventName as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsSignups INNER JOIN {databaseOwner}{objectQualifier}Events ON {databaseOwner}{objectQualifier}EventsSignups.EventID = {databaseOwner}{objectQualifier}Events.EventID where PayPalAmount is null
Union select 'Null Error - EventsSignups-->PayPalFee' as Type, SignupID as KeyID, 'EventName: ' + {databaseOwner}{objectQualifier}Events.EventName as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsSignups INNER JOIN {databaseOwner}{objectQualifier}Events ON {databaseOwner}{objectQualifier}EventsSignups.EventID = {databaseOwner}{objectQualifier}Events.EventID where PayPalFee is null
Union select 'Null Error - EventsSignups-->EventTimeBegin' as Type, SignupID as KeyID, 'EventName: ' + {databaseOwner}{objectQualifier}Events.EventName as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsSignups INNER JOIN {databaseOwner}{objectQualifier}Events ON {databaseOwner}{objectQualifier}EventsSignups.EventID = {databaseOwner}{objectQualifier}Events.EventID where {databaseOwner}{objectQualifier}EventsSignups.EventTimeBegin is null
Union select 'Null Error - EventsSignups-->TimezoneOffset' as Type, SignupID as KeyID, 'EventName: ' + {databaseOwner}{objectQualifier}Events.EventName as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsSignups INNER JOIN {databaseOwner}{objectQualifier}Events ON {databaseOwner}{objectQualifier}EventsSignups.EventID = {databaseOwner}{objectQualifier}Events.EventID where {databaseOwner}{objectQualifier}EventsSignups.TimezoneOffset is null
Union select 'Null Error - EventsPPErrorLog-->SignupID' as Type, PayPalID as KeyID, 'No Other Data' as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsPPErrorLog where SignupID is null
Union select 'Null Error - EventsPPErrorLog-->CreateDate' as Type, PayPalID as KeyID, 'No Other Data' as KeyName, null as [Missing Key] from {databaseOwner}{objectQualifier}EventsPPErrorLog where CreateDate is null