In your organization, users have been provisioned with either G Suite Enterprise, G Suite Business, or no license, depending on their job duties, and the cost of user licenses is paid out of each division's budget. In order to effectively manage the license disposition, team leaders require the ability to look up the type of license that is currently assigned, along with the last logon date, for their direct reports. You have been tasked with recommending a solution to the Director of IT, and have gathered the following requirements: Team leaders must be able to retrieve this data on their own (i.e., self-service). Team leaders are not permitted to have any level of administrative access to the G Suite Admin panel. Team leaders must only be able to look up data for their direct reports. The data must always be current to within 1 week. Costs must be mitigated. What approach should you recommend?

Question

Quizplus · Accepted Answer

Using App Script and filter views within a Google Sheet allows team leaders to access the necessary data in a self-service manner without requiring administrative access, while keeping costs low and ensuring data is current.

In Your Organization, Users Have Been Provisioned with Either G