Table AuditLog and its Relations

@mircea @badita

Hello Orchestrator Developer Team,

at the moment I analyze the possibilities to export the audit log to an external database system. Here I have two tiny questions to the content of the AuditLogs table:

  1. To which table does the EntityId field refer?

  2. The fields Action and Component contains numbers, e.g. Action 4 = Start Job with Component 11 = Jobs or Action 7 = Upload with Component 17 = Libraries. Where can I find the enumeration of number to description? The description is here, but unfortunately no numbers.

AuditLog

Thanks for tips and answers.
Best regards
Stefan

1 Like

Hi Stefan,
I dont know how to answer your question, but in my opinion, what you are trying to do should be easir using the orchestrator API, since in the swagger docs they are more or less answering you questions, look:
image


Im not sure, but I think that you can use the second image to answer your questions about the action enum.

Regards.

1 Like

@lucas.stern

Hello Lucas,
excellent, thank you very much. :grinning:
Best regards
Stefan

Action

The action performed.
Unknown              =  0
Create               =  1
Update               =  2
Delete               =  3
StartJob             =  4
StopJob              =  5
Associate            =  6
Upload               =  7
ChangeStatus         =  8
Import               =  9
ChangePassword       = 10
Register             = 11
Toggle               = 12
ResetPassword        = 13
PasswordResetAttempt = 14
Download             = 15
Acknowledge          = 16
Activate             = 17
Assign               = 18
BulkUpload           = 19
UpdateFeature        = 20
ResumeJob            = 21
Start                = 22
End                  = 23
Skip                 = 24
Unassign             = 25
Deactivate           = 26
CreateBlobFileSas    = 27
DeleteBlobFile       = 28
Move                 = 29
Set                  = 30
StartDelete          = 31
ExploreStart         = 32
ExploreEnd           = 33
Save                 = 34
Convert              = 35

Component

The component for which the action was performed.
Unknown                 =  0
Assets                  =  1
Environments            =  2
Processes               =  3
Queues                  =  4
Robots                  =  5
Roles                   =  6
Schedules               =  7
Users                   =  8
Comments                =  9
Units                   = 10
Jobs                    = 11
Settings                = 12
Packages                = 13
License                 = 14
Tenant                  = 15
Machines                = 16
Libraries               = 17
Webhooks                = 18
ExecutionMedia          = 19
Monitoring              = 20
CredentialStores        = 21
DefaultCredentialStores = 22
TaskCatalogs            = 23
Tasks                   = 24
Maintenance             = 25
Folders                 = 26
DirectoryService        = 27
Buckets                 = 28
DataRetentionPolicies   = 29
TenantMove              = 30
Secrets                 = 31
PersonalWorkspaces      = 32
1 Like

In the event you need other value definitions and schemas, you can also look up the EnumTypes in the /odata/$metadata endpoint.

https://<orchestrator>/odata/$metadata

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.