BLOG | knowit | Page 4 of 5

Windows start time (server statistic)

net statistics server

select CURRENT_DATE from dual;

SELECT [UCID] ,[STARTDATETIME] ,[ANI] as 'PHONE Number calling' ,[PHONE_NUM] as 'Identification Phone' ,[EVENT_VALUE_1] = case...

SELECT top 1 [RECORD_ID] ,[UCID] ,[MODULE_NAME] ,[STARTDATETIME] ,[ANI] ,[PHONE_NUM] ,[DNIS] ,[CUST_LANG] ,[IVR_POINT] ,[EVENT_TYPE]...

SELECT fromaddress, Record_Count=Count(*) FROM [ASMSData1].[dbo].[Interactions] as interact JOIN [ASMSData1].[dbo].[Sectors] AS secto ON...

SELECT date = CONVERT(DATE,[STARTDATETIME]), EVENT_VALUE_1, count (*) FROM [NAV360DataSummary].[dbo].[TBL_REPORT_MAIN] where...

SELECT groupid.[Group_Id] FROM [nav360_231].[dbo].[Users_Groups] as groupid JOIN [nav360_231].[dbo].[Users] AS userim ON groupid.User_Id...

SELECT fromaddress, Record_Count=Count(*) FROM [ASMSData1].[dbo].[Interactions] as interact JOIN [ASMSData1].[dbo].[Sectors] AS secto ON...

Now – 2 hours =RelativeDate([Date];-0.0833333333333333) 2 hours from 24 hours (1 day) = 0.083333333 of a day. LastExecutionDate...

SELECT date = CONVERT(DATE, STARTDATETIME), count = count (distinct [UCID]) FROM [NAV360DataSummary].[dbo].[TBL_REPORT_MAIN] where...