Home Analyst Portal - Community

Created By Team?

Jason_MeyerJason_Meyer Customer Advanced IT Monkey ✭✭✭

Is there any way to build a view in Service Portal that would display any/all requests CREATED BY members of a Support Group? I have one team using the product that has the need to be able to find any tickets created by the team easily/quickly. We have SSRS reporting on the backend but that takes too much time. CREATED BY is also not an attribute that is available currently to us in our Analyst Portal search.


Thoughts?

Best Answer

  • Shane_WhiteShane_White Cireson Support Super IT Monkey ✭✭✭✭✭
    Answer ✓

    Hi @Jason_Meyer

    Yes this is definitely something you could achieve with a SQL query, you would need to select from dbo.workitem, but join to dbo.CI$User and dbo.CI$DomainGroup so get user and group information.

    Then build the query around that data.

    Thanks,

    Shane

Answers

  • Shane_WhiteShane_White Cireson Support Super IT Monkey ✭✭✭✭✭
    Answer ✓

    Hi @Jason_Meyer

    Yes this is definitely something you could achieve with a SQL query, you would need to select from dbo.workitem, but join to dbo.CI$User and dbo.CI$DomainGroup so get user and group information.

    Then build the query around that data.

    Thanks,

    Shane

Sign In or Register to comment.