SCSM Incident Details

Open IN sorted by Name

select [Assigned User], COUNT ([Assigned User]) as INCount from  APPNAME_Incidentsvw

where status != 'Closed' and CreatedDate > '2012-06-30 23:59:59.000'
group by [Assigned User]

order by  COUNT ([Assigned User]) desc

IN which are Un Assigned

select [Incident Number], CreatedDate,  Application, [Assigned User],
status from  APPNAME_Incidentsvw
where CreatedDate > '2012-06-30 23:59:59.000'
and [Assigned User] = 'Not Assigned'
order by  CreatedDate desc

Closed IN sorted by Application and Classification Monthly Basis

select Application, Environment, [Classification Category],DATENAME(Month, [ClosedDate]) as Month,COUNT (Application)as TotalIN from APPNAME_Incidentsvw
where createddate > '2012-06-30 23:59:59.000'
and Status = 'Closed'
group by Application,Environment, [Classification Category], DATENAME(Month, [ClosedDate])
order by Application, Environment, [Classification Category], DATENAME(Month, [ClosedDate])

Closed IN Full Details.

select [Incident Number],[Application], [Environment],

Title,[Support Group],Tier,[CreatedDate],[ClosedDate],

[Resolution Category],[Issue Type], [Classification Category] as Classification,ResolutionDescription,

[Escalate_to_T2_SLA],[Escalate_to_T3_SLA],[Initial_Response_SLA],[MaxCommunicationsGap_SLA],
[Assigned User],[Resolved By User] from APPNAME_Incidentsvw
where createddate > '2012-06-30 23:59:59.000'
and Status = 'Closed'

Open Ins queue Details

select [Incident Number],[Application],Title,[Assigned User],DATEDIFF(DAY, createddate, GETDATE()) as DaysOld,Status, [Support Group],Tier,[CreatedDate],[Issue Type],

[Environment],[Escalate_to_T2_SLA],[Escalate_to_T3_SLA],[Initial_Response_SLA],
[MaxCommunicationsGap_SLA]
from APPNAME_Incidentsvw
where createddate > '2012-06-30 23:59:59.000'
and Status != 'Closed'
order by createddate