BMC Track-It Wallboard SQL Queries

trackit_wallboard.sql

-- Today
SELECT 
	COUNT(*)
FROM dbo.TASKS 
WHERE 
	WorkOrderStatusId <> 2 
AND WorkOrderStatusId <> 101
AND WorkOrderTypeId = 0
AND DUEDATE < (CAST(DATEADD(day, 1, GETDATE()) AS DATE))
AND RESPONS IN ('ICT Support');

-- New
SELECT COUNT(WO_NUM)
FROM dbo.TASKS 
WHERE 
	WorkOrderStatusId <> 2 
AND WorkOrderStatusId <> 101
AND WorkOrderTypeId = 0
AND WOTYPE2 IS NULL;

-- Next Hour
SELECT 
	COUNT(*)
FROM dbo.TASKS 
WHERE 
	WorkOrderStatusId <> 2 
AND WorkOrderStatusId <> 101
AND WorkOrderTypeId = 0
AND DUEDATE > GETUTCDATE()
AND DUEDATE < DATEADD(hh, +1, GETUTCDATE());

-- Overdue
SELECT 
	CAST(COUNT(*) AS INT)
FROM dbo.TASKS 
WHERE 
	WorkOrderStatusId <> 2 
AND WorkOrderStatusId <> 101
AND WorkOrderTypeId = 0
AND DUEDATE < GETUTCDATE()
AND DUEDATE <> '' 
AND DUEDATE > 0;