28.09.2023
10:30
hello,
I need to migrate local groups from production to dev environment, do you know database table or do you have sql that will show me all local grups, even empty one ? thanks in advance.
28.09.2023
10:49
MVP
HI
SELECT [BUS_ID]
,[BUS_AccountType]
,[BUS_BpsID]
,[BUS_PhoneNumber]
,[BUS_JobTitle]
,[BUS_Email]
,[BUS_DisplayName]
,[BUS_ManagerBpsID]
,[BUS_TSInsert]
,[BUS_TSUpdate]
,[BUS_RowVersion]
,[BUS_Picture]
FROM [BPS_Config].[dbo].[BpsUsers]
where [BUS_AccountType] = 2
Regards
28.09.2023
11:37
HI
SELECT [BUS_ID]
,[BUS_AccountType]
,[BUS_BpsID]
,[BUS_PhoneNumber]
,[BUS_JobTitle]
,[BUS_Email]
,[BUS_DisplayName]
,[BUS_ManagerBpsID]
,[BUS_TSInsert]
,[BUS_TSUpdate]
,[BUS_RowVersion]
,[BUS_Picture]
FROM [BPS_Config].[dbo].[BpsUsers]
where [BUS_AccountType] = 2
Regards
thank you
