Microsoft 365 Community Microsoft Teams, 28 Oct 2021

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: Automatically recognize your team champions 🏆 with CLI for Microsoft 365

Description

In this 12-minute demo, Albert-Jan Schot shows how with existing cmdlets in CLI, query criteria and a business objective (to identify champions), Tenant Admins can modify general site wide reporting (i.e., chat, file activity) to precisely identify the top active Microsoft Teams contributors or SharePoint users within a timeframe. For chat ranking in a channel - count messages, replies, likes and comments by contributor. Via Webhook, send Adaptive Card to top three performers in time period. This PnP Community demo is taken from the General Microsoft 365 Development Special Interest Group (SIG) - Bi-weekly sync call recorded on October 28, 2021.

Demo Presenter: Albert-Jan Schot (BLIS.digital) | @appieschot

Supporting materials:
• Tool - CLI for Microsoft 365 | https://aka.ms/cli-m365
• Repo - CLI for Microsoft 365 | https://github.com/pnp/cli-microsoft365
• Article - Recognize active team members with the CLI for Microsoft 365 | https://www.cloudappie.nl/recognize-active-team-members-cli-microsoft-365/
• Article - Recognize contributions using the CLI for Microsoft 365 | https://www.cloudappie.nl/recognize-contributions-clim365/
• Article - How to send Adaptive Cards with CLI Microsoft 365 | https://techcommunity.microsoft.com/t5/microsoft-365-pnp-blog/how-to-send-adaptive-cards-with-cli-microsoft-365/ba-p/2143466
• Tool – Adaptive Cards IO Designer | https://www.adaptivecards.io/designer/

Learn more:
• Learn more about the Microsoft 365 Patterns and Practices community at: http://aka.ms/m365pnp
• Visit the Microsoft 365 Patterns and Practices community YouTube channel: https://aka.ms/m365pnp-videos

A

So there we go. Let me share my screen and we should all be good. Now I didn't prep any slides. I just wanted to walk you through some some demos, so it's gonna be demo heavy.

A

I think it was two or three weeks ago that that my friend tommy actually did a session on xiaomi dashboard who on who was active in in microsoft teams and it all started with us discussing okay, you have people working in teams and if they are working in teams, is there a way to actually see what they are doing and adding um adding points to that so give them. Let's say an activity bonus or things they are doing now?

A

If you would go to teams what you typically do on teams, is you create files, or you have chat messages, you're you're chatting having meetings stuff like that now envision, a way where you could actually hand out points or identify who is active? Now with that, let's say challenge, I started looking at cli to see what we could do with with the cli and it turns out.

A

There are already quite a few things in the cli that you can either abuse or actually use to generate reports like that now out of the box in your tenant. There are some reports available for you that you can use to get some insights into your activity. Now you can actually read those reports using the cli. So if you install the cli, let me quickly show you: if you go to pmp.github.io, slash, cli micro 365, you actually get an overview of all the things you can do.

A

I already installed everything not going to spend time on that. But if you have the cli installed and you are logged in, you can actually talk to your tenant and what I can do is, I can say, m365, sharepoint online report and I'm gonna say activity.

A

That's always hard user detail. You have to specify a period and then I can say: okay give me the last seven days of things that are happening on my tenant around sharepoint online. So what I get is I get an overview and, as you can see, I get two entities because I have two demo accounts on my environment and I can see some deal deals like last activity date. I can see synced files shared internally files.

A

I can do things like external file count and I have pretty much the same account if I want to do things around teams, so I can do the teams report user activity, user details. Oh sorry, I have to specify a period as well, so I'm going to do mine, oops, minus d7, instead of an end, ampersand, that's better, and that would return a somewhat similar json structure with only different properties. So, instead of files, I now get uh private chess messages. Teams, chat messages, so that's all stuff that I already get out of the box.

A

Now. Imagine that I have a report like this and I wanted to do anything with it. So I want to actually report based on this information. Now what you can do with the cli is, you can actually send adaptive cards and when you want to send adaptive cards, you need to design an adaptive card. So you do need to do some things with an additive card designer, but once you have that in place, you can actually send those adaptive cards to teams and in order to send them to teams, you need a web hook.

A

I'm going to show you in a second, but there was this really nice write-up by louise cda, how to send adaptive cards with cli for microsoft, 365, which is basically all the things that we need. It's it's creating a web hook, making sure that we have some adaptive card json that we can actually send add some data to that adaptive card and then send it to uh send it to your teams.

A

Now, if I go to the designer there is this really cool website, where you have a designer that you can use to design your adaptive cards, making sure that it looks pretty. There are some samples out there that you can abuse as well. Now, in my case, I just went with a really really simple or simple uh setup, but what I wanted to do is I wanted to get some details, so I wanted to get that report that we just saw.

A

I wanted to map that to to a specific adaptive card, and then I wanted to make sure that I wanted. I can actually send it now. What I did is I going to paste it in here as well, so the first thing that I'll need is I'll need a webhook url. I've already created that so for the cycle. For the sake of time, I'm gonna I'm gonna, skip that. Then what I needed to do is I'll need to get that report, and actually I need to do something with that report.

A

I wanted to with that report. As you can imagine um here we go. Let me get the team's one with that report. I want to do something with some of the properties. So let's say I want to get the private chat message, count and use that as the most used property so I'll need to sort this result set, and I want to sort it on either the team's chat message counter or something else.

A

So it depends on on what you want to sort on, but if you would want to sort in teams on the team's chat message count, it will look like this. I'm going to open my code, it's going to be easier. Let me get this out of the way. So what I'll need to do is I'll need to get that team's report.

A

User activity details need to specify a period and then what I'm going to do is I'm going to pass in a query where I'm going to say: okay, the first thing we're going to do is we're going to sort by the teams, chat, message, gown and then I'm gonna reverse it so that I at least get the most sent or the user that sent the most teams chat messages and then what I'm gonna do is I'm gonna get the top three of that and I'm gonna.

A

Do the user principal name and I'm gonna convert that from json, then the next thing that I'm going to do is I'm going to use that cli command called m365 adaptive card send and what I'm going to do is I'm going to send a well I'm going to send that to a url, a web book url and I'm actually going to send that card now? If I would send this, this is gonna, be the top three sharepoint based on file interactions and I'm not sure if I did a lot of things on my tenant.

A

But what I can do looks there is a typo in there as well. Let me get what the typo is: it's the convert from json. There should be a space in there or there could be an enter from.

B

A

This should be better. Let me do this now. What this will do is they will retrieve the data and then it will. It will send it. There is a question: what permissions are needed to get this report data um the it's using the out of the box report, data that is available so you'll need, I think, to be a sharepoint administrator if you're getting the sharepoint reports. If you do the teams reports, you need to be a teams administrator. If your global admin, you can see anything by default.

A

Currently it will filter out the user display or the upns. So there is this checkbox to anonymize the reports. If you want to use this approach, you and you want to get identifiable data you'll need to actually disable that otherwise it won't show. But with this what we now did is: okay, we sent the sharepoint weekly social champions, meaning that I at least get some get some insights.

A

Now what you can also do and that's a bit more of a complex one- you could actually go through all the data in a team and then use a custom scoring model. So it's pretty much the same approach. We're gonna rank people in a team for what they're doing now, I'm gonna I'm gonna, ignore this one.

A

So what I do is I get all my tea or I get my teams get uh get some details, then, for each team, I'm gonna process that team and I'm gonna say: okay, I need all the team details and I'll need wrong. One I'll need this one. So what I need to do is I'll need to get a specific team, I'm not going to process all teams. I want to get one specific team, then I'm going to say: okay, how long am I gonna look back?

A

Do I need to get champions for the last year or for the last 50 days or the last seven days, so you can rim this report periodically now what I'm gonna do is I'm gonna gonna get all the channels for that specific team, then for each channel I'm gonna get all the messages, because you need all messages to actually get details from and then that's where it gets interesting. If you retrieve all the messages, you also need to get some message details.

A

I'm gonna show you later, but the first thing that we're going to do is for each message, I'm going to say: okay, if the message was created by a user instead of a chatbot or a backend service, then I'm going to do something. So if I do have a user id, which is the is only filled if you're, actually a real user who logged in and did something, then I'm gonna do something so I'm gonna set the type to post, I'm gonna say: okay, there were details with the reaction type. What was the user?

A

That did something and I'm gonna specify whether it was a subject, because I think any post in a team's channel should have a subject then for each reaction, which is all the likes and comments. I'm gonna add that to my results as well, then. Finally, I'm gonna get all the replies for each message and I'm going to add those as well, because a reply should count as well, then running that you will have all messages, all replies all likes and comments and all likes on all comments that you would have now with that data.

A

You can then say: oh, let me get some user details and then I'm going to say I'm going to create my own scoring model, and this coordinated is slightly, let's say slightly simplistic, we're only going to say we are getting. uh Are we counting or we are valuing your your post? Now you would say: okay, a post counts for two points. A subject counts for an additional pound. As additional point, your reply count for an additional account.

A

Your reaction only counts for a half a point, so it's not uh not something that you uh count or or score really high, but with that what you can then do is. If you would run this, this will actually post somewhat a similar result, and it will tell me okay, who are the most active users in this specific team, now steve you're, totally right. If you want to run this against all teams in your environment, then it could potentially be come fairly slow. So what you could do is you get?

A

You could get this information and you could add some additional logic you could see if a team has any activity in the last week and if not not process it. If it does have uh activity, then you can get some again can get some details now running this. It's already done means that I can now see. Oh apparently I and someone else did something in this specific team. I sent some messages and I actually replied that now this is all running from my local machine, it's all running in my powershell window or my terminal.

A

Actually, you could also run this in a logic app, so you could have a logic app and quickly show you that here you can have a logic app where you could create a container, so an azure container within the azure container you can get the cli running. There is a docker container available for the cli. You would need to set up a managed identity, but given time no time for that- and that would be my demo conclude the results.

A

Imagine this kind of thing in m language and power, bi yeah. It was really cool to get this data to let's say teams, dataverse and query power bi against that. Definitely a good scenario.

B

Awesome, thank you appy. This is really really cool stuff. Is there anything the cli cannot do eventually we're going to be applying for jobs and they're going to say no. No thanks. We've got the cli from 365.

A

We can do anything if you want.

B

To help out there.

A

Are a lot of good first issues to to see and get your bets for that as well?.

B

Absolutely thank you. Awesome.