Table AuditLog and its Relations

Help Orchestrator
1

@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
2

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

image
image1089×153 7.68 KB

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

Regards.

1 Like
3

@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
4

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
5

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