Показать сообщение отдельно
Старый 17.07.2020, 20:50   #11  
dech is offline
dech
Участник
Аватар для dech
Самостоятельные клиенты AX
 
643 / 347 (13) ++++++
Регистрация: 25.06.2009
Адрес: Омск
Записей в блоге: 3
Таки нашел у себя скрипт.
X++:
SET NOCOUNT ON

-- automatically add admins

DECLARE @RecId BIGINT
DECLARE @RecCount INT

CREATE TABLE #AdminUsers (
	Id NVARCHAR(5) NOT NULL,
	SecId NVARCHAR(124) NOT NULL,
	Alias NVARCHAR(20) NOT NULL,
	Name NVARCHAR(40) NOT NULL,
	Email NVARCHAR(80) NOT NULL,
	Domain NVARCHAR(255) NOT NULL DEFAULT 'your-domain.com'
)

CREATE NONCLUSTERED INDEX IX_ID
ON #AdminUsers (Id)

-- add admin users here:
INSERT INTO #AdminUsers VALUES ('Vasya', 'S-1-5-21-3902653788-3936360043-4268998436-25184', 'PupkinV', 'Pupkin, Vasily', 'vasily.pupkin@your-domain.com', DEFAULT)

SELECT @RecCount = COUNT(*) FROM #AdminUsers

-- UserInfo
EXEC ppoGetRecId 65531, @RecCount, @RecId OUTPUT
DELETE UserInfo WHERE Id IN (SELECT Id FROM #AdminUsers)
INSERT INTO UserInfo ([RecId], [Id], [Sid], [NetworkAlias], [NetworkDomain], [Company], [Enable], [Name], [Language], [HelpLanguage], [CompilerWarningLevel], [DebugInfo])
	SELECT ROW_NUMBER() OVER(ORDER BY Id) - 1 + @RecId, [Id], [SecId], [Alias], [Domain], 'clt', 1, [Name], 'EN-US', 'EN-US', 4, 16 FROM #AdminUsers

-- SysUserInfo
EXEC ppoGetRecId 956, @RecCount, @RecId OUTPUT
DELETE SysUserInfo WHERE Id IN (SELECT Id FROM #AdminUsers)
INSERT INTO SysUserInfo (RecId, Id, HelpTheme, DocuHandlingActive, DocuToolbarButtonActive, EventPollFrequency, EventPopUps, Email)
	SELECT ROW_NUMBER() OVER(ORDER BY Id) - 1 + @RecId, [Id], 'Dynamics', 1, 0, 15, 1, [Email] FROM #AdminUsers

-- UserGroupList
EXEC ppoGetRecId 65529, @RecCount, @RecId OUTPUT
DELETE UserGroupList WHERE UserId (SELECT Id FROM #AdminUsers)
INSERT INTO UserGroupList (RecId, UserId, GroupId)
	SELECT ROW_NUMBER() OVER(ORDER BY Id) - 1 + @RecId, [Id], 'Admin' FROM #AdminUsers

DROP TABLE #AdminUsers
__________________
// no comments
За это сообщение автора поблагодарили: oleggy (1).