How can we help you today?

Solution home EMS Custom Reporting

SQL Custom Reports

SQL - ORDER BY t.LogDate, t.Sender, WHERE t.LogDate BETWEEN @StartDate AND @EndDate AND t.Sent = 1, FROM Traffic t
DECLARE @PastDays INT = 30 DECLARE @EndDate DATE = GETDATE() DECLARE @StartDate DATE = DATEADD(DAY, -@PastDays, @EndDate) PRINT @StartDate PRINT @...
Fri, 7 Jul, 2017 at 3:18 PM
SQL - Select Sum(CountSent) AS Messages Sent, Sum(CountReceived) AS Messages Received), SET @PastDays = 30
DECLARE @StartPastDays INT SET @StartPastDays = 1; DECLARE @PastDays INT SET @PastDays = 30; DECLARE @StartDate NVARCHAR(64) DECLARE @EndDate NVARCHAR(64...
Fri, 7 Jul, 2017 at 9:21 PM
SQL - ORDER BY t.LogDate, t.Sender, WHERE t.LogDate BETWEEN @StartDate AND @EndDate, FROM Traffic t INNER JOIN MessageList m ON t.TrafficId = m.TrafficId, SELECT t.LogDate
DECLARE @PastDays INT = 30 DECLARE @EndDate DATE = GETDATE() DECLARE @StartDate DATE = DATEADD(DAY, -@PastDays, @EndDate) PRINT @StartDate PRINT @...
Mon, 10 Jul, 2017 at 12:14 PM
SQL - DROP TABLE UserPwdLastSet, ORDER BY PwdLastSet DESC, FROM UserPwdLastSet
IF OBJECT_ID('TempDB..#UserPwdLastSet', 'U') IS NOT NULL DROP TABLE #UserPwdLastSet; Create Table #UserPwdLastSet (displayName nvarchar(256...
Mon, 10 Jul, 2017 at 12:32 PM
SQL - ORDER BY [Order], SELECT [Year], [Week], [Week Start], [Week End], [Count], GROUP BY YEAR(t.LogDate), DATEPART(WEEK, t.LogDate)
DECLARE @StartDate DATETIME = '20140101' PRINT @StartDate DECLARE @EndDate DATETIME = '20141001' PRINT @EndDate SET @EndDate = DAT...
Mon, 10 Jul, 2017 at 12:46 PM
SQL - ORDER BY [Year], [Week], GROUP BY YEAR(t.LogDate), DATEPART(WEEK, t.LogDate), FROM Traffic tINNER JOIN MessageList m ON t.TrafficId = m.RecipientListId
DECLARE @StartDate DATETIME = '20140101' PRINT @StartDate DECLARE @EndDate DATETIME = '20141001' PRINT @EndDate SET @EndDate = DAT...
Mon, 10 Jul, 2017 at 12:56 PM
SQL - ORDER BY [Year], GROUP BY YEAR(t.LogDate), FROM Traffic t INNER JOIN MessageList m ON t.TrafficID = m.TrafficId, SELECT YEAR(t.LogDate) AS [Year]
DECLARE @StartDate DATETIME = '20130101' PRINT @StartDate DECLARE @EndDate DATETIME = '20141001' PRINT @EndDate SET @EndDate = DAT...
Mon, 10 Jul, 2017 at 1:03 PM
SQL - DROP TABLE ADComputer, ORDER BY whenChanged DESC, FROM ADComputer, SELECT name as Computer Name
DECLARE @PastDays INT SET @PastDays = 30; DECLARE @StartPastDays INT SET @StartPastDays = 1; DECLARE @date DATETIME SET @date = '20000101'...
Mon, 10 Jul, 2017 at 1:18 PM
SQL - ORDER BY MONTH(LogDate), DATEPART(HOUR, LogDate), GROUP BY MONTH(LogDate), DATEPART(HOUR, LogDate), WHERE t.[Sent] = 1, FROM Traffic t
SELECT MONTH(LogDate) AS [Month]                  , DATEPART(HOUR, LogDate) AS 'Hour'                  --, Sender                  --, mbx.Mailbo...
Mon, 10 Jul, 2017 at 1:28 PM
SQL - GROUP BY t.Sender, WHERE --dbo.IsInternalEmailByDomain(t.Sender, t.SenderDomain) = 1, FROM Traffic t INNER JOIN MessageList m ON t.TrafficId = r.RecipientListId, SELECT t.Sender
DECLARE @StartPastDays INT SET @StartPastDays = 1; DECLARE @PastDays INT SET @PastDays = 7; DECLARE @StartDate NVARCHAR(64) DECLARE @EndDate NVAR...
Mon, 10 Jul, 2017 at 2:06 PM
Help Desk Software by Freshdesk