Home Service Manager

Seeing 'Blank' Reviewers in Review Activities

Tony_CollettTony_Collett Cireson Support Super IT Monkey ✭✭✭✭✭
Occasionally if a review activity isn't populated with an approver and it is set to In Progress, SCSM automatically populates the activity with a 'blank' reviewer. 

Is there any way to see (either with Powershell or a good advanced search filter) all of the requests that have this blank approver where the RA is In Progress?


Best Answer


  • Geoff_RossGeoff_Ross Cireson Consultant Super IT Monkey ✭✭✭✭✭
    Hi Tony,
    I've not seen this behaviour but will try and replicate it later as I'm intrigued. 
    As for the PowerShell its totally possible but gets a bit complex as linking a User to an RA as a reviewer is a 2 step process programmatically. an RA Object is related to a Reviewer Object with a relationship of class System.ReviewActivityHasReviewer and then the Review is related to the User with the class of System.ReviewerIsUser.
    So you need to get all RAs In Progress, and for each, find the Reviewer object related with System.ReviewActivityHasReviewer. If it has one, you need to check if there is a User related with System.ReviewerIsUser and if there isn't, then this situation has occurred. Add this RA to an array and continue looping. At the end of the loop, the array will contain all the RAs with a blank approver.

    Hope this helps, let me know if you need any more help turning the pseudo code into PowerShell.

  • L_SchickL_Schick Member Advanced IT Monkey ✭✭✭

    I found this link which has a powershell script that may help


    Otherwise if you use Orchestrator you can get all in progress review activities -> get related reviewers -> Then get AD Users or Groups where the "Relationship Class" does not equal "Is User" and dump that to a list. This should give you all the related reviewers that are not User or Group objects

  • Adam_DzyackyAdam_Dzyacky Product Owner Contributor Monkey ✭✭✭✭✭
    I have a script to get all RAs In Progress with no reviewers and show the parent WI, but if I'm not mistaken you're actually referring to an empty object is actually in the list of reviewers right? Something you can click on in the list, but is not defined whatsoever?

    If not I'll post the PowerShell!
  • Tony_CollettTony_Collett Cireson Support Super IT Monkey ✭✭✭✭✭
    Thanks for the responses. To clarify, I'll show you an image of what I'm talking about: http://imgur.com/rf7r8o2

    This happens when a Review activity goes from Pending to In Progress and doesn't have a reviewer beforehand. 

    I would like to be able to find all the reviewers where the name is blank. Only need to print out a list at this stage. I'll have a look at creating a Runbook that does that - thanks L_Schick. 

  • seth_coussensseth_coussens Member Ninja IT Monkey ✭✭✭✭
    That script should do it for you...
  • Tony_CollettTony_Collett Cireson Support Super IT Monkey ✭✭✭✭✭
    I've been able to find them with an Advanced Search for the criteria:
    RA = In Progress AND Reviewer > Is User > Display Name is Empty. 

    I tested the script provided by Adam, and it seems to display All RAs In Progress. I didn't have time to modify it to include the empty Reviewer object. 

  • Candice_YeudallCandice_Yeudall Customer Advanced IT Monkey ✭✭✭
    Every review activity that we add gets that, but I guess that would because the default change request automatically creates a Review activity, it is really annoying for our people to have to go in and change it every time. BTW this happens in both the console and portal so it is something with in SCSM itself.
Sign In or Register to comment.