Home› General Discussion

Query open ReviewActivities by user

Andreas_VoigtAndreas_Voigt Customer IT Monkey ✭
in General Discussion
Hello there everyone, 

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-BoKonstantin_Slavin-Bo Ninja IT Monkey ✭✭✭✭
    Accepted Answer
    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.

Answers

  • Konstantin_Slavin-BoKonstantin_Slavin-Bo Customer Ninja IT Monkey ✭✭✭✭
    Accepted Answer
    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.
  • Andreas_VoigtAndreas_Voigt Customer IT Monkey ✭
    Thanks a lot, thats exactly what i needed. Working fine now
Sign In or Register to comment.