PowerShell Activity - SR AffectedUser

Paul_Dalkin

HI, just in the very early days of experimenting with this - if the PS Activity is contained within the WF of a SR, will it take the AU 'as is' for the functionality required (e.g. setting an expanded Exchange mailbox quota) or will the AffectedUser need to invoked in the script from the parent SR work item before carrying out the work required?

Brian_Wiest

Here is something to get you started
This script grabs the created by user of a CR and creates a relationship for assigned to user.
Just modify the class to SR and perform the function you would like to accomplish. 
the Param ID is "Parent Base ID"

Param([guid]$id)

Import-Module SMLets

$crcl = get-scsmclass -name system.workitem.changerequest$

$cr = get-scsmobject -class $crcl -filter "id -eq '$id'"

$createdByRel = Get-SCSMRelationshipClass -name system.workitemcreatedbyuser$

$createdyByUser = get-scsmrelatedobject -SMObject $cr -Relationship $createdByRel

$assignedByRel = get-scsmrelationshipclass -name system.workitemassignedtouser$

New-SCSMRelationshipObject -Relationship $assignedByRel -source $cr -target $createdyByUser -bulk

Remove-Module SMlets

Brian_Wiest

Here is something to get you started
This script grabs the created by user of a CR and creates a relationship for assigned to user.
Just modify the class to SR and perform the function you would like to accomplish. 
the Param ID is "Parent Base ID"

Param([guid]$id)

Import-Module SMLets

$crcl = get-scsmclass -name system.workitem.changerequest$

$cr = get-scsmobject -class $crcl -filter "id -eq '$id'"

$createdByRel = Get-SCSMRelationshipClass -name system.workitemcreatedbyuser$

$createdyByUser = get-scsmrelatedobject -SMObject $cr -Relationship $createdByRel

$assignedByRel = get-scsmrelationshipclass -name system.workitemassignedtouser$

New-SCSMRelationshipObject -Relationship $assignedByRel -source $cr -target $createdyByUser -bulk

Remove-Module SMlets

Paul_Dalkin

Thanks Brian!

Alexander_Becker

Hi Brian, i used your Script and recieved the following error: "Cannot bind argument to parameter 'Class' because it is null." When i try to run your script direct from the powershell console, your script is working. Do you have a solution for the problem?

Brian_Wiest

Do you have SMLets installed on your primary management server? and are you testing SMlets while logged in as the workflow account? I have run into edge cases where SMLets will only install as the logged in user profile as not as everyone. So its best to log in as the service account and test running powershell in a non admin console and see if it loads the module. 

Robin_Fakler

Alexander please try to use the ID of the used SCSM Class instead of the name:

$SCSMclassSR = Get-SCSMClass -Name "System.WorkItem.ServiceRequest$" # Error: Cannot bind argument to parameter 'Class' because it is null.
$SCSMclassSR = Get-SCSMClass -ID "04B69835-6343-4DE2-4B19-6BE08C612989"  # Working

Alexander_Becker

thank you. I used the ID instead of the name and now it works.