Home SQL Server

How To - Report All work items

Marek_LefekMarek_Lefek Customer Advanced IT Monkey ✭✭✭
edited October 2018 in SQL Server
Hi Community, is there possibility to select all workitems like SR, CR, PR, RR and activities: manual, review, runbook ,pararell, sequential ?
I Table WorkItem in ServiceManagement database are missing activities as runbok act, pararell act.
In ServiceManger different types (SR, CR, MA, etc) are in different tables and there is lot of coding;)
Is there parent table with workitems where are all WorkItems?

I need to report WorkItem ID an ParentWorkItem ID for closed SR, CR with pending Activitities and for Pending SR, CR with Closed Activities.

Answers

  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭
    @Marek_Lefek - There's not a single table that has all the information you're wanting.  You could build a SQL view that combines everything like you're wanting and then you could just query that view.
  • Marek_LefekMarek_Lefek Customer Advanced IT Monkey ✭✭✭
    @Justin_Workman could you advice in which tables in Cireson DB are activities as runbok act, pararell act?
  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭
    @Marek_Lefek - The PAs and RBAs aren't in ServiceManagement.  I was suggesting creating a view in the ServiceManager database.  As you say though, it will require quite a bit of SQL coding.
Sign In or Register to comment.