I’m attempting to integrate Orchestrator with ArkSight (Security: Logs management system) as one of our requirements in our company. Integration is done through Ms SQL Server queries and I’m having two issues.
- Logs date are still in UCT 00:00 although I have set in Orchestrtor settings to UCT +03:00,
I have found a work around but I would love to have a permanent fix for this.
SELECT [Id] ,[UserName] ,DATEADD(hh, 3,[LastLoginTime]) AT TIME ZONE 'E. Africa Standard Time' AS LastLoginTime /* LOGIN */ ,DATEADD(hh, 3,[LastModificationTime]) AT TIME ZONE 'E. Africa Standard Time' AS LastModificationTime /* LOGOUT */ FROM [UiPath].[dbo].[Users]
- Users table overwrites instead of adding record (i.e Updates instead of Insert) in case of use login/logout it is a challenge to obtain previous logs. Is there a place in web.config file or ASP.NET file I can change this, and is it legal to change?