{"id":3616,"date":"2013-06-16T18:54:59","date_gmt":"2013-06-16T16:54:59","guid":{"rendered":"http:\/\/contoso.se\/blog\/?p=3616"},"modified":"2013-06-17T10:48:20","modified_gmt":"2013-06-17T08:48:20","slug":"show-status-of-the-last-review-activity-with-a-pinch-of-orchestrator-magic","status":"publish","type":"post","link":"https:\/\/contoso.se\/blog\/?p=3616","title":{"rendered":"Show Status of the last Review Activity (with a pinch of Orchestrator magic)"},"content":{"rendered":"

A friend\u00c2\u00a0asked me if it is possible to show the status of a related\u00c2\u00a0review activity in the “All\u00c2\u00a0Open\u00c2\u00a0Service Requests” view?\u00c2\u00a0After a while we\u00c2\u00a0realized that a\u00c2\u00a0requirements was to show the status of the last review activities, so if there were multiple review activities we just wanted to show the last one. The reason why they needed this view was that customer called service desk and asked about service requests. With a view like this the operator could easy see if all the manual review activities was completed, if the service request was still waiting on more\u00c2\u00a0approvals\u00c2\u00a0or if someone was building\/working on\u00c2\u00a0the requested service.<\/p>\n

We started by extending the Service Request class in Service Manager with two new properties, one to show the last review activity status and one to show when we last updated that status.<\/p>\n

\"20130616_SRStatus03\"<\/a>We use a runbook to update these properties<\/p>\n

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

Comprehensive description of each activity in the runbook<\/p>\n

    \n
  1. Monitor Date\/Time. The runbook runs every 30 minutes<\/li>\n
  2. Query Database. Truncates a database that is used to store data temporary. The runbook use a database table to store review activity information temporary.
    \n    \"20130616_SRStatus04\"<\/a><\/li>\n
  3. Get Object. Gets all open Service Requests, from the extended Service Request class.<\/li>\n
  4. Get Relationship. Get related Review Activities for each open Service Request<\/li>\n
  5. Update\u00c2\u00a0Object. If there\u00c2\u00a0are no related review activities it will update the “LastStatus” property with “No Review Activities”<\/li>\n
  6. Get Object. If there are related review activities it will get the review activity and write review activitiy and Service Request information to the database<\/li>\n
  7. Junction is used to merge all threads together to one<\/li>\n
  8. Format the current time\/date to a format that works with Service Manager<\/li>\n
  9. Query Database. Query the database to get last review activity for each Service Request and status of it<\/li>\n
  10. Update Object. Updates each Service Request that is in the database with review activity status<\/li>\n<\/ol>\n

    The result in the Service Manager console can look like this<\/p>\n

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

    You can download my example runbook and Service Manager class extension here, 20130616_SRStatus<\/a><\/p>\n

    Note that this is provided \u00e2\u20ac\u0153AS-IS\u00e2\u20ac\u009d with no warranties at all. This is not a production ready management pack or solution, just a idea and an example.<\/p>\n","protected":false},"excerpt":{"rendered":"

    A friend\u00c2\u00a0asked me if it is possible to show the status of a related\u00c2\u00a0review activity in the “All\u00c2\u00a0Open\u00c2\u00a0Service Requests” view?\u00c2\u00a0After a while we\u00c2\u00a0realized that a\u00c2\u00a0requirements was to show the status of the last review activities, so if there were multiple review activities we just wanted to show the last one. The reason why they needed … 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":[60,25],"tags":[],"_links":{"self":[{"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3616"}],"collection":[{"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3616"}],"version-history":[{"count":5,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3616\/revisions"}],"predecessor-version":[{"id":3624,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3616\/revisions\/3624"}],"wp:attachment":[{"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}