SQL Custom Reports : Support Portal

SQL Custom Reports

SQL - ORDER BY [Time Stamp], WHERE t.[Sent] = 1, FROM Traffic t INNER JOIN MessageList m ON t.TrafficId = m.TrafficId, SELECT t.LogDate AS [Time Stamp]

DECLARE @StartDate DATE = '20160101' DECLARE @EndDate DATE = '20160531' DECLARE @User NVARCHAR(128) = 'first.last@yourdomain....

Mon, 10 Jul, 2017 at 2:21 PM

SQL - ORDER BY [LogDate], GROUP BY [LogDate], WHERE TrafficType = 'Message' AND Detail = 1, FROM [Mailscape].[dbo].[TrafficStatus] ts, SELECT [LogDate]

SELECT [LogDate] ,[TrafficType] ,[Server] ,[Detail] , COUNT(*) AS [Count] FROM [Mailscape]...

Mon, 10 Jul, 2017 at 2:37 PM

SQL - DROP TABLE ADComputer, ORDER BY whenChanged DESC, FROM ADComputer, SELECT name as Computer Name, SELECT name, description,lastlogon,whenChanged,distinguishedName

DECLARE @PastDays INT SET @PastDays = 60; DECLARE @StartPastDays INT SET @StartPastDays = 1; DECLARE @date DATETIME SET @date = '20000101'...

Mon, 10 Jul, 2017 at 2:50 PM

SQL - ORDER BY C.Sender, FROM, SELECT C.Sender

DECLARE @StartDate DATE --NVARCHAR(64) DECLARE @EndDate DATE --NVARCHAR(64) SET @StartDate = (SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())-1, 0)...

Mon, 10 Jul, 2017 at 3:15 PM

SQL - WHERE t.LogDate, FROM Traffic t INNER JOIN MessageList m ON t.TrafficId = m.TrafficId, SELECT SUM(CASE WHEN t.Size

DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SET @StartDate = '2015/01/18 00:00:00'; SET @EndDate = '2015/10/30 23:59:59'; ...

Mon, 10 Jul, 2017 at 3:26 PM

SQL - ORDER By name ASC, WHERE mail NOT IN, SELECT name As 'Distribution List', mailAs 'EMail Address', 0 As 'Message Count'

DECLARE @StartPastDays INT SET @StartPastDays = 1; DECLARE @PastDays INT SET @PastDays = 180; DECLARE @date DATETIME SET @date = '20000101...

Mon, 10 Jul, 2017 at 3:52 PM

SQL - DROP TABLE data, ORDER BY Region, [Index], FROM data, SELECT Criterion, [Region], [Count], GROUP BY sr.Region, WHERE LTRIM(ISNULL(EMailAddress, FROM [Mailscape].[dbo].[Mailbox]

DECLARE @filter NVARCHAR(64) = '' IF OBJECT_ID('tempdb..#data') IS NOT NULL DROP TABLE #data CREATE TABLE #data( C...

Mon, 10 Jul, 2017 at 4:10 PM

How can we help you today?

SQL Custom Reports