UPDATE ReportHeader SET IpOrg = 1, IpOwner = 1, ReportName = N'TBDed', ReportDescription = N'Ski Team, 22/4/2017 2:07 AM', CategoryCode = N'AUDITREPORTS', SubCategoryCode = N'ADMINREPORTS', ActionFamilyCode = N'JAVA', UpdateTypeCode = N'DUPLICATE', AccessFilterCode = N'', ChartPlacementCode = null, ScheduleTypeCode = N'MANUAL', ExecutionObjectName = null, ReportTemplateCode = N'REPORTANDCHART', ReportStatusCode = N'DELETED', RelatedReportsFlag = 0, MaxRowReturnedCount = 10000, SQLText = null, HitCount = 1, AverageRunTime = 0, ParentReportId = 0, ReportChargeCode = null, IpLastModifier = 5, LastModifiedGMTDateTime = 20170421160913, LastModifiedDate = '20170421', LastModifiedTime = 58153, RoleCode = N'OPERATIONAL', DataOutputCode = N'COLUMN', RowGrandTotalFlag = 0, ColumnGrandTotalFlag = 0, ViewId = 59543, TimeDimensionCode = null, IpApprover = 0, ApprovalGMTDateTime = 0, ApprovalDate = null, ApprovalTime = 0, ExternalAccessCode = N'CORPORATE', ExternalSecurityCode = N'USERVALIDATE', SourceId = 54700, PageHeader = null, PageFooter = null, DisplayMethodCode = N'DASHBOARD', XMLDocumentId = 0, BroadcastAccessCode = N'BROADCASTSUBSCRIBE', DrillCode = N'NODRILL', AccessCode = N'LOGIN', PublishDate = '20170421', RefreshTime = 0, PublishUUID = N'2b0ca980-7a06-4b96-86ae-7aa8af7b4c13', TranslationTimestamp = null, TranslationStatusCode = null, IpCreator = 5, AdhocEmailEnabled = 1 WHERE ReportId = 63817 DELETE FROM TaskSchedule WHERE IpOrg = 1 AND ScheduleSubjectCode = N'MIREPORT' AND ScheduleUnitCode = N'REPORTID' AND ScheduleUnitId = 63817 UPDATE ReportHeader SET IpOrg = 1, IpOwner = 1, ReportName = N'Append 1', ReportDescription = null, CategoryCode = N'AUDITREPORTS', SubCategoryCode = N'ADMINREPORTS', ActionFamilyCode = N'JAVA', UpdateTypeCode = null, AccessFilterCode = null, ChartPlacementCode = null, ScheduleTypeCode = N'MANUAL', ExecutionObjectName = null, ReportTemplateCode = N'REPORTANDCHART', ReportStatusCode = N'DELETED', RelatedReportsFlag = 0, MaxRowReturnedCount = 0, SQLText = null, HitCount = 0, AverageRunTime = 0, ParentReportId = 63817, ReportChargeCode = null, IpLastModifier = 5, LastModifiedGMTDateTime = 20170421160913, LastModifiedDate = '20170421', LastModifiedTime = 58153, RoleCode = N'SUBQUERY', DataOutputCode = N'COLUMN', RowGrandTotalFlag = 0, ColumnGrandTotalFlag = 0, ViewId = 59543, TimeDimensionCode = null, IpApprover = 0, ApprovalGMTDateTime = 0, ApprovalDate = null, ApprovalTime = 0, ExternalAccessCode = null, ExternalSecurityCode = null, SourceId = 54700, PageHeader = null, PageFooter = null, DisplayMethodCode = null, XMLDocumentId = 0, BroadcastAccessCode = null, DrillCode = null, AccessCode = null, PublishDate = null, RefreshTime = 0, PublishUUID = null, TranslationTimestamp = null, TranslationStatusCode = null, IpCreator = 5, AdhocEmailEnabled = 0 WHERE ReportId = 63818 DELETE FROM ReportAssociate WHERE ParentReportId = 63818 OR ChildReportId = 63818 DELETE FROM PersonFavourite WHERE ContentTypeCode = N'REPORT' AND ContentId = 63818 AND CreateByCode = N'APPROVAL' UPDATE ReportInstance SET ReportStatusCode = 'ARCHIVED' WHERE ReportId = 63818 AND ReportStatusCode = 'OPEN' INSERT INTO Event ( EventId, EventTypeCode, GMTDateTime, IpSource, SessionId, FinancialTransactionValue, FinancialCommission, FinancialDestinationValue, FinancialTaxValue, EventTime, EventDate, EventCode, EventData, ReferenceId, UnitId, TomcatSessionId, ReasonCode, ReasonDescription, ContentId ) VALUES (72825,N'REPORT',20170421160913,5,N'0:0:0:0:0:0:0:1',0,0,0,0,0,'20170421',N'RPTDELETE',N'report=63818',63818,1,N'2673CD8A1177BC57460E22740F3A155B',N'',N'',63818) DELETE FROM ReportAssociate WHERE ParentReportId = 63817 OR ChildReportId = 63817 DELETE FROM PersonFavourite WHERE ContentTypeCode = N'REPORT' AND ContentId = 63817 AND CreateByCode = N'APPROVAL' UPDATE ReportInstance SET ReportStatusCode = 'ARCHIVED' WHERE ReportId = 63817 AND ReportStatusCode = 'OPEN' INSERT INTO Event ( EventId, EventTypeCode, GMTDateTime, IpSource, SessionId, FinancialTransactionValue, FinancialCommission, FinancialDestinationValue, FinancialTaxValue, EventTime, EventDate, EventCode, EventData, ReferenceId, UnitId, TomcatSessionId, ReasonCode, ReasonDescription, ContentId ) VALUES (72826,N'REPORT',20170421160914,5,N'0:0:0:0:0:0:0:1',0,0,0,0,0,'20170421',N'RPTDELETE',N'report=63817',63817,1,N'2673CD8A1177BC57460E22740F3A155B',N'',N'',63817)