Current Cases By User
true
false
Total Current Cases By User
SELECT TOP 100 PERCENT dbo.tbl_Users.UserID, dbo.tbl_Users.FirstName + ' ' + dbo.tbl_Users.LastName AS SystemUser, dbo.tbl_Users.Archived,
dbo.tbl_QueueUsers.QueueID,
(SELECT COUNT(CallID)
FROM tbl_Calls
WHERE UserID = tbl_QueueUsers.UserID AND QueueID = [PARAM1] AND CallStatusID IN (1, 2, 4, 7)) AS RecCount
FROM dbo.tbl_Users RIGHT OUTER JOIN
dbo.tbl_QueueUsers ON dbo.tbl_Users.UserID = dbo.tbl_QueueUsers.UserID
WHERE (dbo.tbl_Users.Archived = 0 OR dbo.tbl_Users.Archived IS NULL) AND (dbo.tbl_QueueUsers.QueueID = [PARAM1])
ORDER BY dbo.tbl_Users.LastName, dbo.tbl_Users.FirstName
true
Assigned To
# Cases
Current Cases
SELECT dbo.tbl_Calls.CallID AS [Case #], dbo.tbl_Calls.Subject, (dbo.tbl_Users.FirstName + ' ' + dbo.tbl_Users.LastName) AS [Assigned To], dbo.tbl_PrimaryKeys.PrimaryKey AS [Category 1], dbo.tbl_SecondaryKeys.SecondaryKey AS [Category 2],
dbo.tbl_TertiaryKeys.TertiaryKey AS [Category 3], dbo.tbl_Calls.UserID, dbo.tbl_Calls.QueueID, dbo.tbl_Calls.Key1, dbo.tbl_Calls.Key2, dbo.tbl_Calls.Key3,
dbo.tbl_Calls.CompanyName AS [Primary Company], (dbo.tbl_Calls.FirstName + ' ' + dbo.tbl_Calls.LastName) AS [Primary Contact], dbo.tbl_Calls.ReqCompanyName AS [Secondary Company], (dbo.tbl_Calls.ReqFirstName + ' ' +
dbo.tbl_Calls.ReqLastName) AS [Secondary Contact], dbo.tbl_Calls.GroupID, dbo.tbl_Calls.CallStatusID, dbo.tbl_Calls.DateEntered AS [Date Entered], dbo.tbl_Calls.DueDate AS [Due Date],
dbo.tbl_Calls.Computer AS [Primary SLA], dbo.tbl_Calls.ReqComputer AS [Secondary SLA],
dbo.tbl_Groups.GroupName
FROM dbo.tbl_Calls LEFT OUTER JOIN
dbo.tbl_Groups ON dbo.tbl_Calls.GroupID = dbo.tbl_Groups.GroupID LEFT OUTER JOIN
dbo.tbl_TertiaryKeys ON dbo.tbl_Calls.Key3 = dbo.tbl_TertiaryKeys.TertiaryKeyID LEFT OUTER JOIN
dbo.tbl_SecondaryKeys ON dbo.tbl_Calls.Key2 = dbo.tbl_SecondaryKeys.SecondaryKeyID LEFT OUTER JOIN
dbo.tbl_PrimaryKeys ON dbo.tbl_Calls.Key1 = dbo.tbl_PrimaryKeys.PrimaryKeyID LEFT OUTER JOIN
dbo.tbl_Users ON dbo.tbl_Calls.UserID = dbo.tbl_Users.UserID
WHERE (dbo.tbl_Calls.QueueID = [PARAM1]) AND (dbo.tbl_Calls.CallStatusID IN (1, 2, 4, 7))
ORDER BY (dbo.tbl_Users.FirstName + ' ' + dbo.tbl_Users.LastName), dbo.tbl_PrimaryKeys.PrimaryKey, dbo.tbl_SecondaryKeys.SecondaryKey, dbo.tbl_TertiaryKeys.TertiaryKey