{"id":12504,"date":"2019-06-17T19:11:58","date_gmt":"2019-06-17T19:11:58","guid":{"rendered":"https:\/\/dbtut.com\/?p=12504"},"modified":"2019-06-17T19:11:59","modified_gmt":"2019-06-17T19:11:59","slug":"how-to-check-disabled-audits-using-policy-based-management","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/","title":{"rendered":"How To Check Disabled Audits Using Policy Based Management"},"content":{"rendered":"<p>Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to set our standards and to make our controls automatically. For example, we can create a policy for control purposes so that the names of our stored procedures do not start with a number or database recovery models are not simple.<\/p>\n<p>To comprehend Policy Based Management (PBM), you need to understand some concepts.<\/p>\n<h2>Facet<\/h2>\n<p>A feature that can be managed by PBM. For example, there is a facet called Audit. And using this facet, you can create a policy that checks whether the audits you have defined are disabled.<\/p>\n<p>You can access all facets via SSMS as follows. To access the facet details, you must double-click on it.<\/p>\n<p id=\"OwPCfCy\"><img loading=\"lazy\" decoding=\"async\" width=\"576\" height=\"584\" class=\"size-full wp-image-12506  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/img_5d0782a830a0d.png\" alt=\"\"><\/p>\n<h2>Condition<\/h2>\n<p>Checks whether the sub-property of the related facets provide the specified condition. \u00d6rne\u011fin Audit facet&#8217;\u0131n\u0131n Enabled alt \u00f6zelli\u011fini kontrol ederek disable edilmi\u015f audit&#8217;leri kontrol edebilirsiniz.<\/p>\n<p>Let&#8217;s create a policy that checks disabled audits.<\/p>\n<h2>Create a Policy<\/h2>\n<p>Right click Policies tab as follows from the Management&gt; Policy tab and click New Policy.<\/p>\n<p id=\"xSFQjYX\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-12508  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/img_5d07856e9aebb.png\" alt=\"\" width=\"532\" height=\"180\"><\/p>\n<p>We give a name to Policy on the screen that appears. We need to create a condition from Check Condition.<\/p>\n<p>We&#8217;re clicking on New Condition.<\/p>\n<p id=\"iBJAxkY\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-12510  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/img_5d07858a6c0a5.png\" alt=\"\" width=\"676\" height=\"406\"><\/p>\n<p>We give a name to the condition from the screen that appears.<\/p>\n<p>We select Audit facet&nbsp; from facet section because we will check disabled audits.<\/p>\n<p>By clicking &#8220;&#8230;&#8221; in the Expression section, we select @Enabled, which is the sub-feature of Audit facet.<\/p>\n<p>We select = from Operator, and True in Value. Thus, if Audit is disabled the policy will fail.<\/p>\n<p>If you want to check that the Database Audit Specification that will use this Audit is also disabled, you must use the Database Audit Specification Facet in another policy. For detailed information about audits, I recommend reading &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/12\/how-to-create-sql-server-audit\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Create SQL Server Audit<\/a>&#8220;.<\/p>\n<p id=\"OWBOZvn\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-12512  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/img_5d0785ba72126.png\" alt=\"\" width=\"649\" height=\"347\"><\/p>\n<p>By selecting On Schedule from the Evaluation Mode, we select the interval at which the policy will be checked and then click the Enable check box.<\/p>\n<p>If we choose On Demand, it only checks when we execute policy.<\/p>\n<p>If you have a server-based condition, you can create a server-based condition from the server restriction section.<\/p>\n<p id=\"SbzEVLw\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-12514  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/img_5d0785d9b8945.png\" alt=\"\" width=\"654\" height=\"644\"><\/p>\n<p>If you want it to be checked automatically at certain intervals, click New in the Schedule section and determine the frequency that the policy will check the condition. We set it up to work once every day at 12: 00: 000 PM.<\/p>\n<p id=\"hCuZIMg\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-12516  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/img_5d0785fc56675.png\" alt=\"\" width=\"654\" height=\"524\"><\/p>\n<p>We created our policy. We click Evaluate as below to run it manually.<\/p>\n<p id=\"bEgFFQd\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-12518  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/img_5d078618e8707.png\" alt=\"\" width=\"554\" height=\"284\"><\/p>\n<p>I got a result as follows in my local.<\/p>\n<p id=\"kpmqfjY\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-12520  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/img_5d07863299f6d.png\" alt=\"\" width=\"692\" height=\"603\"><\/p>\n<p>I would like to talk about another thing about Audit Facet.<\/p>\n<p>You can create a condition that sets the OnFailed property to Continue as follows. It ensures that some audits are set to Continue instead of Shutdown.<\/p>\n<p>The reason we do this is when the audit fails, if the audit is set to Shutdown, the sql server service fails. This is usually something we don&#8217;t want. Of course, you may need to shutdown sql server service for some critical applications if cannot write the audit.<\/p>\n<p id=\"NAjvBmQ\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-12522  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/img_5d07865313265.png\" alt=\"\" width=\"564\" height=\"238\"><\/p>\n<p>Or you can use the DateLastModified property to check whether the audit has been modified by anyone.<\/p>\n<p id=\"Snfpjdm\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-12524  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/img_5d07866d16b06.png\" alt=\"\" width=\"539\" height=\"214\"><\/p>\n<p>With Policy Based Management, you can check many things on SQL Server. And I think a professional database manager should use this feature that SQL Server offers us. You can find more articles on Policy Based Management at the following links.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/05\/20\/how-to-check-the-compatibility-level-of-databases-using-policy-based-management\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Check the Compatibility Level of Databases Using Policy Based Management<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/06\/09\/how-to-check-recovery-model-of-all-databases-using-policy-based-management\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Check Recovery Model of All Databases Using Policy Based Management<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/06\/11\/how-to-check-stored-procedure-names-using-policy-based-managementregex\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Check Stored Procedure Names Using Policy Based Management<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Check VLF Counts in the Databases Using Policy Based Management<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/06\/15\/how-to-check-sql-logins-without-password-policy-enforced-or-password-expiration-enabled-using-policy-based-management\/\" target=\"_blank\" rel=\"bookmark noopener noreferrer\">How To Check SQL Logins Without Password Policy Enforced or Password Expiration Enabled Using Policy Based Management<\/a>&#8220;,<\/p>\n<p>&#8220;How To Check Auto Shrink Option of Databases Using Policy Based Management&#8221;,<\/p>\n<p>&#8220;How To Check Whether Availability Groups is Ready To Failover Using Policy Based Management&#8221;,<\/p>\n<p>&#8220;How To Check Availability Group&#8217;s Backup Preference Using Policy Based Management&#8221;,<\/p>\n<p>&#8220;How To Check Availability Group Automatic Failover Settings Using Policy Based Management&#8221;,<\/p>\n<p>&#8220;How To Check Whether Readable Secondary is Enabled on Availability Groups Using Policy Based Management&#8221;,<\/p>\n<p>&#8220;How To Check Whether Data File Sizes is Reached a Specific Size Using Policy Based Management&#8221;,<\/p>\n<p>&#8220;How To Check Auto Close Option of Databases Using Policy Based Management&#8221;,<\/p>\n<p>&#8220;How To Check Last Log Backup Time Using Policy Based Management&#8221;,<\/p>\n<p>&#8220;How To Check Page Verify Option of Databases Using Policy Based Management&#8221;<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_12504\" class=\"pvc_stats all  \" data-element-id=\"12504\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to set our standards and to make our controls automatically. For example, we can create a policy for control purposes so that the names of our stored procedures do not start &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_12504\" class=\"pvc_stats all  \" data-element-id=\"12504\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":12526,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1],"tags":[4557,4559,4560,4562,4561,4558,4563],"class_list":["post-12504","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-uncategorized","tag-check-disabled-audits","tag-check-status","tag-enable-and-disable-the-audit-in-sql-server","tag-how-to-check-audit-disabled","tag-how-to-check-audit-status","tag-is-audir-disabled","tag-sql-server-auditing-best-practices"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Check Disabled Audits Using Policy Based Management - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Check Disabled Audits Using Policy Based Management\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Check Disabled Audits Using Policy Based Management - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Check Disabled Audits Using Policy Based Management\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-17T19:11:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-06-17T19:11:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-5.png\" \/>\n\t<meta property=\"og:image:width\" content=\"613\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Check Disabled Audits Using Policy Based Management\",\"datePublished\":\"2019-06-17T19:11:58+00:00\",\"dateModified\":\"2019-06-17T19:11:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/\"},\"wordCount\":764,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-5.png\",\"keywords\":[\"check disabled audits\",\"Check status\",\"enable and disable the Audit in SQL Server\",\"how to check audit disabled\",\"How to check audit status\",\"is audir disabled\",\"sql server auditing best practices\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/\",\"name\":\"How To Check Disabled Audits Using Policy Based Management - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-5.png\",\"datePublished\":\"2019-06-17T19:11:58+00:00\",\"dateModified\":\"2019-06-17T19:11:59+00:00\",\"description\":\"How To Check Disabled Audits Using Policy Based Management\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-5.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-5.png\",\"width\":613,\"height\":375},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Check Disabled Audits Using Policy Based Management\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Check Disabled Audits Using Policy Based Management - Database Tutorials","description":"How To Check Disabled Audits Using Policy Based Management","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:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/","og_locale":"en_US","og_type":"article","og_title":"How To Check Disabled Audits Using Policy Based Management - Database Tutorials","og_description":"How To Check Disabled Audits Using Policy Based Management","og_url":"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/","og_site_name":"Database Tutorials","article_published_time":"2019-06-17T19:11:58+00:00","article_modified_time":"2019-06-17T19:11:59+00:00","og_image":[{"width":613,"height":375,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-5.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Check Disabled Audits Using Policy Based Management","datePublished":"2019-06-17T19:11:58+00:00","dateModified":"2019-06-17T19:11:59+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/"},"wordCount":764,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-5.png","keywords":["check disabled audits","Check status","enable and disable the Audit in SQL Server","how to check audit disabled","How to check audit status","is audir disabled","sql server auditing best practices"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/","url":"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/","name":"How To Check Disabled Audits Using Policy Based Management - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-5.png","datePublished":"2019-06-17T19:11:58+00:00","dateModified":"2019-06-17T19:11:59+00:00","description":"How To Check Disabled Audits Using Policy Based Management","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-5.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-5.png","width":613,"height":375},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/17\/how-to-check-disabled-audits-using-policy-based-management\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Check Disabled Audits Using Policy Based Management"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=12504"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12504\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/12526"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=12504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=12504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=12504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}