Fetch last activity date in all Teams teams

Robin Couvreur 26

Hello everyone,

As a Teams administrator, I am looking for a way to monitor my Teams environment. For that purpose, I would like to fetch a list of all the teams with the last activity date (last message or last shared documents) in my environment.

If someone could help me, it could be great!

Thank you all in advance

JimmyYang-MSFT 48,551 Reputation points Microsoft Vendor

2022-04-15T07:47:07.467+00:00

Hi @Robin Couvreur

According to your description, your question is related to Teams API development, which is not in our support scope. So I will also add office-teams-app-dev tag to your thread. Thanks for your understanding!

1 answer

Vasil Michev 94,836 Reputation points MVP

2022-04-14T13:31:33.07+00:00

The easy way is to fetch the Teams Usage report data via Graph: https://www.michev.info/Blog/Post/3805/at-long-last-teams-usage-reports-are-available-via-the-graph-api
As the documentation is not published yet, I'm not certain at this point whether per-date queries will also be available (as in using the (date=2022-04-01) format), but the metadata document hints they should be.

Other than that, you can Tony's activity report script: https://office365itpros.com/2022/03/14/microsoft-365-groups-teams-activity-report/
Please sign in to rate this answer.
Robin Couvreur 26 Reputation points

2022-04-14T13:40:22.153+00:00

Hello @Vasil Michev

The problem of the first command is that the Teams ID are not well displayed (only 0000-0000...), and the team name is also not the good one...

Vasil Michev 94,836 Reputation points MVP

2022-04-14T14:57:13.76+00:00

Not sure what you mean by that. The Graph API endpoint will return both the name and the GUID, here's an example:

Robin Couvreur 26 Reputation points

2022-04-14T15:19:17.767+00:00

Yes normally it should... But I got this:
{
"value": [
{
"reportRefreshDate": "2022-04-12",
"teamId": "00000000-0000-0000-0000-000000000000",
"teamName": "16DF5E74C57A5EADE85973788D834C46",
"lastActivityDate": "2022-04-12",
"teamType": "Public",
"details": [
{
"activeSharedChannels": 0,
"activeExternalUsers": 0,
"reportPeriod": 90,
"activeUsers": 3,
"activeChannels": 1,
"channelMessages": 0,
"reactions": 0,
"meetingsOrganized": 0,
"postMessages": 0,
"replyMessages": 0,
"urgentMessages": 0,
"mentions": 0,
"guests": 0
}
]
},
As you can see, the name and the GUID does not make any sense... I got this for each team.

Vasil Michev 94,836 Reputation points MVP

2022-04-14T16:13:36.023+00:00

Ah, that's the "anonymization" setting at work: https://learn.microsoft.com/en-us/office365/troubleshoot/miscellaneous/reports-show-anonymous-user-name

Robin Couvreur 26 Reputation points

2022-04-15T07:25:32.297+00:00

Perfect, it works now!

But what does exactly "last activity date" mean? I suppose it is not only the last sent message date?

Vasil Michev 94,836 Reputation points MVP

2022-04-15T07:51:05.163+00:00

Any activity within the Team, which should include things such as reactions, meetings, etc.

Robin Couvreur 26 Reputation points

2022-04-19T08:22:17.93+00:00

And reading the messages in the conversation also counts? If you have details about this call, do not hesitate to refer me to it.
Sign in to comment