Zoomtopia is here. Unlock the transformative power of generative AI, helping you connect, collaborate, and Work Happy with AI Companion.
Register nowEmpowering you to increase productivity, improve team effectiveness, and enhance skills.
Learn moreKeep your Zoom app up to date to access the latest features.
Download Center Download the Zoom appDownload hi-res images and animations to elevate your next Zoom meeting.
Browse Backgrounds Zoom Virtual BackgroundsEmpowering you to increase productivity, improve team effectiveness, and enhance skills.
Zoom AI Companion2022-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!!