Meeting Attend Dates Different

This script helps to identify a very rare but annoying problem.

This problem is not readily visible, but it manifests itself in another way when you see two Organization Member records for the same person in an organization.

We have seen this happen once before, but honestly don’t know what can cause it. We think it happens when you create a meeting with the incorrect time and then change that time. But we know how to fix it and this is the script helps us to pinpoint the problem.

The fix by the way is to go to the offending meeting, and change the meeting time to one minute later then change it back to the correct time.

The recommended name is MeetingAttendDatesDifferent

Use the following code to Create the SQL Script. See How to create a SQL Script.

SELECT  a.MeetingId
       ,a.MeetingDate AttendDate
       ,m.MeetingDate
       ,o.OrganizationName
       ,p.PeopleId
       ,p.Name2
FROM dbo.Meetings m
JOIN dbo.Attend a ON a.MeetingId = m.MeetingId
JOIN dbo.People p ON p.PeopleId = a.PeopleId
JOIN dbo.Organizations o ON o.OrganizationId = m.OrganizationId
WHERE a.MeetingDate <> m.MeetingDate