Query open ReviewActivities by user

I am struggeling with some users that dont finish their review-activitys on time. At the moment I have to dig through the "in progress-activiets" but im thinking about creating a query that gives me the users that have in-progress review activitys and so i can contact them directly.
Does anybody have a idea what path i should take ? WIll this be something with Powershell or more lile SQL ?
I would actually prefer Powershell.
Thanks in advance
Andreas
Best Answer
-
Konstantin_Slavin-Bo Customer Ninja IT Monkey ✭✭✭✭
Hi Andreas,If you have SMLets (if not, you should), something like this should give you what you need:
ipmo smlets
The script gets all active RAs, and builds an array of objects with RA ID and array of reviewers.
1
Answers