{"id":3870,"date":"2014-01-09T13:04:57","date_gmt":"2014-01-09T12:04:57","guid":{"rendered":"http:\/\/contoso.se\/blog\/?p=3870"},"modified":"2014-01-09T13:08:12","modified_gmt":"2014-01-09T12:08:12","slug":"logging-in-service-management-automation-sma","status":"publish","type":"post","link":"http:\/\/contoso.se\/blog\/?p=3870","title":{"rendered":"Logging in Service Management Automation (SMA)"},"content":{"rendered":"

In Service Management Automation (SMA) there are a couple of different ways to write to a log. In this blog post I will show you how to write to the job history tab and how to write to an external SQL database.<\/p>\n

If you have published a runbook you can use Write-Verbose, Write-Progress and Write-Debug as shown in figure 1 to write log message. The result of write actions will be shown in History for each runbook job, example shown in figure 2. Figure 3 show important settings to make this work, you need to enable logging on the runbook, else you will see no log messages in the job history.<\/p>\n

\"\"<\/a><\/p>\n

Figure 1 Write to log examples
\n<\/em><\/span><\/p>\n

\"\"<\/a><\/p>\n

Figure 2 Log examples
\n<\/em><\/span><\/p>\n

\"\"<\/a><\/p>\n

Figure 3 Log settings
\n<\/em><\/span><\/p>\n

Another alternative for logging is logging to an external database. We have earlier used the same logging solution for Orchestrator runbooks<\/a>. Figure 4 shows a SMA runbook that writes to a SQL database named SMALOG. As you can see in figure 4 the “writelog” SMA runbook use three parameters, Runbook, Job and Description. Other runbooks invoking this runbook need to provide current runbook, current job ID and a log message description. To get the current runbook name and job ID you can use the code shown in figure 5. The writelog runbook use the Get-Date to get current time. The log database is shown in figure 6.<\/p>\n

\"\"<\/a><\/p>\n

Figure 4 SMA runbook writes logs to SQL database
\n<\/em><\/span><\/p>\n

\"\"<\/a><\/p>\n

Figure 5 Get current runbook name and job ID
\n<\/em><\/span><\/p>\n

 <\/p>\n

\"\"<\/a><\/p>\n

Figure 6 Example of log database
\n<\/em><\/span><\/p>\n

Download examples here. Logging<\/a>\u00c2\u00a0. Note that this is provided “AS-IS” with no warranties at all. This is not a production ready solution, just an idea and an example.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

In Service Management Automation (SMA) there are a couple of different ways to write to a log. In this blog post I will show you how to write to the job history tab and how to write to an external SQL database. If you have published a runbook you can use Write-Verbose, Write-Progress and Write-Debug … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[62],"tags":[],"_links":{"self":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3870"}],"collection":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3870"}],"version-history":[{"count":2,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3870\/revisions"}],"predecessor-version":[{"id":3873,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3870\/revisions\/3873"}],"wp:attachment":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3870"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}