SELECT  TOP 10000 
   "Content Folder"."ContentTypeCode",
   "Content Folder"."ContentCode",
   "Users"."FullName",
   "Content Folder"."LoginAccessCode",
   "Content Folder"."ContentManagementId",
   "Dashboard Tags"."TagCode",
   "Dashboard Favourites"."IpPerson",
   "Dashboard Favourites"."FullName",
   "Dashboard"."CategoryCode",
   "Dashboard"."SubCategoryCode",
   "Dashboard"."StatusCode",
   "Dashboard"."GroupId",
   "Data Source"."AccessCode",
   "Data Source"."ConnectionMethodCode",
   "Data Source"."SourceName",
   "Data Source"."SourceDescription",
   "Data Source"."ConnectionDriver",
   "Data Source"."ConnectionTypeCode",
   "Data Source"."ConnectionTimeOut",
   "Data Source"."MinConnections",
   "Data Source"."MaxConnections",
   "Data Source"."SourceId",
   "Organisation_DataSource"."OrgName",
   "Events"."EventId",
   "Events"."EventTypeCode",
   "Events"."EventCode",
   "Event Date Hierarchy"."CalendarYear",
   "Event Date Hierarchy"."MonthCode",
   "Events"."EventDate",
   "Events"."EventDate",
   "Export / Import"."ContentType",
   "Export / Import"."StatusCode",
   "Exporter"."FullName",
   "Export / Import"."ClientOrg",
   "Export / Import"."IpExporter",
   "Export / Import"."IpTester",
   "Export / Import"."IpCreator",
   "Export / Import"."ContentId",
   "Report"."PublishUUID",
   "Report"."ReportName",
   "Report"."ReportDescription",
   "Report"."ReportStatusCode",
   "Report"."RoleCode",
   "Report Writer"."FullName",
   "Report Updater"."FullName",
   "Report"."CategoryCode",
   "Report"."SubCategoryCode",
   "Report"."LastModifiedDate",
   "Report Tags"."TagCode",
   "Report Instance"."ReportDuration",
   "Report Instance"."RowsProcessed",
   "Report"."HitCount",
   "Report Favourites"."IpPerson",
   "Report Favourites"."FullName",
   "Organisation_Report"."OrgName",
   "Report Broadcast"."UserName",
   "Report Broadcast"."BroadcastTypeCode",
   "Report Broadcast"."DeliveryRuleTypeCode",
   "Report Broadcast"."RequestTypeCode",
   "Report Broadcast"."BroadcastCode",
   "Report Broadcast"."StatusNotificationCode",
   "Report Broadcast"."SubjectLine",
   "Report Broadcast"."ReportId",
   "Report Broadcast"."BroadcastId",
   "Report Broadcast"."LastModifiedDate",
   "Report Broadcast"."EndDate",
   "Report Broadcast"."StartDate",
   "Report Broadcast"."FilterSourceCode",
   "Report Broadcast"."RecipientSourceCode",
   "Report Broadcast Result"."BroadcastId",
   "Report Broadcast Result"."BroadcastSuccess",
   "Report Broadcast Result"."ResultCode",
   "Report Broadcast Result"."EmailAddress",
   "Report Broadcast Result"."BroadcastTimestamp",
   "Report Broadcast Result"."Description",
   "Report Broadcast Result"."RecipientTypeCode",
   "TaskSchedule"."ScheduleIsOn",
   "TaskSchedule"."LastRunStatus",
   "TaskSchedule"."ScheduleUnitCode",
   "TaskSchedule"."ScheduleSubjectCode",
   "TaskSchedule"."LastRunTime",
   "TaskSchedule"."ScheduleUnitId",
   "TaskSchedule"."LastRunDate",
   "Storyboard"."StoryboardUUID",
   "Storyboard"."Title",
   "Storyboard"."Description",
   "Storyboard"."StatusCode",
   "Storyboard"."CategoryCode",
   "Storyboard"."SubCategoryCode",
   "Users"."FullName",
   "Users"."Status",
   "Users"."IpPerson",
   "View"."ViewDescription",
   "View"."BusinessDescription",
   "View"."ViewStatusCode",
   "View"."ContentCategoryCode",
   "View"."ContentSubCategoryCode",
   "View"."ViewId",
   "Report"."ReportName",
   "Report"."ReportStatusCode",
   "Report Instance"."ReportDuration",
   "Report Instance"."RowsProcessed"
FROM "Person" AS "Exporter"
INNER JOIN "TransferContentItem" AS "Export / Import"
ON (
   "Exporter"."IpPerson" = "Export / Import"."IpExporter"
)
INNER JOIN (
   select * from Event
UNION ALL 
Select * from EventArchive

) AS "Events"
ON (
   "Events"."IpSource" = "Export / Import"."IpExporter"
)
AND (
   "Events"."EventTypeCode" != N'SYSTEMTASK'
)
INNER JOIN "ReferenceDay" AS "Event Date Hierarchy"
ON (
   "Events"."EventDate" = "Event Date Hierarchy"."DayDate"
)
INNER JOIN "Person" AS "Users"
ON (
   "Events"."IpSource" = "Users"."IpPerson"
)
LEFT OUTER JOIN "ReportHeader" AS "Report"
ON (
   "Events"."ContentId" = "Report"."ReportId"
)
AND (
   "Report"."RoleCode" != N'SUBQUERY'
)
LEFT OUTER JOIN "ReportBroadcast" AS "Report Broadcast"
ON (
   "Report"."ReportId" = "Report Broadcast"."ReportId"
)
LEFT OUTER JOIN "Person" AS "Report Writer"
ON (
   "Report"."IpCreator" = "Report Writer"."IpPerson"
)
LEFT OUTER JOIN "Person" AS "Report Updater"
ON (
   "Report"."IpLastModifier" = "Report Updater"."IpPerson"
)
LEFT OUTER JOIN "ContentManagement" AS "Content Folder"
ON (
   "Report"."CategoryCode" = "Content Folder"."ContentTypeCode"
   AND "Report"."SubCategoryCode" = "Content Folder"."ContentCode"
)
LEFT OUTER JOIN "ReportBroadcastResult" AS "Report Broadcast Result"
ON (
   "Report Broadcast"."BroadcastId" = "Report Broadcast Result"."BroadcastId"
)
LEFT OUTER JOIN (
   SELECT DISTINCT
c.ContentId,
c.IpPerson,
p.FullName
FROM PersonFavourite c
LEFT OUTER JOIN Person p ON c.IpPerson = p.IpPerson

) AS "Report Favourites"
ON (
   "Report"."ReportId" = "Report Favourites"."ContentId"
)
LEFT OUTER JOIN "ReportGroup" AS "Dashboard"
ON (
   "Events"."ContentId" = "Dashboard"."GroupId"
)
LEFT OUTER JOIN (
   SELECT DISTINCT
c.ContentId,
c.IpPerson,
p.FullName
FROM PersonFavourite c
LEFT OUTER JOIN Person p ON c.IpPerson = p.IpPerson

) AS "Dashboard Favourites"
ON (
   "Dashboard"."GroupId" = "Dashboard Favourites"."ContentId"
)
LEFT OUTER JOIN "ContentTag" AS "Report Tags"
ON (
   "Report"."ReportId" = "Report Tags"."EntityId"
)
LEFT OUTER JOIN "dbo"."Organisation" AS "Organisation_Report"
ON (
   "Report"."IpOrg" = "Organisation_Report"."IpOrg"
)
LEFT OUTER JOIN "ContentTag" AS "Dashboard Tags"
ON (
   "Dashboard"."GroupId" = "Dashboard Tags"."EntityId"
)
LEFT OUTER JOIN "ReportView" AS "View"
ON (
   "Report"."ViewId" = "View"."ViewId"
)
LEFT OUTER JOIN "ReportViewSource" AS "Data Source"
ON (
   "View"."SourceId" = "Data Source"."SourceId"
)
LEFT OUTER JOIN "dbo"."Organisation" AS "Organisation_DataSource"
ON (
   "Data Source"."IpOrg" = "Organisation_DataSource"."IpOrg"
)
LEFT OUTER JOIN "dbo"."Organisation" AS "Organisation_ContentFolder"
ON (
   "Content Folder"."IpOrg" = "Organisation_ContentFolder"."IpOrg"
)
LEFT OUTER JOIN "TaskSchedule"
ON (
   "Data Source"."SourceId" = "TaskSchedule"."ScheduleUnitId"
)
LEFT OUTER JOIN "Storyboard"
ON (
   "Events"."ContentId" = "Storyboard"."StoryboardId"
)
LEFT OUTER JOIN "ReportInstance" AS "Report Instance"
ON (
   "Report"."ReportId" = "Report Instance"."ReportId"
)