What do the numbers in the Action, Component, and UserID columns of the UiPath AuditLogs table represent?
When opening the UiPath.dbo.AuditLogs table from the Orchestrator database, there are going to be three columns that contain numeric values Component, Action, and UserId.
SELECT [Id],[UserId],[Action],[Component] FROM [UiPath].[dbo].[AuditLogs]
For example:
What do the numbers in the Action, Component, and UserID columns of the UiPath AuditLogs table represent?
To find the meaning of each numeric value for those columns, check the below references.
Action 0 -> Unknown 1 -> Create 2 -> Update 3 -> Delete 4 -> StartJob 5 -> StopJob 6 -> Associate 7 -> Upload 8 -> ChangeStatus 9 -> Import 10 -> ChangePassword 11 -> Register 12 -> Toggle 13 -> ResetPassword 14 -> PasswordResetAttempt 15 -> Download 16 -> Acknowledge 17 -> Activate 18 -> Assign 19 -> BulkUpload 20 -> UpdateFeature 21 -> ResumeJob 22 -> Start 23 -> End 24 -> Skip 25 -> Unassign 26 -> Deactivate 27 -> CreateBlobFileSas 28 -> DeleteBlobFile 29 -> Move 30 -> Set 31 -> StartDelete 32 -> ExploreStart 33 -> ExploreEnd 34 -> Save 35 -> Convert 36 -> Forward 37 -> BulkComplete 38 -> BulkSave 39 -> ForceStopJob 40 -> MigrateFolder 41 -> EditTaskMetadata 42 -> Archive 43 -> StartMigrateFolders 44 -> ToggleUserFolderSubscription 45 -> StartUninstall 46 -> StartInstall
Component 0 -> Unknown 1 -> Assets 2 -> Environments 3 -> Processes 4 -> Queues 5 -> Robots 6 -> Roles 7 -> Schedules 8 -> Users 9 -> Comments 10 -> Units 11 -> Jobs 12 -> Settings 13 -> Packages 14 -> License 15 -> Tenant 16 -> Machines 17 -> Libraries 18 -> Webhooks 19 -> ExecutionMedia 20 -> Monitoring 21 -> CredentialStores 22 -> DefaultCredentialStores 23 -> TaskCatalogs 24 -> Tasks 25 -> Maintenance 26 -> Folders 27 -> DirectoryService 28 -> Buckets 29 -> DataRetentionPolicies 30 -> TenantMove 31 -> Secrets 32 -> PersonalWorkspaces 33 -> CloudSubscriptions 34 -> CloudSnapshots 35 -> Sessions 36 -> CredentialStoreHosts 37 -> StudioWeb 38 -> AutomationSolutions 101 -> TestSets 102 -> TestSetSchedules 103 -> TestDataQueues 104 -> TestDataQueueItems
UserId
The UserId column represents the Id of the user who performed the action. It's details can be found in the [UiPath].[dbo].[Users] table.
SELECT * FROM [UiPath].[dbo].[Users] WHERE [Id] = 'UserId_value_found_in_UiPath_dbo_AuditLogs_table'