Home› Self-Service Portal - Community
Options

All Team Requests View Groups List

Ozgur_SahinOzgur_Sahin Customer IT Monkey ✭
edited May 2017 in Self-Service Portal - Community
Hi
How can I get a list of all "Team Requests View Groups" ?
to get it via Portal is very difficult.
Maybe is there a SQL query??

Best Answer

  • Options
    Konstantin_Slavin-BoKonstantin_Slavin-Bo Customer Ninja IT Monkey ✭✭✭✭
    edited May 2017 Answer ✓
    You can look it up in the ServiceManagement DB from the CI$DomainGroup table where TeamGroup is 1, i.e:

    SELECT [DisplayName]
      FROM [ServiceManagement].[dbo].[CI$DomainGroup]
      WHERE TeamGroup = 1

Answers

  • Options
    Konstantin_Slavin-BoKonstantin_Slavin-Bo Customer Ninja IT Monkey ✭✭✭✭
    edited May 2017 Answer ✓
    You can look it up in the ServiceManagement DB from the CI$DomainGroup table where TeamGroup is 1, i.e:

    SELECT [DisplayName]
      FROM [ServiceManagement].[dbo].[CI$DomainGroup]
      WHERE TeamGroup = 1

Sign In or Register to comment.