{"id":1875,"date":"2010-09-23T15:14:38","date_gmt":"2010-09-23T13:14:38","guid":{"rendered":"http:\/\/contoso.se\/blog\/?p=1875"},"modified":"2010-09-23T15:14:38","modified_gmt":"2010-09-23T13:14:38","slug":"notification-on-all-unassigned-incidents","status":"publish","type":"post","link":"http:\/\/contoso.se\/blog\/?p=1875","title":{"rendered":"Notification on all unassigned incidents"},"content":{"rendered":"

I saw a question in the forum today about notification on unassigned incidents. This is difficult to do from the console because there is no support for subscribing to the absence of a relationship. If you want notification on all unassigned incidents that are older then X hours you could instead use a custom script. The script could then be triggered by a workflow in Service Manager. In this post I can build a simple script that I will add to a workflow. The script will run every hour and see if there are any unassigned incidents that are older then 2 hours.<\/p>\n

    \n
  1. Open Service Manager Authoring Tool and create a new management pack, in my case Contoso.Unassigned<\/li>\n
  2. Right-click Workflows and create a new workflow<\/li>\n
  3. In the Create Workflow Wizard, General, input a name, for example ContosoUnassignedIncidents<\/li>\n
  4. In the Create Workflow Wizard, Trigger Condition, select Run at a scheduled time or at…<\/li>\n
  5. In the Create Workflow Wizard, Trigger Criteria, select Other interval and 1 Hours<\/li>\n
  6. In the Workflow window, from the toolbox, drag and drop the Windows PowerShell Script\"\"<\/a><\/li>\n
  7. In the properties of the script activity, paste the following script into the script body field
    \n

    $smtphost=”LUDSRV206″
    \n$to=”kurt@contoso.local”
    \n$from=”svc-wf-ludsrv204@contoso.local”<\/p>\n

    function Send-Mail
    \n{
    \nparam($From,$To,$Subject,$Body)
    \n$smtp = new-object system.net.mail.smtpClient($smtphost)
    \n$mail = new-object System.Net.Mail.MailMessage
    \n$mail.from= $From
    \n$mail.to.add($To)
    \n$mail.subject= $Subject
    \n$mail.body= $Body
    \n$mail.isbodyhtml=$true
    \n$smtp.send($mail)
    \n}<\/p>\n

    Import-Module SMLets
    \n$BeforeDate = (get-date).AddHours(-2).ToString(“yyy-MM-dd HH:mm:ss”)
    \n$getIncidents = Get-SCSMIncident -Status “Active” -CreatedBefore $BeforeDate | where { $_.AssignedTo -eq $NULL } | select ID, Title, AffectedUser<\/p>\n

    if ($getIncidents.count -gt 0) {<\/p>\n

    $subject= “Unassigned incidents in Service Manager, total of ” + $getIncidents.count
    \n$body=$getIncidents|convertto-html
    \nSend-Mail $from $to $subject $body<\/p>\n

    }<\/p>\n

    Remove-Module SMLets<\/p><\/blockquote>\n<\/li>\n

  8. Modify the following parameters to fit your environment\n