PowerShell/SCSM - Get Review Activities Rejected in the last 60 days

In the following post I demonstrate how you can retrieve all the rejected Review Activities from the last 60 days. I also include the DisplayName, the Decision and the Comment of the Reviewer.

Hope this help some people out there.

# Smlets Module

Import-module -name smlets

# Capture the SR Failed Status

$RAStatusFailed = Get-SCSMEnumeration -Name ActivityStatusEnum.Failed$

# Capture the date from where we are searching

$RAModifiedDay = (get-date).Adddays(-60)

# Get the Manual Activity Class

$RAClass = Get-SCSMClass -Name System.WorkItem.Activity.ReviewActivity$

# Get the Criteria Class

$CriteriaClass = “Microsoft.EnterpriseManagement.Common.EnterpriseManagementObjectCriteria”

# Define the filter

$Filter = "Status = '$($RAStatusFailed.Id)' AND LastModified > '$RAModifiedDay'"

# Create the Criteria Object

$CriteriaObject = new-object $CriteriaClass $Filter,$RAClass

# Get the Reviewer relationship classes

$RAHasReviewerClass = Get-SCSMRelationshipClass System.ReviewActivityHasReviewer$

$ReviewerIsUserClass = Get-SCSMRelationshipClass System.ReviewerIsUser$

# Get the RA rejected in the last 60 days

Get-SCSMObject -criteria $CriteriaObject |

    ForEach-Object -Process {

        # Current Review Activity

        $RA = $_

        # Get the rejected review(s) on this RA

        $RejectedReview = Get-SCSMRelatedObject -SMObject $RA -Relationship $RAHasReviewerClass | Where {$_.decision.displayname -eq 'Rejected'}

        foreach ($item in $RejectedReview)

        {

            # Get the reviewer information

$ReviewerObj = Get-SCSMRelatedObject -SMObject $Item -Relationship $ReviewerIsUserClass

            

            # Create a new PowerShell Object

            [pscustomobject][ordered]@{

                ReviewActivityName = $RA.Name

                ReviewerDisplayName = $ReviewerObj.displayname

                Decision = $item.decision.displayname

                Comments = $item.comments -as [string]

            }

}

    }#| Format-List

Thanks for reading! If you have any questions, leave a comment or send me an email at fxcat@lazywinadmin.com. I invite you to follow me on Twitter @lazywinadm / Google+ / LinkedIn. You can also follow the LazyWinAdmin Blog on Facebook Page and Google+ Page.