Learn how to retrieve user management setting change records using a data query job.

1. Submit a data query job through UI or API with the following SQL query:

   SELECT username          AS UpdatedBy, 
          timestamp         AS Timestamp, 
          settingtype       AS Type, 
          settingobjectname AS ObjectName, 
          newvalue          AS NewValue, 
          oldvalue          AS OldValue, 
          namespace         AS Namespace, 
          action            AS Action, 
          attributename     AS AttributeName 
   FROM   auditsettingchangeevent 
   WHERE  namespace = 'UserManagement' 
          AND year = 2022
          AND month = 11
   ORDER  BY timestamp DESC 
   LIMIT  100000

2. Check the status of the query job through UI or Get data query job API operation.
3. Download the query result when the job is completed. See the following snippet of the query result.

   UpdatedBy,Timestamp,Type,ObjectName,NewValue,OldValue,Namespace,Action,AttributeName
   audittraile2e@example.com,2022-11-18T07:00:10.286Z,User,34084+user@zuora.com,,Administrator,UserManagement,REMOVED_FROM_COLLECTION,roles
   audittraile2e@example.com,2022-11-18T07:00:10.286Z,User,34084+user@zuora.com,Standard User,,UserManagement,ADDED_TO_COLLECTION,roles
   audittraile2e@example.com,2022-11-18T06:59:08.413Z,Role,audit_1574060164607_update,,,UserManagement,DELETED,
   audittraile2e@example.com,2022-11-18T06:58:08.157Z,Role,audit_1574060164607_update,apiWrite,,UserManagement,ADDED_TO_COLLECTION,permissions
   audittraile2e@example.com,2022-11-18T06:58:08.157Z,Role,audit_1574060164607_update,,ui,UserManagement,REMOVED_FROM_COLLECTION,permissions
   audittraile2e@example.com,2022-11-18T06:57:06.187Z,Role,audit_1574060164607,desc_update,desc,UserManagement,UPDATED,description
   audittraile2e@example.com,2022-11-18T06:57:06.187Z,Role,audit_1574060164607,audit_1574060164607_update,audit_1574060164607,UserManagement,UPDATED,name
   audittraile2e@example.com,2022-11-18T06:56:05.777Z,Role,audit_1574060164607,ui,,UserManagement,ADDED_TO_COLLECTION,permissions
   audittraile2e@example.com,2022-11-18T06:56:05.418Z,Role,audit_1574060164607,,,UserManagement,CREATED,
   audittraile2e@example.com,2022-11-18T06:54:03.701Z,OAuth Client,0fecbd03-9445-4b72-8145-7f813e6b63f5,,,UserManagement,DELETED,