I am currently trying to put together an entitlement review for all of our vendors or non-full time employees. I was able to spin up a scheduled task that does exactly what I want it do to except if the manager has more than 1 direct report, I would like them to be grouped in 1 email and in a table or an attached CSV file. Below is a sample of the wording that I would like to send out to the listed manager.
Please review access for the following user. If the following user no longer reports to you, please contact the Helpdesk and ask that the user be transferred to their current manager.
Username - %sAMAccountName%
First Name - %givenName%
Last Name - %sn%
Expiration Date - %accountExpires%
If user Manager1 has 3 direct reports (User1, User2, User3), I would like Manager1 to get 1 email monthly to review that the 3 direct reports are still indeed employed and on the account.
Thanks!