Forum Discussion
Create automated usage report from Microsoft Teams
I am looking into a way to create an automated report that creates a usage report that you can run in the MS Teams admin center 'https://admin.teams.microsoft.com/analytics/reports' and somehow send that data in an email with a CSV or just sample report.
This would be a report for a call queue and not against a singular user etc.
From what I can see I can get the data like any usage report for a call queue and export it manually in the admin center but I can't find any commands to trigger a usage report etc, but I can use Get-CSCallQueue to get info on a Call Queue.
Is there anyway to do this at all, maybe I could use an API but not touched that before and mostly use the Teams powershell Module.
https://learn.microsoft.com/en-us/powershell/module/teams/?view=teams-ps
I have a script I started working on but still testing it out.
# Specify the Call Queue ID
$CallQueueID = ""
# Retrieve the specific call queue
$callQueue = Get-CsCallQueue -Identity $CallQueueID
# Compile the data
$queueData = [PSCustomObject]@{
QueueName = $callQueue.Name
QueueID = $callQueue.Identity
# Add more fields as necessary
}
# Create an array to hold the report data
$report = @()
$report += $queueData
# Export the report to a CSV file
$report | Export-Csv -Path "C:\Path\To\Your\CallQueueReport.csv" -NoTypeInformation
# Output the report to the console (optional)
$report | Format-Table -AutoSize
- There is no supported way to get the data out of this report programmatically. What Microsoft positions as solution for this task is the Auto attendant and Call queue historical reports PowerBI pack :https://learn.microsoft.com/en-us/microsoftteams/aa-cq-cqd-historical-reports
- There is no supported way to get the data out of this report programmatically. What Microsoft positions as solution for this task is the Auto attendant and Call queue historical reports PowerBI pack :https://learn.microsoft.com/en-us/microsoftteams/aa-cq-cqd-historical-reports
- TechyTroublezBrass Contributor
Thanks for taking the time to review my post and assist me.
I had a feeling this was the case but wanted to ask around as I could not see any commands at in the module for teams or API etc.
I will take a look into the BI method and mark your answer as a solution!
Cheers
Dean
- AndiW16Copper Contributor
Although this is not available in Microsoft Teams at the moment, there are third party apps available that can provide reports. In addition some have the capability to email reports on a set schedule.
Have a look in the apps store for Call Analytics or try this,
Hope this helps
Andi