Audit logs in Zoho DataPrep

Audit settings



Zoho DataPrep allows you to manage all user activities and user access in your organization using the Audit tab under Settings. You can also export and download these audit logs.

DataPrep provides you with the below audit trials:

  • Access audit - Enabling this option helps you monitor all the users who access entities in your organization. 
    (Learn about the entities in Zoho DataPrep)

  • Activity audit - Enabling this option helps you monitor all the user activities in your organization. 
    (But this does not log every run of the active schedules)

    NotesNote: Only the Account admin and Organization admins can access and export the audit logs.

To enable the Audit settings

To enable the audit settings,

1. Choose the Audit tab under Settings.

2. Toggle the Activity audit or Access audit as required.

3. This enables the tracking of audit logs. The access and activity actions will be logged starting soon after you enable them.

4. Similarly when you disable audit logs, the tracking will be stopped immediately. Likewise, when you enable again, access and activity actions will be logged from that point in time and those logs that were previously tracked will be retained.

5. The maximum retaining period of audit logs is two years. When you export audit logs, the audit file includes events from the last two years until one hour before you click the Export button in Zoho DataPrep. The duration is measured from the moment the administrator enabled the audit.




Notes

Note: The Audit settings is mandatory for HIPAA-compliant organizations. Therefore, it is enabled by default if the HIPAA compliance is enabled for your organization. However, you can enable or disable this option when the HIPAA compliance is disabled. Learn more.

To export Activity audit 

1. Click the Activity audit toggle in the Audit tab under Settings.

Enabling the Activity audit option allows you to monitor and log all the user activities such as data import, create, update, delete, share, export, data catalog, schedule, configure etc performed in your organization. Using Activity Logs, you can identify the users responsible for every action, along with the time and location from where the account was accessed to execute these activities.

Notes
The audit logs can be exported from the time the activity audit is enabled and not from the time when the organization was created.

2. Click Export to export the Activity logs data.

3. You will receive a download link to your email address when the data is ready. This link will be active for 7 days.



4. Click the Download button in the email to download the logs.

5. The activity audit logs will be exported as a compressed zip file. Upon extracting the zip file, you will find CSV files with the logs data that was recorded on an hourly basis. This file documents instances of all completed activities.

InfoThe Activity log data you export includes events from the last two years until one hour before you click the Export button in Zoho DataPrep. This duration is measured from the moment the administrator enabled the audit.
NotesNote: You can export logs thrice a day only. Since logs are generally big data, it could cause severe load on the server side to take, encrypt, and compress data when the user initiates it multiple times.

The exported activity logs contain the following data:

  • method

  • os

  • entity_name

  • description

  • ip_address

  • entity_id

  • requester_type

  • user_agent_type

  • workspace_id

  • domain_name

  • -#-EOL-#-

  • user_email_id

  • date_and_time

  • browser

  • details category

  • zsoid

  • entity

  • user_agent

  • workspace_name

  • audit_type

  • status

  • _zl_timestamp

 

 Below is a snapshot of an exported Activity audit log,



 To export the Access audit 

1. Click the Access audit toggle in the Audit tab under Settings.

Enabling Access audit option allows you to monitor and log the details of the users who accessed entities within your organization, along with the time and location of access.
Notes
The audit logs can be exported from the time the access audit is enabled and not from the time when the organization was created.

2. Click Export to start exporting the Access logs data.  


3. You will receive a download link to your email address when the data is ready. This link will be active for 7 days.



4. Click the Download button in the email to download the logs.

5. The access logs will be exported as a compressed zip file. Upon extracting the zip file, you will find CSV files with the logs data that was recorded on an hourly basis.This file documents instances of all accesses.

InfoThe Access log data you export includes events from the last two years until one hour before you click the Export button in Zoho DataPrep. This duration is measured from the moment the administrator enabled the audit.
NotesNote: You can export logs thrice a day only. Since logs are generally big data, it could cause severe load on the server side to take, encrypt, and compress data when the user initiates it multiple times.

The exported access audit logs contain the following data.

  • method

  • os

  • entity_name

  • description

  • ip_address

  • entity_id

  • requester_type

  • user_agent_type

  • workspace_id

  • domain_name

  • -#-EOL-#-

  • user_email_id

  • date_and_time

  • browser

  • details category

  • zsoid

  • entity

  • user_agent

  • workspace_name

  • audit_type

  • status

  • _zl_timestamp

 

Below is a snapshot of an exported Access audit log,

 



SEE ALSO

HIPAA compliance in Zoho DataPrep.

How to mark ePHI data?

Security measures to protect ePHI data.




    Access your files securely from anywhere

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION









                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • Zoho DataPrep with HIPAA Compliance

                                                                                                                The Health Insurance Portability and Accountability Act, HIPAA (including the Privacy Rule, Security Rule, Breach Notification Rule, and Health Information Technology for Economic and Clinical Health Act), requires Covered Entities and Business ...
                                                                                                              • Zoho DataPrep with HIPAA Compliance

                                                                                                                The Health Insurance Portability and Accountability Act, HIPAA (including the Privacy Rule, Security Rule, Breach Notification Rule, and Health Information Technology for Economic and Clinical Health Act), requires Covered Entities and Business ...
                                                                                                              • Organization settings

                                                                                                                Select the Organization settings tab from the Settings side pane to view and edit your organization information. Note: This setting is accessible only to the Account admins of the organization. Organization details You can view your organization ...
                                                                                                              • Manage Databridge

                                                                                                                In the Settings page, select Databridges from the side panel to manage the linked databridges. If you have added Databridges already, you can view details such as: The name of the Databridge, the host server, and the OS it runs on. Number of users ...
                                                                                                              • Manage subscription

                                                                                                                In the Manage subscription tab, you can review your current plan, the number of rows processed, total storage used in your portal and more. It also gives an overview of the other usage details such as the number of data sources and destinations ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources