Wednesday 18 June 2014

Can we change the User ID for given user in RED DOT

Yes we can for eg if we have some user as userxyz and if we would like to have userpqr .. We can change the same.

Wednesday 21 May 2014

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_LGVLanguage 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_EJEE-mail notification for a publishing job