Таки нашел у себя скрипт.
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