Discover Zoom success stories and upcoming events! Explore our Customer Success Forum & Events page.
Visit NowEverything you need to work together, all in one place.
Explore Zoom One's Collaboration ToolsConnect virtually from anywhere with Zoom Meetings
Collaborate together with Zoom Chat
Call the world with Zoom Phone
Create and brainstorm with Zoom Whiteboard
Rich conversation analytics to improve sales
Send and receive messages and calendar invitations
Collaborate over video without scheduling a meeting
Remove the hassle of traditional scheduling with Zoom Scheduler
Simplify communication and drive engagement with Workvivo
Innovative video solutions for every meeting space.
Bring meeting spaces online with Zoom Rooms
Conference Room Connector links existing rooms to Zoom
Innovative solutions for every space
Solutions to host impactful virtual and hybrid experiences.
Find a Solution for Every EventHost hybrid and virtual events with Zoom Events
Elevate your brand with single session events powered by Zoom Sessions
Broadcast at scale with Zoom Webinars
Host and attend classes, group events, and more OnZoom
An omnichannel cloud solution optimized for video.
Engage customers with Zoom Contact Center
Deliver intelligent support with conversational AI
Optimize contact center agent performance and engagement
Zoom solutions elevate collaboration across vertical use cases.
Discover Zoom Industry SolutionsEnabling exciting new ways to teach, learn, and connect globally
Transforming client engagement and employee experiences
Improving collaboration between agencies, ministries and constituents
Connecting care, collaboration, and medical innovation
Real-time communication, anywhere in the world
Bridging the in-store and online experiences
Expert support and services for all your design, strategy, implementation, event, and hardware needs.
Global Services
Hardware purchase and subscription options
Flexible subscription plans for hardware
Protect certain data at rest with your own encryption keys
An open platform that allows developers to build Zoom apps and integrations.
Explore thousands of apps that work with or within Zoom
Documentation for building with Zoom's technology using SDKs, APIs, and webhooks
Post your questions and get help from our developer community
Zoom Partners bring Zoom's communications platform to market through alliance, sales, and service partnerships.
Explore Zoom's technology ecosystem
Find a trusted Partner
Learn about Zoom's Partner Programs
Access marketing & sales resources
Login to the Partner Portal and click 'Learn'
Discover new ways to use Zoom solutions to power your modern workforce.
Access expert-led tutorials on Zoom products and features.
Network with other Zoom users, and share your own product and industry insights.
Get documentation on deploying, managing, and using the Zoom platform.
Keep your Zoom client up to date to access the latest features.
Download CenterDownload hi-res images and animations to elevate your next Zoom meeting.
Browse Backgrounds2022-10-12 07:05 AM - last edited on 2023-08-09 01:40 PM by RN
Hello all,
I am attempting to create a report that shows all users' total phone call time, as well as their license, to determine if a user's current license is not a good fit for them. For example, a user with a 'Metered' license having 2500 minutes called would be better off on an 'Unlimited' license (and vice versa).
I don't believe such a report exists; but if such a report (or combination of reports) does exist, it would simplify this process significantly. The 'phone system usage by users' report yields the total call time, but does not contain the users' licenses. I am unsure if the desired report would require use of the API, which I am inexperienced with.
Any insight would be greatly appreciated -- thanks for reading!
Solved! Go to Solution.
2022-10-13 06:26 AM
I have been playing with this a bit and while it will take a little effort on your part, I think I have a possible solution. Export both the usage report and your phone users. Copy columns A-D from the user export to a new sheet on the Excel document for usage so both exports are part of the same excel document. In column E of the new sheet use the following formula "=VLOOKUP("*"&A2&"*",Usage!A:K,"11",0)", change the word "usage" to match the sheet name for your usage report. You will also need to format col E to Time 13:30:55 in order for the results to display properly.
Hope this helps!
2022-10-12 11:55 AM
Hi Impressive,
You are correct that no such report exists. You could potentially run the report you mentioned and then export your users from the users menu. With some good excel skills, you could then create a formula to pull the matching plan based on the user name. I would also suggest that you fill out the feature request form here https://zoom.us/feed.
2022-10-13 06:26 AM
I have been playing with this a bit and while it will take a little effort on your part, I think I have a possible solution. Export both the usage report and your phone users. Copy columns A-D from the user export to a new sheet on the Excel document for usage so both exports are part of the same excel document. In column E of the new sheet use the following formula "=VLOOKUP("*"&A2&"*",Usage!A:K,"11",0)", change the word "usage" to match the sheet name for your usage report. You will also need to format col E to Time 13:30:55 in order for the results to display properly.
Hope this helps!
2022-10-13 06:50 AM
Hi @ChrisO ,
I really appreciate your response. I sent in a feature request, as you suggested. I feel like such a report makes a lot of sense to have, for cost management and analysis.
Regarding your other suggestion, this is effectively what I've been doing -- utilizing Excel to do a little magic between the two reports. It's not perfect, but I think it will get the job done. My approach was slightly different, so I'll have to give yours a try -- thanks so much!
2023-01-17 08:23 AM
Hi Impressive, could you share a sample of the final report that you use that shows both usage and license type for Zoom phone? Thank you!!