Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.
SELECT * FROM (SELECT Incident_ID AS [Ticket Number], CONVERT(datetime, DateClosed / 86402.027 + 25567) AS [Date Closed], AssignedGroup AS [Assigned Group], AssignedTechnician AS [Assigned Technician], CASE Priority WHEN 4 THEN 'Low' WHEN 3 THEN 'Medium' WHEN 2 THEN 'High' END AS Priority, CASE Status WHEN 3 THEN 'Closed' WHEN 8 THEN 'Drill Status' WHEN 4 THEN 'Hold' WHEN 1 THEN 'Assigned' WHEN 0 THEN 'New' WHEN 9 THEN 'Project' END AS Status, CONVERT(datetime, Date_Opened / 86402.027 + 25567) AS [Date Opened], CASE COMPLEXITY WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END AS [Suspense Missed] FROM dbo.TTS_Main) derived WHERE (Status <> 'Closed') AND ([Date Opened] <= DATEADD(dd, - 8, DATEDIFF(dd, 0, GETDATE()))) AND (Status <> 'Project')
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!