{"id":268,"date":"2010-10-28T12:50:00","date_gmt":"2010-10-28T12:50:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=268"},"modified":"2025-01-27T11:15:26","modified_gmt":"2025-01-27T11:15:26","slug":"pull-that-trigger-now-and-audit-all-data-in-sagecrm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/","title":{"rendered":"Pull that Trigger Now and Audit All Data in SageCRM"},"content":{"rendered":"
This is a term that we normally come across in Accounting and ERP packages and not in CRM. In SageCRM we do have tracking in Case and Opportunity which comes close to auditing but it is not actually auditing.\u00a0 It is more of tracking of the phases that an opportunity or a case goes through in its entire life cycle. But what about other entities like company, person in SageCRM. These entities too have critical data like address and phone details. Any unauthorized changes to these will have significant impact on the customer information.\u00a0 Even in the entities like opportunity and cases there is no provision to store the changes made to field other than those mentioned in tracking. Although there is a field that stores the user who had last updated but that does not help. The information does not tell you what has been updated. <\/span><\/div>\n
\u00a0<\/span><\/div>\n
This can be achieved rather easily by using SQL. All you need to do is write a trigger on each of the tables that need to be audited and based on the old value and new value provided by the trigger insert a record in a custom table. This table can store the record id, date and time, user, field name, old value and new value. You can then create custom tab in the entity and using the record id show the administrator exactly which fields were updated and by whom. Depending on the frequency of the edits that you might for your SageCRM, you can create different audit tables for different entities.<\/span><\/div>\n
\u00a0<\/span><\/div>\n
And you thought trigger was only useful in guns!<\/span><\/div>\n

For queries regarding the functionality, please feel free to drop us an email at crm@greytrix.com<\/a>. <\/b><\/p>\n","protected":false},"excerpt":{"rendered":"

This is a term that we normally come across in Accounting and ERP packages and not in CRM. In SageCRM we do have tracking in Case and Opportunity which comes close to auditing but it is not actually auditing.\u00a0 It is more of tracking of the phases that an opportunity or a case goes through\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[586,1076,2472],"class_list":["post-268","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-audit","tag-entity","tag-trigger"],"yoast_head":"\nPull that Trigger Now and Audit All Data in SageCRM<\/title>\n<meta name=\"description\" content=\"This is a term that we normally come across in Accounting and ERP packages and not in CRM. In SageCRM we do have tracking in Case and Opportunity which comes close to auditing but it is not actually auditing.\u00a0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pull that Trigger Now and Audit All Data in SageCRM\" \/>\n<meta property=\"og:description\" content=\"This is a term that we normally come across in Accounting and ERP packages and not in CRM. In SageCRM we do have tracking in Case and Opportunity which comes close to auditing but it is not actually auditing.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2010-10-28T12:50:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-27T11:15:26+00:00\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/\",\"name\":\"Pull that Trigger Now and Audit All Data in SageCRM\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2010-10-28T12:50:00+00:00\",\"dateModified\":\"2025-01-27T11:15:26+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"description\":\"This is a term that we normally come across in Accounting and ERP packages and not in CRM. In SageCRM we do have tracking in Case and Opportunity which comes close to auditing but it is not actually auditing.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pull that Trigger Now and Audit All Data in SageCRM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pull that Trigger Now and Audit All Data in SageCRM","description":"This is a term that we normally come across in Accounting and ERP packages and not in CRM. In SageCRM we do have tracking in Case and Opportunity which comes close to auditing but it is not actually auditing.\u00a0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/","og_locale":"en_US","og_type":"article","og_title":"Pull that Trigger Now and Audit All Data in SageCRM","og_description":"This is a term that we normally come across in Accounting and ERP packages and not in CRM. In SageCRM we do have tracking in Case and Opportunity which comes close to auditing but it is not actually auditing.\u00a0","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2010-10-28T12:50:00+00:00","article_modified_time":"2025-01-27T11:15:26+00:00","author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/","name":"Pull that Trigger Now and Audit All Data in SageCRM","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2010-10-28T12:50:00+00:00","dateModified":"2025-01-27T11:15:26+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"description":"This is a term that we normally come across in Accounting and ERP packages and not in CRM. In SageCRM we do have tracking in Case and Opportunity which comes close to auditing but it is not actually auditing.\u00a0","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/28\/pull-that-trigger-now-and-audit-all-data-in-sagecrm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Pull that Trigger Now and Audit All Data in SageCRM"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=268"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/268\/revisions"}],"predecessor-version":[{"id":29107,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/268\/revisions\/29107"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}