get user information list sharepoint powershell

Requirement: From a business requirement, we need to generate a report for department-wise users of an Intranet portal site. Say, How many users from the “Sales” department have access to the SharePoint Intranet portal? Solution: Either query the user profiles store or user information list to get the user profile properties such…