Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.36 KB | None | 0 0
  1. DECLARE @t1 DATETIME;
  2. DECLARE @t2 DATETIME;
  3.  
  4. SET @t1 = GETDATE();
  5. exec qfm_WebGetEDListV24
  6. @SelCol=N'EventID,ReportedBy,EventType,Status,WFStatusName,Region,Site,Location,Unit,Partition,EventName,WorkType,PriorityName,EquipmentGroupName,EquipmentReference,Model,RepReference,Instructions,Contractor,CASE WHEN
  7. OperativeCount>1 THEN ''(Multiple)'' ELSE Operative END AS Operative,ReportedDateTime,NotifiedDateTime,DueDateTime,StartedDateTime,CompletedDateTime,space(100) as HasChanged,space(100) as AlertImage,space(100) as CountDownMinsText,AlertLevel,SiteId,GeographyID,NextActionTime,NextWarningTime,CountDownMins,PriorityId,ChangedSinceLastRefresh,WatchDate,AgentId,CASE WHEN OperativeCount>1 THEN NULL ELSE OperativeId END AS OperativeId,IsSubTask,StructuralCodeID,StructuralCode,StructuralPath,ReportedByID,WorkTypeID,ModelORServiceID,OnBehalfID,UserID,TimeStamp,InventoryID,ContractID,DueCalculationTypeID,Reference,CostCode,CostAllocationCode,AssigneeID,WorksOrderNo,ScheduleActivityID,PlannedItemID,Chargeable,EventReference,ClientContractID,Latitude,Longitude',@ProfileType=N'4',@Class=N'17',@UserID=N'2',@MaxRows=4000,@MaxDays=N'90',@LastRefresh='2018-10-22 11:42:44.427',@OperativeLike=N'',@ContractorLike=N'',@RegionLike=N'',@SiteLike=N'',@AlertStates=N'',@States=N'',@UpdatedByMe=0,@ActiveEventsOnly=0,@EventIdList=N'',@UserOfInterestID=N'2',@HasActions=N'0',@ReportedDateFrom=default,@ReportedDateTo=default,@NotifiedDateFrom=default,@NotifiedDateTo=default,@StartedDateFrom=default,@StartedDateTo=default,@DueDateFrom=default,@DueDateTo=default,@CompletedDateFrom=default,@CompletedDateTo=default,@RTSDateFrom=default,@RTSDateTo=default,@CancelledDateFrom=default,@CancelledDateTo=default,@LangId=1033,@IsLastUpdatedByUser=default,@IsCreatedByUser=default,@IsOnBehalfOfUser=default,@IsReportedByUser=default,@IsAssignedToUser=default,@IsAssignedToUserAsOperative=default,@IsAssignedToUserAgent=default,@IsWatchedByUser=default,@AdhocFilterClause=default,@OrderBy=N'EventID DESC',@ChooseLatestActionOnly=N'1',@WFStateTagList=default,@WFEventTagList=default,@WatchTypeList=N'1',@GeographyIdList=N'',@IncludeChildGeographies=N'1',@InventoryIdList=N'',@IgnoreDataScoping=0,@EventTypesList=N'',@PostCodeLike=N'',@ClientContractList=N'',@ProjectNameLike=N'',@DayType=10,@MaxDaysTo=180,@ServiceGroupID=default,@NoLock=1
  8.  
  9. SET @t2 = GETDATE();
  10. SELECT DATEDIFF(millisecond,@t1,@t2) AS elapsed_ms;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement