notebooks/dotNETNotebooks/dbachecks/04-dbachecks-SavingConfigurations.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "005ed3e9-3d1c-4ef2-a8ee-dc18c250ddb4"
   },
   "source": [
    "![First Power Bi](.\\images\\dbachecks-logo.png )\r\n",
    "# dbachecks - Saving Configurations\r\n",
    "\r\n",
    "You can alter the configurations for any check at the command line to ensure that you are running checks that will test what you want.\r\n",
    "\r\n",
    "You will want to save those configurations so that you can pass them to other people or run them using automation.\r\n",
    "\r\n",
    "The process that you will need to follow is \r\n",
    "\r\n",
    "- Create the configuration\r\n",
    "- test the configuration\r\n",
    "- save the configuration with `Export-DbcConfig`\r\n",
    "\r\n",
    "This will create a json file of the configuration which you can save in source control and then you, others in your team or automation can use the configuration with `Import-DbcConfig`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script type=\"text/javascript\">#!javascript\r\n",
       "if ((typeof(requirejs) !==  typeof(Function)) || (typeof(requirejs.config) !== typeof(Function))) { \r\n",
       "    let script = document.createElement(\"script\"); \r\n",
       "    script.setAttribute(\"src\", \"https://cdnjs.cloudflare.com/ajax/libs/require.js/2.3.6/require.min.js\"); \r\n",
       "    script.onload = function(){\r\n",
       "        loadDotnetInteractiveApi();\r\n",
       "    };\r\n",
       "    document.getElementsByTagName(\"head\")[0].appendChild(script); \r\n",
       "}\r\n",
       "else {\r\n",
       "    loadDotnetInteractiveApi();\r\n",
       "}\r\n",
       "\r\n",
       "function loadDotnetInteractiveApi(){\r\n",
       "    let apiRequire = requirejs.config({context:\"dotnet-interactive.27368.63836\",paths:{dotnetInteractive:\"http://localhost:63836/resources/dotnet-interactive\"}});\r\n",
       "    apiRequire(['dotnetInteractive'], \r\n",
       "    function(api) {       \r\n",
       "        api.createDotnetInteractiveClient(\"http://localhost:63836/\", window);\r\n",
       "    },\r\n",
       "    function(error){\r\n",
       "        console.log(error);\r\n",
       "    });\r\n",
       "}</script>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "cd C:\\Users\\mrrob\\OneDrive\\Documents\\GitHub\\dbachecks\n",
    "ipmo .\\dbachecks.psd1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "1f10c372-d687-4ee5-a6cd-da6c18195506"
   },
   "source": [
    "# Excluding and skipping checks\r\n",
    "\r\n",
    "As well as the configuration items that you saw in the simple configuration notebook, which will change the value for a check such as making sure that the database owners are the accounts that you expect, there are other configuration items which enable you to exclude checks, instances or databases from checks, skip parts of checks.\r\n",
    "\r\n",
    "You can see those configurations by running the block below.\r\n",
    "\r\n",
    "When you are creating configurations for saving and sharing, you will find `command.invokedbccheck.excludecheck` and `command.invokedbccheck.excludedatabases` useful.\r\n",
    "\r\n",
    "`command.invokedbccheck.excludecheck` will set the configuration so that any checks specified here will not run. It is best to exclude Groups of checks rather than individual ones here.\r\n",
    "`command.invokedbccheck.excludedatabases` will set the configuration for any databases that you do not wish to run checks against.\r\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "azdata_cell_guid": "77b6428c-768f-4030-8f76-b091afb2f314"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Name                                                                   Value Description\n",
      "----                                                                   ----- -----------\n",
      "agent.failedjob.excludecancelled                                       False Exclude agent jobs wi…\n",
      "command.invokedbccheck.excludecheck                                       {} Invoke-DbcCheck: The …\n",
      "command.invokedbccheck.excludedatabases                                   {} Invoke-DbcCheck: The …\n",
      "database.querystoredisabled.excludedb                                     {} A List of databases t…\n",
      "database.querystoreenabled.excludedb                                      {} A List of databases t…\n",
      "policy.adlogingroup.excludecheck                                             Active Directory Grou…\n",
      "policy.adloginuser.excludecheck                                              Active Directory User…\n",
      "policy.certificateexpiration.excludedb         {master, msdb, model, tempdb} Databases to exclude …\n",
      "policy.database.filegrowthexcludedb                                       {} Databases to exclude …\n",
      "policy.database.maxdopexcludedb                                           {} Database Names that w…\n",
      "policy.database.status.excludeoffline                                     {} Database names that w…\n",
      "policy.database.status.excludereadonly                                    {} Database names that w…\n",
      "policy.database.status.excluderestoring                                   {} Database names that w…\n",
      "policy.instancemaxdop.excludeinstance                                     {} Any Instances to excl…\n",
      "policy.invaliddbowner.excludedb                {master, msdb, model, tempdb} Databases to exclude …\n",
      "policy.recoverymodel.excludedb                              {master, tempdb} Databases to exclude …\n",
      "policy.server.excludeDiskAllocationUnit                                   {} The disks to skip fro…\n",
      "policy.validdbowner.excludedb                  {master, msdb, model, tempdb} Databases to exclude …\n",
      "skip.agent.alert                                                       False Skips the agent alert…\n",
      "skip.agent.lastjobruntime                                              False Skip the last agent j…\n",
      "skip.agent.longrunningjobs                                             False Skip the long running…\n",
      "skip.backup.readonly                                                   False Check read-only datab…\n",
      "skip.backup.testing                                                     True Don't run Test-DbaLas…\n",
      "skip.connection.auth                                                   False Skip the authenticato…\n",
      "skip.connection.ping                                                   False Skip the ping check f…\n",
      "skip.connection.remoting                                               False Skip PowerShell remot…\n",
      "skip.database.filegrowthdisabled                                        True Skip validation of da…\n",
      "skip.database.logfilecounttest                                         False Skip the logfilecount…\n",
      "skip.datafilegrowthdisabled                                             True Skip validation of da…\n",
      "skip.dbcc.datapuritycheck                                              False Skip data purity chec…\n",
      "skip.diffbackuptest                                                    False Skip the Differential…\n",
      "skip.hadr.listener.pingcheck                                           False Skip the HADR listene…\n",
      "skip.hadr.listener.tcpport                                             False Skip the HADR AG List…\n",
      "skip.hadr.replica.tcpport                                              False Skip the HADR Replica…\n",
      "skip.instance.defaulttrace                                             False Skip the default trac…\n",
      "skip.instance.latestbuild                                              False Skip the scan the lat…\n",
      "skip.instance.modeldbgrowth                                            False Skip the model databa…\n",
      "skip.instance.oleautomationproceduresdisabled                          False Skip OLE Automation P…\n",
      "skip.instance.remoteaccessdisabled                                     False Skip the remote acces…\n",
      "skip.instance.scanforstartupproceduresdisabled                         False Skip the scan for sta…\n",
      "skip.logfilecounttest                                                  False Skip the logfilecount…\n",
      "skip.logshiptesting                                                    False Skip the logshipping …\n",
      "skip.security.asymmetrickeysize                                         True Skips the test for th…\n",
      "skip.security.builtinadmin                                              True Skips the scan for BU…\n",
      "skip.security.clrassembliessafe                                         True Skips the scan for CL…\n",
      "skip.security.containedbautoclose                                       True Skips the scan for co…\n",
      "skip.security.ContainedDBSQLAuth                                        True Skips the scan for if…\n",
      "skip.security.engineserviceadmin                                        True Skips the scan for th…\n",
      "skip.security.fulltextserviceadmin                                      True Skips the scan for th…\n",
      "skip.security.guestuserconnect                                          True Skips the scan for gu…\n",
      "skip.security.hideinstance                                              True Skips the scan for if…\n",
      "skip.security.localwindowsgroup                                         True Skips the scan for if…\n",
      "skip.security.loginauditlevelfailed                                     True Skips the scan for if…\n",
      "skip.security.loginauditlevelsuccessful                                 True Skips the scan for if…\n",
      "skip.security.LoginCheckPolicy                                          True Skips the scan for CH…\n",
      "skip.security.LoginMustChange                                           True Skips the scan for ne…\n",
      "skip.security.LoginPasswordExpiration                                   True Skips the scan for pa…\n",
      "skip.security.nonstandardport                                           True Skips the check for w…\n",
      "skip.security.publicrolepermission                                      True Skips the scan for if…\n",
      "skip.security.sadisabled                                                True Skip the check for if…\n",
      "skip.security.saexist                                                   True Skip the check for a …\n",
      "skip.security.sqlagentproxiesnopublicrole                               True Skips the scan for if…\n",
      "skip.security.symmetrickeyencryptionlevel                               True Skips the test for if…\n",
      "skip.tempdb1118                                                        False Don't run test for Tr…\n",
      "skip.tempdbfilecount                                                   False Don't run test for Te…\n",
      "skip.tempdbfilegrowthpercent                                           False Don't run test for Te…\n",
      "skip.tempdbfilesizemax                                                 False Don't run test for Te…\n",
      "skip.tempdbfilesonc                                                    False Don't run test for Te…\n",
      "\n"
     ]
    }
   ],
   "source": [
    "Get-DbcConfig | Where-Object{$_.Name -like '*exclude*' -or $_.Name -like '*skip*'} "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "d7c49093-9e26-4c63-a861-69d85ffbd3ef"
   },
   "source": [
    "# Create a configuration\n",
    "\n",
    "First you will need to create your configuration. \n",
    "\n",
    "## Reset the configuration to default first\n",
    "It is best practice to run `Reset-DbcConfig` before you start to do this to avoid confusion. This will reset all of the configurations to the default values. It will also list all of the configurations and you can see the current (default) values  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "azdata_cell_guid": "0041f1b7-7b78-41f1-88d0-98ae964d4f3d"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Name                                                                                          Value\n",
      "----                                                                                          -----\n",
      "agent.alert.job                                                                               False\n",
      "agent.alert.messageid                                                               {823, 824, 825}\n",
      "agent.alert.notification                                                                       True\n",
      "agent.alert.severity                                                              {16, 17, 18, 19…}\n",
      "agent.databasemailprofile                                                                          \n",
      "agent.dbaoperatoremail                                                                             \n",
      "agent.dbaoperatorname                                                                              \n",
      "agent.failedjob.excludecancelled                                                              False\n",
      "agent.failedjob.since                                                                            30\n",
      "agent.failsafeoperator                                                                             \n",
      "agent.history.maximumhistoryrows                                                               1000\n",
      "agent.history.maximumjobhistoryrows                                                             100\n",
      "agent.lastjobruntime.percentage                                                                  50\n",
      "agent.longrunningjob.percentage                                                                  50\n",
      "agent.validjobowner.name                                                                         sa\n",
      "app.checkrepos                                     …rob\\OneDrive\\Documents\\GitHub\\dbachecks\\checks}\n",
      "app.cluster                                                                                        \n",
      "app.computername                                                                                   \n",
      "app.localapp                                                 C:\\Users\\mrrob\\AppData\\Local\\dbachecks\n",
      "app.maildirectory                                  …rs\\mrrob\\AppData\\Local\\dbachecks\\dbachecks.mail\n",
      "app.sqlcredential                                                                                  \n",
      "app.sqlinstance                                                                                    \n",
      "app.wincredential                                                                                  \n",
      "command.invokedbccheck.excludecheck                                                              {}\n",
      "command.invokedbccheck.excludedatabases                                                          {}\n",
      "database.exists                                                       {master, msdb, tempdb, model}\n",
      "database.querystoredisabled.excludedb                                                            {}\n",
      "database.querystoreenabled.excludedb                                                             {}\n",
      "domain.domaincontroller                                                                            \n",
      "domain.name                                                                                        \n",
      "domain.organizationalunit                                                                          \n",
      "global.notcontactable                                                                            {}\n",
      "mail.failurethreshhold                                                                            0\n",
      "mail.from                                                                                          \n",
      "mail.smtpserver                                                                                    \n",
      "mail.subject                                                                      dbachecks results\n",
      "mail.to                                                                                            \n",
      "ola.JobName.CommandLogCleanup                                                    CommandLog Cleanup\n",
      "ola.JobName.DeleteBackupHistory                                             sp_delete_backuphistory\n",
      "ola.JobName.OutputFileCleanup                                                   Output File Cleanup\n",
      "ola.JobName.PurgeBackupHistory                                                  sp_purge_jobhistory\n",
      "ola.JobName.SystemFull                                     DatabaseBackup - SYSTEM_DATABASES - FULL\n",
      "ola.JobName.SystemIntegrity                               DatabaseIntegrityCheck - SYSTEM_DATABASES\n",
      "ola.JobName.UserDiff                                         DatabaseBackup - USER_DATABASES - DIFF\n",
      "ola.JobName.UserFull                                         DatabaseBackup - USER_DATABASES - FULL\n",
      "ola.JobName.UserIndex                                                IndexOptimize - USER_DATABASES\n",
      "ola.JobName.UserIntegrity                                   DatabaseIntegrityCheck - USER_DATABASES\n",
      "ola.JobName.UserLog                                           DatabaseBackup - USER_DATABASES - Log\n",
      "policy.adlogingroup.excludecheck                                                                   \n",
      "policy.adloginuser.excludecheck                                                                    \n",
      "policy.backup.datadir                                                                              \n",
      "policy.backup.defaultbackupcompression                                                         True\n",
      "policy.backup.diffmaxhours                                                                       25\n",
      "policy.backup.fullmaxdays                                                                         1\n",
      "policy.backup.logdir                                                                               \n",
      "policy.backup.logmaxminutes                                                                      15\n",
      "policy.backup.newdbgraceperiod                                                                    0\n",
      "policy.backup.testserver                                                                           \n",
      "policy.build.behind                                                                                \n",
      "policy.build.warningwindow                                                                        6\n",
      "policy.certificateexpiration.excludedb                                {master, msdb, model, tempdb}\n",
      "policy.certificateexpiration.warningwindow                                                        1\n",
      "policy.connection.authscheme                                                               Kerberos\n",
      "policy.connection.pingcount                                                                       3\n",
      "policy.connection.pingmaxms                                                                      10\n",
      "policy.dacallowed                                                                              True\n",
      "policy.database.autoclose                                                                     False\n",
      "policy.database.autocreatestatistics                                                           True\n",
      "policy.database.autoshrink                                                                    False\n",
      "policy.database.autoupdatestatistics                                                           True\n",
      "policy.database.autoupdatestatisticsasynchronously                                            False\n",
      "policy.database.filebalancetolerance                                                              5\n",
      "policy.database.filegrowthexcludedb                                                              {}\n",
      "policy.database.filegrowthfreespacethreshold                                                     20\n",
      "policy.database.filegrowthtype                                                                   kb\n",
      "policy.database.filegrowthvalue                                                               65535\n",
      "policy.database.logfilecount                                                                      1\n",
      "policy.database.logfilesizecomparison                                                       average\n",
      "policy.database.logfilesizepercentage                                                           100\n",
      "policy.database.maxdop                                                                            0\n",
      "policy.database.maxdopexcludedb                                                                  {}\n",
      "policy.database.maxvlf                                                                          512\n",
      "policy.database.status.excludeoffline                                                            {}\n",
      "policy.database.status.excludereadonly                                                           {}\n",
      "policy.database.status.excluderestoring                                                          {}\n",
      "policy.database.wrongcollation                                                                   {}\n",
      "policy.dbcc.maxdays                                                                               7\n",
      "policy.diskspace.percentfree                                                                     20\n",
      "policy.dump.maxcount                                                                              1\n",
      "policy.errorlog.logcount                                                                         -1\n",
      "policy.errorlog.warningwindow                                                                     2\n",
      "policy.hadr.agtcpport                                                                              \n",
      "policy.hadr.tcpport                                                                            1433\n",
      "policy.identity.usagepercent                                                                     90\n",
      "policy.instance.sqlenginestart                                                            Automatic\n",
      "policy.instance.sqlenginestate                                                              Running\n",
      "policy.instancemaxdop.excludeinstance                                                            {}\n",
      "policy.instancemaxdop.maxdop                                                                      0\n",
      "policy.instancemaxdop.userecommended                                                          False\n",
      "policy.invaliddbowner.excludedb                                       {master, msdb, model, tempdb}\n",
      "policy.invaliddbowner.name                                                                       sa\n",
      "policy.network.latencymaxms                                                                      40\n",
      "policy.ola.CommandLogCleanUp                                                                     30\n",
      "policy.ola.CommandLogenabled                                                                   True\n",
      "policy.ola.CommandLogscheduled                                                                 True\n",
      "policy.ola.database                                                                          master\n",
      "policy.ola.DeleteBackupHistoryCleanUp                                                            30\n",
      "policy.ola.DeleteBackupHistoryenabled                                                          True\n",
      "policy.ola.DeleteBackupHistoryscheduled                                                        True\n",
      "policy.ola.installed                                                                           True\n",
      "policy.ola.OutputFileCleanUp                                                                     30\n",
      "policy.ola.OutputFileCleanupenabled                                                            True\n",
      "policy.ola.OutputFileCleanupscheduled                                                          True\n",
      "policy.ola.PurgeJobHistoryCleanUp                                                                30\n",
      "policy.ola.PurgeJobHistoryenabled                                                              True\n",
      "policy.ola.PurgeJobHistoryscheduled                                                            True\n",
      "policy.ola.systemfullenabled                                                                   True\n",
      "policy.ola.systemfullretention                                                                  192\n",
      "policy.ola.systemfullscheduled                                                                 True\n",
      "policy.ola.SystemIntegrityCheckenabled                                                         True\n",
      "policy.ola.SystemIntegrityCheckscheduled                                                       True\n",
      "policy.ola.userdiffenabled                                                                     True\n",
      "policy.ola.userdiffretention                                                                    192\n",
      "policy.ola.userdiffscheduled                                                                   True\n",
      "policy.ola.userfullenabled                                                                     True\n",
      "policy.ola.userfullretention                                                                    192\n",
      "policy.ola.userfullscheduled                                                                   True\n",
      "policy.ola.UserIndexOptimizeenabled                                                            True\n",
      "policy.ola.UserIndexOptimizescheduled                                                          True\n",
      "policy.ola.UserIntegrityCheckenabled                                                           True\n",
      "policy.ola.UserIntegrityCheckscheduled                                                         True\n",
      "policy.ola.userlogenabled                                                                      True\n",
      "policy.ola.userlogretention                                                                     192\n",
      "policy.ola.userlogscheduled                                                                    True\n",
      "policy.oleautomation                                                                          False\n",
      "policy.pageverify                                                                          Checksum\n",
      "policy.recoverymodel.excludedb                                                     {master, tempdb}\n",
      "policy.recoverymodel.type                                                                      Full\n",
      "policy.security.adhocdistributedqueriesenabled                                                False\n",
      "policy.security.clrenabled                                                                    False\n",
      "policy.security.containedbautoclose                                                           False\n",
      "policy.security.crossdbownershipchaining                                                      False\n",
      "policy.security.databasemailenabled                                                           False\n",
      "policy.security.latestbuild                                                                    True\n",
      "policy.security.oleautomationproceduresdisabled                                                True\n",
      "policy.security.remoteaccessdisabled                                                              0\n",
      "policy.security.scanforstartupproceduresdisabled                                               True\n",
      "policy.security.xpcmdshelldisabled                                                             True\n",
      "policy.server.cpuprioritisation                                                                True\n",
      "policy.server.excludeDiskAllocationUnit                                                          {}\n",
      "policy.storage.backuppath                                                                          \n",
      "policy.traceflags.expected                                                                       {}\n",
      "policy.traceflags.notexpected                                                                    {}\n",
      "policy.twodigityearcutoff                                                                      2049\n",
      "policy.validdbowner.excludedb                                         {master, msdb, model, tempdb}\n",
      "policy.validdbowner.name                                                                         sa\n",
      "policy.whoisactive.database                                                                  master\n",
      "policy.xevent.requiredrunningsession                                                               \n",
      "policy.xevent.requiredstoppedsession                                                               \n",
      "policy.xevent.validrunningsession                                                                  \n",
      "skip.agent.alert                                                                              False\n",
      "skip.agent.lastjobruntime                                                                     False\n",
      "skip.agent.longrunningjobs                                                                    False\n",
      "skip.backup.readonly                                                                          False\n",
      "skip.backup.testing                                                                            True\n",
      "skip.connection.auth                                                                          False\n",
      "skip.connection.ping                                                                          False\n",
      "skip.connection.remoting                                                                      False\n",
      "skip.database.filegrowthdisabled                                                               True\n",
      "skip.database.logfilecounttest                                                                False\n",
      "skip.datafilegrowthdisabled                                                                    True\n",
      "skip.dbcc.datapuritycheck                                                                     False\n",
      "skip.diffbackuptest                                                                           False\n",
      "skip.hadr.listener.pingcheck                                                                  False\n",
      "skip.hadr.listener.tcpport                                                                    False\n",
      "skip.hadr.replica.tcpport                                                                     False\n",
      "skip.instance.defaulttrace                                                                    False\n",
      "skip.instance.latestbuild                                                                     False\n",
      "skip.instance.modeldbgrowth                                                                   False\n",
      "skip.instance.oleautomationproceduresdisabled                                                 False\n",
      "skip.instance.remoteaccessdisabled                                                            False\n",
      "skip.instance.scanforstartupproceduresdisabled                                                False\n",
      "skip.logfilecounttest                                                                         False\n",
      "skip.logshiptesting                                                                           False\n",
      "skip.security.agentserviceadmin                                                                True\n",
      "skip.security.asymmetrickeysize                                                                True\n",
      "skip.security.builtinadmin                                                                     True\n",
      "skip.security.clrassembliessafe                                                                True\n",
      "skip.security.containedbautoclose                                                              True\n",
      "skip.security.ContainedDBSQLAuth                                                               True\n",
      "skip.security.engineserviceadmin                                                               True\n",
      "skip.security.fulltextserviceadmin                                                             True\n",
      "skip.security.guestuserconnect                                                                 True\n",
      "skip.security.hideinstance                                                                     True\n",
      "skip.security.localwindowsgroup                                                                True\n",
      "skip.security.loginauditlevelfailed                                                            True\n",
      "skip.security.loginauditlevelsuccessful                                                        True\n",
      "skip.security.LoginCheckPolicy                                                                 True\n",
      "skip.security.LoginMustChange                                                                  True\n",
      "skip.security.LoginPasswordExpiration                                                          True\n",
      "skip.security.nonstandardport                                                                  True\n",
      "skip.security.publicrolepermission                                                             True\n",
      "skip.security.sadisabled                                                                       True\n",
      "skip.security.saexist                                                                          True\n",
      "skip.security.sqlagentproxiesnopublicrole                                                      True\n",
      "skip.security.symmetrickeyencryptionlevel                                                      True\n",
      "skip.tempdb1118                                                                               False\n",
      "skip.tempdbfilecount                                                                          False\n",
      "skip.tempdbfilegrowthpercent                                                                  False\n",
      "skip.tempdbfilesizemax                                                                        False\n",
      "skip.tempdbfilesonc                                                                           False\n",
      "testing.integration.instance                                                            {localhost}\n",
      "\n"
     ]
    }
   ],
   "source": [
    "Reset-DbcConfig"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "7b634ca0-3555-4ad0-90b1-f6d663368d2d"
   },
   "source": [
    "## Morning Checks Configuration\r\n",
    "\r\n",
    "Lets create a configuration for some morning checks for our Production estate. You will\r\n",
    "\r\n",
    "- Check the production instances (we only have two in this demo) 'localhost,15592','localhost,15593'\r\n",
    "- Ensure the instance is available and the connection authentication scheme is SQL (because we are using SQL Auth) but don't check PSRemoting\r\n",
    "- Ensure that all agent jobs have succeeded\r\n",
    "- All databases have backups that meet RPO/RTO\r\n",
    "- There are no errors in the Error Logs in the last 24 hours\r\n",
    "- The disk space is not less than 10% free\r\n",
    "- There are no Memory Dumps\r\n",
    "- The last duration of the agent jobs was not more than 10% of the average run time including any currently running jobs\r\n",
    "- The log file sizes are less than 50% of the data file sizes\r\n",
    "- That databases have more than 10% free space available\r\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "azdata_cell_guid": "e72f1c7e-5128-4eb1-bca6-a0eecb06efdb"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Name                                  Value                              Description\n",
      "----                                  -----                              -----------\n",
      "app.sqlinstance                       {localhost,15592, localhost,15593} List of SQL Server instan…\n",
      "app.computername                      {localhost,15592, localhost,15593} List of Windows Servers t…\n",
      "policy.connection.authscheme          SQL                                Auth requirement (Kerbero…\n",
      "skip.connection.remoting              True                               Skip PowerShell remoting …\n",
      "policy.backup.fullmaxdays             7                                  Maximum number of days be…\n",
      "policy.backup.diffmaxhours            24                                 Maximum number of hours b…\n",
      "policy.backup.logmaxminutes           15                                 Maximum number of minutes…\n",
      "policy.diskspace.percentfree          10                                 Percent disk free\n",
      "policy.dump.maxcount                  1                                  Maximum number of expecte…\n",
      "agent.lastjobruntime.percentage       10                                 The maximum percentage va…\n",
      "agent.longrunningjob.percentage       10                                 The maximum percentage va…\n",
      "policy.database.logfilesizecomparison Average                            How to compare data and l…\n",
      "policy.database.logfilesizepercentage 50                                 Maximum percentage of Dat…\n",
      "policy.database.filegrowthfreespacet… 10                                 Integer representing perc…\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Set the instances and computernames to run the check against\r\n",
    "Set-DbcConfig -Name app.sqlinstance -Value 'localhost,15592','localhost,15593'\r\n",
    "Set-DbcConfig -Name app.computername -Value 'localhost,15592','localhost,15593'\r\n",
    "# Set the auth scheme to SQL as we are using SQL Auth\r\n",
    "Set-DbcConfig -Name policy.connection.authscheme -Value SQL\r\n",
    "# Don't check the PSRemoting\r\n",
    "Set-DbcConfig -Name skip.connection.remoting -Value $true\r\n",
    "# Set expected backup - 7 days for full - 24 hours for diff - 15 minutes for log\r\n",
    "Set-DbcConfig -Name policy.backup.fullmaxdays -Value 7\r\n",
    "Set-DbcConfig -Name policy.backup.diffmaxhours -Value 24\r\n",
    "Set-DbcConfig -Name policy.backup.logmaxminutes -Value 15\r\n",
    "# Set config for disk space\r\n",
    "Set-DbcConfig -Name policy.diskspace.percentfree -Value 10\r\n",
    "# Maximum number of memory dumps\r\n",
    "Set-DbcConfig -Name policy.dump.maxcount -Value 1\r\n",
    "# Set config for job run times\r\n",
    "Set-DbcConfig -Name agent.lastjobruntime.percentage -Value 10\r\n",
    "Set-DbcConfig -Name agent.longrunningjob.percentage -Value 10\r\n",
    "# Set max size of log files compared to data file size\r\n",
    "Set-DbcConfig -Name policy.database.logfilesizecomparison -Value Average\r\n",
    "Set-DbcConfig -Name policy.database.logfilesizepercentage -Value 50\r\n",
    "# Set config to ensure files have more than 10% free\r\n",
    "Set-DbcConfig -Name policy.database.filegrowthfreespacethreshold -Value 10"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "740713a3-70cb-4b41-af15-26a6e5c62a8b"
   },
   "source": [
    "# Examining the current configuration and saving it\r\n",
    "\r\n",
    "When you set the configuration, the output shows the cuurently configured values for the configuration items that you have changed.\r\n",
    "\r\n",
    "You can examine the complete current configuration with `Get-DbcConfig`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "azdata_cell_guid": "810539c5-a5d0-4bb9-94fc-225ce835a608"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Name                                                                                          Value\n",
      "----                                                                                          -----\n",
      "agent.alert.Job                                                                               False\n",
      "agent.alert.messageid                                                               {823, 824, 825}\n",
      "agent.alert.Notification                                                                       True\n",
      "agent.alert.Severity                                                              {16, 17, 18, 19…}\n",
      "agent.databasemailprofile                                                                          \n",
      "agent.dbaoperatoremail                                                                             \n",
      "agent.dbaoperatorname                                                                              \n",
      "agent.failedjob.excludecancelled                                                              False\n",
      "agent.failedjob.since                                                                            30\n",
      "agent.failsafeoperator                                                                             \n",
      "agent.history.maximumhistoryrows                                                               1000\n",
      "agent.history.maximumjobhistoryrows                                                             100\n",
      "agent.lastjobruntime.percentage                                                                  10\n",
      "agent.longrunningjob.percentage                                                                  10\n",
      "agent.validjobowner.name                                                                         sa\n",
      "app.checkrepos                                     …nts\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks}\n",
      "app.cluster                                                                                        \n",
      "app.computername                                                 {localhost,15592, localhost,15593}\n",
      "app.localapp                                                 C:\\Users\\mrrob\\AppData\\Local\\dbachecks\n",
      "app.maildirectory                                  …rs\\mrrob\\AppData\\Local\\dbachecks\\dbachecks.mail\n",
      "app.sqlcredential                                                                                  \n",
      "app.sqlinstance                                                  {localhost,15592, localhost,15593}\n",
      "app.wincredential                                                                                  \n",
      "command.invokedbccheck.excludecheck                                                              {}\n",
      "command.invokedbccheck.excludedatabases                                                          {}\n",
      "database.exists                                                       {master, msdb, tempdb, model}\n",
      "database.querystoredisabled.excludedb                                                            {}\n",
      "database.querystoreenabled.excludedb                                                             {}\n",
      "domain.domaincontroller                                                                            \n",
      "domain.name                                                                                        \n",
      "domain.organizationalunit                                                                          \n",
      "global.notcontactable                                                                            {}\n",
      "mail.failurethreshhold                                                                            0\n",
      "mail.from                                                                                          \n",
      "mail.smtpserver                                                                                    \n",
      "mail.subject                                                                      dbachecks results\n",
      "mail.to                                                                                            \n",
      "ola.JobName.CommandLogCleanup                                                    CommandLog Cleanup\n",
      "ola.JobName.DeleteBackupHistory                                             sp_delete_backuphistory\n",
      "ola.JobName.OutputFileCleanup                                                   Output File Cleanup\n",
      "ola.JobName.PurgeBackupHistory                                                  sp_purge_jobhistory\n",
      "ola.JobName.SystemFull                                     DatabaseBackup - SYSTEM_DATABASES - FULL\n",
      "ola.JobName.SystemIntegrity                               DatabaseIntegrityCheck - SYSTEM_DATABASES\n",
      "ola.JobName.UserDiff                                         DatabaseBackup - USER_DATABASES - DIFF\n",
      "ola.JobName.UserFull                                         DatabaseBackup - USER_DATABASES - FULL\n",
      "ola.JobName.UserIndex                                                IndexOptimize - USER_DATABASES\n",
      "ola.JobName.UserIntegrity                                   DatabaseIntegrityCheck - USER_DATABASES\n",
      "ola.JobName.UserLog                                           DatabaseBackup - USER_DATABASES - Log\n",
      "policy.adlogingroup.excludecheck                                                                   \n",
      "policy.adloginuser.excludecheck                                                                    \n",
      "policy.backup.datadir                                                                              \n",
      "policy.backup.defaultbackupcompression                                                         True\n",
      "policy.backup.diffmaxhours                                                                       24\n",
      "policy.backup.fullmaxdays                                                                         7\n",
      "policy.backup.logdir                                                                               \n",
      "policy.backup.logmaxminutes                                                                      15\n",
      "policy.backup.newdbgraceperiod                                                                    0\n",
      "policy.backup.testserver                                                                           \n",
      "policy.build.behind                                                                                \n",
      "policy.build.warningwindow                                                                        6\n",
      "policy.certificateexpiration.excludedb                                {master, msdb, model, tempdb}\n",
      "policy.certificateexpiration.warningwindow                                                        1\n",
      "policy.connection.authscheme                                                                    SQL\n",
      "policy.connection.pingcount                                                                       3\n",
      "policy.connection.pingmaxms                                                                      10\n",
      "policy.dacallowed                                                                              True\n",
      "policy.database.autoclose                                                                     False\n",
      "policy.database.autocreatestatistics                                                           True\n",
      "policy.database.autoshrink                                                                    False\n",
      "policy.database.autoupdatestatistics                                                           True\n",
      "policy.database.autoupdatestatisticsasynchronously                                            False\n",
      "policy.database.filebalancetolerance                                                              5\n",
      "policy.database.filegrowthexcludedb                                                              {}\n",
      "policy.database.filegrowthfreespacethreshold                                                     10\n",
      "policy.database.filegrowthtype                                                                   kb\n",
      "policy.database.filegrowthvalue                                                               65535\n",
      "policy.database.logfilecount                                                                      1\n",
      "policy.database.logfilesizecomparison                                                       Average\n",
      "policy.database.logfilesizepercentage                                                            50\n",
      "policy.database.maxdop                                                                            0\n",
      "policy.database.maxdopexcludedb                                                                  {}\n",
      "policy.database.maxvlf                                                                          512\n",
      "policy.database.status.excludeoffline                                                            {}\n",
      "policy.database.status.excludereadonly                                                           {}\n",
      "policy.database.status.excluderestoring                                                          {}\n",
      "policy.database.wrongcollation                                                                   {}\n",
      "policy.dbcc.maxdays                                                                               7\n",
      "policy.diskspace.percentfree                                                                     10\n",
      "policy.dump.maxcount                                                                              1\n",
      "policy.errorlog.logcount                                                                         -1\n",
      "policy.errorlog.warningwindow                                                                     2\n",
      "policy.hadr.agtcpport                                                                              \n",
      "policy.hadr.tcpport                                                                            1433\n",
      "policy.identity.usagepercent                                                                     90\n",
      "policy.instance.sqlenginestart                                                            Automatic\n",
      "policy.instance.sqlenginestate                                                              Running\n",
      "policy.instancemaxdop.excludeinstance                                                            {}\n",
      "policy.instancemaxdop.maxdop                                                                      0\n",
      "policy.instancemaxdop.userecommended                                                          False\n",
      "policy.invaliddbowner.excludedb                                       {master, msdb, model, tempdb}\n",
      "policy.invaliddbowner.name                                                                       sa\n",
      "policy.network.latencymaxms                                                                      40\n",
      "policy.ola.CommandLogCleanUp                                                                     30\n",
      "policy.ola.CommandLogenabled                                                                   True\n",
      "policy.ola.CommandLogscheduled                                                                 True\n",
      "policy.ola.database                                                                          master\n",
      "policy.ola.DeleteBackupHistoryCleanUp                                                            30\n",
      "policy.ola.DeleteBackupHistoryenabled                                                          True\n",
      "policy.ola.DeleteBackupHistoryscheduled                                                        True\n",
      "policy.ola.installed                                                                           True\n",
      "policy.ola.OutputFileCleanUp                                                                     30\n",
      "policy.ola.OutputFileCleanupenabled                                                            True\n",
      "policy.ola.OutputFileCleanupscheduled                                                          True\n",
      "policy.ola.PurgeJobHistoryCleanUp                                                                30\n",
      "policy.ola.PurgeJobHistoryenabled                                                              True\n",
      "policy.ola.PurgeJobHistoryscheduled                                                            True\n",
      "policy.ola.systemfullenabled                                                                   True\n",
      "policy.ola.systemfullretention                                                                  192\n",
      "policy.ola.systemfullscheduled                                                                 True\n",
      "policy.ola.SystemIntegrityCheckenabled                                                         True\n",
      "policy.ola.SystemIntegrityCheckscheduled                                                       True\n",
      "policy.ola.userdiffenabled                                                                     True\n",
      "policy.ola.userdiffretention                                                                    192\n",
      "policy.ola.userdiffscheduled                                                                   True\n",
      "policy.ola.userfullenabled                                                                     True\n",
      "policy.ola.userfullretention                                                                    192\n",
      "policy.ola.userfullscheduled                                                                   True\n",
      "policy.ola.UserIndexOptimizeenabled                                                            True\n",
      "policy.ola.UserIndexOptimizescheduled                                                          True\n",
      "policy.ola.UserIntegrityCheckenabled                                                           True\n",
      "policy.ola.UserIntegrityCheckscheduled                                                         True\n",
      "policy.ola.userlogenabled                                                                      True\n",
      "policy.ola.userlogretention                                                                     192\n",
      "policy.ola.userlogscheduled                                                                    True\n",
      "policy.oleautomation                                                                          False\n",
      "policy.pageverify                                                                          Checksum\n",
      "policy.recoverymodel.excludedb                                                     {master, tempdb}\n",
      "policy.recoverymodel.type                                                                      Full\n",
      "policy.security.adhocdistributedqueriesenabled                                                False\n",
      "policy.security.clrenabled                                                                    False\n",
      "policy.security.containedbautoclose                                                           False\n",
      "policy.security.crossdbownershipchaining                                                      False\n",
      "policy.security.databasemailenabled                                                           False\n",
      "policy.security.latestbuild                                                                    True\n",
      "policy.security.oleautomationproceduresdisabled                                                True\n",
      "policy.security.remoteaccessdisabled                                                              0\n",
      "policy.security.scanforstartupproceduresdisabled                                               True\n",
      "policy.security.xpcmdshelldisabled                                                             True\n",
      "policy.server.cpuprioritisation                                                                True\n",
      "policy.server.excludeDiskAllocationUnit                                                          {}\n",
      "policy.storage.backuppath                                                                          \n",
      "policy.traceflags.expected                                                                       {}\n",
      "policy.traceflags.notexpected                                                                    {}\n",
      "policy.twodigityearcutoff                                                                      2049\n",
      "policy.validdbowner.excludedb                                         {master, msdb, model, tempdb}\n",
      "policy.validdbowner.name                                                                         sa\n",
      "policy.whoisactive.database                                                                  master\n",
      "policy.xevent.requiredrunningsession                                                               \n",
      "policy.xevent.requiredstoppedsession                                                               \n",
      "policy.xevent.validrunningsession                                                                  \n",
      "skip.agent.alert                                                                              False\n",
      "skip.agent.lastjobruntime                                                                     False\n",
      "skip.agent.longrunningjobs                                                                    False\n",
      "skip.backup.readonly                                                                          False\n",
      "skip.backup.testing                                                                            True\n",
      "skip.connection.auth                                                                          False\n",
      "skip.connection.ping                                                                          False\n",
      "skip.connection.remoting                                                                       True\n",
      "skip.database.filegrowthdisabled                                                               True\n",
      "skip.database.logfilecounttest                                                                False\n",
      "skip.datafilegrowthdisabled                                                                    True\n",
      "skip.dbcc.datapuritycheck                                                                     False\n",
      "skip.diffbackuptest                                                                           False\n",
      "skip.hadr.listener.pingcheck                                                                  False\n",
      "skip.hadr.listener.tcpport                                                                    False\n",
      "skip.hadr.replica.tcpport                                                                     False\n",
      "skip.instance.defaulttrace                                                                    False\n",
      "skip.instance.latestbuild                                                                     False\n",
      "skip.instance.modeldbgrowth                                                                   False\n",
      "skip.instance.oleautomationproceduresdisabled                                                 False\n",
      "skip.instance.remoteaccessdisabled                                                            False\n",
      "skip.instance.scanforstartupproceduresdisabled                                                False\n",
      "skip.logfilecounttest                                                                         False\n",
      "skip.logshiptesting                                                                           False\n",
      "skip.security.asymmetrickeysize                                                                True\n",
      "skip.security.builtinadmin                                                                     True\n",
      "skip.security.clrassembliessafe                                                                True\n",
      "skip.security.containedbautoclose                                                              True\n",
      "skip.security.ContainedDBSQLAuth                                                               True\n",
      "skip.security.engineserviceadmin                                                               True\n",
      "skip.security.fulltextserviceadmin                                                             True\n",
      "skip.security.guestuserconnect                                                                 True\n",
      "skip.security.hideinstance                                                                     True\n",
      "skip.security.localwindowsgroup                                                                True\n",
      "skip.security.loginauditlevelfailed                                                            True\n",
      "skip.security.loginauditlevelsuccessful                                                        True\n",
      "skip.security.LoginCheckPolicy                                                                 True\n",
      "skip.security.LoginMustChange                                                                  True\n",
      "skip.security.LoginPasswordExpiration                                                          True\n",
      "skip.security.nonstandardport                                                                  True\n",
      "skip.security.publicrolepermission                                                             True\n",
      "skip.security.sadisabled                                                                       True\n",
      "skip.security.saexist                                                                          True\n",
      "skip.security.sqlagentproxiesnopublicrole                                                      True\n",
      "skip.security.symmetrickeyencryptionlevel                                                      True\n",
      "skip.tempdb1118                                                                               False\n",
      "skip.tempdbfilecount                                                                          False\n",
      "skip.tempdbfilegrowthpercent                                                                  False\n",
      "skip.tempdbfilesizemax                                                                        False\n",
      "skip.tempdbfilesonc                                                                           False\n",
      "testing.integration.instance                                                            {localhost}\n",
      "\n"
     ]
    }
   ],
   "source": [
    "Get-DbcConfig"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "f68350d3-b173-4e04-ac15-12b376b81bd5"
   },
   "source": [
    "## Saving the configuration to a file for reuse\r\n",
    "\r\n",
    "Once you have a configuration created, you can save it for easy importing into your session or for use with automation. I suggest that the best place for you to save this is in a source control repository so changes can be controlled and auditted\r\n",
    "\r\n",
    "To save the current configuration use `Export-DbcConfig`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "azdata_cell_guid": "edeb1f12-1aa0-4061-89dc-7503d9e54a15",
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[96m[\u001b[0m\u001b[37m13:50:03\u001b[0m\u001b[96m][\u001b[0m\u001b[37mExport-DbcConfig\u001b[0m\u001b[96m] Wrote file to C:\\Users\\mrrob\\Documents\\dbachecks\\Morning-Checks-Production.json\u001b[0m\n"
     ]
    }
   ],
   "source": [
    "$FolderPath = $Env:USERPROFILE + '\\Documents\\dbachecks'\r\n",
    "Export-DbcConfig -Path $FolderPath\\Morning-Checks-Production.json "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "291ade07-0005-4d14-8f83-86b0574282d2"
   },
   "source": [
    "The file that is created is just json, you can take a look at it (and alter it directly if you wish)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "azdata_cell_guid": "66aa7fec-93d0-44ca-bc9f-750f291517e1"
   },
   "outputs": [],
   "source": [
    "azuredatastudio $FolderPath\\Morning-Checks-Production.json "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "30d72dbb-6930-4eb8-a15a-3c3cec4aae84"
   },
   "source": [
    "# Loading the configuration from a file\r\n",
    "\r\n",
    "To use the configuration that you have saved you use `Import-DbcConfig`\r\n",
    "\r\n",
    "This will take the values from the json file and set the configuration accordingly"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "azdata_cell_guid": "1b84b47f-6552-4a52-ad27-a189f6aa2a8e"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Name                                                                                          Value\n",
      "----                                                                                          -----\n",
      "agent.alert.Job                                                                               False\n",
      "agent.alert.messageid                                                               {823, 824, 825}\n",
      "agent.alert.Notification                                                                       True\n",
      "agent.alert.Severity                                                              {16, 17, 18, 19…}\n",
      "agent.databasemailprofile                                                                          \n",
      "agent.dbaoperatoremail                                                                             \n",
      "agent.dbaoperatorname                                                                              \n",
      "agent.failedjob.excludecancelled                                                              False\n",
      "agent.failedjob.since                                                                            30\n",
      "agent.failsafeoperator                                                                             \n",
      "agent.history.maximumhistoryrows                                                               1000\n",
      "agent.history.maximumjobhistoryrows                                                             100\n",
      "agent.lastjobruntime.percentage                                                                  10\n",
      "agent.longrunningjob.percentage                                                                  10\n",
      "agent.validjobowner.name                                                                         sa\n",
      "app.checkrepos                      …rs\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks}\n",
      "app.cluster                                                                                        \n",
      "app.computername                                                 {localhost,15592, localhost,15593}\n",
      "app.localapp                                                 C:\\Users\\mrrob\\AppData\\Local\\dbachecks\n",
      "app.maildirectory                             C:\\Users\\mrrob\\AppData\\Local\\dbachecks\\dbachecks.mail\n",
      "app.sqlcredential                                                                                  \n",
      "app.sqlinstance                                                  {localhost,15592, localhost,15593}\n",
      "app.wincredential                                                                                  \n",
      "command.invokedbccheck.excludecheck                                                              {}\n",
      "command.invokedbccheck.excludedata…                                                              {}\n",
      "database.exists                                                      {master, msdb, tempdb, model…}\n",
      "domain.domaincontroller                                                                            \n",
      "domain.name                                                                                        \n",
      "domain.organizationalunit                                                                          \n",
      "global.notcontactable                                                                            {}\n",
      "mail.failurethreshhold                                                                            0\n",
      "mail.from                                                                                          \n",
      "mail.smtpserver                                                                                    \n",
      "mail.subject                                                                      dbachecks results\n",
      "mail.to                                                                                            \n",
      "ola.JobName.CommandLogCleanup                                                    CommandLog Cleanup\n",
      "ola.JobName.DeleteBackupHistory                                             sp_delete_backuphistory\n",
      "ola.JobName.OutputFileCleanup                                                   Output File Cleanup\n",
      "ola.JobName.PurgeBackupHistory                                                  sp_purge_jobhistory\n",
      "ola.JobName.SystemFull                                     DatabaseBackup - SYSTEM_DATABASES - FULL\n",
      "ola.JobName.SystemIntegrity                               DatabaseIntegrityCheck - SYSTEM_DATABASES\n",
      "ola.JobName.UserDiff                                         DatabaseBackup - USER_DATABASES - DIFF\n",
      "ola.JobName.UserFull                                         DatabaseBackup - USER_DATABASES - FULL\n",
      "ola.JobName.UserIndex                                                IndexOptimize - USER_DATABASES\n",
      "ola.JobName.UserIntegrity                                   DatabaseIntegrityCheck - USER_DATABASES\n",
      "ola.JobName.UserLog                                           DatabaseBackup - USER_DATABASES - Log\n",
      "policy.adlogingroup.excludecheck                                                                   \n",
      "policy.adloginuser.excludecheck                                                                    \n",
      "policy.backup.datadir                                                                              \n",
      "policy.backup.defaultbackupcompres…                                                            True\n",
      "policy.backup.diffmaxhours                                                                       24\n",
      "policy.backup.fullmaxdays                                                                         7\n",
      "policy.backup.logdir                                                                               \n",
      "policy.backup.logmaxminutes                                                                      15\n",
      "policy.backup.newdbgraceperiod                                                                    0\n",
      "policy.backup.testserver                                                                           \n",
      "policy.build.behind                                                                                \n",
      "policy.build.warningwindow                                                                        6\n",
      "policy.certificateexpiration.exclu…                                   {master, msdb, model, tempdb}\n",
      "policy.certificateexpiration.warni…                                                               1\n",
      "policy.connection.authscheme                                                                    SQL\n",
      "policy.connection.pingcount                                                                       3\n",
      "policy.connection.pingmaxms                                                                      10\n",
      "policy.dacallowed                                                                              True\n",
      "policy.database.autoclose                                                                     False\n",
      "policy.database.autocreatestatisti…                                                            True\n",
      "policy.database.autoshrink                                                                    False\n",
      "policy.database.autoupdatestatisti…                                                            True\n",
      "policy.database.autoupdatestatisti…                                                           False\n",
      "policy.database.filebalancetoleran…                                                               5\n",
      "policy.database.filegrowthexcludedb                                                              {}\n",
      "policy.database.filegrowthfreespac…                                                              10\n",
      "policy.database.filegrowthtype                                                                   kb\n",
      "policy.database.filegrowthvalue                                                               65535\n",
      "policy.database.logfilecount                                                                      1\n",
      "policy.database.logfilesizecompari…                                                         Average\n",
      "policy.database.logfilesizepercent…                                                              50\n",
      "policy.database.maxdop                                                                            0\n",
      "policy.database.maxdopexcludedb                                                                  {}\n",
      "policy.database.maxvlf                                                                          512\n",
      "policy.database.status.excludeoffl…                                                              {}\n",
      "policy.database.status.excluderead…                                                              {}\n",
      "policy.database.status.excluderest…                                                              {}\n",
      "policy.database.wrongcollation                                                                   {}\n",
      "policy.dbcc.maxdays                                                                               7\n",
      "policy.diskspace.percentfree                                                                     10\n",
      "policy.dump.maxcount                                                                              1\n",
      "policy.errorlog.logcount                                                                         -1\n",
      "policy.errorlog.warningwindow                                                                     2\n",
      "policy.hadr.tcpport                                                                            1433\n",
      "policy.identity.usagepercent                                                                     90\n",
      "policy.instance.sqlenginestart                                                            Automatic\n",
      "policy.instance.sqlenginestate                                                              Running\n",
      "policy.instancemaxdop.excludeinsta…                                                              {}\n",
      "policy.instancemaxdop.maxdop                                                                      0\n",
      "policy.instancemaxdop.userecommend…                                                           False\n",
      "policy.invaliddbowner.excludedb                                       {master, msdb, model, tempdb}\n",
      "policy.invaliddbowner.name                                                                 sqladmin\n",
      "policy.network.latencymaxms                                                                      40\n",
      "policy.ola.CommandLogCleanUp                                                                     30\n",
      "policy.ola.CommandLogenabled                                                                   True\n",
      "policy.ola.CommandLogscheduled                                                                 True\n",
      "policy.ola.database                                                                          master\n",
      "policy.ola.DeleteBackupHistoryClea…                                                              30\n",
      "policy.ola.DeleteBackupHistoryenab…                                                            True\n",
      "policy.ola.DeleteBackupHistorysche…                                                            True\n",
      "policy.ola.installed                                                                           True\n",
      "policy.ola.OutputFileCleanUp                                                                     30\n",
      "policy.ola.OutputFileCleanupenabled                                                            True\n",
      "policy.ola.OutputFileCleanupschedu…                                                            True\n",
      "policy.ola.PurgeJobHistoryCleanUp                                                                30\n",
      "policy.ola.PurgeJobHistoryenabled                                                              True\n",
      "policy.ola.PurgeJobHistoryscheduled                                                            True\n",
      "policy.ola.systemfullenabled                                                                   True\n",
      "policy.ola.systemfullretention                                                                  192\n",
      "policy.ola.systemfullscheduled                                                                 True\n",
      "policy.ola.SystemIntegrityCheckena…                                                            True\n",
      "policy.ola.SystemIntegrityChecksch…                                                            True\n",
      "policy.ola.userdiffenabled                                                                     True\n",
      "policy.ola.userdiffretention                                                                    192\n",
      "policy.ola.userdiffscheduled                                                                   True\n",
      "policy.ola.userfullenabled                                                                     True\n",
      "policy.ola.userfullretention                                                                    192\n",
      "policy.ola.userfullscheduled                                                                   True\n",
      "policy.ola.UserIndexOptimizeenabled                                                            True\n",
      "policy.ola.UserIndexOptimizeschedu…                                                            True\n",
      "policy.ola.UserIntegrityCheckenabl…                                                            True\n",
      "policy.ola.UserIntegrityChecksched…                                                            True\n",
      "policy.ola.userlogenabled                                                                      True\n",
      "policy.ola.userlogretention                                                                     192\n",
      "policy.ola.userlogscheduled                                                                    True\n",
      "policy.oleautomation                                                                          False\n",
      "policy.pageverify                                                                          Checksum\n",
      "policy.recoverymodel.excludedb                                                     {master, tempdb}\n",
      "policy.recoverymodel.type                                                                      Full\n",
      "policy.security.adhocdistributedqu…                                                           False\n",
      "policy.security.clrenabled                                                                    False\n",
      "policy.security.containedbautoclose                                                           False\n",
      "policy.security.crossdbownershipch…                                                           False\n",
      "policy.security.databasemailenabled                                                           False\n",
      "policy.security.latestbuild                                                                    True\n",
      "policy.security.oleautomationproce…                                                            True\n",
      "policy.security.remoteaccessdisabl…                                                               0\n",
      "policy.security.scanforstartupproc…                                                            True\n",
      "policy.security.xpcmdshelldisabled                                                             True\n",
      "policy.server.cpuprioritisation                                                                True\n",
      "policy.server.excludeDiskAllocatio…                                                              {}\n",
      "policy.storage.backuppath                                                                          \n",
      "policy.traceflags.expected                                                                       {}\n",
      "policy.traceflags.notexpected                                                                    {}\n",
      "policy.twodigityearcutoff                                                                      2049\n",
      "policy.validdbowner.excludedb                                         {master, msdb, model, tempdb}\n",
      "policy.validdbowner.name                                                                   thebeard\n",
      "policy.whoisactive.database                                                                  master\n",
      "policy.xevent.requiredrunningsessi…                                                                \n",
      "policy.xevent.requiredstoppedsessi…                                                                \n",
      "policy.xevent.validrunningsession                                                                  \n",
      "skip.agent.lastjobruntime                                                                     False\n",
      "skip.agent.longrunningjobs                                                                    False\n",
      "skip.backup.readonly                                                                          False\n",
      "skip.backup.testing                                                                            True\n",
      "skip.connection.auth                                                                          False\n",
      "skip.connection.ping                                                                          False\n",
      "skip.connection.remoting                                                                       True\n",
      "skip.database.filegrowthdisabled                                                               True\n",
      "skip.database.logfilecounttest                                                                False\n",
      "skip.datafilegrowthdisabled                                                                    True\n",
      "skip.dbcc.datapuritycheck                                                                     False\n",
      "skip.diffbackuptest                                                                           False\n",
      "skip.hadr.listener.pingcheck                                                                  False\n",
      "skip.instance.defaulttrace                                                                    False\n",
      "skip.instance.latestbuild                                                                     False\n",
      "skip.instance.modeldbgrowth                                                                   False\n",
      "skip.instance.oleautomationprocedu…                                                           False\n",
      "skip.instance.remoteaccessdisabled                                                            False\n",
      "skip.instance.scanforstartupproced…                                                           False\n",
      "skip.logfilecounttest                                                                         False\n",
      "skip.logshiptesting                                                                           False\n",
      "skip.security.asymmetrickeysize                                                                True\n",
      "skip.security.builtinadmin                                                                     True\n",
      "skip.security.containedbautoclose                                                              True\n",
      "skip.security.guestuserconnect                                                                 True\n",
      "skip.security.hideinstance                                                                     True\n",
      "skip.security.localwindowsgroup                                                                True\n",
      "skip.security.loginauditlevelfailed                                                            True\n",
      "skip.security.loginauditlevelsucce…                                                            True\n",
      "skip.security.publicrolepermission                                                             True\n",
      "skip.security.sadisabled                                                                       True\n",
      "skip.security.saexist                                                                          True\n",
      "skip.security.sqlagentproxiesnopub…                                                            True\n",
      "skip.security.symmetrickeyencrypti…                                                            True\n",
      "skip.tempdb1118                                                                               False\n",
      "skip.tempdbfilecount                                                                          False\n",
      "skip.tempdbfilegrowthpercent                                                                  False\n",
      "skip.tempdbfilesizemax                                                                        False\n",
      "skip.tempdbfilesonc                                                                           False\n",
      "testing.integration.instance                                                            {localhost}\n",
      "\n"
     ]
    }
   ],
   "source": [
    "Import-DbcConfig -Path $FolderPath\\Morning-Checks-Production.json "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "3f16422e-b293-4933-9aa3-b994bd5d2c1b"
   },
   "source": [
    "# Run the Checks with that configuration\r\n",
    "\r\n",
    "You can then run the checks with that configuration as usual. You do not need to specify the computer names or Instance names as they are in the configuration already. You will reset the configuration, load the configuration from the file and run the checks\r\n",
    "\r\n",
    "It will take about  30 seconds or so"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "azdata_cell_guid": "c8b83e01-84e6-498c-933c-064c88b680c9"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[97m    ____            __\n",
      "   / __ \\___  _____/ /____  _____\n",
      "  / /_/ / _ \\/ ___/ __/ _ \\/ ___/\n",
      " / ____/  __(__  ) /_/  __/ /\n",
      "/_/    \\___/____/\\__/\\___/_/\n",
      "Pester v4.9.0\n",
      "Executing all tests in 'C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1', 'C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1', 'C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1', 'C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Server.Tests.ps1' with Tags InstanceConnection', 'FailedJob', 'LastBackup', 'ErrorLog', 'DiskCapacity', 'MemoryDump', 'LastJobRunTime', 'LongRunningJob', 'LogfileSize', 'FutureFileGrowth\u001b[0m\n",
      "\n",
      "\u001b[92mExecuting script C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Failed Jobs\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking for failed enabled jobs since 02/19/2020 13:50:50 on localhost,15592\u001b[0m\n",
      "\u001b[32m      [+] CommandLog Cleanup's last run outcome on 69017f5d2a89 is Succeeded\u001b[0m\u001b[90m 63ms\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - SYSTEM_DATABASES - FULL's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 18ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - USER_DATABASES - DIFF's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - USER_DATABASES - FULL's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - USER_DATABASES - LOG's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseIntegrityCheck - SYSTEM_DATABASES's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseIntegrityCheck - USER_DATABASES's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 6ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[32m      [+] IndexOptimize - USER_DATABASES's last run outcome on 69017f5d2a89 is Succeeded\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] sp_delete_backuphistory's last run outcome on 69017f5d2a89 is Succeeded\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] sp_purge_jobhistory's last run outcome on 69017f5d2a89 is Succeeded\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[91m      [-] The Beard is Important's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 7ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Long Running Agent Jobs\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing long running jobs on localhost,15592\u001b[0m\n",
      "\u001b[32m      [+] There are no running jobs currently on localhost,15592\u001b[0m\u001b[90m 20ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Agent Job Run\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last job run time on localhost,15592\u001b[0m\n",
      "\u001b[32m      [+] Job IndexOptimize - USER_DATABASES last run duration should be not be greater than 10 % extra of the average run time on localhost,15592\u001b[0m\u001b[90m 26ms\u001b[0m\n",
      "\u001b[32m      [+] Job DatabaseBackup - SYSTEM_DATABASES - FULL last run duration should be not be greater than 10 % extra of the average run time on localhost,15592\u001b[0m\u001b[90m 7ms\u001b[0m\n",
      "\u001b[32m      [+] Job DatabaseBackup - USER_DATABASES - FULL last run duration should be not be greater than 10 % extra of the average run time on localhost,15592\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[32m      [+] Job DatabaseIntegrityCheck - SYSTEM_DATABASES last run duration should be not be greater than 10 % extra of the average run time on localhost,15592\u001b[0m\u001b[90m 13ms\u001b[0m\n",
      "\u001b[32m      [+] Job DatabaseIntegrityCheck - USER_DATABASES last run duration should be not be greater than 10 % extra of the average run time on localhost,15592\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[32m      [+] Job DatabaseBackup - USER_DATABASES - DIFF last run duration should be not be greater than 10 % extra of the average run time on localhost,15592\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Failed Jobs\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking for failed enabled jobs since 02/19/2020 13:50:52 on localhost,15593\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Long Running Agent Jobs\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing long running jobs on localhost,15593\u001b[0m\n",
      "\u001b[32m      [+] There are no running jobs currently on localhost,15593\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Agent Job Run\u001b[0m\n",
      "\n",
      "\u001b[92mExecuting script C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Full Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last full backups on localhost,15592\u001b[0m\n",
      "\u001b[32m      [+] AdventureWorks2017 full backups on localhost,15592 should be less than 7 days\u001b[0m\u001b[90m 8ms\u001b[0m\n",
      "\u001b[32m      [+] master full backups on localhost,15592 should be less than 7 days\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] model full backups on localhost,15592 should be less than 7 days\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] msdb full backups on localhost,15592 should be less than 7 days\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[32m      [+] Northwind full backups on localhost,15592 should be less than 7 days\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] pubs full backups on localhost,15592 should be less than 7 days\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Diff Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last diff backups on localhost,15592\u001b[0m\n",
      "\u001b[32m      [+] AdventureWorks2017 diff backups on localhost,15592 should be less than 24 hours\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] Northwind diff backups on localhost,15592 should be less than 24 hours\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[32m      [+] pubs diff backups on localhost,15592 should be less than 24 hours\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Log Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last log backups on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Log File Size Checks\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Log File size for localhost,15592\u001b[0m\n",
      "\u001b[32m      [+] AdventureWorks2017 on localhost,15592 Should have no log files larger than 50% of the Average of DataFiles\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[32m      [+] master on localhost,15592 Should have no log files larger than 50% of the Average of DataFiles\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[32m      [+] model on localhost,15592 Should have no log files larger than 50% of the Average of DataFiles\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] msdb on localhost,15592 Should have no log files larger than 50% of the Average of DataFiles\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] Northwind on localhost,15592 Should have no log files larger than 50% of the Average of DataFiles\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\u001b[32m      [+] pubs on localhost,15592 Should have no log files larger than 50% of the Average of DataFiles\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] tempdb on localhost,15592 Should have no log files larger than 50% of the Average of DataFiles\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Future File Growth\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing for files likely to grow soon on localhost,15592\u001b[0m\n",
      "\u001b[32m      [+] AdventureWorks2017 file AdventureWorks2017 on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 16ms\u001b[0m\n",
      "\u001b[32m      [+] AdventureWorks2017 file AdventureWorks2017_log on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[91m      [-] master file master on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 6ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than or equal to 10, because free space within the file should be lower than threshold of 10 %, but got 0.951999999999998.\u001b[0m\n",
      "\u001b[91m        612:                                 $PSItem.PercentFree | Should -BeGreaterOrEqual $threshold -Because \"free space within the file should be lower than threshold of $threshold %\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 612\u001b[0m\n",
      "\u001b[32m      [+] master file mastlog on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] model file modeldev on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\u001b[32m      [+] model file modellog on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m      [-] msdb file MSDBData on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 8ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than or equal to 10, because free space within the file should be lower than threshold of 10 %, but got 1.271.\u001b[0m\n",
      "\u001b[91m        612:                                 $PSItem.PercentFree | Should -BeGreaterOrEqual $threshold -Because \"free space within the file should be lower than threshold of $threshold %\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 612\u001b[0m\n",
      "\u001b[32m      [+] msdb file MSDBLog on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[32m      [+] Northwind file Northwind on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] Northwind file Northwind_log on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[32m      [+] pubs file pubs on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] pubs file pubs_log on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] tempdb file tempdev on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\u001b[32m      [+] tempdb file templog on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] tempdb file tempdev2 on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] tempdb file tempdev3 on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] tempdb file tempdev4 on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Full Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last full backups on localhost,15593\u001b[0m\n",
      "\u001b[91m      [-] AdventureWorks2017 full backups on localhost,15593 should be less than 7 days\u001b[0m\u001b[90m 7ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-13T13:50:58.5882566Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:42:01.0000000Z.\u001b[0m\n",
      "\u001b[91m        463:                         $psitem.LastBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddDays( - ($maxfull)) -Because \"Taking regular backups is extraordinarily important\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 463\u001b[0m\n",
      "\u001b[91m      [-] master full backups on localhost,15593 should be less than 7 days\u001b[0m\u001b[90m 6ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-13T13:50:58.6019034Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:41:56.0000000Z.\u001b[0m\n",
      "\u001b[91m        463:                         $psitem.LastBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddDays( - ($maxfull)) -Because \"Taking regular backups is extraordinarily important\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 463\u001b[0m\n",
      "\u001b[91m      [-] model full backups on localhost,15593 should be less than 7 days\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-13T13:50:58.6155094Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:41:56.0000000Z.\u001b[0m\n",
      "\u001b[91m        463:                         $psitem.LastBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddDays( - ($maxfull)) -Because \"Taking regular backups is extraordinarily important\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 463\u001b[0m\n",
      "\u001b[91m      [-] msdb full backups on localhost,15593 should be less than 7 days\u001b[0m\u001b[90m 7ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-13T13:50:58.6251129Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:41:57.0000000Z.\u001b[0m\n",
      "\u001b[91m        463:                         $psitem.LastBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddDays( - ($maxfull)) -Because \"Taking regular backups is extraordinarily important\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 463\u001b[0m\n",
      "\u001b[91m      [-] Northwind full backups on localhost,15593 should be less than 7 days\u001b[0m\u001b[90m 6ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-13T13:50:58.6403950Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:42:01.0000000Z.\u001b[0m\n",
      "\u001b[91m        463:                         $psitem.LastBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddDays( - ($maxfull)) -Because \"Taking regular backups is extraordinarily important\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 463\u001b[0m\n",
      "\u001b[91m      [-] pubs full backups on localhost,15593 should be less than 7 days\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-13T13:50:58.6521415Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:42:02.0000000Z.\u001b[0m\n",
      "\u001b[91m        463:                         $psitem.LastBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddDays( - ($maxfull)) -Because \"Taking regular backups is extraordinarily important\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 463\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Diff Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last diff backups on localhost,15593\u001b[0m\n",
      "\u001b[91m      [-] AdventureWorks2017 diff backups on localhost,15593 should be less than 24 hours\u001b[0m\u001b[90m 6ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-19T13:50:58.8533191Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:42:00.0000000Z.\u001b[0m\n",
      "\u001b[91m        487:                             $psitem.LastDifferentialBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddHours( - ($maxdiff)) -Because 'Taking regular backups is extraordinarily important'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 487\u001b[0m\n",
      "\u001b[91m      [-] Northwind diff backups on localhost,15593 should be less than 24 hours\u001b[0m\u001b[90m 7ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-19T13:50:58.8688956Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:42:00.0000000Z.\u001b[0m\n",
      "\u001b[91m        487:                             $psitem.LastDifferentialBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddHours( - ($maxdiff)) -Because 'Taking regular backups is extraordinarily important'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 487\u001b[0m\n",
      "\u001b[91m      [-] pubs diff backups on localhost,15593 should be less than 24 hours\u001b[0m\u001b[90m 7ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-19T13:50:58.8861271Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:42:00.0000000Z.\u001b[0m\n",
      "\u001b[91m        487:                             $psitem.LastDifferentialBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddHours( - ($maxdiff)) -Because 'Taking regular backups is extraordinarily important'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 487\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Log Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last log backups on localhost,15593\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Log File Size Checks\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Log File size for localhost,15593\u001b[0m\n",
      "\u001b[32m      [+] AdventureWorks2017 on localhost,15593 Should have no log files larger than 50% of the Average of DataFiles\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] master on localhost,15593 Should have no log files larger than 50% of the Average of DataFiles\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\u001b[32m      [+] model on localhost,15593 Should have no log files larger than 50% of the Average of DataFiles\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[32m      [+] msdb on localhost,15593 Should have no log files larger than 50% of the Average of DataFiles\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] Northwind on localhost,15593 Should have no log files larger than 50% of the Average of DataFiles\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\u001b[32m      [+] pubs on localhost,15593 Should have no log files larger than 50% of the Average of DataFiles\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[32m      [+] tempdb on localhost,15593 Should have no log files larger than 50% of the Average of DataFiles\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Future File Growth\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing for files likely to grow soon on localhost,15593\u001b[0m\n",
      "\u001b[32m      [+] AdventureWorks2017 file AdventureWorks2017 on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\u001b[32m      [+] AdventureWorks2017 file AdventureWorks2017_log on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[91m      [-] master file master on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than or equal to 10, because free space within the file should be lower than threshold of 10 %, but got 0.951999999999998.\u001b[0m\n",
      "\u001b[91m        612:                                 $PSItem.PercentFree | Should -BeGreaterOrEqual $threshold -Because \"free space within the file should be lower than threshold of $threshold %\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 612\u001b[0m\n",
      "\u001b[32m      [+] master file mastlog on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] model file modeldev on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\u001b[32m      [+] model file modellog on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\u001b[91m      [-] msdb file MSDBData on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than or equal to 10, because free space within the file should be lower than threshold of 10 %, but got 1.271.\u001b[0m\n",
      "\u001b[91m        612:                                 $PSItem.PercentFree | Should -BeGreaterOrEqual $threshold -Because \"free space within the file should be lower than threshold of $threshold %\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 612\u001b[0m\n",
      "\u001b[32m      [+] msdb file MSDBLog on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] Northwind file Northwind on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\u001b[32m      [+] Northwind file Northwind_log on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[32m      [+] pubs file pubs on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\u001b[32m      [+] pubs file pubs_log on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\u001b[32m      [+] tempdb file tempdev on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\u001b[32m      [+] tempdb file templog on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] tempdb file tempdev2 on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[32m      [+] tempdb file tempdev3 on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[32m      [+] tempdb file tempdev4 on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\n",
      "\u001b[92mExecuting script C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Instance Connection\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Instance Connection on localhost,15592\u001b[0m\n",
      "\u001b[32m      [+] connects successfully to localhost,15592\u001b[0m\u001b[90m 7ms\u001b[0m\n",
      "\u001b[32m      [+] auth scheme should be SQL on localhost,15592\u001b[0m\u001b[90m 105ms\u001b[0m\n",
      "\u001b[32m      [+] localhost,15592 is pingable\u001b[0m\u001b[90m 18ms\u001b[0m\n",
      "\u001b[93m      [!] localhost,15592 Is PSRemoteable\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SQL Memory Dumps\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that dumps on localhost,15592 do not exceed 1 for localhost,15592\u001b[0m\n",
      "\u001b[32m      [+] dump count of  is less than or equal to the 1 dumps on localhost,15592\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Error Log Entries\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking error log on localhost,15592\u001b[0m\n",
      "\u001b[32m      [+] Error log should be free of error severities 17-24 on localhost,15592\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Instance Connection\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Instance Connection on localhost,15593\u001b[0m\n",
      "\u001b[32m      [+] connects successfully to localhost,15593\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[32m      [+] auth scheme should be SQL on localhost,15593\u001b[0m\u001b[90m 89ms\u001b[0m\n",
      "\u001b[32m      [+] localhost,15593 is pingable\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[93m      [!] localhost,15593 Is PSRemoteable\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SQL Memory Dumps\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that dumps on localhost,15593 do not exceed 1 for localhost,15593\u001b[0m\n",
      "\u001b[32m      [+] dump count of  is less than or equal to the 1 dumps on localhost,15593\u001b[0m\u001b[90m 1ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Error Log Entries\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking error log on localhost,15593\u001b[0m\n",
      "\u001b[32m      [+] Error log should be free of error severities 17-24 on localhost,15593\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\n",
      "\u001b[92mExecuting script C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Server.Tests.ps1\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Disk Space\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Disk Space on localhost,15592\u001b[0m\n",
      "\u001b[32m      [+] C:\\ with 44.58% free should be at least 10% free on localhost\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Disk Space\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Disk Space on localhost,15593\u001b[0m\n",
      "\u001b[32m      [+] C:\\ with 44.58% free should be at least 10% free on localhost\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[97mTests completed in 69.47s\u001b[0m\n",
      "\u001b[97mTests Passed: 69, \u001b[0m\u001b[91mFailed: 20, \u001b[0m\u001b[93mSkipped: 2, \u001b[0m\u001b[90mPending: 0, \u001b[0m\u001b[90mInconclusive: 0 \u001b[0m\n"
     ]
    }
   ],
   "source": [
    "$FolderPath = $Env:USERPROFILE + '\\Documents\\dbachecks'\r\n",
    "$SqlCredential = Import-Clixml -Path $FolderPath\\sqladmin.cred\r\n",
    "# Just in case the config has been altered\r\n",
    "$null = Reset-DbcConfig\r\n",
    "$null = Import-DbcConfig -Path $FolderPath\\Morning-Checks-Production.json \r\n",
    "$invokeDbcCheckSplat = @{\r\n",
    "\r\n",
    "    SqlCredential = $SqlCredential\r\n",
    "    Check = 'InstanceConnection', 'FailedJob', 'LastBackup', 'ErrorLog', 'DiskCapacity', 'MemoryDump', 'LastJobRunTime', 'LongRunningJob', 'LogfileSize', 'FutureFileGrowth'\r\n",
    "}\r\n",
    "Invoke-DbcCheck @invokeDbcCheckSplat"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "3230a695-2f74-419a-a1e6-3fb7b2b100f2"
   },
   "source": [
    "## Only showing the failures\r\n",
    "\r\n",
    "This will run 91 checks and most will pass. To avoid filling our buffer will all the checks that have passed, we can only display the failed checks using the `-Show` parameter with the `Fails` value. (NOTE - This is a better option than `Failed` which will only show the failed tests and no context for them)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "azdata_cell_guid": "a3aab53a-2ac1-4aca-8a65-a1c85ebacfe1"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[97m    ____            __\n",
      "   / __ \\___  _____/ /____  _____\n",
      "  / /_/ / _ \\/ ___/ __/ _ \\/ ___/\n",
      " / ____/  __(__  ) /_/  __/ /\n",
      "/_/    \\___/____/\\__/\\___/_/\n",
      "Pester v4.9.0\n",
      "Executing all tests in 'C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1', 'C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1', 'C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1', 'C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Server.Tests.ps1' with Tags InstanceConnection', 'FailedJob', 'LastBackup', 'ErrorLog', 'DiskCapacity', 'MemoryDump', 'LastJobRunTime', 'LongRunningJob', 'LogfileSize', 'FutureFileGrowth\u001b[0m\n",
      "\n",
      "\u001b[92mExecuting script C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Failed Jobs\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking for failed enabled jobs since 02/19/2020 13:52:08 on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - SYSTEM_DATABASES - FULL's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - USER_DATABASES - DIFF's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - USER_DATABASES - FULL's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 7ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - USER_DATABASES - LOG's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseIntegrityCheck - SYSTEM_DATABASES's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseIntegrityCheck - USER_DATABASES's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 8ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] The Beard is Important's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Long Running Agent Jobs\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing long running jobs on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Agent Job Run\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last job run time on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Failed Jobs\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking for failed enabled jobs since 02/19/2020 13:52:10 on localhost,15593\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Long Running Agent Jobs\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing long running jobs on localhost,15593\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Agent Job Run\u001b[0m\n",
      "\n",
      "\u001b[92mExecuting script C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Full Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last full backups on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Diff Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last diff backups on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Log Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last log backups on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Log File Size Checks\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Log File size for localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Future File Growth\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing for files likely to grow soon on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] master file master on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 6ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than or equal to 10, because free space within the file should be lower than threshold of 10 %, but got 0.951999999999998.\u001b[0m\n",
      "\u001b[91m        612:                                 $PSItem.PercentFree | Should -BeGreaterOrEqual $threshold -Because \"free space within the file should be lower than threshold of $threshold %\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 612\u001b[0m\n",
      "\u001b[91m      [-] msdb file MSDBData on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than or equal to 10, because free space within the file should be lower than threshold of 10 %, but got 1.271.\u001b[0m\n",
      "\u001b[91m        612:                                 $PSItem.PercentFree | Should -BeGreaterOrEqual $threshold -Because \"free space within the file should be lower than threshold of $threshold %\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 612\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Full Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last full backups on localhost,15593\u001b[0m\n",
      "\u001b[91m      [-] AdventureWorks2017 full backups on localhost,15593 should be less than 7 days\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-13T13:52:14.0922644Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:42:01.0000000Z.\u001b[0m\n",
      "\u001b[91m        463:                         $psitem.LastBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddDays( - ($maxfull)) -Because \"Taking regular backups is extraordinarily important\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 463\u001b[0m\n",
      "\u001b[91m      [-] master full backups on localhost,15593 should be less than 7 days\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-13T13:52:14.1005956Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:41:56.0000000Z.\u001b[0m\n",
      "\u001b[91m        463:                         $psitem.LastBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddDays( - ($maxfull)) -Because \"Taking regular backups is extraordinarily important\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 463\u001b[0m\n",
      "\u001b[91m      [-] model full backups on localhost,15593 should be less than 7 days\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-13T13:52:14.1108876Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:41:56.0000000Z.\u001b[0m\n",
      "\u001b[91m        463:                         $psitem.LastBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddDays( - ($maxfull)) -Because \"Taking regular backups is extraordinarily important\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 463\u001b[0m\n",
      "\u001b[91m      [-] msdb full backups on localhost,15593 should be less than 7 days\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-13T13:52:14.1204912Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:41:57.0000000Z.\u001b[0m\n",
      "\u001b[91m        463:                         $psitem.LastBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddDays( - ($maxfull)) -Because \"Taking regular backups is extraordinarily important\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 463\u001b[0m\n",
      "\u001b[91m      [-] Northwind full backups on localhost,15593 should be less than 7 days\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-13T13:52:14.1309936Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:42:01.0000000Z.\u001b[0m\n",
      "\u001b[91m        463:                         $psitem.LastBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddDays( - ($maxfull)) -Because \"Taking regular backups is extraordinarily important\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 463\u001b[0m\n",
      "\u001b[91m      [-] pubs full backups on localhost,15593 should be less than 7 days\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-13T13:52:14.1428840Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:42:02.0000000Z.\u001b[0m\n",
      "\u001b[91m        463:                         $psitem.LastBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddDays( - ($maxfull)) -Because \"Taking regular backups is extraordinarily important\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 463\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Diff Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last diff backups on localhost,15593\u001b[0m\n",
      "\u001b[91m      [-] AdventureWorks2017 diff backups on localhost,15593 should be less than 24 hours\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-19T13:52:14.2954330Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:42:00.0000000Z.\u001b[0m\n",
      "\u001b[91m        487:                             $psitem.LastDifferentialBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddHours( - ($maxdiff)) -Because 'Taking regular backups is extraordinarily important'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 487\u001b[0m\n",
      "\u001b[91m      [-] Northwind diff backups on localhost,15593 should be less than 24 hours\u001b[0m\u001b[90m 6ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-19T13:52:14.3087960Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:42:00.0000000Z.\u001b[0m\n",
      "\u001b[91m        487:                             $psitem.LastDifferentialBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddHours( - ($maxdiff)) -Because 'Taking regular backups is extraordinarily important'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 487\u001b[0m\n",
      "\u001b[91m      [-] pubs diff backups on localhost,15593 should be less than 24 hours\u001b[0m\u001b[90m 7ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than 2020-03-19T13:52:14.3205828Z, because Taking regular backups is extraordinarily important, but got 2019-12-21T14:42:00.0000000Z.\u001b[0m\n",
      "\u001b[91m        487:                             $psitem.LastDifferentialBackupDate.ToUniversalTime() | Should -BeGreaterThan (Get-Date).ToUniversalTime().AddHours( - ($maxdiff)) -Because 'Taking regular backups is extraordinarily important'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 487\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Log Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last log backups on localhost,15593\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Log File Size Checks\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Log File size for localhost,15593\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Future File Growth\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing for files likely to grow soon on localhost,15593\u001b[0m\n",
      "\u001b[91m      [-] master file master on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than or equal to 10, because free space within the file should be lower than threshold of 10 %, but got 0.951999999999998.\u001b[0m\n",
      "\u001b[91m        612:                                 $PSItem.PercentFree | Should -BeGreaterOrEqual $threshold -Because \"free space within the file should be lower than threshold of $threshold %\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 612\u001b[0m\n",
      "\u001b[91m      [-] msdb file MSDBData on 2a4ce913a3ce has free space under threshold\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than or equal to 10, because free space within the file should be lower than threshold of 10 %, but got 1.271.\u001b[0m\n",
      "\u001b[91m        612:                                 $PSItem.PercentFree | Should -BeGreaterOrEqual $threshold -Because \"free space within the file should be lower than threshold of $threshold %\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 612\u001b[0m\n",
      "\n",
      "\u001b[92mExecuting script C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Instance Connection\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Instance Connection on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] We should be able to remote onto localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SQL Memory Dumps\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that dumps on localhost,15592 do not exceed 1 for localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Error Log Entries\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking error log on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Instance Connection\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Instance Connection on localhost,15593\u001b[0m\n",
      "\u001b[93m      [!] We should be able to remote onto localhost,15593\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SQL Memory Dumps\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that dumps on localhost,15593 do not exceed 1 for localhost,15593\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Error Log Entries\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking error log on localhost,15593\u001b[0m\n",
      "\n",
      "\u001b[92mExecuting script C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Server.Tests.ps1\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Disk Space\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Disk Space on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Disk Space\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Disk Space on localhost,15593\u001b[0m\n",
      "\u001b[97mTests completed in 64.46s\u001b[0m\n",
      "\u001b[97mTests Passed: 69, \u001b[0m\u001b[91mFailed: 20, \u001b[0m\u001b[93mSkipped: 2, \u001b[0m\u001b[90mPending: 0, \u001b[0m\u001b[90mInconclusive: 0 \u001b[0m\n"
     ]
    }
   ],
   "source": [
    "$invokeDbcCheckSplat = @{\r\n",
    "    SqlCredential = $SqlCredential\r\n",
    "    Check = 'InstanceConnection', 'FailedJob', 'LastBackup', 'ErrorLog', 'DiskCapacity', 'MemoryDump', 'LastJobRunTime', 'LongRunningJob', 'LogfileSize', 'FutureFileGrowth'\r\n",
    "    Show = 'Fails'\r\n",
    "}\r\n",
    "Invoke-DbcCheck @invokeDbcCheckSplat"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "7e9b08b5-2481-4760-bc59-61dfbe7a7c61"
   },
   "source": [
    "# Configuration for New Instance\r\n",
    "\r\n",
    "You might want to create a configuration to run after a new instance has been set up\r\n",
    "\r\n",
    "This might require the following configurations (other settings will also be checked with default configurations)\r\n",
    "\r\n",
    "- Database mail has been set up\r\n",
    "- Operators and Failsafe Operators are set up\r\n",
    "- Agent Jobs are owned by the correct account\r\n",
    "- Agent Alerts are set up correctly\r\n",
    "- Job History settings are set up correctly\r\n",
    "- Ola Hallengrens Maintenance solution is set up as expected\r\n",
    "- The expected Extended Events sessions are installed and running\r\n",
    "- The correct Error Logs Setting\r\n",
    "\r\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "azdata_cell_guid": "13ce3069-a0c6-462f-9bff-fe57107db6c3",
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Name                                 Value\n",
      "----                                 -----                                                         \n",
      "command.invokedbccheck.excludecheck  {FailsafeOperator, DatabaseMailEnabled, DatabaseMailProfile, …\n",
      "policy.connection.authscheme         SQL                                                           \n",
      "skip.connection.remoting             True                                                          \n",
      "agent.dbaoperatorname                SQLAdmins                                                     \n",
      "agent.dbaoperatoremail               SQLAdmins@TheBeard.local                                      \n",
      "agent.validjobowner.name             OldSa                                                         \n",
      "agent.alert.messageid                {1101, 1105, 1121, 1214…}                                     \n",
      "agent.history.maximumhistoryrows     1000                                                          \n",
      "agent.history.maximumjobhistoryrows  100                                                           \n",
      "policy.xevent.requiredrunningsession {15 Second IO Error, Blocked Process Report, Stored Procedure…\n",
      "policy.errorlog.logcount             -1                                                            \n",
      "skip.instance.remoteaccessdisabled   True                                                          \n",
      "\n"
     ]
    }
   ],
   "source": [
    "# reset the configuration\r\n",
    "$null = Reset-DbcConfig\r\n",
    "# Set Checks to exclude (these wont run on containers)\r\n",
    "Set-DbcConfig -Name command.invokedbccheck.excludecheck -Value FailsafeOperator,DatabaseMailEnabled,DatabaseMailProfile,SqlEngineServiceAccount,OrphanedFile,ServerNameMatch\r\n",
    "# Set the auth scheme to SQL as we are using SQL Auth\r\n",
    "Set-DbcConfig -Name policy.connection.authscheme -Value SQL\r\n",
    "# Don't check the PSRemoting\r\n",
    "Set-DbcConfig -Name skip.connection.remoting -Value $true\r\n",
    "# Set config for expected Operators\r\n",
    "Set-DbcConfig -Name agent.dbaoperatorname -Value SQLAdmins\r\n",
    "# Set COnfig for operators email address\r\n",
    "Set-DbcConfig -Name agent.dbaoperatoremail -Value SQLAdmins@TheBeard.local\r\n",
    "# Set config for the expected job owner\r\n",
    "Set-DbcConfig -Name agent.validjobowner.name -Value OldSa\r\n",
    "# Set config for expected agent alerts\r\n",
    "$Ids = '1101','1105','1121','1214','17130','17179','17300','17883','17884','17887','17888','17890','2508','2511','28036','3271','3452','3619','3624','5180','5228','5229','5242','5243','5250','5572','5901','605','701','802','823','824','825','832','833','845','855','856','8966','9002','9100'\r\n",
    "Set-DbcConfig -Name agent.alert.messageid -Value $Ids\r\n",
    "# Set the config for the job history settings\r\n",
    "Set-DbcConfig -Name agent.history.maximumhistoryrows -Value 1000\r\n",
    "Set-DbcConfig -Name agent.history.maximumjobhistoryrows -Value 100\r\n",
    "# Set config for the extended events\r\n",
    "Set-DbcConfig -Name policy.xevent.requiredrunningsession -Value '15 Second IO Error','Blocked Process Report','Stored Procedure Parameters' \r\n",
    "# Sets Error log - Its a container!\r\n",
    "Set-DbcConfig -Name policy.errorlog.logcount -Value -1\r\n",
    "# Set Remote Access configuration\r\n",
    "Set-DbcConfig -Name skip.instance.remoteaccessdisabled -Value $true\r\n",
    "\r\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "8d4b5df6-2d6b-42b3-a391-00735a86b4bc"
   },
   "source": [
    "With the configuration created you can save it to a file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "azdata_cell_guid": "8494c923-b677-474d-8179-61d7eb7e4536"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[96m[\u001b[0m\u001b[37m13:54:19\u001b[0m\u001b[96m][\u001b[0m\u001b[37mExport-DbcConfig\u001b[0m\u001b[96m] Wrote file to C:\\Users\\mrrob\\Documents\\dbachecks\\New-Instance.json\u001b[0m\n"
     ]
    }
   ],
   "source": [
    "$FolderPath = $Env:USERPROFILE + '\\Documents\\dbachecks'\r\n",
    "Export-DbcConfig -Path $FolderPath\\New-Instance.json "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "5fd5592b-17a3-46b8-9e7e-b2c743703cab"
   },
   "source": [
    "You can then load that configuration and run it. This will take a couple of minutes to run, be patient."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "azdata_cell_guid": "81860f9a-4d62-45bb-b538-16bec95d63ec"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[97m    ____            __\n",
      "   / __ \\___  _____/ /____  _____\n",
      "  / /_/ / _ \\/ ___/ __/ _ \\/ ___/\n",
      " / ____/  __(__  ) /_/  __/ /\n",
      "/_/    \\___/____/\\__/\\___/_/\n",
      "Pester v4.9.0\n",
      "Executing all tests in 'C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1', 'C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1' with Tags Instance', 'Agent\u001b[0m\n",
      "\n",
      "\u001b[92mExecuting script C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SQL Agent Account\u001b[0m\n",
      "\u001b[93m    [!] Running on Linux or connecting to container so can't check Services on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing DBA Operators\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing DBA Operators exists on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Failed Jobs\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking for failed enabled jobs since 02/19/2020 13:54:33 on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - SYSTEM_DATABASES - FULL's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - USER_DATABASES - DIFF's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - USER_DATABASES - FULL's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - USER_DATABASES - LOG's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseIntegrityCheck - SYSTEM_DATABASES's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseIntegrityCheck - USER_DATABASES's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 6ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] The Beard is Important's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Valid Job Owner\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing job owners on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] Job The Beard is Important  - owner sqladmin should be in this list ( OldSa ) on 69017f5d2a89\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected collection OldSa to contain 'sqladmin', because The account that is the job owner is not what was expected, but it was not found.\u001b[0m\n",
      "\u001b[91m        191:                                     $psitem.OwnerLoginName | Should -BeIn $TargetOwner -Because \"The account that is the job owner is not what was expected\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 191\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Agent Alerts\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Agent Alerts Severity exists on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Agent Alerts MessageID exists on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Job History Configuration\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing job history configuration on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Long Running Agent Jobs\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing long running jobs on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Agent Job Run\u001b[0m\n",
      "\n",
      "\u001b[92mExecuting script C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Instance Connection\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Instance Connection on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] localhost,15592 Is PSRemoteable\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing TempDB Configuration\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing TempDB Configuration on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] should have TF1118 enabled on 69017f5d2a89\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Ad Hoc Workload Optimization\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Ad Hoc Workload Optimization on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Backup Path Access\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Backup Path Access on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Default File Path\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Default Data File Path on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Default Log File Path on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Dedicated Administrator Connection\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Dedicated Administrator Connection on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Network Latency\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Network Latency on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Linked Servers\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Linked Servers on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Max Memory\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Max Memory on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] Max Memory setting should be correct on localhost,15592\u001b[0m\u001b[90m 1.47s\u001b[0m\n",
      "\u001b[91m        DivideByZeroException: Attempted to divide by zero.\u001b[0m\n",
      "\u001b[91m        RuntimeException: Attempted to divide by zero.\u001b[0m\n",
      "\u001b[91m        at Test-DbaMaxMemory<Process>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbatools\\1.0.100\\allcommands.ps1: line 72154\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1: line 294\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SQL Memory Dumps\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that dumps on localhost,15592 do not exceed 1 for localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Supported Build\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that build is still supportedby Microsoft for localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SA Login Renamed\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that sa login has been renamed on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SA Login Disabled\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that sa login has been disabled on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] sa login is disabled on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Login SA cannot exist\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that a login named sa does not exist on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] sa login does not exist on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Default Backup Compression\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Default Backup Compression on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing XE Sessions That should be Stopped\u001b[0m\n",
      "\u001b[93mWARNING: You need to use Set-DbcConfig -Name policy.xevent.requiredstoppedsession -Value to add some Extended Events session names to run this check\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing XE Sessions That should be Running\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking running sessions on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing XE Sessions That Are Allowed to Be Running\u001b[0m\n",
      "\u001b[93mWARNING: You need to use Set-DbcConfig -Name policy.xevent.validrunningsession -Value to add some Extended Events session names to run this check\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing OLE Automation\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing OLE Automation on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing sp_whoisactive is Installed\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing WhoIsActive exists on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Model Database Growth\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing model database growth setting is not default on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Ad Users and Groups \u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Active Directory users on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Active Directory groups on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Error Log Entries\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking error log on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] Error log should be free of error severities 17-24 on localhost,15592\u001b[0m\u001b[90m 19ms\u001b[0m\n",
      "\u001b[91m        Expected $null or empty, because these severities indicate serious problems, but got @(@{LogDate=Do not know the Date; ProcessInfo=Do not know the Process; Text=Do not know the Test; InstanceName=An Error occurred [localhost,15592]}).\u001b[0m\n",
      "\u001b[91m        770:     $AllInstanceInfo.ErrorLog | Should -BeNullOrEmpty -Because \"these severities indicate serious problems\"\u001b[0m\n",
      "\u001b[91m        at Assert-ErrorLogEntry, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\internal\\assertions\\Instance.Assertions.ps1: line 770\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1: line 693\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Error Log Count\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking error log count on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Instance MaxDop\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Instance MaxDop Value on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Two Digit Year Cutoff\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Two Digit Year Cutoff on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Trace Flags Expected\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Expected Trace Flags on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Trace Flags Not Expected\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Not Expected Trace Flags on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing CLR Enabled\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing CLR Enabled on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Cross Database Ownership Chaining\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Cross Database Ownership Chaining on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] Cross Database Ownership Chaining should be disabled on localhost,15592\u001b[0m\u001b[90m 9ms\u001b[0m\n",
      "\u001b[91m        Expected 0, because We expected the Cross DB Ownership Chaining to be disabled, but got 'We Could not Connect to $Instance'.\u001b[0m\n",
      "\u001b[91m        743:     $AllInstanceInfo.CrossDBOwnershipChaining.ConfiguredValue | Should -Be 0 -Because \"We expected the Cross DB Ownership Chaining to be disabled\"\u001b[0m\n",
      "\u001b[91m        at Assert-CrossDBOwnershipChaining, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\internal\\assertions\\Instance.Assertions.ps1: line 743\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1: line 820\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Ad Hoc Distributed Queries\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Ad Hoc Distributed Queries on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing XP CmdShell\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing XP CmdShell on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Scan For Startup Procedures\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Scan For Startup Procedures on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] Scan For Startup Procedures should be disabled on localhost,15592\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected 0, because We expected the scan for startup procedures to be disabled, but got 'We Could not Connect to $Instance'.\u001b[0m\n",
      "\u001b[91m        623:     $AllInstanceInfo.ScanForStartupProceduresDisabled.ConfiguredValue | Should -Be 0 -Because \"We expected the scan for startup procedures to be disabled\"\u001b[0m\n",
      "\u001b[91m        at Assert-ScanForStartupProcedures, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\internal\\assertions\\Instance.Assertions.ps1: line 623\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1: line 872\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Default Trace\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking Default Trace on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] The Default Trace should be enabled on localhost,15592\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected 1, because We expected the Default Trace to be enabled, but got 'We Could not Connect to $Instance'.\u001b[0m\n",
      "\u001b[91m        598:     $AllInstanceInfo.DefaultTrace.ConfiguredValue | Should -Be 1 -Because \"We expected the Default Trace to be enabled\"\u001b[0m\n",
      "\u001b[91m        at Assert-DefaultTrace, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\internal\\assertions\\Instance.Assertions.ps1: line 598\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1: line 889\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing OLE Automation Procedures Disabled\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking OLE Automation Procedures on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] The OLE Automation Procedures should be disabled on localhost,15592\u001b[0m\u001b[90m 8ms\u001b[0m\n",
      "\u001b[91m        Expected 0, because We expect the OLE Automation Procedures to be disabled, but got 'We Could not Connect to $Instance'.\u001b[0m\n",
      "\u001b[91m        617:     $AllInstanceInfo.OleAutomationProceduresDisabled.ConfiguredValue | Should -Be 0 -Because \"We expect the OLE Automation Procedures to be disabled\"\u001b[0m\n",
      "\u001b[91m        at Assert-OleAutomationProcedures, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\internal\\assertions\\Instance.Assertions.ps1: line 617\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1: line 906\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Remote Access Disabled\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Remote Access on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] The Remote Access should be disabled on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Latest Build\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Latest Build on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Login BUILTIN Administrators cannot exist\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that a login named BUILTIN\\Administrators does not exist on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] BUILTIN\\Administrators login does not exist on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Local Windows Groups Not Have SQL Logins\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that local Windows groups do not have SQL Logins on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] Local Windows groups should not SQL Logins on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Failed Login Auditing\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing if failed login auditing is in place on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] The failed login auditing should be set on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Successful Login Auditing\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing if successful and failed login auditing is in place on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] The successful and failed auditng should be set on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SqlAgentProxiesNoPublicRole\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing to see if the public role has access to the SQL Agent proxies on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] The public role should not have access to the SQL Agent Proxies on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Hide Instance\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking the Hide an Instance of SQL Server Database Engine property on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] The Hide an Instance of SQL Server Database Engine property on SQL Server instance localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SQL Browser Service\u001b[0m\n",
      "\u001b[93mWARNING: [13:54:49][Get-ComputerName] You must specify -ComputerName or use Set-DbcConfig app.computername to setup a list of servers\u001b[0m\n",
      "\u001b[97mTests completed in 17.41s\u001b[0m\n",
      "\u001b[97mTests Passed: 208, \u001b[0m\u001b[91mFailed: 14, \u001b[0m\u001b[93mSkipped: 12, \u001b[0m\u001b[90mPending: 0, \u001b[0m\u001b[90mInconclusive: 0 \u001b[0m\n"
     ]
    }
   ],
   "source": [
    "# Just in case the config has been altered\n",
    "$null = Reset-DbcConfig\n",
    "$null = Import-DbcConfig -Path $FolderPath\\New-Instance.json \n",
    "$invokeDbcCheckSplat = @{\n",
    "    SqlInstance = 'localhost,15592'\n",
    "    SqlCredential = $SqlCredential\n",
    "    Check = 'Instance','Agent'\n",
    "    Show = 'Fails'\n",
    "}\n",
    "Invoke-DbcCheck @invokeDbcCheckSplat"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "a6270932-2431-4331-af09-ae4acb323ca3"
   },
   "source": [
    "# Configuration for Weekly Check\r\n",
    "\r\n",
    "This configuration could be used for a weekly check of an estate. It includes\r\n",
    "\r\n",
    "- Failed jobs in the last 2 days - I ran this on a Sunday so checking weekend maintenance\r\n",
    "\r\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "azdata_cell_guid": "77762126-5715-484a-b6e6-7caa5ef5987b"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Name                                         Value\n",
      "----                                         -----                                                 \n",
      "command.invokedbccheck.excludecheck          {FailsafeOperator, DatabaseMailEnabled, DatabaseMailP…\n",
      "app.sqlinstance                              {localhost,15592, localhost,15593}                    \n",
      "app.computername                             {localhost,15592, localhost,15593}                    \n",
      "policy.connection.authscheme                 SQL                                                   \n",
      "skip.connection.remoting                     True                                                  \n",
      "agent.failedjob.since                        2                                                     \n",
      "policy.build.behind                          1SP                                                   \n",
      "policy.build.warningwindow                   2                                                     \n",
      "policy.certificateexpiration.warningwindow   2                                                     \n",
      "policy.database.filebalancetolerance         3                                                     \n",
      "policy.database.filegrowthfreespacethreshold 10                                                    \n",
      "policy.database.logfilesizecomparison        average                                               \n",
      "policy.database.logfilesizepercentage        50                                                    \n",
      "policy.database.maxvlf                       256                                                   \n",
      "policy.dbcc.maxdays                          3                                                     \n",
      "policy.diskspace.percentfree                 5                                                     \n",
      "agent.validjobowner.name                     OldSa                                                 \n",
      "agent.alert.messageid                        {1101, 1105, 1121, 1214…}                             \n",
      "agent.history.maximumhistoryrows             1000                                                  \n",
      "agent.history.maximumjobhistoryrows          100                                                   \n",
      "policy.xevent.requiredrunningsession         {15 Second IO Error, Blocked Process Report, Stored P…\n",
      "policy.invaliddbowner.name                   OldSa                                                 \n",
      "policy.validdbowner.name                     sqladmin                                              \n",
      "database.exists                              {master, msdb, tempdb, model…}                        \n",
      "\n"
     ]
    }
   ],
   "source": [
    "# reset the configuration\n",
    "$null = Reset-DbcConfig\n",
    "# Set Checks to exclude (these wont run on containers)\n",
    "Set-DbcConfig -Name command.invokedbccheck.excludecheck -Value FailsafeOperator,DatabaseMailEnabled,DatabaseMailProfile,SqlEngineServiceAccount,OrphanedFile,ServerNameMatch, SqlBrowserServiceAccount\n",
    "# Set the instances and computernames to run the check against\n",
    "Set-DbcConfig -Name app.sqlinstance -Value 'localhost,15592','localhost,15593'\n",
    "Set-DbcConfig -Name app.computername -Value 'localhost,15592','localhost,15593'\n",
    "# Set the auth scheme to SQL as we are using SQL Auth\n",
    "Set-DbcConfig -Name policy.connection.authscheme -Value SQL\n",
    "# Don't check the PSRemoting\n",
    "Set-DbcConfig -Name skip.connection.remoting -Value $true\n",
    "Set-DbcConfig -Name agent.failedjob.since -Value 2\n",
    "# COnfig for build warning\n",
    "Set-DbcConfig -Name policy.build.behind\t-Value 1SP\n",
    "Set-DbcConfig -Name policy.build.warningwindow\t-Value 2\n",
    "# COnfig for when we want to know certs are going to expire\n",
    "Set-DbcConfig -Name policy.certificateexpiration.warningwindow -Value 2\t\n",
    "# How different can our files be in a filegroup\n",
    "Set-DbcConfig -Name policy.database.filebalancetolerance -Value 3\n",
    "# Free Space in file\n",
    "Set-DbcConfig -Name policy.database.filegrowthfreespacethreshold 10\n",
    "# How big can our log file be in comparison to our data files\n",
    "Set-DbcConfig -Name policy.database.logfilesizecomparison -Value average\t\n",
    "Set-DbcConfig -Name policy.database.logfilesizepercentage -Value 50\n",
    "# max number of VLFs allowed\n",
    "Set-DbcConfig -Name policy.database.maxvlf 256\n",
    "# Last DBCC\n",
    "Set-DbcConfig -Name policy.dbcc.maxdays -Value 3\n",
    "#Disk Space\n",
    "Set-DbcConfig -Name policy.diskspace.percentfree -Value 5\n",
    "# Set config for the expected job owner\n",
    "Set-DbcConfig -Name agent.validjobowner.name -Value OldSa\n",
    "# Set config for expected agent alerts\n",
    "$Ids = '1101','1105','1121','1214','17130','17179','17300','17883','17884','17887','17888','17890','2508','2511','28036','3271','3452','3619','3624','5180','5228','5229','5242','5243','5250','5572','5901','605','701','802','823','824','825','832','833','845','855','856','8966','9002','9100'\n",
    "Set-DbcConfig -Name agent.alert.messageid -Value $Ids\n",
    "# Set the config for the job history settings\n",
    "Set-DbcConfig -Name agent.history.maximumhistoryrows -Value 1000\n",
    "Set-DbcConfig -Name agent.history.maximumjobhistoryrows -Value 100\n",
    "# Set config for the extended events\n",
    "Set-DbcConfig -Name policy.xevent.requiredrunningsession -Value '15 Second IO Error','Blocked Process Report','Stored Procedure Parameters' \n",
    "# Set Database owners\n",
    "Set-DbcConfig -Name policy.invaliddbowner.name -Value OldSa\n",
    "Set-DbcConfig -Name policy.validdbowner.name -Value sqladmin\n",
    "\n",
    "Set-DbcConfig -Name database.exists -Value 'pubs','NorthWind','AdventureWorks2017' -Append\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "f12015e9-e786-4b2a-958b-e3dae1c91fc5"
   },
   "source": [
    "and save it"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "azdata_cell_guid": "f130454d-8b4d-4fb5-a22f-5af7f38ff68f"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[96m[\u001b[0m\u001b[37m14:05:39\u001b[0m\u001b[96m][\u001b[0m\u001b[37mExport-DbcConfig\u001b[0m\u001b[96m] Wrote file to C:\\Users\\mrrob\\Documents\\dbachecks\\Weekly-Check.json\u001b[0m\n"
     ]
    }
   ],
   "source": [
    "$FolderPath = $Env:USERPROFILE + '\\Documents\\dbachecks'\r\n",
    "Export-DbcConfig -Path $FolderPath\\Weekly-Check.json "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "azdata_cell_guid": "5e036f5c-3d32-4f21-8f7e-02ef27633722"
   },
   "source": [
    "load it and run it.  \r\n",
    "\r\n",
    "This will run nearly 900 tests and takes a minute or so"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "azdata_cell_guid": "f5115bea-83c6-47ee-959c-bfd6785e7e99"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[97m    ____            __\n",
      "   / __ \\___  _____/ /____  _____\n",
      "  / /_/ / _ \\/ ___/ __/ _ \\/ ___/\n",
      " / ____/  __(__  ) /_/  __/ /\n",
      "/_/    \\___/____/\\__/\\___/_/\n",
      "Pester v4.9.0\n",
      "Executing all tests in 'C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1', 'C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1', 'C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1' with Tags Agent', 'Database', 'Instance\u001b[0m\n",
      "\n",
      "\u001b[92mExecuting script C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SQL Agent Account\u001b[0m\n",
      "\u001b[93m    [!] Running on Linux or connecting to container so can't check Services on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing DBA Operators\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing DBA Operators exists on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Failed Jobs\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking for failed enabled jobs since 03/18/2020 14:05:50 on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - SYSTEM_DATABASES - FULL's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - USER_DATABASES - DIFF's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - USER_DATABASES - FULL's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseBackup - USER_DATABASES - LOG's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseIntegrityCheck - SYSTEM_DATABASES's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] DatabaseIntegrityCheck - USER_DATABASES's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\u001b[91m      [-] The Beard is Important's last run outcome on 69017f5d2a89 is Failed\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected 'Succeeded', because All Agent Jobs should have succeed - you need to investigate the failed jobs, but got Failed.\u001b[0m\n",
      "\u001b[91m        169:                                         $psitem.LastRunOutcome | Should -Be \"Succeeded\" -Because 'All Agent Jobs should have succeed - you need to investigate the failed jobs'\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 169\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Valid Job Owner\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing job owners on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] Job The Beard is Important  - owner sqladmin should be in this list ( OldSa ) on 69017f5d2a89\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected collection OldSa to contain 'sqladmin', because The account that is the job owner is not what was expected, but it was not found.\u001b[0m\n",
      "\u001b[91m        191:                                     $psitem.OwnerLoginName | Should -BeIn $TargetOwner -Because \"The account that is the job owner is not what was expected\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Agent.Tests.ps1: line 191\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Agent Alerts\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Agent Alerts Severity exists on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Agent Alerts MessageID exists on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Job History Configuration\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing job history configuration on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Long Running Agent Jobs\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing long running jobs on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Agent Job Run\u001b[0m\n",
      "\n",
      "\u001b[92mExecuting script C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Database Collation\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing database collation on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Suspect Page\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing suspect pages on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Backup Restore Test\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Backup VerifyOnly\u001b[0m\n",
      "\n",
      "\u001b[92m    Context VerifyOnly tests of last backups on localhost,15592\u001b[0m\n"
     ]
    },
    {
     "data": {
      "text/plain": []
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "\u001b[92m  Describing Valid Database Owner\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Database Owners on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] Database AdventureWorks2017 - owner thebeard should be in this list ( sqladmin ) on localhost,15592\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected collection sqladmin to contain 'thebeard', because The account that is the database owner is not what was expected, but it was not found.\u001b[0m\n",
      "\u001b[91m        154:                         $psitem.Owner | Should -BeIn $TargetOwner -Because \"The account that is the database owner is not what was expected\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 154\u001b[0m\n",
      "\u001b[91m      [-] Database Northwind - owner thebeard should be in this list ( sqladmin ) on localhost,15592\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected collection sqladmin to contain 'thebeard', because The account that is the database owner is not what was expected, but it was not found.\u001b[0m\n",
      "\u001b[91m        154:                         $psitem.Owner | Should -BeIn $TargetOwner -Because \"The account that is the database owner is not what was expected\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 154\u001b[0m\n",
      "\u001b[91m      [-] Database pubs - owner thebeard should be in this list ( sqladmin ) on localhost,15592\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected collection sqladmin to contain 'thebeard', because The account that is the database owner is not what was expected, but it was not found.\u001b[0m\n",
      "\u001b[91m        154:                         $psitem.Owner | Should -BeIn $TargetOwner -Because \"The account that is the database owner is not what was expected\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 154\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Invalid Database Owner\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Database Owners on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Good DBCC CHECKDB\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Last Good DBCC CHECKDB on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Column Identity Usage\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Column Identity Usage on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Recovery Model\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Recovery Model on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] msdb should be set to Full on 69017f5d2a89\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected 'Full', because You expect this recovery model, but got Simple.\u001b[0m\n",
      "\u001b[91m        262:                         $psitem.RecoveryModel | Should -Be $recoverymodel -Because \"You expect this recovery model\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 262\u001b[0m\n",
      "\u001b[91m      [-] AdventureWorks2017 should be set to Full on 69017f5d2a89\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected 'Full', because You expect this recovery model, but got Simple.\u001b[0m\n",
      "\u001b[91m        262:                         $psitem.RecoveryModel | Should -Be $recoverymodel -Because \"You expect this recovery model\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 262\u001b[0m\n",
      "\u001b[91m      [-] Northwind should be set to Full on 69017f5d2a89\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected 'Full', because You expect this recovery model, but got Simple.\u001b[0m\n",
      "\u001b[91m        262:                         $psitem.RecoveryModel | Should -Be $recoverymodel -Because \"You expect this recovery model\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 262\u001b[0m\n",
      "\u001b[91m      [-] pubs should be set to Full on 69017f5d2a89\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected 'Full', because You expect this recovery model, but got Simple.\u001b[0m\n",
      "\u001b[91m        262:                         $psitem.RecoveryModel | Should -Be $recoverymodel -Because \"You expect this recovery model\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 262\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Duplicate Index\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing duplicate indexes on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] AdventureWorks2017 on localhost,15592 should return 0 duplicate indexes\u001b[0m\u001b[90m 597ms\u001b[0m\n",
      "\u001b[91m        Expected 0, because Duplicate indexes waste disk space and cost you extra IO, CPU, and Memory, but got 2.\u001b[0m\n",
      "\u001b[91m        61:     @(Find-DbaDbDuplicateIndex -SqlInstance $Instance -Database $Database).Count | Should -Be 0 -Because \"Duplicate indexes waste disk space and cost you extra IO, CPU, and Memory\"\u001b[0m\n",
      "\u001b[91m        at Assert-DatabaseDuplicateIndex, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\internal\\assertions\\Database.Assertions.ps1: line 61\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 289\u001b[0m\n",
      "\u001b[91m      [-] Northwind on localhost,15592 should return 0 duplicate indexes\u001b[0m\u001b[90m 277ms\u001b[0m\n",
      "\u001b[91m        Expected 0, because Duplicate indexes waste disk space and cost you extra IO, CPU, and Memory, but got 12.\u001b[0m\n",
      "\u001b[91m        61:     @(Find-DbaDbDuplicateIndex -SqlInstance $Instance -Database $Database).Count | Should -Be 0 -Because \"Duplicate indexes waste disk space and cost you extra IO, CPU, and Memory\"\u001b[0m\n",
      "\u001b[91m        at Assert-DatabaseDuplicateIndex, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\internal\\assertions\\Database.Assertions.ps1: line 61\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 289\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Unused Index\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Unused indexes on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] The SQL Service on localhost,15592 was restarted on 03/20/2020 13:36:50, which is not long enough for a solid evaluation. on  should return 0 Unused indexes\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Disabled Index\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Disabled indexes on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Database Growth Event\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing database growth event on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Page Verify\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing page verify on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Auto Close\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Auto Close on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Auto Shrink\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Auto Shrink on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Full Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last full backups on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Diff Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last diff backups on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Last Log Backup Times\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing last log backups on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Virtual Log Files\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Database VLFs on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Log File Count Checks\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Log File count for localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Log File Size Checks\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Log File size for localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Future File Growth\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing for files likely to grow soon on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] master file master on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than or equal to 10, because free space within the file should be lower than threshold of 10 %, but got 0.951999999999998.\u001b[0m\n",
      "\u001b[91m        612:                                 $PSItem.PercentFree | Should -BeGreaterOrEqual $threshold -Because \"free space within the file should be lower than threshold of $threshold %\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 612\u001b[0m\n",
      "\u001b[91m      [-] msdb file MSDBData on 69017f5d2a89 has free space under threshold\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than or equal to 10, because free space within the file should be lower than threshold of 10 %, but got 1.271.\u001b[0m\n",
      "\u001b[91m        612:                                 $PSItem.PercentFree | Should -BeGreaterOrEqual $threshold -Because \"free space within the file should be lower than threshold of $threshold %\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 612\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Correctly sized Filegroup members\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing for balanced FileGroups on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Certificate Expiration\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that encryption certificates have not expired on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Auto Create Statistics\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Auto Create Statistics on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Auto Update Statistics\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Auto Update Statistics on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Auto Update Statistics Asynchronously\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Auto Update Statistics Asynchronously on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Datafile Auto Growth Configuration\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing datafile growth type on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] master on filegroup PRIMARY should have GrowthType set to kb on 69017f5d2a89\u001b[0m\u001b[90m 14ms\u001b[0m\n",
      "\u001b[91m        Expected strings to be the same, because We expect a certain file growth type, but they were different.\u001b[0m\n",
      "\u001b[91m        Expected length: 2\u001b[0m\n",
      "\u001b[91m        Actual length:   7\u001b[0m\n",
      "\u001b[91m        Strings differ at index 0.\u001b[0m\n",
      "\u001b[91m        Expected: 'kb'\u001b[0m\n",
      "\u001b[91m        But was:  'Percent'\u001b[0m\n",
      "\u001b[91m        751:                             $psitem.GrowthType | Should -Be $datafilegrowthtype -Because \"We expect a certain file growth type\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 751\u001b[0m\n",
      "\u001b[91m      [-] master on filegroup PRIMARY should have Growth set equal or higher than 65535 on 69017f5d2a89\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than or equal to 65535, because We expect a certain file growth value, but got 80.\u001b[0m\n",
      "\u001b[91m        755:                                 $psitem.Growth * 8 | Should -BeGreaterOrEqual $datafilegrowthvalue  -because \"We expect a certain file growth value\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 755\u001b[0m\n",
      "\u001b[91m      [-] mastlog on filegroup  should have GrowthType set to kb on 69017f5d2a89\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected strings to be the same, because We expect a certain file growth type, but they were different.\u001b[0m\n",
      "\u001b[91m        Expected length: 2\u001b[0m\n",
      "\u001b[91m        Actual length:   7\u001b[0m\n",
      "\u001b[91m        Strings differ at index 0.\u001b[0m\n",
      "\u001b[91m        Expected: 'kb'\u001b[0m\n",
      "\u001b[91m        But was:  'Percent'\u001b[0m\n",
      "\u001b[91m        751:                             $psitem.GrowthType | Should -Be $datafilegrowthtype -Because \"We expect a certain file growth type\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 751\u001b[0m\n",
      "\u001b[91m      [-] mastlog on filegroup  should have Growth set equal or higher than 65535 on 69017f5d2a89\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than or equal to 65535, because We expect a certain file growth value, but got 80.\u001b[0m\n",
      "\u001b[91m        755:                                 $psitem.Growth * 8 | Should -BeGreaterOrEqual $datafilegrowthvalue  -because \"We expect a certain file growth value\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 755\u001b[0m\n",
      "\u001b[91m      [-] MSDBData on filegroup PRIMARY should have GrowthType set to kb on 69017f5d2a89\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected strings to be the same, because We expect a certain file growth type, but they were different.\u001b[0m\n",
      "\u001b[91m        Expected length: 2\u001b[0m\n",
      "\u001b[91m        Actual length:   7\u001b[0m\n",
      "\u001b[91m        Strings differ at index 0.\u001b[0m\n",
      "\u001b[91m        Expected: 'kb'\u001b[0m\n",
      "\u001b[91m        But was:  'Percent'\u001b[0m\n",
      "\u001b[91m        751:                             $psitem.GrowthType | Should -Be $datafilegrowthtype -Because \"We expect a certain file growth type\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 751\u001b[0m\n",
      "\u001b[91m      [-] MSDBData on filegroup PRIMARY should have Growth set equal or higher than 65535 on 69017f5d2a89\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than or equal to 65535, because We expect a certain file growth value, but got 80.\u001b[0m\n",
      "\u001b[91m        755:                                 $psitem.Growth * 8 | Should -BeGreaterOrEqual $datafilegrowthvalue  -because \"We expect a certain file growth value\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 755\u001b[0m\n",
      "\u001b[91m      [-] MSDBLog on filegroup  should have GrowthType set to kb on 69017f5d2a89\u001b[0m\u001b[90m 8ms\u001b[0m\n",
      "\u001b[91m        Expected strings to be the same, because We expect a certain file growth type, but they were different.\u001b[0m\n",
      "\u001b[91m        Expected length: 2\u001b[0m\n",
      "\u001b[91m        Actual length:   7\u001b[0m\n",
      "\u001b[91m        Strings differ at index 0.\u001b[0m\n",
      "\u001b[91m        Expected: 'kb'\u001b[0m\n",
      "\u001b[91m        But was:  'Percent'\u001b[0m\n",
      "\u001b[91m        751:                             $psitem.GrowthType | Should -Be $datafilegrowthtype -Because \"We expect a certain file growth type\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 751\u001b[0m\n",
      "\u001b[91m      [-] MSDBLog on filegroup  should have Growth set equal or higher than 65535 on 69017f5d2a89\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected the actual value to be greater than or equal to 65535, because We expect a certain file growth value, but got 80.\u001b[0m\n",
      "\u001b[91m        755:                                 $psitem.Growth * 8 | Should -BeGreaterOrEqual $datafilegrowthvalue  -because \"We expect a certain file growth value\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 755\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Trustworthy Option\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing database trustworthy option on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Database Orphaned User\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing database orphaned user event on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing PseudoSimple Recovery Model\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing database is not in PseudoSimple recovery model on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Compatibility Level\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing database compatibility level matches server compatibility level on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] AdventureWorks2017 has a database compatibility level equal to the level of 69017f5d2a89\u001b[0m\u001b[90m 8ms\u001b[0m\n",
      "\u001b[91m        Expected 'Version150', because it means you are on the appropriate compatibility level for your SQL Server version to use all available features, but got Version140.\u001b[0m\n",
      "\u001b[91m        839:                         $psItem.DatabaseCompatibility | Should -Be $psItem.ServerLevel -Because \"it means you are on the appropriate compatibility level for your SQL Server version to use all available features\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 839\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Foreign keys and check constraints not trusted\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Foreign Keys and Check Constraints are not trusted localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] FK_Employees_Employees foreign key on table [dbo].[Employees] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 6ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        858:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 858\u001b[0m\n",
      "\u001b[91m      [-] FK_Order_Details_Orders foreign key on table [dbo].[Order Details] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        858:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 858\u001b[0m\n",
      "\u001b[91m      [-] FK_Order_Details_Products foreign key on table [dbo].[Order Details] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 3ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        858:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 858\u001b[0m\n",
      "\u001b[91m      [-] FK_Orders_Customers foreign key on table [dbo].[Orders] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 7ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        858:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 858\u001b[0m\n",
      "\u001b[91m      [-] FK_Orders_Employees foreign key on table [dbo].[Orders] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 7ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        858:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 858\u001b[0m\n",
      "\u001b[91m      [-] FK_Orders_Shippers foreign key on table [dbo].[Orders] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        858:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 858\u001b[0m\n",
      "\u001b[91m      [-] FK_Products_Categories foreign key on table [dbo].[Products] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        858:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 858\u001b[0m\n",
      "\u001b[91m      [-] FK_Products_Suppliers foreign key on table [dbo].[Products] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        858:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 858\u001b[0m\n",
      "\u001b[91m      [-] CK_Birthdate check constraint on table [dbo].[Employees] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 2ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        864:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 864\u001b[0m\n",
      "\u001b[91m      [-] CK_Discount check constraint on table [dbo].[Order Details] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        864:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 864\u001b[0m\n",
      "\u001b[91m      [-] CK_Quantity check constraint on table [dbo].[Order Details] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        864:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 864\u001b[0m\n",
      "\u001b[91m      [-] CK_UnitPrice check constraint on table [dbo].[Order Details] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        864:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 864\u001b[0m\n",
      "\u001b[91m      [-] CK_Products_UnitPrice check constraint on table [dbo].[Products] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        864:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 864\u001b[0m\n",
      "\u001b[91m      [-] CK_ReorderLevel check constraint on table [dbo].[Products] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        864:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 864\u001b[0m\n",
      "\u001b[91m      [-] CK_UnitsInStock check constraint on table [dbo].[Products] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        864:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 864\u001b[0m\n",
      "\u001b[91m      [-] CK_UnitsOnOrder check constraint on table [dbo].[Products] within database Northwind should be trusted on 69017f5d2a89.\u001b[0m\u001b[90m 7ms\u001b[0m\n",
      "\u001b[91m        Expected $true, because This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation, but got $false.\u001b[0m\n",
      "\u001b[91m        864:                         $psitem.IsChecked | Should -Be $true -Because \"This can have a huge performance impact on queries. SQL Server won't use untrusted constraints to build better execution plans. It will also avoid data violation\"\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Database.Tests.ps1: line 864\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Database MaxDop\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Database MaxDop setting is correct on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Database Status\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Database status is correct on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Database Exists\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Database exists on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Contained Database Auto Close\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing contained database auto close option on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Guest User\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Guest user has CONNECT permission on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] Guest user should return no CONNECT permissions in AdventureWorks2017 on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\u001b[93m      [!] Guest user should return no CONNECT permissions in model on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\u001b[93m      [!] Guest user should return no CONNECT permissions in Northwind on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\u001b[93m      [!] Guest user should return no CONNECT permissions in pubs on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing AsymmetricKeySize\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Asymmetric Key Size is 2048 or higher on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] AdventureWorks2017 on localhost,15592 Asymmetric Key Size should be at least 2048\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\u001b[93m      [!] model on localhost,15592 Asymmetric Key Size should be at least 2048\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\u001b[93m      [!] Northwind on localhost,15592 Asymmetric Key Size should be at least 2048\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\u001b[93m      [!] pubs on localhost,15592 Asymmetric Key Size should be at least 2048\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SymmetricKeyEncryptionLevel\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Symmetric Key Encruption Level at least AES_128 or higher on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] AdventureWorks2017 on localhost,15592 Symmetric Key Encryption Level should have AES_128 or higher\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\u001b[93m      [!] model on localhost,15592 Symmetric Key Encryption Level should have AES_128 or higher\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\u001b[93m      [!] Northwind on localhost,15592 Symmetric Key Encryption Level should have AES_128 or higher\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\u001b[93m      [!] pubs on localhost,15592 Symmetric Key Encryption Level should have AES_128 or higher\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92mExecuting script C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Instance Connection\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Instance Connection on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] localhost,15592 Is PSRemoteable\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing TempDB Configuration\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing TempDB Configuration on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] should have TF1118 enabled on 69017f5d2a89\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Ad Hoc Workload Optimization\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Ad Hoc Workload Optimization on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Backup Path Access\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Backup Path Access on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Default File Path\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Default Data File Path on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Default Log File Path on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Dedicated Administrator Connection\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Dedicated Administrator Connection on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Network Latency\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Network Latency on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Linked Servers\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Linked Servers on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Max Memory\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Max Memory on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] Max Memory setting should be correct on localhost,15592\u001b[0m\u001b[90m 989ms\u001b[0m\n",
      "\u001b[91m        DivideByZeroException: Attempted to divide by zero.\u001b[0m\n",
      "\u001b[91m        RuntimeException: Attempted to divide by zero.\u001b[0m\n",
      "\u001b[91m        at Test-DbaMaxMemory<Process>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbatools\\1.0.100\\allcommands.ps1: line 72154\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1: line 294\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SQL Memory Dumps\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that dumps on localhost,15592 do not exceed 1 for localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Supported Build\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that build is still supportedby Microsoft for localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SA Login Renamed\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that sa login has been renamed on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SA Login Disabled\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that sa login has been disabled on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] sa login is disabled on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Login SA cannot exist\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that a login named sa does not exist on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] sa login does not exist on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Default Backup Compression\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Default Backup Compression on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing XE Sessions That should be Stopped\u001b[0m\n",
      "\u001b[93mWARNING: You need to use Set-DbcConfig -Name policy.xevent.requiredstoppedsession -Value to add some Extended Events session names to run this check\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing XE Sessions That should be Running\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking running sessions on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing XE Sessions That Are Allowed to Be Running\u001b[0m\n",
      "\u001b[93mWARNING: You need to use Set-DbcConfig -Name policy.xevent.validrunningsession -Value to add some Extended Events session names to run this check\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing OLE Automation\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing OLE Automation on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing sp_whoisactive is Installed\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing WhoIsActive exists on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Model Database Growth\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing model database growth setting is not default on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Ad Users and Groups \u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Active Directory users on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Active Directory groups on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Error Log Entries\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking error log on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] Error log should be free of error severities 17-24 on localhost,15592\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected $null or empty, because these severities indicate serious problems, but got @(@{LogDate=Do not know the Date; ProcessInfo=Do not know the Process; Text=Do not know the Test; InstanceName=An Error occurred [localhost,15592]}).\u001b[0m\n",
      "\u001b[91m        770:     $AllInstanceInfo.ErrorLog | Should -BeNullOrEmpty -Because \"these severities indicate serious problems\"\u001b[0m\n",
      "\u001b[91m        at Assert-ErrorLogEntry, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\internal\\assertions\\Instance.Assertions.ps1: line 770\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1: line 693\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Error Log Count\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking error log count on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Instance MaxDop\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Instance MaxDop Value on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Two Digit Year Cutoff\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Two Digit Year Cutoff on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Trace Flags Expected\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Expected Trace Flags on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Trace Flags Not Expected\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Not Expected Trace Flags on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing CLR Enabled\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing CLR Enabled on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Cross Database Ownership Chaining\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Cross Database Ownership Chaining on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] Cross Database Ownership Chaining should be disabled on localhost,15592\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected 0, because We expected the Cross DB Ownership Chaining to be disabled, but got 'We Could not Connect to $Instance'.\u001b[0m\n",
      "\u001b[91m        743:     $AllInstanceInfo.CrossDBOwnershipChaining.ConfiguredValue | Should -Be 0 -Because \"We expected the Cross DB Ownership Chaining to be disabled\"\u001b[0m\n",
      "\u001b[91m        at Assert-CrossDBOwnershipChaining, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\internal\\assertions\\Instance.Assertions.ps1: line 743\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1: line 820\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Ad Hoc Distributed Queries\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Ad Hoc Distributed Queries on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing XP CmdShell\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing XP CmdShell on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Scan For Startup Procedures\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Scan For Startup Procedures on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] Scan For Startup Procedures should be disabled on localhost,15592\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected 0, because We expected the scan for startup procedures to be disabled, but got 'We Could not Connect to $Instance'.\u001b[0m\n",
      "\u001b[91m        623:     $AllInstanceInfo.ScanForStartupProceduresDisabled.ConfiguredValue | Should -Be 0 -Because \"We expected the scan for startup procedures to be disabled\"\u001b[0m\n",
      "\u001b[91m        at Assert-ScanForStartupProcedures, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\internal\\assertions\\Instance.Assertions.ps1: line 623\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1: line 872\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Default Trace\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking Default Trace on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] The Default Trace should be enabled on localhost,15592\u001b[0m\u001b[90m 7ms\u001b[0m\n",
      "\u001b[91m        Expected 1, because We expected the Default Trace to be enabled, but got 'We Could not Connect to $Instance'.\u001b[0m\n",
      "\u001b[91m        598:     $AllInstanceInfo.DefaultTrace.ConfiguredValue | Should -Be 1 -Because \"We expected the Default Trace to be enabled\"\u001b[0m\n",
      "\u001b[91m        at Assert-DefaultTrace, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\internal\\assertions\\Instance.Assertions.ps1: line 598\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1: line 889\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing OLE Automation Procedures Disabled\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking OLE Automation Procedures on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] The OLE Automation Procedures should be disabled on localhost,15592\u001b[0m\u001b[90m 5ms\u001b[0m\n",
      "\u001b[91m        Expected 0, because We expect the OLE Automation Procedures to be disabled, but got 'We Could not Connect to $Instance'.\u001b[0m\n",
      "\u001b[91m        617:     $AllInstanceInfo.OleAutomationProceduresDisabled.ConfiguredValue | Should -Be 0 -Because \"We expect the OLE Automation Procedures to be disabled\"\u001b[0m\n",
      "\u001b[91m        at Assert-OleAutomationProcedures, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\internal\\assertions\\Instance.Assertions.ps1: line 617\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1: line 906\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Remote Access Disabled\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Remote Access on localhost,15592\u001b[0m\n",
      "\u001b[91m      [-] The Remote Access should be disabled on localhost,15592\u001b[0m\u001b[90m 4ms\u001b[0m\n",
      "\u001b[91m        Expected 0, because We expected Remote Access to be disabled, but got 'We Could not Connect to $Instance'.\u001b[0m\n",
      "\u001b[91m        632:     $AllInstanceInfo.RemoteAccess.ConfiguredValue | Should -Be 0 -Because \"We expected Remote Access to be disabled\"\u001b[0m\n",
      "\u001b[91m        at Assert-RemoteAccess, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\internal\\assertions\\Instance.Assertions.ps1: line 632\u001b[0m\n",
      "\u001b[91m        at <ScriptBlock>, C:\\Users\\mrrob\\Documents\\PowerShell\\Modules\\dbachecks\\1.2.25\\checks\\Instance.Tests.ps1: line 923\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Latest Build\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing Latest Build on localhost,15592\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Login BUILTIN Administrators cannot exist\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that a login named BUILTIN\\Administrators does not exist on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] BUILTIN\\Administrators login does not exist on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Local Windows Groups Not Have SQL Logins\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking that local Windows groups do not have SQL Logins on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] Local Windows groups should not SQL Logins on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Failed Login Auditing\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing if failed login auditing is in place on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] The failed login auditing should be set on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Successful Login Auditing\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing if successful and failed login auditing is in place on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] The successful and failed auditng should be set on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing SqlAgentProxiesNoPublicRole\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Testing to see if the public role has access to the SQL Agent proxies on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] The public role should not have access to the SQL Agent Proxies on localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\n",
      "\u001b[92m  Describing Hide Instance\u001b[0m\n",
      "\n",
      "\u001b[92m    Context Checking the Hide an Instance of SQL Server Database Engine property on localhost,15592\u001b[0m\n",
      "\u001b[93m      [!] The Hide an Instance of SQL Server Database Engine property on SQL Server instance localhost,15592\u001b[0m\u001b[93m, is skipped\u001b[0m\u001b[90m 0ms\u001b[0m\n",
      "\u001b[97mTests completed in 52.59s\u001b[0m\n",
      "\u001b[97mTests Passed: 819, \u001b[0m\u001b[91mFailed: 51, \u001b[0m\u001b[93mSkipped: 24, \u001b[0m\u001b[90mPending: 0, \u001b[0m\u001b[90mInconclusive: 0 \u001b[0m\n"
     ]
    }
   ],
   "source": [
    "$FolderPath = $Env:USERPROFILE + '\\Documents\\dbachecks'\r\n",
    "$SqlCredential = Import-Clixml -Path $FolderPath\\sqladmin.cred\r\n",
    "# Just in case the config has been altered\r\n",
    "$null = Reset-DbcConfig\r\n",
    "$null = Import-DbcConfig -Path $FolderPath\\Weekly-Check.json \r\n",
    "$invokeDbcCheckSplat = @{\r\n",
    "    SqlInstance = 'localhost,15592'\r\n",
    "    SqlCredential = $SqlCredential\r\n",
    "    Check = 'Agent', 'Database','Instance'\r\n",
    "    Show = 'Fails'\r\n",
    "}\r\n",
    "Invoke-DbcCheck @invokeDbcCheckSplat"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".NET (PowerShell)",
   "language": "PowerShell",
   "name": ".net-powershell"
  },
  "language_info": {
   "file_extension": ".ps1",
   "mimetype": "text/x-powershell",
   "name": "PowerShell",
   "pygments_lexer": "powershell",
   "version": "7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}