How to find the List of Group for given Project

SELECT *

  FROM [IoAdministration].[dbo].[IO_GRP]

where grp0 in (SELECT rel1

  FROM [IoAdministration].[dbo].[IO_REL]

where rel3= projectiD

and rel2 = 'GRP')

How to find all the User for Given Project

SELECT usr2,usr3,usr8

  FROM [IoAdministration].[dbo].[IO_USR]

where usr0 in (SELECT rel1

  FROM [IoAdministration].[dbo].[IO_REL]

where rel3= 'Projectid'

and rel2 = 'USR')

order by usr2

How to find all groups in given RED DOT Server

SELECT *
  FROM [IoAdministration].[dbo].[IO_GRP]

How to Get the list of Language Variant for Given Project in RED DOT

SELECT 8
  FROM

[IO_LGV]

IO_LGV

Language variants

How We Can Find the given List of user Who will get the Publication Notification when a RED DOT project is Published

SELECT  *
  FROM    [IO_EJE]

IO_EJE

E-mail notification for a publishing job

How to get the list of User in Given Projects from Database

SELECT [PSU0]
      ,[PSU2]
      ,[PSU3]
      ,[PSU4]
  FROM [Project Name].[dbo].[IO_PSU]
order by psu2



SELECT usr2,usr3,usr8
  FROM [IoAdministration].[dbo].[IO_USR]
where usr0 in (SELECT rel1
  FROM [IoAdministration].[dbo].[IO_REL]

where rel3= 'Projectid'
and rel2 = 'USR')

order by usr2

How To Get Project Details from Database

SELECT *
  FROM [IoAdministration].[dbo].[IO_PRJ]
where prj0=PROJECTGUID

How to find the guid of the project in reddot

Server Manager > Administer Projects > Projects > [PROJECT_NAME], click the "i" icon in the top right hand corner of the Action menu.