Kaizen 239 - Audit Log Monitoring with Proactive Alerts

Kaizen 239 - Audit Log Monitoring with Proactive Alerts



Hello, CRM Wizards!

Welcome to a fresh week of Kaizen. 

In this post, we will look at how to track system and user activity in your CRM using audit logs and broadcast actionable alerts across the organization when something goes wrong.

Business Problem 

In most CRM setups, issues are identified only after they affect outcomes.
  1. Deals remain untouched for long periods.
  2. Automation failures are missed.
  3. Teams lack visibility into system activity.
Audit logs capture all of this information, but they are rarely monitored regularly.

Solution

We recommend building a simple monitoring flow using:
  1. CRM Audit Logs API to fetch activity.
  2. A scheduled function to process the data periodically.
  3. A team communication tool to send alerts.
In this example, we use Zoho Cliq to send notifications. You can use any team communication platform that supports webhooks or APIs.

For this walkthrough, we will detect automation execution failures and notify the team.

Prerequisites

1. Create Connections in Zoho CRM

Follow the connection setup guide and create the following:

Zoho CRM connection with ZohoFiles.files.READ,ZohoCRM.settings.audit_logs.CREATE,ZohoCRM.settings.audit_logs.READ scopes. 


Zoho Cliq connection with ZohoCliq.Webhooks.CREATE scope. 


Store the Connection link name of the both the connections to use them in the function. 

2. Create a Zoho Cliq Bot

Refer to the Managing Bots help resource and build a cliq bot to which we will share the alerts. 


Store the Cliq Bot's unique name to use in the functions. 

Step 1: Create a Scheduled Function

  1. Go to Setup → Automation → Schedules and click Create New Schedule.
  2. Enter a Schedule Name and Description. 
  3. In Function to be executed, select Writing Function.
  4. Provide the following in the pop-up:
    1. Display Name
    2. Function Name
    3. Description
  5. Click Create.

Step 2: Code the function

I. Fetch Audit Log

Use the invokeUrl() function to make calls to the Export Audit Log APIs. While constructing the Create Export Audit Log API, filter the records using the audited_time field to retrieve data from the last 7 days.
  1. Use zoho.currenttime system variable as the end time.
  2. Calculate the start time by subtracting 7 days from the current time.
endTime = zoho.currenttime;
startTime = endTime.addDay(-7);
endTime = endTime.addDay(1);
startStr = startTime.toString("yyyy-MM-dd'T'00:00:00XXX");
endStr = endTime.toString("yyyy-MM-dd'T'23:59:59XXX");

Apply this time range in the request body as a filter to limit the results to recent activity. The audit log response will be returned as CSV file(s).

auditLogFile = invokeurl
[
url :downloadUrl //fetched from the Audit Log Job Status API call
type :GET
connection:"zylker_oauth_connection"
];
info auditLogFile;

Notes
Note 

When downloading and processing files using APIs in Deluge, the supported file size depends on the API source:
  1. Up to 5 MB for files fetched from external (non-Zoho) APIs.
  2. Up to 15 MB for files fetched from Zoho domain APIs.

II. Process the Logs

Convert the CSV data to string and iterate through each row to check for execution.failure to identify the failures. 

csvData = auditLogFile.toString();
// Split rows: every row ends with AM" or PM", use ||| as row separator
csvData = csvData.replaceAll("AM\"", "AM\"|||", true);
csvData = csvData.replaceAll("PM\"", "PM\"|||", true);
rows = csvData.toList("|||");
info "Total rows: " + rows.size();
failureList = List();
for each row in rows
{
//Loop and search for the required data
}

II. Build the Alert

Get the count of number of failures and construct a message stating it along with a URL that redirects the user to the Audit Log. 

if(failureList.size() > 0)
{
    info "--- Failure Summary (" + failureList.size() + " failures) ---";
    failureCount = failureList.size();
    cliqMessage = failureCount + " executions have failed in automation. Kindly check the";
info cliqMessage;
}

IV. Send Notification

Use the Post to Bot Cliq integration Deluge task to share the message to your communication platform. Here we are pushing the message to a cliq bot using Zoho Cliq API. 

cliqResponse = zoho.cliq.postToBot("crmactivitykaize", cliqMessage, "cliq_oauth_connection");
 info "Cliq Response: " + cliqResponse;

Step 3: Set Frequency for the scheduler

  1. Click Save and provide the Execution Start Date. 
  2. Set the Frequency to weekly and Ends as Never. You can configure the frequency based on your business needs. 
  3. Save the Schedule. 


Try it Out!

Trigger a workflow failure for testing and run the function.



The sample code is provided at the end of this post for your reference.

Similar Scenarios

You can extend this approach to:
  1. Identify inactive (silent) deals
  2. Track activity gaps
  3. Monitor repeated failures
  4. Analyze usage patterns
We hope this kaizen helped you to build monitoring and alert system with minimal setup. 

Have questions or suggestions? Drop them in the comments or write to us at support@zohocrm.com.

On to Better Building!

-------------------------------------------------------------------------------------------------------------
Idea
Previous Kaizen: Fetching Data from Microsoft SQL Server Using Queries | Kaizen Collection: Home

    Access your files securely from anywhere

          What's new
          Blogs
          Community
          Zia
          API resources
          Pricing
          Integrations
          Town Hall
          Custom Apps


          All-in-one knowledge management and training platform for your employees and customers.






                                Zoho Developer Community



                                    Bootcamp
                                    Community
                                    Pricing
                                    Webinars
                                    What's New
                                    Integrations
                                    Contact Support
                                    Contact Sales
                                      Zoho Survey Resources
                                        Features
                                        Survey Templates
                                        Integrations
                                        Community
                                        iOS Mobile Surveys
                                        Pricing
                                        Android Mobile Surveys
                                        Insurvey Blogs
                                        Insight Blogs
                                        Tips & Tricks





                                                    Latest Feature Updates

                                                      • Desk Community Learning Series


                                                      • Digest


                                                      • Functions


                                                      • Meetups


                                                      • Kbase


                                                      • Resources


                                                      • Glossary


                                                      • Desk Marketplace


                                                      • MVP Corner


                                                      • Word of the Day


                                                      • Ask the Experts




                                                          Zoho SalesIQ Resources

                                                                • Sticky Posts

                                                                • Kaizen #198: Using Client Script for Custom Validation in Blueprint

                                                                  Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.

                                                                • Kaizen #226: Using ZRC in Client Script

                                                                  Hello everyone! Welcome to another week of Kaizen. In today's post, lets see what is ZRC (Zoho Request Client) and how we can use ZRC methods in Client Script to get inputs from a Salesperson and update the Lead status with a single button click. In this

                                                                • Kaizen #222 - Client Script Support for Notes Related List

                                                                  Hello everyone! Welcome to another week of Kaizen. The final Kaizen post of the year 2025 is here! With the new Client Script support for the Notes Related List, you can validate, enrich, and manage notes across modules. In this post, we’ll explore how

                                                                • Kaizen #217 - Actions APIs : Tasks

                                                                  Welcome to another week of Kaizen! In last week's post we discussed Email Notifications APIs which act as the link between your Workflow automations and you. We have discussed how Zylker Cloud Services uses Email Notifications API in their custom dashboard.

                                                                • Kaizen #216 - Actions APIs : Email Notifications

                                                                  Welcome to another week of Kaizen! For the last three weeks, we have been discussing Zylker's workflows. We successfully updated a dormant workflow, built a new one from the ground up and more. But our work is not finished—these automated processes are


                                                                Manage your brands on social media
                                                                Access Zoho Social

                                                                  Zoho Pagesense Resources


                                                                      Zoho TeamInbox Resources

                                                                        Zoho DataPrep Resources


                                                                          Zoho CRM Plus Resources

                                                                            Zoho Books Resources


                                                                              Zoho Subscriptions Resources

                                                                                Zoho Projects Resources


                                                                                  Zoho Sprints Resources


                                                                                    Qntrl Resources


                                                                                      Zoho Creator Resources



                                                                                          Zoho CRM Resources

                                                                                          • CRM Community Learning Series

                                                                                            CRM Community Learning Series


                                                                                          • Kaizen

                                                                                            Kaizen

                                                                                          • Functions

                                                                                            Functions

                                                                                          • Meetups

                                                                                            Meetups

                                                                                          • Kbase

                                                                                            Kbase

                                                                                          • Resources

                                                                                            Resources

                                                                                          • Digest

                                                                                            Digest

                                                                                          • CRM Marketplace

                                                                                            CRM Marketplace

                                                                                          • MVP Corner

                                                                                            MVP Corner









                                                                                              Design. Discuss. Deliver.

                                                                                              Create visually engaging stories with Zoho Show.

                                                                                              Get Started Now


                                                                                                Zoho Show Resources

                                                                                                  Zoho Writer

                                                                                                  Get Started. Write Away!

                                                                                                  Writer is a powerful online word processor, designed for collaborative work.

                                                                                                    Zoho CRM コンテンツ





                                                                                                      Nederlandse Hulpbronnen


                                                                                                          ご検討中の方