DECLARE @serverVersion INTSET @serverVersion =ISNULL(CAST(COALESCE(SERVERPROPERTY('ProductMajorVersion'),PARSENAME(CAST(SERVERPROPERTY('productversion')ASvarchar(20)),4))asINT),0)IFNOTEXISTS(SELECT1 from [dbo].[Settings]WHERE[Name]='Migration.AuditCleanup.Buckets'AND[TenantId]ISNULL)BEGINIF @serverVersion >=13--SQL Server 2016-- Remove just the password if json functions are supported
EXECUTE sp_executesql N'
UPDATE[dbo].[AuditLogs]SET[Parameters]=JSON_MODIFY([Parameters],''$.bucketDto.Password'',NULL)WHERE[TenantId]IN(SELECTDISTINCT TenantId FROM[dbo].[Buckets]WHERE[StorageProvider]IN(''Amazon'',''Azure'',''Minio'',''S3Compatible''))AND[ServiceName]=''UiPath.Orchestrator.Web.Api.OData.Controllers.BucketsController''ANDCHARINDEX(''Password'',[Parameters])>0ANDNULLIF(JSON_VALUE([Parameters],''$.bucketDto.Password''),'''')ISNOTNULL'
-- Remove all parameters if json functions are not supported
EXECUTE sp_executesql N'
UPDATE[dbo].[AuditLogs]SET[Parameters]=''''WHERE[TenantId]IN(SELECTDISTINCT TenantId FROM[dbo].[Buckets]WHERE[StorageProvider]IN(''Amazon'',''Azure'',''Minio'',''S3Compatible''))AND[ServiceName]=''UiPath.Orchestrator.Web.Api.OData.Controllers.BucketsController''ANDCHARINDEX
(''Password'',[Parameters])>0'
INSERTINTO[dbo].[Settings]([TenantId],[UserId],[Name],[Value],[CreationTime])VALUES(null,null,'Migration.AuditCleanup.Buckets','true',GETUTCDATE())IFNOTEXISTS(SELECT1 from [dbo].[Settings]WHERE[Name]='Migration.AuditCleanup.CredentialStores'AND[TenantId]ISNULL)BEGINIF @serverVersion >=13--SQL Server 2016-- Remove just the password if json functions are supported
EXECUTE sp_executesql N'
UPDATE[dbo].[AuditLogs]SET[Parameters]=JSON_MODIFY([Parameters],''$.credentialStoreDto.AdditionalConfiguration'',NULL)WHERE[TenantId]IN(SELECTDISTINCT TenantId FROM[dbo].[CredentialStores]WHERE[Type]<>''Database'')AND[ServiceName]=''UiPath.Orchestrator.Web.Api.OData.Controllers.CredentialStoresController''ANDCHARINDEX(''AdditionalConfiguration'',[Parameters])>0ANDISJSON([Parameters])=1ANDNULLIF(JSON_VALUE([Parameters],''$.credentialStoreDto.AdditionalConfiguration''),'''')ISNOTNULL-- Some records are truncated, so not valid JSONUPDATE[dbo].[AuditLogs]SET[Parameters]=''''WHERE[TenantId]IN(SELECTDISTINCT TenantId FROM[dbo].[CredentialStores]WHERE[Type]<>''Database'')AND[ServiceName]=''UiPath.Orchestrator.Web.Api.OData.Controllers.CredentialStoresController''ANDCHARINDEX(''AdditionalConfiguration'',[Parameters])>0ANDISJSON([Parameters])=0'
-- Remove all parameters if json functions are not supported
EXECUTE sp_executesql N'
UPDATE[dbo].[AuditLogs]SET[Parameters]=''''WHERE[TenantId]IN(SELECTDISTINCT TenantId FROM[dbo].[CredentialStores]WHERE[Type]<>''Database'')AND[ServiceName]=''UiPath.Orchestrator.Web.Api.OData.Controllers.CredentialStoresController''ANDCHARINDEX(''AdditionalConfiguration'',[Parameters])>0'
INSERTINTO[dbo].[Settings]([TenantId],[UserId],[Name],[Value],[CreationTime])VALUES(null,null,'Migration.AuditCleanup.CredentialStores','true',GETUTCDATE())IFNOTEXISTS(SELECT1 from [dbo].[Settings]WHERE[Name]='Migration.AuditCleanup.PackageFeedApiKey'AND[TenantId]ISNULL)BEGINIF @serverVersion >=13--SQL Server 2016-- Remove just the password if json functions are supported
EXECUTE sp_executesql N'
UPDATE[dbo].[AuditLogEntities]SET[CustomData]=JSON_MODIFY([CustomData],''$.ApiKey'',NULL)WHERE[EntityId]ISNULLAND[EntityName]=''UiPackageFeed''ANDCHARINDEX(''ApiKey'',[CustomData])>0ANDJSON_VALUE([CustomData],''$.ApiKey'')ISNOT
NULL'
-- Remove just the password if json functions are supported
EXECUTE sp_executesql N'
UPDATE[dbo].[AuditLogEntities]SET[CustomData]=''''WHERE[EntityId]ISNULLAND[EntityName]=''UiPackageFeed''ANDCHARINDEX(''ApiKey'',[CustomData])>0'
INSERTINTO[dbo].[Settings]([TenantId],[UserId],[Name],[Value],[CreationTime])VALUES(null,null,'Migration.AuditCleanup.PackageFeedApiKey','true',GETUTCDATE())IFNOTEXISTS(SELECT1 from [dbo].[Settings]WHERE[Name]='Migration.AuditCleanup.PackageFeedBasicPassword'AND[TenantId]ISNULL)BEGINIF @serverVersion >=13--SQL Server 2016-- Remove just the password if json functions are supported
EXECUTE sp_executesql N'
UPDATE[dbo].[AuditLogEntities]SET[CustomData]=JSON_MODIFY([CustomData],''$.BasicPassword'',NULL)WHERE[EntityId]ISNULLAND[EntityName]=''UiPackageFeed''ANDCHARINDEX(''BasicPassword'',[CustomData])>0ANDJSON_VALUE([CustomData],''$.BasicPassword'')ISNOTNULL'
-- Remove just the password if json functions are supported
EXECUTE sp_executesql N'
UPDATE[dbo].[AuditLogEntities]SET[CustomData]=''''WHERE[EntityId]ISNULLAND[EntityName]=''UiPackageFeed''ANDCHARINDEX(''BasicPassword'',[CustomData])>0'
INSERTINTO[dbo].[Settings]([TenantId],[UserId],[Name],[Value],[CreationTime])VALUES(null,null,'Migration.AuditCleanup.PackageFeedBasicPassword','true',GETUTCDATE())IFNOTEXISTS(SELECT1 from [dbo].[Settings]WHERE[Name]='Migration.AuditCleanup.LicenseKey'AND[TenantId]ISNULL)BEGINIF @serverVersion >=13--SQL Server 2016EXECUTE sp_executesql N'
UPDATE[dbo].[AuditLogs]SET[Parameters]=JSON_MODIFY([Parameters],''$.licenseKey'',NULL)WHERE[ServiceName]=''UiPath.Orchestrator.Web.Api.OData.Controllers.SettingsController''ANDCHARINDEX(''licenseKey'',[Parameters])>0ANDISJSON([Parameters])=1ANDJSON_VALUE([Parameters],''$.licenseKey'')ISNOTNULLUPDATE[dbo].[AuditLogs]SET[Parameters]=''''WHERE[ServiceName]=''UiPath.Orchestrator.Web.Api.OData.Controllers.SettingsController''ANDCHARINDEX(''licenseKey'',[Parameters])>0ANDISJSON([Parameters])=0'
EXECUTE sp_executesql N'
UPDATE[dbo].[AuditLogs]SET[Parameters]=''''WHERE[ServiceName]=''UiPath.Orchestrator.Web.Api.OData.Controllers.SettingsController''ANDCHARINDEX(''licenseKey'',[Parameters])>0'
INSERTINTO[dbo].[Settings]([TenantId],[UserId],[Name],[Value],[CreationTime])VALUES(null,null,'Migration.AuditCleanup.LicenseKey','true',GETUTCDATE())ENDDECLARE @serverVersion INT
SET @serverVersion = ISNULL(CAST(COALESCE(SERVERPROPERTY('ProductMajorVersion'),PARSENAME(CAST(SERVERPROPERTY('productversion') AS varchar(20)), 4)) as INT),0)
IF NOT EXISTS (SELECT 1 from [dbo].[Settings] WHERE [Name] = 'Migration.AuditCleanup.Buckets' AND [TenantId] IS NULL)
BEGIN
IF @serverVersion >= 13 -- SQL Server 2016
-- Remove just the password if json functions are supported
EXECUTE sp_executesql N'
UPDATE [dbo].[AuditLogs]
SET [Parameters] = JSON_MODIFY([Parameters], ''$.bucketDto.Password'', NULL)
WHERE
[TenantId] IN (SELECT DISTINCT TenantId FROM [dbo].[Buckets] WHERE [StorageProvider] IN (''Amazon'',''Azure'',''Minio'',''S3Compatible'')) AND
[ServiceName] = ''UiPath.Orchestrator.Web.Api.OData.Controllers.BucketsController'' AND
CHARINDEX(''Password'', [Parameters]) > 0 AND
NULLIF(JSON_VALUE([Parameters], ''$.bucketDto.Password''), '''') IS NOT NULL'
-- Remove all parameters if json functions are not supported
EXECUTE sp_executesql N'
UPDATE [dbo].[AuditLogs]
SET [Parameters] = ''''
WHERE
[TenantId] IN (SELECT DISTINCT TenantId FROM [dbo].[Buckets] WHERE [StorageProvider] IN (''Amazon'',''Azure'',''Minio'',''S3Compatible'')) AND
[ServiceName] = ''UiPath.Orchestrator.Web.Api.OData.Controllers.BucketsController'' AND
CHARINDEX(''Password'', [Parameters]) > 0'
INSERT INTO [dbo].[Settings] ([TenantId],[UserId],[Name],[Value],[CreationTime])
VALUES (null,null,'Migration.AuditCleanup.Buckets','true',GETUTCDATE())
IF NOT EXISTS (SELECT 1 from [dbo].[Settings] WHERE [Name] = 'Migration.AuditCleanup.CredentialStores' AND [TenantId] IS NULL)
BEGIN
IF @serverVersion >= 13 -- SQL Server 2016
-- Remove just the password if json functions are supported
EXECUTE sp_executesql N'
UPDATE [dbo].[AuditLogs]
SET [Parameters] = JSON_MODIFY([Parameters], ''$.credentialStoreDto.AdditionalConfiguration'', NULL)
WHERE
[TenantId] IN (SELECT DISTINCT TenantId FROM [dbo].[CredentialStores] WHERE [Type] <> ''Database'') AND
[ServiceName] = ''UiPath.Orchestrator.Web.Api.OData.Controllers.CredentialStoresController'' AND
CHARINDEX(''AdditionalConfiguration'', [Parameters]) > 0 AND
ISJSON([Parameters]) = 1 AND
NULLIF(JSON_VALUE([Parameters], ''$.credentialStoreDto.AdditionalConfiguration''), '''') IS NOT NULL
-- Some records are truncated, so not valid JSON
UPDATE [dbo].[AuditLogs]
SET [Parameters] = ''''
WHERE
[TenantId] IN (SELECT DISTINCT TenantId FROM [dbo].[CredentialStores] WHERE [Type] <> ''Database'') AND
[ServiceName] = ''UiPath.Orchestrator.Web.Api.OData.Controllers.CredentialStoresController'' AND
CHARINDEX(''AdditionalConfiguration'', [Parameters]) > 0 AND
ISJSON([Parameters]) = 0'
-- Remove all parameters if json functions are not supported
EXECUTE sp_executesql N'
UPDATE [dbo].[AuditLogs]
SET [Parameters] = ''''
WHERE
[TenantId] IN (SELECT DISTINCT TenantId FROM [dbo].[CredentialStores] WHERE [Type] <> ''Database'') AND
[ServiceName] = ''UiPath.Orchestrator.Web.Api.OData.Controllers.CredentialStoresController'' AND
CHARINDEX(''AdditionalConfiguration'', [Parameters]) > 0'
INSERT INTO [dbo].[Settings] ([TenantId],[UserId],[Name],[Value],[CreationTime])
VALUES (null,null,'Migration.AuditCleanup.CredentialStores','true',GETUTCDATE())
IF NOT EXISTS (SELECT 1 from [dbo].[Settings] WHERE [Name] = 'Migration.AuditCleanup.PackageFeedApiKey' AND [TenantId] IS NULL)
BEGIN
IF @serverVersion >= 13 -- SQL Server 2016
-- Remove just the password if json functions are supported
EXECUTE sp_executesql N'
UPDATE [dbo].[AuditLogEntities]
SET [CustomData] = JSON_MODIFY([CustomData], ''$.ApiKey'', NULL)
WHERE
[EntityId] IS NULL AND
[EntityName] = ''UiPackageFeed'' AND
CHARINDEX(''ApiKey'', [CustomData]) > 0 AND
JSON_VALUE([CustomData], ''$.ApiKey'') IS NOT NULL'
-- Remove just the password if json functions are supported
EXECUTE sp_executesql N'
UPDATE [dbo].[AuditLogEntities]
SET [CustomData] = ''''
WHERE
[EntityId] IS NULL AND
[EntityName] = ''UiPackageFeed'' AND
CHARINDEX(''ApiKey'', [CustomData]) > 0'
INSERT INTO [dbo].[Settings] ([TenantId],[UserId],[Name],[Value],[CreationTime])
VALUES (null,null,'Migration.AuditCleanup.PackageFeedApiKey','true',GETUTCDATE())
IF NOT EXISTS (SELECT 1 from [dbo].[Settings] WHERE [Name] = 'Migration.AuditCleanup.PackageFeedBasicPassword' AND [TenantId] IS NULL)
BEGIN
IF @serverVersion >= 13 -- SQL Server 2016
-- Remove just the password if json functions are supported
EXECUTE sp_executesql N'
UPDATE [dbo].[AuditLogEntities]
SET [CustomData] = JSON_MODIFY([CustomData], ''$.BasicPassword'', NULL)
WHERE
[EntityId] IS NULL AND
[EntityName] = ''UiPackageFeed'' AND
CHARINDEX(''BasicPassword'', [CustomData]) > 0 AND
JSON_VALUE([CustomData], ''$.BasicPassword'') IS NOT NULL'
-- Remove just the password if json functions are supported
EXECUTE sp_executesql N'
UPDATE [dbo].[AuditLogEntities]
SET [CustomData] = ''''
WHERE
[EntityId] IS NULL AND
[EntityName] = ''UiPackageFeed'' AND
CHARINDEX(''BasicPassword'', [CustomData]) > 0'
INSERT INTO [dbo].[Settings] ([TenantId],[UserId],[Name],[Value],[CreationTime])
VALUES (null,null,'Migration.AuditCleanup.PackageFeedBasicPassword','true',GETUTCDATE())
IF NOT EXISTS (SELECT 1 from [dbo].[Settings] WHERE [Name] = 'Migration.AuditCleanup.LicenseKey' AND [TenantId] IS NULL)
BEGIN
IF @serverVersion >= 13 -- SQL Server 2016
EXECUTE sp_executesql N'
UPDATE [dbo].[AuditLogs]
SET [Parameters] = JSON_MODIFY([Parameters], ''$.licenseKey'', NULL)
WHERE
[ServiceName] = ''UiPath.Orchestrator.Web.Api.OData.Controllers.SettingsController'' AND
CHARINDEX(''licenseKey'', [Parameters]) > 0 AND
ISJSON([Parameters]) = 1 AND
JSON_VALUE([Parameters], ''$.licenseKey'') IS NOT NULL
UPDATE [dbo].[AuditLogs]
SET [Parameters] = ''''
WHERE
[ServiceName] = ''UiPath.Orchestrator.Web.Api.OData.Controllers.SettingsController'' AND
CHARINDEX(''licenseKey'', [Parameters]) > 0 AND
ISJSON([Parameters]) = 0'
EXECUTE sp_executesql N'
UPDATE [dbo].[AuditLogs]
SET [Parameters] = ''''
WHERE
[ServiceName] = ''UiPath.Orchestrator.Web.Api.OData.Controllers.SettingsController'' AND
CHARINDEX(''licenseKey'', [Parameters]) > 0'
INSERT INTO [dbo].[Settings] ([TenantId],[UserId],[Name],[Value],[CreationTime])
VALUES (null,null,'Migration.AuditCleanup.LicenseKey','true',GETUTCDATE())
使用 BeyondTrust Server 的最新版本或升级到最新版本有时会导致集成问题。现在一切已正常。
对于通过无凭据帐户执行的作业,在“作业”页面和“日志”页面上按主机身份进行筛选将无法正常工作。在 Windows 计算机上运行作业时,“主机身份”列将填充机器人的实际身份 (domain\username),但按此值进行筛选不会返回任何作业。在 Linux 计算机上运行作业时,将以 Root 用户身份执行作业,但此值不可用于筛选。
升级警告窗口中的“确定”和“取消”按钮未在日语版应用程序中正确显示。这些按钮现在可见。
2023 年 4 月 24 日添加
使用 Mozilla Firefox 时,有时无法正确显示“监控”页面“概述”部分中的“作业历史记录”和“事务”图。如果发生这种情况,刷新浏览器应该可以解决该问题。