html_output<\/td> Folder<\/td> –<\/td> Will contain the report audit produced.<\/td> It stores HTML reports.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nWhat does it look like ?<\/strong><\/p>\n\n\n\nHow does it work ?<\/strong><\/p>\n\n\n\nImplementation<\/h2>\n\n\n\n Code – A basic implementation :<\/p>\n\n\n\n
dbi-audit-config.json :<\/p>\n\n\n\n
[\n\t{\n\t\t\"Name\": \"app.computername\",\n\t\t\"Value\": [\n\t\t\t\t\t \"WS-2022-A\",\n \"ad\"\n\t\t\t\t ],\n\t\t\"Description\": \"List of Windows Servers that Windows-based tests will run against\"\n\t},\n\t{\n\t\t\"Name\": \"app.sqlinstance\",\n\t\t\"Value\": [\n\t\t\t\t\t \"WS-2022-A\\\\INSTANCEA,1433\"\n\t\t\t\t ],\n\t\t\"Description\": \"List of SQL Server instances that SQL-based tests will run against\"\n\t},\n\t{\n\t\t\"Name\": \"dbi-app.checkcomputersinformation.enabled\",\n\t\t\"Value\": \"True\",\n\t\t\"Description\": \"Get some information on OS level\"\n\t},\n\t{\n\t\t\"Name\": \"dbi-app.checkoperatingsystem.enabled\",\n\t\t\"Value\": \"True\",\n\t\t\"Description\": \"Perform some OS checks\"\n\t},\n\t{\n\t\t\"Name\": \"dbi-app.checksqlsystemconfiguration.enabled\",\n\t\t\"Value\": \"True\",\n\t\t\"Description\": \"Check some SQL Server system settings\"\n\t}\n]<\/code><\/pre>\n\n\n\ndbi-audit-controls-library.ps1 :<\/p>\n\n\n\n
#We import our configuration\n$AuditConfig = [PSCustomObject](Get-Content .\\dbi-audit-config.json | Out-String | ConvertFrom-Json)\n\n#We retrieve the values contained in our json file. Each value is stored in a variable\n$Computers = $AuditConfig | Where-Object { $_.Name -eq 'dbi-app.computername' } | Select-Object Value\n$SQLInstances = $AuditConfig | Where-Object { $_.Name -eq 'dbi-app.sqlinstance' } | Select-Object Value\n$UnitFileSize = ($AuditConfig | Where-Object { $_.Name -eq 'app.unitfilesize' } | Select-Object Value).Value\n\n#Our configuration file allow to enable or disable some checks. We also retrieve those values.\n$EnableCheckComputersInformation = ($AuditConfig | Where-Object { $_.Name -eq 'dbi-app.checkcomputersinformation.enabled' } | Select-Object Value).Value\n$EnableCheckOperatingSystem = ($AuditConfig | Where-Object { $_.Name -eq 'dbi-app.checkoperatingsystem.enabled' } | Select-Object Value).Value\n$EnableCheckSQLSystemConfiguration = ($AuditConfig | Where-Object { $_.Name -eq 'dbi-app.checksqlsystemconfiguration.enabled' } | Select-Object Value).Value\n\n#Used to invoke command queries\n$ComputersList = @()\n$ComputersList += $Computers | Foreach-Object {\n $_.Value \n}\n\n\nfunction Get-ComputersInformation()\n{\n if ($EnableCheckComputersInformation -eq $True)\n { \n $ComputersInformationList = @()\n $ComputersInformationList += $Computers | Foreach-Object { \n Get-DbaComputerSystem -ComputerName $_.Value | \n Select-Object ComputerName, Domain, NumberLogicalProcessors, \n NumberProcessors, TotalPhysicalMemory\n }\n }\n \n return $ComputersInformationList\n}\n\n\nfunction Get-OperatingSystem()\n{\n if ($EnableCheckOperatingSystem -eq $True)\n { \n $OperatingSystemList = @()\n $OperatingSystemList += $Computers | Foreach-Object {\n Get-DbaOperatingSystem -ComputerName $_.Value | \n Select-Object ComputerName, Architecture, OSVersion, ActivePowerPlan\n }\n }\n\n return $OperatingSystemList\n}\n\n\nfunction Get-OSDiskSpace()\n{\n if ($EnableCheckOSDiskSpace -eq $True)\n { \n $OSDiskSpaceList = @()\n $OSDiskSpaceList += $Computers | Foreach-Object {\n Get-DbaDiskSpace -ComputerName $_.Value -Unit $UnitFileSize | \n Select-Object ComputerName, Name, Label, Capacity, Free, PercentFree, BlockSize, FileSystem\n }\n }\n \n return $OSDiskSpaceList\n}\n\n\nfunction Get-SQLServerServiceState()\n{\n if ($EnableCheckSQLServerServiceState -eq $True)\n {\n $SQLServerServiceStateList = @()\n $SQLServerServiceStateList += $Computers | Foreach-Object {\n Get-DbaService -ComputerName $_.Value | \n Select-Object ComputerName, ServiceName, ServiceType, DisplayName, StartName, State, StartMode\n }\n }\n\n return $SQLServerServiceStateList\n}\n<\/code><\/pre>\n\n\n\ndbi-audit-main.ps1 :<\/p>\n\n\n\n
. .\\dbi-audit-controls-library.ps1\n\n$HTMLHeader = '<!DOCTYPE html><head><meta charset=\"utf-8\"\/><link href=\"..\\dbi-audit-style.css\" rel=\"stylesheet\"><\/head><body><div id=\"sidebar\"><\/div>'\n$HTMLFooter = \"<\/body><\/html>\"\n\n$HeaderMapping = @{\n ComputersInformation = \"Computers Information\"\n OperatingSystem = \"Operation System Information\"\n OSDiskSpace = \"Disk Space Information\"\n SQLServerServiceState = \"SQL Server Services State\"\n}\n\n$Checks = [ordered] @{}\n$Checks['ComputersInformation'] = Get-ComputersInformation\n$Checks['OperatingSystem'] = Get-OperatingSystem\n$Checks['OSDiskSpace'] = Get-OSDiskSpace\n$Checks['SQLServerServiceState'] = Get-SQLServerServiceState\n\n$Output = ''\n\n$Checks.Keys | ForEach-Object {\n \n $TitleSection = $HeaderMapping[$_]\n $Output += $Checks[$_] | ConvertTo-HTML -Pre \"<div class=`\"$_`\">\" -Post \"<\/div>\" -Property * -Fragment\n $Output = $Output -replace \"(?s)<colgroup>.*?<\/colgroup>\", \"<h2>$TitleSection<\/h2>\" \n $Output = $Output -Replace '<td>Stopped','<td class=\"control_failed\">Stopped'\n $Output = $Output -Replace '<td>Running','<td class=\"control_passed\">Running'\n $Output = $Output -Replace '<td>Balanced','<td class=\"control_failed\">Balanced'\n $Output = $Output -Replace '<td>High performance','<td class=\"control_passed\">High performance'\n}\n\n$HTML = $HTMLHeader + $Output + $HTMLFooter\n$HTML | Out-File \".\\html_output\\dbi-audit.html\" -Encoding utf8<\/code><\/pre>\n\n\n\n<\/p>\n\n\n\n
dbi-audit-style.css :<\/p>\n\n\n\n
th,\ntd {\n border: 1px solid rgb(160 160 160);\n padding: 8px 10px;\n}\n\nth[scope='col'] {\n background-color: #505050;\n color: #fff;\n}\n\nth[scope='row'] {\n background-color: #d6ecd4;\n}\n\ntd {\n text-align: center;\n}\n\ntr:nth-of-type(even) {\n background-color: #eee;\n}\n\ntable {\n border-collapse: collapse;\n border: 2px solid rgb(140 140 140);\n font-family: sans-serif;\n font-size: 0.8rem;\n letter-spacing: 1px;\n -moz-box-shadow: 0 0 3px #888;\n -webkit-box-shadow: 0 0 5px#888;\n box-shadow: rgba(50, 50, 93, 0.25) 0px 2px 5px -1px, rgba(0, 0, 0, 0.3) 0px 1px 3px -1px;\n}\n\ntr .control_failed {\n\tcolor: #F7F7F7;\n\tbackground-color: #BE4025;\n}\n\ntr .control_passed {\n\tcolor: #F7F7F7;\n\tbackground-color: #16BA00;\n}\n\ncaption {\n caption-side: bottom;\n padding: 10px;\n}\n\nhtml {\n padding:0;\n margin:0;\n}\n\nbody {\n\tbackground-color:#fbfbfb;\n margin:0;\n padding: 0;\n}\n\nh2 {\n\tfont-family: \"Gill Sans\", sans-serif;\n text-shadow: 2px 2px 2px #c9c9c9;\t\n}\n\n#sidebar {\n float:left;\n background-color:#ffa733;\n width:4%;\n margin-right:20px; \n height:100vh;\n box-shadow: 5px 10px #154c79;\n}\n\n#sidebar .dbi_audit {\n display: inline-block;\n transform: rotate(-90deg);\n transform-origin: top left;\n}<\/code><\/pre>\n\n\n\nHow does it run ?<\/p>\n\n\n\n
.\\dbi-audit-main.ps1<\/code><\/pre>\n\n\n\nOutput (what does it really look like ?) :<\/p>\n\n\n\nNice to have<\/h2>\n\n\n\n Let’s say I would like to add new checks. How would I proceed ?<\/strong><\/p>\n\n\n\n\nEdit the dbi-audit-config.json and add your check<\/li>\n\n\n\n Edit the dbi-audit-checks.ps1<\/li>\n\n\n\n Retrieve the information related to your check<\/li>\n<\/ul>\n\n\n\n$EnableCheckSQLDatabaseQueryStore = ($AuditConfig | Where-Object { $_.Name -eq 'app.checksqldatabasequerystore.enabled' } | Select-Object Value).Value<\/code><\/pre>\n\n\n\n\nAdd another function<\/li>\n<\/ul>\n\n\n\nfunction Get-SQLDatabaseQueryStore()\n{\n if ($EnableCheckSQLDatabaseQueryStore -eq $True)\n {\n $SQLDatabaseQueryStoreList = @()\n $SQLDatabaseQueryStoreList += $SQLInstances | Foreach-Object {\n Test-DbaDbQueryStore -SqlInstance $_.Value | \n Where-Object { $_.Name -eq 'ActualState' -and $_.Database -ne 'master' -and $_.Database -ne 'msdb' -and $_.Database -ne 'model' -and $_.Database -ne 'tempdb' } | \n Select-Object ComputerName, SQLInstance, Database, Value\n }\n }\n\n return $SQLDatabaseQueryStoreList\n}<\/code><\/pre>\n\n\n\n\nCall it in the dbi-audit-main.ps1 script<\/li>\n<\/ul>\n\n\n\n$HeaderMapping = @{\n ComputersInformation = \"Computers Information\"\n OperatingSystem = \"Operation System Information\"\n OSDiskSpace = \"Disk Space Information\"\n SQLServerServiceState = \"SQL Server Services State\"\n SQLDatabaseQueryStore = \"Query Store\"\n}\n\n$Checks = [ordered] @{}\n$Checks['ComputersInformation'] = Get-ComputersInformation\n$Checks['OperatingSystem'] = Get-OperatingSystem\n$Checks['OSDiskSpace'] = Get-OSDiskSpace\n$Checks['SQLServerServiceState'] = Get-SQLServerServiceState\n$Checks['SQLDatabaseQueryStore'] = Get-SQLDatabaseQueryStore<\/code><\/pre>\n\n\n\nEnd result :<\/strong><\/p>\n\n\n\nWhat about sending the report through email ?<\/strong><\/p>\n\n\n\n\nWe could add a function that send an email with an attachment.\n\nEdit the dbi-audit-controls-library file\n\nAdd a function Send-EmailWithAuditReport<\/li>\n\n\n\n Add this piece of code to the function :<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\nSend-MailMessage -SmtpServer mysmtpserver -From 'Sender' -To 'Recipient' -Subject 'Audit report' -Body 'Audit report' -Port 25 -Attachments $Attachments<\/code><\/pre>\n\n\n\n\nEdit the dbi-audit-main.ps1<\/li>\n\n\n\n Add a call to the Send-EmailWithAuditReport function Send-EmailWithAuditReport -Attachments $Attachments<\/code><\/li>\n<\/ul>\n\n\n\nConclusion<\/h2>\n\n\n\n The main idea of this solution is to be able to use the same functions while applying a different rendering. To achieve this, you would need to change the CSS file.<\/p>\n\n\n\n
This would allow having the same code to perform the following tasks:<\/p>\n\n\n\n
\nAudit<\/li>\n\n\n\n Health check<\/li>\n\n\n\n …<\/li>\n<\/ul>\n\n\n\nThank you, Amine Haloui.<\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction When you are tasked with conducting an audit at a client’s site or on the environment you manage, you might find it necessary to automate the audit process in order to save time. However, it can be challenging to extract information from either the PowerShell console or a text file. Here, the idea would […]<\/p>\n","protected":false},"author":147,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[99],"tags":[1888,3338,3337,51],"type_dbi":[],"class_list":["post-32477","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-dbatools","tag-html","tag-reporting","tag-sql-server"],"acf":[],"yoast_head":"\n
Build SQL Server audit reports with Powershell - dbi Blog<\/title>\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.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Build SQL Server audit reports with Powershell\" \/>\n<meta property=\"og:description\" content=\"Introduction When you are tasked with conducting an audit at a client’s site or on the environment you manage, you might find it necessary to automate the audit process in order to save time. However, it can be challenging to extract information from either the PowerShell console or a text file. Here, the idea would […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-17T09:15:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-19T08:56:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/image.png\" \/>\n<meta name=\"author\" content=\"Amine Haloui\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Amine Haloui\" \/>\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:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/\"},\"author\":{\"name\":\"Amine Haloui\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/221331d69d49c63fca67069b49b813fe\"},\"headline\":\"Build SQL Server audit reports with Powershell\",\"datePublished\":\"2024-04-17T09:15:13+00:00\",\"dateModified\":\"2024-08-19T08:56:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/\"},\"wordCount\":695,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/image.png\",\"keywords\":[\"dbatools\",\"HTML\",\"Reporting\",\"SQL Server\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/\",\"name\":\"Build SQL Server audit reports with Powershell - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/image.png\",\"datePublished\":\"2024-04-17T09:15:13+00:00\",\"dateModified\":\"2024-08-19T08:56:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/221331d69d49c63fca67069b49b813fe\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/image.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/image.png\",\"width\":607,\"height\":161},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Build SQL Server audit reports with Powershell\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/221331d69d49c63fca67069b49b813fe\",\"name\":\"Amine Haloui\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/64707272207cd8d2667aefcb212f3ff5d19a15813da5aad6553f109d1f1afec1?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64707272207cd8d2667aefcb212f3ff5d19a15813da5aad6553f109d1f1afec1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64707272207cd8d2667aefcb212f3ff5d19a15813da5aad6553f109d1f1afec1?s=96&d=mm&r=g\",\"caption\":\"Amine Haloui\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/aminehaloui\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Build SQL Server audit reports with Powershell - dbi Blog","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.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/","og_locale":"en_US","og_type":"article","og_title":"Build SQL Server audit reports with Powershell","og_description":"Introduction When you are tasked with conducting an audit at a client’s site or on the environment you manage, you might find it necessary to automate the audit process in order to save time. However, it can be challenging to extract information from either the PowerShell console or a text file. Here, the idea would […]","og_url":"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/","og_site_name":"dbi Blog","article_published_time":"2024-04-17T09:15:13+00:00","article_modified_time":"2024-08-19T08:56:17+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/image.png","type":"","width":"","height":""}],"author":"Amine Haloui","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Amine Haloui","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/"},"author":{"name":"Amine Haloui","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/221331d69d49c63fca67069b49b813fe"},"headline":"Build SQL Server audit reports with Powershell","datePublished":"2024-04-17T09:15:13+00:00","dateModified":"2024-08-19T08:56:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/"},"wordCount":695,"commentCount":1,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/image.png","keywords":["dbatools","HTML","Reporting","SQL Server"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/","url":"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/","name":"Build SQL Server audit reports with Powershell - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/image.png","datePublished":"2024-04-17T09:15:13+00:00","dateModified":"2024-08-19T08:56:17+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/221331d69d49c63fca67069b49b813fe"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/image.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/image.png","width":607,"height":161},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/build-sql-server-audit-reports-with-powershell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Build SQL Server audit reports with Powershell"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/221331d69d49c63fca67069b49b813fe","name":"Amine Haloui","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/64707272207cd8d2667aefcb212f3ff5d19a15813da5aad6553f109d1f1afec1?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/64707272207cd8d2667aefcb212f3ff5d19a15813da5aad6553f109d1f1afec1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64707272207cd8d2667aefcb212f3ff5d19a15813da5aad6553f109d1f1afec1?s=96&d=mm&r=g","caption":"Amine Haloui"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/aminehaloui\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/32477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/147"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=32477"}],"version-history":[{"count":55,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/32477\/revisions"}],"predecessor-version":[{"id":34553,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/32477\/revisions\/34553"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=32477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=32477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=32477"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=32477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/image.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/workflow_a.jpg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/image-1-1024x650.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/image-3.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/05\/image-4-1024x780.png\")
<\/figure>\n\n\n\n