 Hey, everybody, well, thanks for those that are dialing in. Thanks for joining us. This is episode 17 of the Microsoft Community Office Hours. We're going to do this vote. Yeah, almost. It's AMA stuff, so ask us anything. That's right. If there's anything you need to know about the American Music Awards, this is where you want to go. Unfiltered. That's right. That's what we're all about. Yeah, we can take crack. Yeah, we can take crack at it. What's that little sound? I sent one of these electronic messages. Oh, wow. Yeah. Oh, fancy. And who did you message, Riz? It was an email. And it was an undisclosed participant. Actually, it was a note to thank him for laughing at my joke. Yeah, that's good. Lots of hearts and sort of kisses and things. Well, Mike and I were just talking. Mike, are you coming on screen? Are you shy this morning? Or what? I'm on. My camera's on. Is it? I don't see it. Well, it shows it. I got the little box showing up. What the hell? I see a little sort of. Your initials look great today, but that's all we see now. Yeah. Why does it not show? If you start up, hey, Sean, let's start things out light. Hey, the t-shirt today. So I finally talked about it. And I think if you guys, the giving here, let me switch. Yeah, nice. Yeah, it's it's blue polo shirt day here. As you can see, as I as I disappear, I disappear. That's nice. Is my camera showing up? No. But you know, the M and the N are really, I think that the Minnesota represented the font really comes out today. It looks great. Yeah. I've got more t-shirts on the way. So do I? I'm drowning in t-shirts. I actually got a reply on Twitter from Quartee, the folks that I ordered from in Great Britain. They pinged me back. They asked you to stop mentioning their name. Partly. So, well, hey, well, just from these videos alone, literally dozens of people will see those t-shirts. So I know, you know, it really does. There's nothing putting us. We're talking discount. Wait, no, wait, I was including us. So putting us OK. Oh, well then, we're still talking discount. Handfuls of people. Yeah. No, so the first, so Mike and I were just chatting about before you guys jumped on about there's an MVP call going on to discuss the latest news coming out of the team's world. So yes, Mike, you're waving a lot. We see you now. Excellent. It is good to see you. I didn't want to interrupt you. Now there's no sound. We shouldn't have told them. I would just left them there. Wait, wait, wait, you got to see the t-shirt. All right, let's see it. Awesome, man. Oh, wow. That is Ignite 2018 from MS Learn. And you'll notice it's got the old keyboard. It's the retro. Yeah, the old computer icon. Oh, yeah. Explorer. And then wait. If anybody can tell me what that is. What's that icon from? Can you see that? Yeah, that's the networking icon. That's the old network neighborhood. Wow. Yeah. Old school. And do you have any ideas? The Matt's headroom grids in the background. Sorry, Eric, what was that? My apologies there. I was going to say it's pretty funny to watch as he stands up, all three of our heads go. Yeah. Yeah. Everyone's in the same position. True. And so we're saying we need to synchronize while we all do this at the same time. Just kind of go like this. Forehead synchronization. No, but so the latest news coming out of Microsoft Teams around the, what is it, the together mode and some other features of some cool stuff that's coming out that I think we've talked about this in the past. Of course, you saw Microsoft react to the needs of the community for the three by three videos. And then you're going up to seven by seven. And they're talking about now, I saw something else in the news that they're going to be up to hundreds that you'll be able to have in interactive. So that's a busy screen. Well, but it's not on the screen. Not on the screen, but they're going to expand the number of people that can be in the meeting. Oh, OK. So I think it'll be whatever you have on screen. And then it'll be like it is now where other people that are not participating actively will be in the people mode, you'll be able to see them all. So it still sounds like some serious multiplexing jiu-jitsu. I think I saw 300 active and 1,000 participants. OK. Wow. But I like the roadmap has 6.9 million little boxes on the screen. Yeah, that's a couple years away. But they're going towards a 6.9 million view. It's going to be. We need a gigabit ethernet cards in our machines to manage the streams IPv6. Yeah. Excellent. Why not? I'm still waiting for the psychic interface. Psychic interface. It works. Watch, Christian. Eric, I told you we're not bringing that up. Table that maybe next week. I got a quiz. Yeah, a quiz. Team's quiz that happened last week. They had a change. They announced a change. I want to see if anybody gets it right. So what is the name of the top role in teams? What governs all other roles in teams? What's the name of it? Can I phone a friend? Is it deity of some kind? No, it's a role. It's kind of like an Azure role. It's actually, everything was called Team Service Administrator. So Team Service Administrator was like the God role. And they are now officially renaming that to Teams Administrator. So that made big news. Well, they realized that the acronym TSA wasn't really a good one. Yeah. Yeah. Not only that. The only video conference that comes with a body cavity search. That was part of what made it more personal to me. I felt like I was, you know. I'm just going to be TA. So you guys actually say, are they a T&A and A? Or just a TA? What are you teaching? Wait, I need my sound effect. Where's my rim shot? Hang on. Wait, wait. It just takes too long every time. Is this not queued up? Got to have this at the ready. Is this on? It's from rim shot. That was it. Sorry. Oh, man. Weak sauce. It's really weak. Yeah. That's the best I can do. Yeah. All right. So if there is anybody watching on the streams, all three of you. Now let me see how many there are. No, we've got about a dozen people in two locations. Feel free to ask a question, post it. And we'll try and address those. But other than that, gentlemen, any questions? Anything that came up for this past week that you would like to discuss? I had actually an issue come up. Somebody asked me about it. I could not find an answer to until I found in some kind of obscure technical document out there. You can actually take the 32-bit version of Office now and convert it to 64 without even doing the whole uninstall and install. And I did not know that. Oh, really? So they were running 32-bit. They're Excel. They were running this thing with macros. It was taken forever. It was a DBA. And they were like, hey, I bring this thing in. Why is it so freaking slow? And I'm like, couldn't figure it out. I'm like, what are you doing? They're telling me all this. And I go, go into Task Manager. Take a look at the process for Excel. And it's like peaked out. It's using GPU. It's going nuts. And sure enough, I'm like, well, what does the line say? And I do a screen share. I'm looking at it, it says Excel 32-bit. Like, oh, dude, you've got to switch to 64. And I'm like, well, that means I've got to uninstall Office. And I've got to reinstall Office. And I'm like, they have to have found a way. So yes, you can do it. You download the Office custom install kit or whatever they call it, that one executable. And it's a switch now. That allows you to switch from 32-bit to 64. Uninstall 32, drop 64. You keep your same settings. You're golden. That's nice. It's not something you'd think about every day anymore. I know back when we were doing the switch to 64 and making more use of resources, memory, whatnot, it was on everyone's mind. But I don't think many people think about that anymore until they go into their Task Manager and look at some processes. And they peek out on memory usage. Well, I mean, does everybody remember that Microsoft used to recommend 32-bit? They would be like, when Office first came out in 32 and 64, they're like, oh, no, no, no, no, use 64. We put it out there, but don't use it. Yeah, I still have that irrational fear of 64-bit. Yeah, so. For Office only. Yeah, there were a couple. I'm trying to remember what it was. There was some feature, something that Tom Duff and I shared in our productivity tips, where there were two features over the last three years that were 32-bit only. I'm like, Microsoft, what are you doing? Yeah. But it was just some cool little Office feature. I think it's almost like it was kind of in the labs days. It was some preview stuff that was out there and that not quite ready for primetime. But I'll see if I can find those. I think I'll go back to Office 2013 or something. There are two questions which are similar, like to talk about. So I'm pulling questions down from the Office 365, as well as the Microsoft Teams communities in Facebook. And that's for those that are watching this recording, not on YouTube, after the fact. You can ask questions, post questions over there. We stream live there. But the first one over in the 365 community from Mirko says, high in Teams, the File tab is mapped to the folder general in SharePoint. Is it possible to change this to the root level of the library? And so the second question, which relates to this, says, this is from Ollie over in the Teams community. When I search for a file in Teams, the result shows what team the file is in, but not which channel. Any idea how I could quickly find the channel name? So we've seen versions of these questions of what is the mapping of files within Teams? And what's the logic? And I think from these questions, we need to do a better job of educating end users of this is how the information architecture of Teams. And so here's the logical flow of where you'll find files and its SharePoint counterparts. So the first question of, can you change the direction or change the mapping of a folder down to the root level? And of course, Paul Stork swooped in, answered a bunch of questions around this. But his first response is, channels in Teams are hard-coded to map to folders, and that cannot be changed for any channel, even the general. Anybody disagree with that? Any? No. If you want to iframe something, you could stick a SharePoint URL in there that points to a lower nested folder and get at it, or perhaps up higher. But that's not the, you're kind of working around the problem rather than actually dealing specifically with it. Right. Well, I think that's it. Eric. Sorry about that. If you were to remap it, then you potentially mess up your whole IA, because everything is built off of that document library and that structure. So think of your connectivity into OneNote, where you open up a team and the channel, and then all your channels are neatly aligned. If you start remapping and playing with things and you won't have alignment there, and you won't have any defaults. Well, I'm assuming that the goal, this person's goal, is that, look, I have all this documentation across these multiple channels, but I want them all to go to the one place down to that root. And certainly there are permissions issues there. There's people that should only have access to those things that are happening in that channel and not another. But for the reasons you stated, it wrecks the information architecture. If your goal, though, is to have like a shared services, I always use the example of a project management organization where there is a central place where all of our project files or all of our templates for our documentation are stored. And then you can create a different library and you can have that map to a tab as well as in files. And then you just, through training, instruct people, hey, when you're going to save your files, it needs to go to this location or pull your templates from this directory. And you can make that part of your provisioning process so that any new team that's created automatically has that tab and that files link folder in place. But no, you can't, for all the reasons that we've just stated, not remap that drive. Yeah, we're totally good at telling you why you can't do it. But unfortunately, we don't have a solution as to how you can do it. Yeah. Aside from the iframe. Yeah. Right. Yeah. So the other question is, is there a way to quickly see which, so when I search for a file in Teams, the results show what team the file is in, but not which channel? Any idea how I could quickly find the channel name? So he's saying use case, I want to store the file dogs.doc next to the file cats.doc. I don't know which channel cats.doc is in. Define features, we'll do that now, right? This control app? Is there a control app function now? I have no idea. Out there was. I mean, it says in the notes, they were implementing. Maybe they had to roll it out, but it's a control app feature that's supposed to search all of your teams for keywords. And I don't know what that covers also files. But I have a link to the actual article where they talk about the release of it. Do you want to share that? Yeah, I'm going to right here. Here it is. Contextual search is coming to teams control app. It was published back in May and it says they updated it. They rollout starts late June, completed by mid July. Yeah, I've got it in my time. And it will allow for contextual search within a specific chat or channel. Once initiated, the search query results will be limited to the focus chat or channel. So you'd have to search each channel. Yeah, so that kind of rolls up. I mean, is there, but you can do a search across a team. Yeah, yeah. Johnny on the spot. Yeah, this is my first thought is that you want to know where it is. Well, you can search at the team level. And then I don't know what the state is of the broader search, the office.com search, which should search across everything that you have access to in theory. I don't know. I've not been keeping up on what's there, but that should be the roll up so that you're able to look and do one search from everything within SharePoint, within Teams, within Yammer, within your desktop that's been shared via LinkedIn. Anything you have access to as well as, well, through Office doesn't have public internet searches part of that. I know with Bing Search, you can enable that. So it'll also look, it'll do an external search as well as internal. But again, I don't know what needs to be set up if anything needs to be set up to be able to do one. Sean, does SharePoint allow for, I mean, SharePoint allows it would go out and do one drive. It would do anything that's related to SharePoint, right? Anything it's got a crawler for, yeah. But I mean, the search in there would should allow you to search anything that's tied to SharePoint, which would include Teams. The files. Anything you've set up a content source for, yeah. Yeah, OK. I'm posting the links and a couple of feeds here. We do have a question. Eric asks, what, and not Eric Riz, just to be clear. Are you sure? He's right here. He might ask the same question, but here, Eric from over from the Facebook community says, what tricks do you use to help logging into multiple tenants? Oh, boy. Boy, is that a key. Yeah, I know what it was. Come on, Riz. Come on. Yeah, you know it was me. Doss box. I'm going to upgrade here. I don't need any more of that. Thank you. Using Doss box. Something that is, yeah. This is something that I know that Microsoft is looking at providing some additional solutions for. Some people go in and create multiple profiles and windows. Other people would just open up multiple browser tabs. Yeah, I use Rambox. Rambox, that's it. Yeah, I've got it open on my desktop right now. Yeah, so Rambox is a free tool that's out there for people don't know. So it uses a lot less memory than having Chrome tabs open. I don't know how it performs against the new Edge browser, because I've been using it really before the full release or the latest release of the Chromium-based Edge. But yeah, so Eric, I would say check out Rambox. It's a great tool for that. I have three or four different teams, profiles, that I utilize throughout every single day. And so I just switch between tabs if there are notifications. And I also have every messaging service up there. So I have my Gmail, my Facebook mail, my LinkedIn mail. I have Hootsuite, and I have these teams. Anything else that's in it? I don't have it open. You're using the web version of Teams then. You're not getting the full fact experience doing that, right? Correct, but the ability to use the other account credentials without having to sign out. I get that, but when this thing kind of bubbled up back in March, right? So we were doing our big summit. And that to me was like one of my big versus a lot of people's burst exposure to Teams and the limitations of Teams. One of the things was, well, in order to do chat, you couldn't use the web client. You had to use the back client. Well, you couldn't do multiple accounts. And if you did, you weren't considered a guest. You weren't considered an actual, they wouldn't let you in because all would have said guest and it had a Gmail address or some other address that wasn't a company address. So I thought they were coming up with a way that you'd actually have Teams, the back client, being able to manage that for you. What you're trying to do is you're just kind of doing a workaround, right? You're just doing the browser tabs and you're just going around. Right, it's a, yeah, correct. You're right. That's what I said at the beginning. We're waiting for Microsoft to have a solution for that. For years. Yeah, in the meantime, yeah, we've been, this was a feature that we identified within the first 90 days of Teams going live three years ago, three and a half years ago. I remember being at the MVP summit. I remember asking the question. And I remember them saying that technical difficulties were not trivial. Yeah, the short answer is use your mobile device. Yes. And while you're all laughing, it is a good answer. It's all the places you need to be and it gets you the quote, unquote best experience that you can have. Yeah, it's very fast. Eric is not done with us. He has another question. Here's another one. Python scripting to connect to Microsoft Graph. Am I not? Sorry, I just want to clarify. As soon as you said Python scripting, you knew it was me. Of course, of course. You just jump at the word Python. The Python scripting across your shirt, it's implied. It's not literally on your shirt, but it's implied that it's there. Therefore, we knew it was you. No, so Python scripting to connect to Microsoft Graph. Am I nuts to try this? I have to create a migration tool from discussion forum to Teams. I don't think he's nuts. I mean... I think those are two separate questions. Thank you for the scripting. Is he nuts? We've been through this, Sean. You've made that mistake before. True. True that. Yeah, scripting-wise, no. I don't think you're nuts to do that. It's... Microsoft has made a number of different libraries available that can be called from multiple platforms and scripting languages. Python's no different than any other one. I use PowerShell. I'll use PowerShell to go through Graph. So Python should be able to do it just fine. I'm not particularly skilled at Python. I only got into it a bit for working with my son in Minecraft and mods and things like that, but it is a viable language. A lot of people use it. Should work. Here is an interesting question, and I'm looking through some of the responses. Oh, and by the way, Hal. Hey, good morning. Hey, Hal. Hi there. Oh, we're having fun here, folks. The delay was the fact that Teams is fighting me again this morning. Oh. Frozen on my screen. Yeah, your face hasn't moved in five minutes, but good. Yeah, I know. That's the policy again. It's because I have a video turned on. And then Mike disappeared. Here comes Amazon with my UPSs. Nice. Oh, which reminds me, I need to go get that SSD that you recommended, Sean. Anyway, I may have another question for you afterwards. Here's a question that's Teams and SharePoint related. So Eddie posted this question. I have to, it says I've run into an issue with Teams and SharePoint that Microsoft cannot figure out. All right. We'll figure this out. Good, great. Yeah, I moved folders and documents from a channel to a private channel within the same team. The files exported out do not reappear in the team channel they were moved in. After some searching, they are listed in the correct channel in SharePoint within the site content section under documents. Microsoft support has not been able to troubleshoot why the files are not listed in the team channel. Does anyone have any thoughts or suggestions? And they were, somebody asked like, how did you move them? And he replied, says from within Teams using the move feature in the dropdown. So that's kind of a snap in your face, Microsoft. Used your own tool to move it. Oh, God. That's interesting. I'm trying to think of what was going on there because the folders, you know, channels and folders are synonymous. But the way that SharePoint handles folders is less than, oh man, less than transparent. My latest blog post, I wrote it a while ago, but it got into the object model of files, folders and whatnot. And it's very interesting, the relationships and how things interact within the object model. I don't know what was going on. I would have to actually get more information to know. It depends. Yeah, thank you. Where's my error horn? That's a, we have to have the it depends sound effect. All I can do is, You know that we don't hear it, right? We can't hear that. We're smiling at you, but we don't actually hear it. We're just being polite. I don't have to set up in this thing. I need to set it up so that each one of these, that it's in OBS, that it also includes the sound through the Elgato. So I don't have that set up. Yeah, apologies. Yeah. So there was a sound effect. You guys would be thoroughly impressed. That's all you need to know. Yeah, you can go back in and edit this later. Yeah, I'll do that. As you know, I do a lot of that kind of editing. Yeah, so Paul Stork responded to this one as well. And he said, boy, lecturing us, Paul. Private channels files are in a completely separate site collection. Did you find the files in the original team SharePoint site collection of the private? And Eddie responded. It's in the private channel SharePoint. So he went through and did screen sharing with Microsoft and they weren't able to determine what was going on. So Jacob says, so by opening your private channel in Teams, go to files, you don't see the files, then click open a SharePoint. And he says that the files appear on the correct SharePoint under the site contents documents, but they just don't appear in the all documents for the SharePoint. Therefore, they don't show up in the Teams, so. I don't know what's going on behind the scenes there if they've got some form of, they've got a cache that they build. The good news is, I know exactly who to speak to Microsoft to get him an answer. And I won't reveal that person's name. Oh, so what good are you? For their own safety. However, I can reach out to that individual and maybe get back to us next week with response. Or later today, and we can share it this evening's whether if you're not able to make it, Eric, if you would do that. I love when you say not able to make it. It's 9 p.m. here, dude. Yeah. And? That was it. That was just a statement of fact. Fair enough. Yeah, that would be great. Eric, if you can do it today, if you can't get a response today, let us know and we'll talk about it next week. Any other questions? And now, Mike is back and Hal's gone, so they might be the same person. Yeah. I'm thinking no on that one. Just a guess, but my spidey senses. Are they tingling? Indeed they are. Much about. Thank you. So what everyone, what are your thoughts about the fact that the Tron 3 is back on, that they're going to be, they're now looking at casting that. There's rumors that Jared Lido, I'm not a fan of Lido, will be part of that. But the fact that it was supposed to be a trilogy, and then, and now it's back on, they're going to do it. It was canceled, now it's done. Let me get a browser open. Tron 3. Are you actually speaking English right now? What? Exactly. Holy smokes. Did you guys hear that hockey is restarting? Is that ice hockey? Yes, the one that's played on the ice. I thought Mike was frozen there for a minute, but his eyes are moving, he's breathing something. So was it, was ice hockey, was that, did that go away? Was some of their problem with refrigeration in the North, Eric? What was going on? No, we keep good ice up here, but evidently the world had a pandemic and they weren't allowing us to play such things. So- How am I just hearing about this just now? True, true. Our avid viewers will know that I'm a hockey player. You know, our frequent listeners and such. The fan mail tells me of these things. So I've been off the ice since March, which is the longest time forever since then. No, no, no, go back to Tron, please. That's more relevant right now. I had no idea they were doing that. You ice hockey? No, Tron. I mean, I like ice hockey, but Tron. That's something else. Here's a question, another team's question. Somebody asked, my team message was deleted and I want undue messages. How to undo a deleted message? That day since? Recycle bin. Is there a recycle bin for your messages? Well, I mean, they're stored, where are they stored? So there's the word. First question, though, is it, are you talking about the threaded message of the discussion within a chat? Or are you talking about a chat? Do you have any indication there? No. Oh, well, then it depends. Ding, ding, ding. We should have a swear jar for it depends. That's right. Something. I've got a lot of quarters. I can. Actually, there's a shortage of. Yeah. Yeah, but that's not real money. No, this is from my monopoly set. I heard there was an actual shortage of change right now in the U.S. Because it's all at my house. Luckily it's going to the safe. That's where the safe is, people. It's in my car. Yeah, I've got those upstairs. Yeah. Similarly full. It's crazy. I think like what a rip off those machines, those coin machines at the grocery store, they take like 10% or 15%. And then when you get things like this full or even bigger, you know, like that five gallon water jug if anybody's done that and filled one of those before, you know, and then you're thinking, there's no way in hell I'm going to roll all these. Take them to the grocery store and sit there, cough it up and take it to coin store. Yeah. Coin store, that's right. That's great. Hey, what's going to show one other, some new toy? You guys might appreciate these. So this was a new purchase. So the little, this is the, what is it, teenage engineering pocket operator. So I was looking for a, just a modern sounding little drum but inexpensive drum machine so that I can use it for beyond a click track, do something a little more a little bit fancier for bass and guitar and keyboards, my synths and stuff. And so this, so the actual, as you see, they're hooked up. You can actually run a, I don't know, I've seen videos with five or six of these things of different sound effects. So I've got my rhythm, which is just the drum track and then I've got the sub, the bass, little sounds and I've got another chorus that is ordered that allows different tones. So you could program these things in and sync them up. So, and then with the export, plug it right into my computer. I can sample it, I can, you know, do the recordings or in with live, it's just, it's a whole lot of fun. So if anybody has experience with these and would like to connect with me and talk about them, you know, my little journey of learning how to use these things and program them, it's a whole lot of fun. Where'd you find them? On the Amazons. Yeah, that was looking at a bunch of some older, I was looking to buy like a TR-505, but one of the older like 80s drum machines for some of those classic sounds and came across these things. The difference being that, you know, buying a drum machine that does something comparable in the hundreds of dollars and these things are like 50 bucks a piece. Very neat. It's a fun little, little gadget to play along, so. Keep me apprised of that. I am definitely interested. What you're essentially saying is that you have untold gizmos at your disposal and you can't get that to do, shh. Right, that's what I'm saying, yes. How hard can it be? Christian, everybody's an argument. Good job. Yeah. No, you know what it is? It's the filtering that Teams has and it filters out a lot of the background noise and we've discovered that with music and other things. And that happened with, well, like Facebook live streams so they filter out a lot of that and it has to do with improper usage of music rights, licensing rights. And so they provide that AI filter that knocks out most of the sound. It's not that it's crappy background sound. It's not a crappy microphone. It's the AI that's filtering a lot of that out. It's why you guys don't hear it when I hit the buttons. A year ago, you'd hear all that stuff but it would pick up dogs barking and people walking in the background, background noise and a lot of that is filtered out now. I hear that. And then I have my little button here. Do what you love. Do what you love, bro. You create your reality. Ha ha ha ha ha. Oh boy. Post affirmations, awesome. First Stuart's bonus. A socket, sandwich. Wait. There you go. We have gone off the rail. We have a picture. Gone off the rail. All right. Let me check with any other questions. Wow. So this is how you can tell when there's no other questions, folks. Ha ha ha ha ha. Please. And all that really means that Liam isn't watching from somewhere. That's right. That's the deal. Other people. See, so Sherman, Sherman that we all know. There's not some other Sherman out there. I think there's just one Sherman. So hey Sherman, thanks for watching. Just tried to that move operation from all from within teams and it worked. So that's the first thing I was gonna do. Obviously I'm running this, there's recording in team so I'm not gonna go and mess around and try and experiment, but. Thanks for the data point, Sherman. Yep. So that would be, I've got in my demo environment, I've got, I can go and try and recreate that and see if I come up with the same result. Cause something else just kind of to that point is that there are little things which should work and occasionally with your tenant, something might not work the same way. So it might be a tenant level issue, but should be easy enough to go and move from an open channel to a private channel and see if the file show up. All right, so no other new questions. If there are, if you are watching, we've got another 20 minutes. If you have a question you'd like us to try and address then feel free to ask. Hey, Sean, I see that you've joined the chat over in the book of faces. I've actually had it open the whole time. Oh, well, you just showed up in there. So. I guess leaving the window focus does something. Yep. Something else, so somebody asked the question, can I pop out a team like you can do with the chat? Talking about being able to now do the pop out chat, has everybody gone and used that new feature? Yeah. No, so it doesn't work here yet. Yeah, so here's what I found. So it doesn't work as in the guest tenants, it has to work when you're fully logged in. So one, and then two, I was kind of hoping, I knew it wouldn't work this way, but I was hoping, it was fingers were crossed that I could then switch tenants and it would still leave it open. No. Nope. So it was, yeah, so I was almost excited about that feature. I can see that. It kind of goes back to what we were discussing earlier of using Rambox or multiple browser instances, Windows, to log into multiple teams environments. I would still love to have a Hootsuite like interface that where I could track chats or team discussions, channel discussions in a column, but across multiple tenants all in one view. That's the ideal, that's the world we need to live in. Let's build it. Something to aspire to. Yeah, like I said, it's somebody wants to, I don't have the ability to go and build it. I suggested that and had the product team members say, it's like, that's a really good idea. It's like, yeah. You're the idea guy. I just want it to exist. So somebody wants to build that. Lucky, I found a good drum piece for you here. Ready. Did you want to tell the joke first? Any joke whatsoever? And then we can hit drums or no. Hashtag ice cream. How's that? Does that work? Yeah, that wasn't a Phil Collins-esque. Yeah. You can always play an 8-Bat soon. Yeah. Oh my gosh. Yes, we could. Yeah. All right. Oh my. Let's see. Any other questions? Oh, there's a question about mail merge. One has racially volunteered to answer that question. Yeah. Step back. How about this? This is one that I know is pertinent to all of us. Does it with the U.S. and, and, Canadian represented. Does anyone know when Excel money is going to include access to U.K. bank accounts? I want to know people. I actually spoke to the Queen about that this morning. And it seems to be, it seems to be tied up in legislation. Boris. You had to talk to Boris. The Queen has not been to do with that. Such a good mood though when I spoke with her. Yeah, Queen's just a figurehead. You're just, you know, she's talking to the Monarchy. Well, Boris is on the money here. Yeah. Oh, we're in trouble. Oh, somebody is asking about, there's a video, it's a demo with Microsoft with their demo system. And Georgie was asking, I want to add, I want the share to teams button in Outlook, like in this video, but I can't see it in my Outlook add-ins. Is it really? And it's because, if anybody's looking, I don't believe it's deployed yet. So this is one of those examples, I believe, correct me if I'm wrong, if it's starting to be deployed, it's out there, but it's like a summer feature, I believe they've said summer, but it's not deployed yet. And so Microsoft has talked about it and shared it. And obviously it's in an internal demo environment that Microsoft is using. However, it's not yet generally available. So if they go into the options and they go into add-ins, they don't see an add-in that says Microsoft Teams meeting add-in for Microsoft. No, it's not that. It's the specific of the share to Microsoft Teams. So this is the ability where you can go and if you receive an email and that you can share it to teams specifically. So it's the addition of a little button that allows you to share it here, I'll share it. I don't have it either. So I thought maybe you can add it, but no. Here's the question for those that are watching the stream and see it, but yeah. So the reason you're not yet seeing is because it's not yet available. Yeah, I'm waiting for it as well. I don't have it in my tenant. Yep. I don't believe it started rolling out yet. Makes sense. But yeah, so that it's what's out there what was released initially was the share, pushing things out to be shared to Outlook so that you can send notification. It's the idea is to pull people into teams saying, hey, there's this thread that's going on, join this discussion or check out this discussion that's happening over in teams. So somebody that might not be part of that team, but might want to respond to that with a link back to the team conversation. And this is just from the other direction, being able to take something that's not yet in teams, push it from Outlook. You should really have that across all Office apps. Because you should be able to share out anything, the teams Excel, Word, PowerPoint, you name it. You should be able to just say share to teams. Well, it took forever. This started with OneNote, right? We've had shared OneNote for years. Yeah, but realistically, I mean, you'd want to share just about anything you create. So yeah, they wouldn't even took it further and they had a web clipper for teams. And I'll say you can actually be on the website and say share to teams and just share them. What would be the right behavior? So if I have a, say a PowerPoint deck that I have locally and I want to share that to teams, then what's the right behavior? So for people to be able to get access to that, part of that process is not just sharing, say, hey, take a look. It might be in bed, they can view only. It would could automatically share it to my OneDrive to make it shareable out there. So it'd be multiple steps. You're not just sharing something locally. They'd have no way of accessing that. So it'd have to be a sharing it as a link. So if it would then have to move it to a location where it's accessible out in teams or elsewhere. And that kind of makes sense with way offices now because office, you can set up the services, right? So, excuse me, I would already have a service set up for my OneDrive and it would just see that and would just say, okay, I can link directly to your OneDrive, right? Because it's all in office, you know, the entire office, we can see those services whenever you open Excel or PowerPoint or Word or you access or whatever, when you go to File, Open, it can see those services that you've added. So I think that teams should be able to do the same thing. Well, we'll eventually be able to do the same thing. Just dance to reason. Logical, to me, Christian doesn't seem sold on the whole idea. You know, I mean, if you think about the behavior today, to be able to share out and to collaborate and co-edit, collaborate on something, it has to either be, you know, it has to be uploaded into teams or it has to be in a, The SharePoint site. Got to be a cloud resident. Right, yeah. So, yeah. So I agree with you. Just the added complexity is that if it's local. So there has to be some in-between stage that alerts you that, hey, you're sharing something that was private, local, out to this place. I do that today. If I am in Word, then I have that on my C drive, the document, and I want to share that. When I click on that Share with someone, it tells me that it's uploading it to OneDrive. So it automatically takes that step, puts it into your OneDrive and then shares it out. So you just need to add it to that step that as teams is a destination. Let you navigate to the right place for that to be shared. Yeah. That makes sense, yeah. Yeah, that makes sense. Sometimes they make sense, you know, just once in a while. Whoa, whoa, whoa, Mike, that was the one time. How old are we? Don't forget, we're gonna start tracking this now. Eric, you still have the score from two weeks back. Yes, add one point for Mike. All right, we're 1812, 00. I won't say. Yes. And we lost you. I need more coffee. I think he passed out and he froze at the same time. I'm gonna be driving my coffee, guys, come on. Hey, the other Eric asks, is anyone played with IoT and single board computer? Like an Andrew, no? Or do we know? Well, depends on who you talk to. Is it Azure or is it Azure? It's Azure. Yeah. I have not. Yeah. Ask Brzeznovich that question. He gets picked. He's at a point where he gets pissed off about it. He's like, Ash, damn it. Yeah. I understand that. I think where the confusion it comes from is that Azure is the name of the bad guy in what is it, the flight of the last Starfighter, the Disney film from the 80s. Really? Wow. Here is that. I got on my Plex server, Mike. Yeah, it's actually, it's good. I mean, it's like the, it's the, you know, Tron being the first movie that included the full, you know, the computer graphics. So this is not much better than that. In fact, I don't think it's as good as Starfighter. He's playing the video game. Yeah. He walks up to the video game and it sucks him into the video game. I remember that. Yeah. But the thing is, is that what I understood was many years ago when we first started having a debate about how it's pronounced, it came around to the different languages pronounced it differently. So the, you know, in French, the people who speak French would say Azure, you know, and we would be like, oh, the Americans say Azure, you know, kind of a thing. Yeah. And so it was more of a cultural or a locality type of difference. So French speakers say it incorrectly. I get that. Yes. In sum. Dim sum? What? I told you, eat before the show. Dim sum is good stuff. We're getting close to lunchtime. Yeah. Oh, but we're only close to the entire fun. Hal, where'd you go? Oh, I'm back. I know. I can see that I've been talking about eating with meat. I've had, it's no fun when you don't, when things don't want to authenticate. And so I've been fading authentication. They, the, the account I'm using, the folks of the Rowland Shore have set up with an authenticator called Duo. And I've been having issues with teams because apparently teams doesn't like Duo. So I've been for the last few minutes trying to see if I could get a different authentication method working and it looks like it filing ads, but I don't know what else I've screwed up in the process. So it's going to be. Sorry to hear that. Hey, Hal, is that a documented issue? Is that like a known problems with Duo and teams? I'm the only one that I know of that's using it. I think I've got Duo. Yeah, I've got Duo. But have you documented it now? Because if you've documented it, you're halfway there. Yeah, well, I've got a client who uses Duo, but I've not had to connect with them. The trouble with it is that the way this is supposed to work is that anywhere I go that needs an authentication for whether it's Microsoft or whatever, that always gets referred back to Duo, which is the second factor. And that brings up an, you know, approved disapproved screen on my phone. With the exception of the last month or so in dealing with teams now, as long as I'm in the role in Shore and Tower Tenet, I got no problems, everything works. When I go over to the Microsoft guest tenant, however, suddenly it won't authenticate. For the last couple of weeks, the only way I could get it to authenticate was to have it phone me. Well, today, we went through a little bit of a generation. It looked like it was going to start using Duo. But then I was presented with a screen that says verifying authentication with exactly one, two things on it, a link that says more information and a button that says cancel. And there's much you can do with that. So I've been dealing with that. And I think I managed to backdoor the Microsoft Authenticator app in, which means I probably screwed up something else somewhere else. Hal, have you tried turning it off and on again? Yes, I did try that. Did you check the flux capacitor? I think that's the exact one pellet, one trip. There you go. You're stuck in this time now, Hal. I'm sorry. It takes a lot to create that 1.2 gigawatts of energy to escape this, but... Buck, we don't insult your own intelligence, man. Everyone knows it's 1.21. Yes. All right. Let's see. Oh, well. There we go. I love teams. Yeah, so much love. Well, we've got one more minute, minute and a half. Here's a great question to wrap up on. Is there a way to turn off Autosave for Office online documents? Hmm. Online? In the desktop app, you can turn it off, but not while opening documents through the web app. I don't think so. I don't think so either. Let me go. No. Yeah, there's plumbing. And Tobias Koprowski, so a good friend based out of the UK and MVP. And he says simple answer, no. This is how the system has been created and designed with online apps. Users don't care about saving. That's why there's also no save button. Correct. Only save. Yep. Yep. Because nobody wants a floppy disk icon in there. I do. I do. What's a floppy disk? Coaster. Wall art somewhere or someone. Yeah, indeed. Well, we are at the top of the hour, gentlemen, so thanks so much for participating and and for the the the nominal advice that provided the value provided to the community here today. Yeah, have we done a service or disservice? Yes. Yes, we have. That's all. The only true statement there is that we're done. Everything else is really subjective. Indeed. We are. Right. Play us out with the. Get it to play here. All right. All right. Thanks a lot. We'll see. We'll be back on at 6 p.m. Pacific. Except for Riz. He's asleep early. He needs his 12 hours. I just had a call booked with a client for 9 p.m. tonight. So lucky me. Yeah. All right. All right. Talk to you later. Everybody. Bye. All right. And we are now live and for those that are that are watching us that are joining via Facebook. We're live streaming here. This is our Microsoft community office hours, which we do every Monday at 8 a.m. Pacific. Or close to midnight. Sean's time. Whatever it is over there. I'm not so good with the time zones. Just 9 p.m. Here. Yeah. Whatever. Yeah. So we're monitoring. Yeah. We actually had a look for this morning. We had so far. We had 308 views of this morning session. And if you've not caught one of these tonight or tomorrow. More likely tomorrow. I got some stuff to finish tonight, but I combine both recordings and I post them over on my blog at buckleyplanet.com where you can go and do a search for office hours or look for the office hours logo. Not hard to miss. And I catalog every topic that we cover in both morning and evening sessions. And so you don't have to watch all two hours. Although Sean, I think you'd agree. It's must watch TV. Absolutely. Yeah. So good. And he's very good at cataloging, I might add. It's so good all the time. Yeah. There's a lot of little knife wounds to my co-hosts where since I've compiled the list, I'm poking fun like Sean's complaining again about this or Eric was whining about something. We all lose fingertips every now and then. Yeah. It happens. You got the rest of the hand. Yeah. So anyway, so if you have questions, go ahead and post them. We've got two places where it's streaming. Go at the watch group that's going over on the Office 365 community, but go ahead and post your questions there. And we're also going through and reading through questions that have been asked. And anything you've come across today, Sean, anything else? No, actually. It's just downstairs filing cards before I came up. Gaming stuff. Yeah. Little magic. You know, I've never played that. Really? So I've got nieces and nephews that are big time into that. And I think at one point, both my older two kids got into that and started collecting cards, but I've never played it. I mean, I'm a bit more old school. I was back in the late 70s, early 80s, was really into Dungeons and Dragons and collected lead figures. Oh, yeah. You got really into role play game stuff. And then of course got into the electronic version. I don't know if I call myself a gamer. Do you call yourself a gamer? I'm a gamer. Okay. I don't know what the line is. For the conversations we have, am I a gamer? Well, you play games. I do play games. Yeah. But see the rest of my family, like my wife loves games, board games, other card games. And I abhor the most of them. Not a fan. I'll do it once in a while. You know, the apples to apples type games or whatever else, you know, but of course I have the, the collection of the exploding kittens, burrito, that kind of stuff. And then of course the online games, the two online games that you're aware of. Yes. Yes, Christian and I are friended on Steam. And so we see each other pop up every now and then. It's a good way. And I don't know if you, if you monitor enough, like sometimes in, because my son will see me on there. He's like, what are you doing on at the middle of the day? I said, I was on there for like 10 minutes and went in, played like half a round of TF2 to, I said, I just need to give my brain a rest after an hour long meeting and do that. So. Yeah, I get it. Yeah. Hop on, play around to magic. As long as I don't get some bozo who's got a deck that gets into all kinds of mechanical nightmares and gyrations and slows the whole thing down. You can get around out pretty quick. Yeah. I do enjoy, I think there's one type of genre of YouTube video that I really enjoy. You don't see as many of them these days, but occasionally you see with like Fortnite and games like that. Was it the other one Apex? I think that's the one my son plays as well, which is like Fortnite. But was World of Warcraft where you'd have videos of people going in and wiping out entire clans. Fantastic. I don't have to play the game to watch. There was somebody like in the real world, that would be our world, Sean. Like, just died or something. Some young gamer. And so they advertised that they were like, no weapons and they were doing a giant funeral procession and a bunch of people took advantage of it and wanted to kill them all. You know, it's fantastic. Ludacris, yeah. We're talking virtual World of Warcraft deaths people, not real life, so. But there's a movie in the making right there. Oh yeah. Wrong tenant. I'll be right back. Ah, it was the voice of Hal coming from the house. Voice of Hal, yeah. Wrong tenant. I'll be right back. All right. Wrong tenant. Hey, so here's to kick things off while we're waiting for other questions here. So somebody made the comment. I think we may have discussed it briefly this morning about it says hello anyone. This is from Hoya. Hello anyone. Microsoft Teams eats more RAM memory, about 700 800 megabytes. So what should I do to reduce usage for teams? Is there anything that someone can do to reduce performance of teams? It's not like Chrome where you can go in every tab that you have open in the browser eats up more like closed tabs. Yeah, I'm not aware of anything you can do. I think it's just a function, you know, as you open up perhaps additional document libraries and SharePoint sites and whatnot and all that stuff comes flying in and cached into memory. It'll chew up memory, but. Go get some more memory. It's it's cheap. I don't have any good tips on. You know what you can do with teams to somehow constrain its usage of your resources. Well, my assumption again, I might be wrong because that's the definition of assumption making an ass of you and me. But is that the browser version of teams is going to eat up fewer resources than the desktop? I don't know if that's it true. Very definitely is true. How are you aware of any way to optimize your team's usage? Anything else you could do? Suck it up buttercup basically. If you're going to use the desktop client, you're basically going to get what the desktop client gives you. Yeah, the advantages of the browser version are it uses a lot less resources. Coming from the world where often we have two or three meetings at the same time. If I load up one meeting in the desktop client, I can maybe get away with one more meeting on the browser client. But usually my machine gives up and throws up and one of the two crashes. Then I start from scratch. If I run just about a browser client, I can get away with two sometimes three meetings concurrently. But how people that are not on a 28640 with an I7 and the best that they could do for it. The only thing it's lacking is the biggest hard drive. Yeah, I'm just looking at some of the comments. It's not the earliest launch. Yeah. Some other things saying like, hey, add more RAM. A few people saying that somebody suggested uninstalling it. That's not a solution. It'll reduce resource usage. The thing of it is, in the case at least of the surface, it's the amount of graphics it runs. The GPU doesn't like getting very warm. And it does that. And then things just stop. Yeah, I like this. Andre says, I've seen a similar post to this elsewhere. Making fun of the problem will not solve it. How about some constructives? Yeah. Shame on us. Shame on us. If I had some suggestions, I would give them. Yeah. I'm still investigating that. I'm happy to come up with some. Yeah, this is a known thing. I'm enjoying this, frankly. Right. No, I think we're all experiencing that. Alistair Pugin, Mr. Pugin, he says, turn off GPU acceleration. OK. And then Jeff below that says, try running in the browser rather than the application. Yeah. Which I, that's, you know, I don't know what they're, look, there's, I've not gotten into the religious discussion with the product team members on why they use the electron app, you know, and why they went that direction. I don't know if there's anything you guys can go more into. I don't know if there's anything you guys can go more in depth of why Microsoft made that architectural decision. I don't know the reasons behind it. I just assume it was like a cross workload integration or, or, you know, I don't know what the other apps are. That's not my world. So, but that, you know, that's been a complaint since day one when it went live, people saying, why did you build it the way that you did? And again, then it goes off to sidebar discussions into those details that, you know, my brain doesn't hold on to some of that stuff because doesn't brain don't care. Well, perhaps we can get somebody from the product group to give us a history or rationale kind of walk through. That would be interesting. Maybe I'll, I'll, you know, ping Lori about Lori Potmar for those that don't know that runs on the community stuff around Microsoft Teams or get Karawana who's over on the, in the engineering organization and speaks for a lot of what they're doing to talk to us about teams and performance. That would be an interesting discussion. I participate in that MVP call for they did that. So, see what we can find out and disseminate to folks. Oh yeah. I think it would probably have been if I had prepared it in advance for some of these questions, maybe go look through the roadmap to see if there's anything around performance for teams on the roadmap. But I'm sure they're always performance tuning and, you know, the recent surge in usage and need for teams has certainly driven some of the behavior that tends to optimize the application over time. I'm sure it's, you know, advancing, but I'm sure they've got folks who are looking at performance. There's, there's all sorts of things that you can do in terms of performance. Just thinking, you know, hypothetically, when you're talking about an AV application, you've got codex involved, streaming rates, you know, how hard are they working your GPU or CPU? Buffering, caching, all sorts of things. So that's a complex beast. Yes, it is. And the thing if it is, they keep announcing new features and a lot of things are taking a while to migrate through. So for example, what we've got here for the most part, most of the things I wind up doing, I've got just the four, the four quadrant screen. Occasionally, I'll get into a meeting and, well, lo and behold, I'm surprised there's nine there for a change. The advertisers, well, for example, the pop-out chat, there are articles and even a couple of Microsoft docs say, you know, okay, this is how you do it. Go here, click that pal out. It's supposed to pop when, fortunately, I click here, but I don't have the click there. Part of it, it's just not there. There's supposed to be a little pop-out thing that you get to from chat or if you're in the chat, you can, it's got a little pop-out icon. Milage may vary. And, you know, and I don't know. I don't mind, you know, waiting if it's a matter of just waiting for the feature set to arrive to buy a particular client. But it brings the question to me is, okay, well, is there something about the tenant that I'm in? Right now, I'm in the rolling shore and tower of business tenant, which is where I need to be in order to get things like the chat and emojis and things like that to work. I guess that's where I came in. First, when I started off, I was in the Microsoft tenant and half the stuff didn't want to work. Oh, it wanted to work. How? It probably did, but there was no way to turn it on or off. No where for the gerbils to run. It's kind of like that thing I had this morning with the authentication where I had this nice little window that came up that says verify your, you know, verify your login and it was a little square window and it has, you know, a more help link and a cancel button. I finally have got that more or less resolved. I don't know if I've got it resolved right, like I was explaining, but at least it works. I'll try to go back and figure that part out later. Another part of the equation I'd like to, for example, in this whole ensuring tower tenant here, I would like to make use of that to put on some webinars and some things and some of the other stuff that they aren't really doing with it yet, but I can't invite guests. Well, that's one of the five or six or seven settings that is involved with guest access and teams, but I'm not privy to that part of the admin console. So there's nothing I can really do about that. I suppose I can go over to the one that I get courtesy of the E5 licenses we get as far as being an MVP, but then I've got to go through all the same steps again. So it's just complex. I think it's a little bit more complex than it needs to be. And of course, you have to take that with a grain of salt considering all the features and things that actually will do and all the places it does it. I guess the best I could put it is it's a work in progress. I mean, it's a love-hate thing. I really like using it from the standpoint of the meetings that we have for an example. We used to do that. The get-together would be on Skype. We would have one drive open to look at the meeting notes minutes and so forth that we were doing. We would also have Slack open for sending stuff back and forth because there really wasn't a good way to do the chat and that. So like there's three or four different things open. Along comes Teams, Pile. Everything happens in one screen. It's gorgeous. I am so in love. And I think we talked about that on one of your buzz feeds. Just for clarification too, for people watching, Slack and Teams are not competitors. According to CEO Stuart Butterfield. Okay. Who paid for a full page Wall Street Journal and New York Times ad or whatever it was when Teams was released. Anyway. That was my... Sort of got the complexities. I say a work in progress. Yep. I'm learning about it daily. Lots of moving parts. Yes, sir. Yes. Hey Hal, anything come up? You wanted to talk about this evening? Any issues today? Sure. I've shot about a third of it. There are a lot of time. I think probably I should shut up and let somebody else say. You're fine now. Oftentimes you're sitting there quietly. We don't hear from you. Okay. Well, it's just been one of those circumstances. And like I said, if I hadn't had to fight with it this morning and miss at least one meeting because it was only a short meeting and it took me a little while to figure out it. Fortunately, most of those get recorded and stuffed somewhere. And I think probably it being one of Lori's meetings, I could certainly find out where and go and go view it. Yeah. Yeah. Having recordings of various proceedings is very helpful these days. You know, you can't be everywhere at once. What are your... Oh, no, go ahead, Hal. I was going to say, that recording feature is just really awesome. Because a lot of the times once I say it, well, like I say in the business meetings, there's a couple of different other tools. One of them is called IT Glue. It's a back in for managed service providers. It's fixes, procedures, all sorts of things that we've collected over time. And it's all good, but it's all put in one place. Is it like wiki? What is it? Sounds like something teenagers huff. No, it's... It's called chuffing. I don't think you word on that one. IT Glue. Yeah, here it is. Yeah. Well, so I was actually going to ask, while I was rudely trying to interrupt you, was what your policy was, personal policies on recordings, teams meetings. So it's with some clients and it's their tenant, but any meeting that we have, we hit the record button. And it was not every one of them, but not every one of the clients do this. But I convinced one of them, who was dead set against it until I explained, I'm like, look, it's your environment. My suggestion is where yours, it's like, oh, I forgot to take that down on my notes from last time. I'm like, capture it. It's part of your repository and it's instantly transcribed and then, well, instantly, and then made searchable within teams. Why would you not record all of those meetings? Well, that's kind of what exactly we do it for. Not for the general regular normal course of the big meeting because we're all looking at a one note sheet of that. But occasionally, like I say, someone will develop something in one or two or three of the other programs we have and then it's a show and tell. It's okay, we've added this new feature. Here's how you use that. And it starts to screen share. And anytime one of those comes up, I record it. I don't remember that stuff all that well, but I got those videos I can go back and look at. I can go back and look at them a dozen times if it isn't making sense. Or if I have questions that I want to ask whoever set it up, it's a ridiculously cool feature. Yeah, I record the collaboration. Don't worry about it. Technology work for you for a change. Exactly. I just want to say again, so anybody watching the live stream, we've got a few people that are out there. If you have a question you would like us to try and tackle then go ahead and type it in and we'll do our best to... And watch us flounder. That's right. I do have a couple of questions kind of queued up to discuss. So the first one, so Liam, not the Liam we know, another Liam asks, this is out in the Microsoft Teams community on Facebook. So I've created a team and we wanted to enroll all users in the tenant into this team automatically. So I have used the dynamic user membership type group. I have created the membership rule and it has pulled through all users that meet the criteria. 41, 36, so 4,136 exported to Excel for confirmation. I've checked a test account and I created it. It shows us meeting the requirements and the validation and it shows the group membership as applied in their account properties in Azure AD. When I go to the relevant team, I can see that it has only 3,823 members of the users from the dynamic group even though it should have done them all. I'm aware of the 5,000 member limit in Teams and we have not exceeded this. What could cause the difference between the dynamic user members and the Teams members and how can I ensure all of them have access to the team? So can he set it up? The way that he set it up, he used the dynamic user membership type group. That sounds like something's wrong. So the one question that was asked, see, Karsten asked is why didn't you just create an org-wide team? I don't know that it would be, well, I guess the difference then would be Liam responding saying that they have to join the team and it isn't forced upon them this other way. It's inviting them all in dynamically based on their permissions in our profile. Dynamic groups are really nice when you can bring them into a mix. But yeah, the fact that it's not reflecting the actual number of users, that doesn't sound right to me. I'm not sure what's going on there. So there's, I mean, my first thought is, well, there must be, for that kind of difference, there must be some other rule that's conflicting there that's not pulling them in. And so it would be to go to root analysis, would be to go and identify some people that should be in there that you can go and confirm, look at their profiles and see if there's anything that would exclude them from that. And I ruled that out. So you have this to simplify it in the Outlook rules that you go and create. I have this all the time where I identify a new type of message from a person or around a topic or a company and I create a folder for that and I want to organize my Outlook, my email and yet they're keep going into the wrong folder because there's conflicting rules. And so I've got to go back through and identify what are the common denominators between these and then I can modify the new rule to override that initial rule. I've not done that yet. It's just super annoying, but I just drag and drop the handful that happens right now. I've got other stuff to do, but... Imagine that. When you're talking about hundreds of users, I mean, still you're talking about 300 users. It's not a small number. It's not a small number to go and manually correct. So go and find somebody that you know, examine their profile, see if there's some conflict that would preclude them from being added. That'd be the place to start. Yeah. What makes them special? So another comment Casper says, this is good point, Teams only as users who have logged on to Teams are not blocked from login or disabled. So just because they have an Azure AD profile does not mean that they have Teams access if they've been blocked or disabled or if they've never logged in. So that would be another kind of cleanup to go and review. True. Yeah. I mean, I'm assuming when he says that those that meet the criteria, the 4136 number, are those that are vetted that are living human beings currently working for the company who have access to Teams. I'm thinking, yeah. But 300 is not out of a 4100 is not a... Would not be a surprise that those 300 people have never logged into Teams. It's certainly reasonable. Conceivable. Conceivable. All right. The other question, I'll see if there's any. So no other questions posted just yet. Again, don't be shy people. Come on. If you're watching the live stream, go ahead and ask some questions. Here's kind of a broader question. I think it's good that we bring this up every once in a while. Patrick asks, where's the best place to learn more about Excel, Word, Publisher, OneNote? Since I've gone through all the trainings offered on the education site. So recommendations. This is like another version of kind of where do you keep up to date with all the technology and where are some suggestions to go? Yeah. How do you want to take a break? I go to MrExcel.com. Bill Jelen. One of the smartest Excel people I know. Yeah, there's I think if you're looking for in depth, good part of training too is finding out who the experts are and having a connection there. And the MVPs would be a great place to go and start. So this I would suggest go look up at mvp.microsoft.com and do a search on the products. Take a look at some of the MVPs that pop up there that have that in their profile. It's a little bit of digging, but find like the blogs that people that are providing a lot of that because a lot of the MVPs are providing video and blog content and other training materials. Most of that for free. No. Don't come to me. I have people that read my, I've got some, I would say that I've got some decent OneNote content on my blog. It's still blog posts that I wrote about OneNote three, four, five years ago still gets heavily trafficked. Yeah. I've got a OneNote article that I wrote like four years ago that's still in my top five articles month after month after month. So thousands of people read it for some reason. Yeah, I've got a few of those as well. Yeah. I'll go to docs.microsoft.com oftentimes just, you know, when I've got to cut to the bone and just get some basics on low level stuff, having that information from oftentimes the product team, other MVPs. There are lots of folks who write for Microsoft docs. We've got, you know, it's often, many of them are GitHub repository managed. So people are contributing, people like us know Mark Anderson typically, I know with SharePoint. He's been directing a lot of the Microsoft docs around SharePoint. He's been pulling in people. He's had Sue Hanley and a whole host of other people write for it. And they've done a great job, Julie Turner. But yeah, find some people you like and, you know, if there's an area that you are particularly interested in and somebody does something, you know, I do a lot of work with performance. And so people who are interested in SharePoint performance typically, you know, I've had people come up to me at conferences and say, you know, you're the only one doing anything on blogging about performance or putting these things out there. And I'll, you know, you need to write something for those four readers. Yeah, exactly. But find somebody who, you know, speaks to what you really like and what you want to know. And see what they do. Learn a little bit about them. You know, it's kind of a variation on the look at the MVP theme. Because most folks, I can tell you that many of the folks I associate with in the, you know, the broader technological ecosphere have their own personal endeavors and interests and, you know, they do their own things. And we all, over time, get to know each other and what, you know, Christian likes to do one thing, you know, Liam Cleary. Of course, if we're talking about Wi-Fi and hacking and things like that, Liam's the first one who comes to mind. You know, those associations get made by learning about people. Yeah. Yeah, that's why I say that if you won't go wrong starting at the MVP portal and searching for experts there, because we're, you know, the vast majority of us are, it's just how we're wired to share that information if you're looking for something specific. Now, there's, I mean, other resources out there, of course, you have the LinkedIn learning tools and there's a lot of free content that's out there. Plural site. Plural site. Is there free stuff through Plural site as well? I believe they do some. Yeah. They've got trials, at least trials where you can get some stuff for free for a while. Well, what's that other huge, I was looking for it here, that other big training or online educational service, there's just a ton of stuff that's free. For writing stuff, there's code.org. Well, yeah, the more technical, they were asking specifically about, like end-user stuff too, but there was Microsoft partnered with somebody. It wasn't Microsoft. Like it wasn't Udemy. It wasn't, just I'm looking through it. I'm still not seeing it. A couple months ago, it was announced that there's a bunch of kind of 100 and 200 level content around Microsoft products that was going to be offered for free through this other training site. And what's the name of it? What are the big? Well, there's just through, well, there's some through Linda, LYNDA, so Linda.com. That's not the one, there's another one though. NX. Hang on. I'm going to provide the links here. So yeah, so here's the edX link. Let me post it in multiple places here. So here, this is the one I was thinking of. It's edX was the one where Microsoft made an announcement to this page, free online courses from Microsoft. And so this is the one that was announced. So Excel, Java, C++, Azure, machine learning, Python. It has all of the various, the products, the office products that are in there as well. Power BI stuff. So that is a fantastic resource. That's the one I was thinking of. The other one, Linda. So they have their office training and tutorials. It is paid, but you get a first month free. So I will add those links in where others can see them. Good deal. Yep, so those are other resources that I would definitely go and check out. Lots of different ways to learn these days. Yep. All right, let's see. No other questions have come in yet. Let me see what else. Had an interesting conversation today. Person I referred you to, Sean, about her background and kind of the beginning days early on with Skype. And so another former Microsofty and working for unified communications. And we walked through some of the history of link and communicator and Skype and kind of where things have come. And so for somebody that was involved with Skype at the beginning of the edition back when Skype consumer and to hear her stories and she's pretty impressed with what they've improved on the UC side through teams, much better experience. So to have somebody that owned part of the user experience for Skype, talk about how improved the team's experiences over a lot of what they built with Skype was good to hear as well. Get her perspective. Got some history there. Lineage. Oh, here's an interesting question. So Adriana asks, is it possible to delete all the historic messages from a chat in teams for me and the other user? So the way that chat is stored, a chat between three of us here. Let's say this were the chat feature versus the threaded discussion that's part of a channel. There's a portion of that discussion that we're involved in that is stored personally for the three of us. So I can go in, leave the system. I can wipe out my history, but both of you would have the history of our discussion that you both participated in with me there. I would no longer be showing as an active user if I were deleted from the system, but there would still be a record. The through the compliance, you'd be able to go in and I still don't know if with the compliance I've not gone in and played with this and it's been a while since I've thought about this, whether you can go into the compliance center security compliance and delete that chat history, which would essentially then be reaching into our individual. Christian's frozen. Oops. I know about that. Go Christian. They say it happens to me pretty regularly, but oh, he's back. That's the first time I've experienced that. That was that was weird. Yeah, you just like went all wack statue on us. Well, I think the recording will show that I was continuing to talk and it was you that was frozen. Now it was yeah, I I've not lost that connection. I'm not sure what happened there, but yeah. Anyway, where was I? What was the last you heard talking about reaching in and yeah, leading portions of the station. Yeah, I don't believe the security compliance. I don't believe you can as an admin go in and delete the chat conversation within that's being stored on my system. I don't believe it works like that and admin has control has the ability to control the discussion that's happened in the threaded discussion. But when you're talking about chat, which is a different communication technology, it's a personal. It's more like a peer to peer so therefore each of the peers that participate in the discussion have a copy of the dialogue while they were active when that within it makes sense. So yeah, so like this looking a couple comments there, somebody saying yeah, they could be I'm going to have to respond to this one. Somebody said you need to put a retention policy in place if you want to delete your private chat or channel conversations correct. Otherwise, they're just stored there. Yeah. So, you know, the answer is I'm going to go and verify whether or not an admin has any ability almost like your mobile device management to reach into the device and take action. I don't believe that's the case with chat but I'll verify that. I looked into that issue a while back. Yeah, that's interesting. See. Oh, here's a question that I can't answer. Somebody, Ayan says could you help how we can find a user in Office 365 using immutable ID via PowerShell finding a user in Office 365 using immutable ID via PowerShell? For what purpose? So, Peter asks why do you need to find which user is using a specific immutable ID? I'm curious. Are you getting some sort of clash? Yeah, there's no there's no other details to why. Again, I've been writing some PowerShell recently to help some folks I'm working with with regard to alerts on lists and users and pulling back user objects and how they're used throughout the system gets kind of interesting. I've provided a link to an octa article on how to get a list of Office 365 immutable IDs from Azure. I'll grab that. There's that article. What could be some reasons for wanting to do it that way, Sean? I'm not too sure. I know immutable IDs have implications during migrations but with that, I'm not too sure. Hang on, guys. I'm going to leave this running. I'm going to restart the stream. It looked like it ended. I'm going to go live again there, refresh that and this refresh on my page. We're still running here. Still hobbling along? Still hobbling along. I'm going to open up another browser and I'll have to mute this one as well. All right. Technical walkers with us. Yes. I have to say something else. Sean, I don't know if you saw this but Dan Usher pulled a cashman did a pun. It's spreading. It's like a virus. It's the virus that we don't speak of often. It's the bad puns. Dan is the king of those. Dan is. I thought cashman was the bad puns. I talk with Dan whether I talk with cashman. Yeah, well cashman post them whether you want them or not. Yeah, Dan's pun was since hockey has been canceled, no one has seen the Zamboni driver but I'm sure he will research eventually. Yeah. Yeah. I don't know what to say to that. I don't want to say well done because then it encourages you. It's not mine. It's just one that I saw that I remember. But it's pretty fair. Let's see. Well, we've got 13 more minutes. So if anybody has question they like us to try and tackle. Feel free. to ask. I saw this question and we didn't get to it this morning. The mail merge and I think everybody grown mail merge. But whether anyone has tried to do a mail merge using a word document open from teams. So the teams or browser version, the mail merge options are inactive in word when she has tried. I've never tried that. It doesn't surprise me. Yeah. Corey had some good advice. She says I would use the open and desktop option for more complex actions. It will automatically save your changes in teams as well. A lot of that those word options are going to go deeper into the product. So. There's there's a little more detail here too. Oh, so bell says thanks I open the document in the desktop and the mail merge options are inactive. I had to copy the contents of the word doc open from teams and paste it in a new document. So the mail merge options were then available. So there's something that carries over that doesn't allow it when you open and the desktop doesn't just work but still holding on to whatever those constraints are for the browser version of word. A new word doc is opened and that content is pasted in than those options are available and Dan responds and says it's because the shadow database files cannot connect to a cloud stored file. It would need to be a local file. Yeah, I would also wonder if there were security implications in there when you're coming out. You know, office is aware of when you're fetching files from the internet and across security boundaries. So there might be some safety sort of things that get enabled disabled as needed just to keep things clean and keep users safe. Well Darren Hemingway had a great response here which is great. He says sync the folder involved to your desktop then you're using a copy. Yeah, that's probably the best bet. Wouldn't need to go through that additional step if you sync with your desktop than it is its local both places and it will still save that cloud version and yet it should open up the feature. Yeah, because anytime you pull down a word document or an Excel spreadsheet or something like that from the internet you're oftentimes if it's crossing zones various attributes flagged on the file you can go in and turn what am I thinking about there's a checkbox you can uncheck for a file that allows you to do more with it on your system potentially unsafe files. Does that include, does it specifically call out like is there a toggle for the mail merge capability? Not that I'm aware of. Yeah, there's a there's a comment on here somebody said yeah you need to enable this feature I don't believe that there's a feature for this to turn on or off for the mail merge and then he says if you have a customer requirement you need to use third-party apps so that's not real advice that's a punt yeah I think that's you know the features there it's inward I mean you've got to, if for some reason the syncing with your desktop doesn't then unlock that feature the copy paste into a new word should you know I haven't tested this out I don't have a data source to go and make this attempt but I believe what Darren pointed out is the same it solves the problem it becomes a local file, right? Absolutely. Darren usually knows what he's talking about so you know I already answered that important question everyone's asking about Excel money in the UK so who gets that? Don't need to work that back again. Yeah yep uh alright what's going on alright yeah Jay Willey wants to jump in now hang on, yeah I don't know at the end he might have something to say he might have value to add here to this discussion of Excel money in the UK you don't know you're right I don't know here you go I'm going to forward this over to him do you know Jeff Willinger how? um not sure names and me don't get along real well unless they've been through the concrete between my ears two or three thousand times so that they stick I understand uh if I saw his face I could probably tell you better. Faces I'm fairly good at remembering yep he's got a pretty memorable face he's a character yes he is I was just going through and looking at some interviews I was going through over on my Buckley planet profile on YouTube I've been working just putting everything in collab talk for the last couple years I forgot about some of the gems that are over on the Buckley planet and thankfully all the Exceler stuff is still out there so all the one thing videos wow so yeah there were you know a couple hundred of those just crazy there are that many um but uh yeah it's fun to push those out every once in a while yeah it's good stuff and get people that that inevitably respond back why are you guys talking about SharePoint 2010 check the dates on videos folks before you respond all kinds of interesting stuff made in that time frame anything else exciting going on this week monsoon season here I suppose we'll see a good deal with that monsoon season in Arizona yeah it starts right about the oh the beginning of the second week in July and we'll run through about the first or second week in September we get a big wet air flow off of the Gulf of California that's right there was a SharePoint Saturday in Phoenix one few years back and in the middle of it and we were moving like we had lunch in a different building and we were at like Arizona state like on the campus or something and walking across those were like golf ball size raindrops like we were drenched not just like oh I'm a little damp like no we were like wringing our shirts out soaking wet and the streets were just flowing rivers it was fantastic they are extremely intense when they happen the real tragedy with these things mostly is the air beneath them is generally pretty dry so what you'll have is one of these clouds show up dump a whole bunch of rain it all mostly evaporates burger and if it's more intense than that what happens next you get all this air that was dry that is now suddenly wet and has cooled off immensely and it falls like many many many tons of bricks so we don't get tornadoes we get wind shear there'll be a downdraft that just it looks like a bomb went off because you look at like telephone poles and they're in a circle around where this thing came down they just they spread out in a circular fashion it's a real heavy one so it's always fun we don't get tornadoes though like I say the cloud bottoms are climbing up in the air out here they will start but they don't really get to the ground I think there's been one or two gosh it actually made it to the ground in Arizona history since they've been keeping tornadoes are smart it's two dang hot down there, forget that yeah I heard that we were at 114 yesterday whack us here in the Midwest this is Tucson not Phoenix they were probably 3-4 degrees hotter wouldn't surprise me it was up 118-119 yesterday I didn't see what the number was I just reported a record hot day I did yesterday oh my gosh I don't know what that is I'm afraid to look I I was thinking when that happened Sean it's a dry heat so it's 136 it really feels like it's 124 it's not that bad oh boy yeah that's where you don't want to break down because to get out you can hear the sizzling of your flat tire but the other tires melting on the road while you change that tire get back in yeah and I'm thinking of my cave fish like complexion my father always said sticking an Irishman in the sun is like putting a fork in the microwave cave fish now I'm just thinking of mine was the land of the lost sleep stacks oh shhh but thankfully I didn't say that out loud because that would have been too extreme oh wow Land that was the inner voice oh boy that goes back yeah that makes me chaka how you're Sally oh yeah that's one of the other characters names I remember I think the girl was Sally well Jay Woolley was a no show wow he wanted it in and he didn't show up that's right so maybe he'll like that one time Sean that you showed up with like 20 seconds to go yeah what did I miss well thank you gentlemen so I'll as I said I've got some other stuff to do tonight so I probably won't get the video posted well I may get the video live tonight but I just won't be able to do the sit and go through and do the links for the blog post but I'll definitely have that live tomorrow but again if you'd like to recap of the topics that we covered you can go to buckleyplanet.com for more research on office hours you should see it episode 17 so this is the second half of episode 17 and you'll be able to get to all the topics the two or three relevant things we talked about today tonight be able to jump through jump to those links and then of course if you have any questions has all of our twitter handles that are part of that so please if you've got questions feel free to reach out to us if there's anything you can continue posting to the recording if you're watching on one of the live streams and we'll be checking that and we'll try to address them and answer them for you as quickly as possible and then we've not really done this but anything that we've answered during the week we should definitely talk about next week but otherwise we'll be back webcast is legal to vote next week this webcast is this oh that's right we're an entity it's like weeks or dog years or whatever yeah so we'll be back live at 8am and 6pm pacific next monday and we'll be doing all again so feel free to ask your questions and we'll do our best to answer them so thanks a lot everybody gentlemen see you later take it easy