Latest / Microsoft Cloud IT Pro Podcast / Episode 409 – Preparing for Copilot- Securing Your Microsoft 365 Data and Beyond
Transcript
- 0:03Welcome to episode 409
- 0:05of the Microsoft Cloud IT Pro podcast recorded
- 0:08live on 08/22/2025.
- 0:11This is a show about Microsoft three sixty
- 0:13five in Azure from the perspective of IT
- 0:15pros and end users, where we discuss a
- 0:18topic or recent news and how it relates
- 0:20to you. In this episode, we explore the
- 0:22configuration
- 0:23decisions tenant administrators
- 0:25face when preparing their Microsoft three sixty five
- 0:28environment for Copilot.
- 0:30And, really, just in general, when thinking about
- 0:32data security in Microsoft three sixty five, we
- 0:35dive into some of the key questions every
- 0:38IT professional should be asking when it comes
- 0:40to users' access to content within the Microsoft
- 0:44three sixty five tenant. So let's dive in.
- 0:49Welcome back from vacation, Ben. Thanks. It was
- 0:52fun all the up until the part where
- 0:54I got back from vacation.
- 0:58I kinda did the same thing. I'm looking
- 1:00forward. We have a US holiday, Labor Day,
- 1:02coming up next week. So Is that next
- 1:04week? Yeah. I'm looking forward to having an
- 1:05extended weekend. That's kind of our last national
- 1:08holiday, federal holiday, for a little while here
- 1:10in The US, so enjoy it while it
- 1:12lasts. No. Vacation was good. Like, we got
- 1:14to go up to Michigan, spend some time
- 1:16up there,
- 1:17then had a family reunion. This is a
- 1:19lot of people's scout. Went out to Denver
- 1:20for, like, a long weekend for a family
- 1:22reunion. With my wife's family, there were 58
- 1:25people that were all out there. So that
- 1:27was kinda fun. Lot of family.
- 1:30It is. But it was cool. Like, there
- 1:32must have been, like, 10 or 12 kids
- 1:34all between the ages of, like, six and
- 1:3610, which are close
- 1:38to our boys' age. And, I mean, it's
- 1:40Colorado. Right? Weather's beautiful. We're out in the
- 1:42woods. The mountains of boys are just outside
- 1:44playing with all the other kids. Sticks and
- 1:47rocks and yeah.
- 1:49Exactly. Made up games with, like, I don't
- 1:51even know what they were doing with volleyballs
- 1:53and throwing them up on the roof of
- 1:54one of the houses we were staying at.
- 1:57Let them go at it and do what
- 1:59they need to do. Yep. One of my
- 2:00wife's cousins is actually big into, like, he
- 2:03lives out near Denver, big into rock climbing,
- 2:06hiking.
- 2:07So he actually, one day, took us
- 2:10we took the rental Jeep. He's like, oh,
- 2:11we can make it here. It's a rental
- 2:13Jeep.
- 2:14I hope he got his did not get
- 2:16charged extra for that run rental Jeep, but
- 2:19took it on a road that we didn't
- 2:20think was that bad. Let's just say there
- 2:22was one point in time where I think
- 2:23only two tires of the Jeep were on
- 2:25the ground. The other two were, like, up
- 2:27in the air, but then went to our
- 2:29Jeeps have solid axles. Right? You need two
- 2:31eighteen millimeter wrenches and hop under and disconnect
- 2:33that sway bar. They you're all good. You
- 2:35have to have those two wrenches or the
- 2:37sway bar disconnect on there, but,
- 2:40yeah, that that's funny. We did a similar
- 2:42thing on our vacation.
- 2:43We we drove through the Red Redwoods in
- 2:45California.
- 2:46There's a road in Jedidiah State Forest, it's
- 2:48called Holland Hills Road. Okay. But you you
- 2:51kinda read about it, and some people say,
- 2:53like, oh, don't take your rental car on
- 2:55there, don't do that. But when you go
- 2:56to the park station in the morning and
- 2:58you say, like, hey, like, we're here for
- 2:59these types of experiences, where should you go?
- 3:01They just ask you. Like like the rangers,
- 3:03they ask. They say, hey, what kind of
- 3:04car do you have? And as long as
- 3:05you have a car with four wheels and
- 3:07you're not towing a trailer,
- 3:09they give you directions to this random To
- 3:12go on this road? Dirt forest Service road.
- 3:15It's a four it's like a 11 mile
- 3:17forest service road, and then it's got yank
- 3:19pull offs for some of the various, like,
- 3:21redwood groves and things like that. But
- 3:23we did that, like, halfway through our road
- 3:26trip on on the West Coast.
- 3:28And from the day we did that on,
- 3:30that car was never clean again. Like, it
- 3:32had a layer of thick dust on it
- 3:35just going through. I was totally expecting to
- 3:37get, like, a ding from the rental car
- 3:39company.
- 3:40Thankfully, it rained, like, at the hotel we
- 3:42were staying at before we flew back the
- 3:44next day to get it, and that cleaned,
- 3:46like, most of it up. But up until
- 3:48that last day, it had, like, a good
- 3:49like, it felt like a this is an
- 3:51exaggeration, but it felt this
- 3:55this way. It felt like it had a
- 3:55half inch of dirt on it, right? Just
- 3:56like everything. You could only see through the
- 3:57windshield, and the only part you could see
- 3:59out of the back windshield was where it
- 4:01had the rear windshield wiper.
- 4:03I had gone to gas stations and tried
- 4:05to clean it up, and it was like,
- 4:07this is just a lost cause. So Not
- 4:09gonna work. Jeeps are tough. Yeah. You'll be
- 4:11fine. All good. So we did fun. But
- 4:12once we got to the end of that,
- 4:13it was to a rock climbing spot where
- 4:15there were routes set up. So he, like,
- 4:17set up routes for us with the ropes,
- 4:18and he had all the harnesses for the
- 4:20kids, so he got to do, like, some
- 4:22real rock climbing because we live in Florida
- 4:24where the biggest rock you climb is, like,
- 4:26a boulder in the front yard of some
- 4:27place Yep. Where you have to do a
- 4:29gym. So it was a good trip. And
- 4:30then from there, I went I came home
- 4:33and was home for, like, sixteen hours and
- 4:35then flew to Atlanta for TechCon three sixty
- 4:38five. That leads us into today's topic.
- 4:40So we've been kinda going back and forth
- 4:44between maybe talking about, like, Copilot and how
- 4:47to enable it in your organization, maybe some
- 4:49things your users can use it for. We
- 4:51just got done kinda talking
- 4:54through MCP and that's how that's helpful and
- 4:56maybe some agentic workflows and stuff like that.
- 4:59But it's been a little bit, and we've
- 5:01never really taken a deep dive on it.
- 5:03So so you had this talk at TechCon
- 5:06about securing Copilot.
- 5:08So so really kind of like, you have
- 5:10to prepare for Copilot in certain ways. There's
- 5:13licenses you need to turn on, there's things
- 5:15you might want to
- 5:16think about within your organization and who has
- 5:19access to what and things like that.
- 5:21But there's more than just lighting up a
- 5:24license to think about. Kinda like when you
- 5:25maybe did, like, SharePoint search back in the
- 5:27day or you do, like, an m three
- 5:28sixty five search thing today, there's all this
- 5:31security trim stuff out there and the these
- 5:33experiences, they have access to a lot of
- 5:35data per user.
- 5:37So you did a talk at TechCon called
- 5:39Preparing for Copilot Securing your Microsoft three sixty
- 5:42five Data and Beyond
- 5:44and I think this is a good one
- 5:45to dive into.
- 5:47It's Copilot
- 5:48centric but a lot of the concepts in
- 5:51here, right, like like just kind of thinking
- 5:53about and taking a step back and, hey,
- 5:55like, let's take a beat and think about
- 5:57what type of data is in my Microsoft
- 6:00three sixty five environment, like what's the sensitivity
- 6:03of that data, maybe I need licensing for
- 6:05things that give me capabilities like sensitivity labels,
- 6:08all that. And then
- 6:10once you've put it together, how do you
- 6:12have to tweak it, what does that look
- 6:14like, and kind of maintenance and everything beyond.
- 6:16So I figured it'd be a good kind
- 6:19of topic to hop into, and since it's
- 6:21been top of mind for you,
- 6:24it's certainly like fresh and right there. And
- 6:27you've got all the context from the conference
- 6:30and questions attendees asked you and things like
- 6:32that. So be a fun little whirlwind tour.
- 6:35It is, and it'll definitely be whirlwind because
- 6:37this was a seventy five minute session. Granted,
- 6:39there were demos and stuff in there, but
- 6:41it has been. It's been an interesting topic,
- 6:43and not only did I I kind of
- 6:45did a session on it because
- 6:47I don't even know how many clients I've
- 6:48had ask me about this recently. Like, hey,
- 6:51we want to deploy Copilot.
- 6:53What should we be thinking about? What does
- 6:54our environment look like? How do we prepare
- 6:57for it? And to your point, it's an
- 6:59interesting one because it's like, well, technically, this
- 7:01is stuff you should have been doing all
- 7:03along. But Copilot is just bringing it to
- 7:06the forefront to that point of that we've
- 7:07talked about before, is Copilot doesn't necessarily
- 7:12introduce any new security vulnerabilities. Like, I I
- 7:15don't know how many times I've talked about
- 7:16this. It just it brings to the forefront
- 7:19quicker and easier mistakes that maybe you've done
- 7:23in the past
- 7:24with your Microsoft three sixty five environment. And
- 7:27that's kinda where even this slide is, like
- 7:30and I'm sharing kind of the slides that
- 7:31I did at the presentation. We can work
- 7:33through those as we talk through it. But
- 7:35it all starts with what should you be
- 7:37thinking about when it comes to Copilot, and
- 7:40a lot of these bullet points too. The
- 7:42things I think through are like, what types
- 7:44of data do you have in Microsoft three
- 7:45sixty five? In particular,
- 7:47SharePoint. What type of data do you put
- 7:49in SharePoint? Because Copilot has access
- 7:52to Exchange or Outlook, your Teams, conversations, all
- 7:55of that stuff. But by and large, that's
- 7:56already secured. Right? Like It should be. It
- 7:59should be. And I don't think Copilot actually
- 8:01even has access yet to share mailboxes. I
- 8:03think that's one limitation is if someone shared
- 8:06their mailbox with you, they have access to
- 8:08a shared mailbox.
- 8:09I don't believe Copilot can reason over that.
- 8:12So I try to frame it as what
- 8:14types of data are out there. You wanna
- 8:15think about should Copilot have access to sensitive
- 8:18data.
- 8:19And this is one that maybe you haven't
- 8:21thought about before, but it's maybe you need
- 8:24access to sensitive data for your day to
- 8:26day work. Right? Like, you're in finance,
- 8:29you're in education,
- 8:31maybe there's data around
- 8:33bank accounts out there, there's
- 8:35financial spreadsheets out there, there's
- 8:38student data that's in your environment.
- 8:41People legitimately need access to some of that
- 8:43to do work, but do you want Copilot
- 8:46to have the same access to it that
- 8:47a user does if they just go open
- 8:49a particular file? So that's another thing to
- 8:52think about. And then one is just who
- 8:54has access to your content. Where has stuff
- 8:56been overshared? This one's been talked about a
- 8:58ton. And then thinking through, so how do
- 9:00you start fixing it, and how do you
- 9:02maintain it once you've done it? You have
- 9:03ten years of bad practices.
- 9:05You go spend six months fixing it. How
- 9:07do you keep those bad practices from continuing
- 9:10after you fix it? It's this kinda, like,
- 9:13whirlwind thing, and
- 9:16as I get more into the world
- 9:18in my day job of thinking about
- 9:21agentic
- 9:22AI and, like, some of the MCP stuff
- 9:25that we talked about, So if you look
- 9:27at tools like Copilot,
- 9:29you can go create your own declarative agent,
- 9:32you can maybe go create an agent in
- 9:33Copilot Studio,
- 9:35there's tools out there or there's services out
- 9:37there like Azure AI Foundry that then have
- 9:39their own tool integrations, all these kinds of
- 9:41things. So we're kind of on this weird
- 9:44cusp again of
- 9:46you have to rationalize things like Copilot and
- 9:49the value and TCO and all that for
- 9:51your organization,
- 9:53but now we're kind of looping back around
- 9:55to
- 9:56user access plus agent access or agentic access.
- 10:00So like what's the right way to build
- 10:02those things? What does that look like and
- 10:04how does that come together?
- 10:06Because
- 10:08eventually, it's like these things are all just
- 10:10going to be like talking to each other.
- 10:12Like that finance example that you have, it
- 10:15might be somebody going in and having access
- 10:17to a
- 10:19a fine tuned model, right, that helps them
- 10:21spit out a financial report at the end
- 10:23of the quarter. Like, use this template. Here's
- 10:25good examples. Here's how these are legally compliant.
- 10:28All these kinds of things, but, you know,
- 10:30those agents are going to either interact as
- 10:33real applications within the environment, so now you're
- 10:36back to like application access and thinking about
- 10:38scoping things, maybe like permissions
- 10:41for,
- 10:42for those, and what are the rights that
- 10:44you give them within the environment. It could
- 10:46be user access. It could be a mix
- 10:48of both depending on what was going on
- 10:51and how it composed and what came together.
- 10:53And then
- 10:54you further kind of muddy the waters there
- 10:56with, like, oh, like, maybe that's not an
- 10:58agent that's just or a user even that's
- 11:00interacting with, like, data in a single system
- 11:03like SharePoint.
- 11:04What happens when they're using the SAP connector
- 11:07or they're using the Dynamics connector, like, and
- 11:10you have these other systems that are talking
- 11:12to each other on the back end and
- 11:13these agentic workflows. And I think it does
- 11:15become, like, an important consideration
- 11:18along the way,
- 11:19and it's an it's an interesting thought exercise.
- 11:22I actually think it's a little scary too
- 11:24depending on, like, where you sit organizationally
- 11:26and how things are composed in your environment
- 11:28today,
- 11:29just to think about
- 11:31where we are today and where the world's
- 11:33gonna be in
- 11:35the the future. And the future could be
- 11:38really short. Like, it could be the next
- 11:39couple months, it could be maybe the next
- 11:41year.
- 11:42I don't think you can take you have
- 11:43the advantage of thinking ahead to five years
- 11:46from now kind of thing. And speaking of
- 11:48scary, can I go completely off topic about
- 11:50a scary, like Squirrel? Squirrel. Yeah. Okay. Squirrel.
- 11:53So but thinking about Copilot and AI and
- 11:56how you're asking it, I did see a
- 11:57really funny I think it was on Instagram
- 11:58where it was two people walking into a
- 12:00room or, like, somebody rang the doorbell of
- 12:02a door, and a guy picked up his
- 12:04phone and said, hey, ChatGPT, someone's knocking at
- 12:06my door. What should I do?
- 12:08And Chad GPT tells him to open it.
- 12:10And then he opens it, and the lady
- 12:13outside the door says, Hey, Chad GPT. He
- 12:15opened the door for me. Now what should
- 12:17I do? And it was, You should say
- 12:19hello or walk in the door and say
- 12:20hello. It was these people that literally were
- 12:23using their phones to have chat gbt tell
- 12:25them how to interact with each other, but
- 12:27I think it does highlight, like, how much
- 12:30we're asking
- 12:31AI and, again, a little bit of a
- 12:33rabbit hole, but how much are we becoming
- 12:35dependent on it and how it could actually
- 12:37be one of those scary environments where we,
- 12:39like, yeah, how it's going to change how
- 12:41we work, interact,
- 12:43live, etcetera. I think it can be scary.
- 12:45Like, it can be exciting, but I also
- 12:48think it kinda raises the priority or the
- 12:52importance of, like, thinking about these questions and
- 12:55thinking through them and making sure that
- 12:57as
- 12:58Microsoft three sixty five customers,
- 13:00could be Azure customer, really, like any kind
- 13:03of, like, SaaS cloud based product that's adopting
- 13:05these kinds of things, or even if you're
- 13:07bringing them into your internal environments, right, like
- 13:09these are all like I think they're common
- 13:12sense considerations, like there's nothing in here that's
- 13:15like,
- 13:16oh my gosh, like, but you have to
- 13:19really take the time and be intentional
- 13:22and go down the path of looking at
- 13:24all of them. Like it's not just a
- 13:26one dimensional kind of thing, it's this multidimensional
- 13:30kind of exercise
- 13:32to
- 13:33to get in. So,
- 13:35like, it's always kinda fun to do these
- 13:37things with you because I get access to
- 13:39the decks and your talks and everything, and
- 13:41we get to talk and plan it out
- 13:42ahead of time. So, like, I know a
- 13:43little bit about where the story's going. So
- 13:46why don't we keep kind of getting in
- 13:48that and kind of Yeah. Yeah. So I
- 13:51think, yeah, like, good place to start. Yeah.
- 13:53Just like, I've got the data out there.
- 13:54How do I figure out, like, what's out
- 13:56there and what's going? And like you said,
- 13:57like, for folks listening here, like, oh my
- 13:59gosh, these, like, crackpots are talking about Copilot
- 14:01and AI again. A lot of these concepts
- 14:04broadly apply to Microsoft March,
- 14:07and they might apply to,
- 14:09heck, your on prem SharePoint environment. Right? There
- 14:12was a CVE for SharePoint on prem last
- 14:14month. A lot of organizations had to go
- 14:16through this kind of, like, patching workflow due
- 14:18to a hack for on prem SharePoint that
- 14:20came out of China.
- 14:21All these things are broadly applicable.
- 14:24And, yeah, it sounds like common sense, but
- 14:28I encourage you, stick with us, and maybe
- 14:30you'll hear something in here that says, Oh,
- 14:33I didn't think about that, or, Oh, you
- 14:35know what? That one was on the back
- 14:36burner for me. Maybe I kinda need to
- 14:38lift it up the priority list and go
- 14:40spend a little bit more time on it.
- 14:42Yeah. And I would say some of these
- 14:44even are more broad
- 14:45than just SharePoint. And
- 14:48this first one, it's tools related to SharePoint,
- 14:51but it's concepts you need to think about
- 14:53for any
- 14:55data that maybe AI has access to. And
- 14:57when I start thinking about exploring the content,
- 14:59it's somewhat what I hit at before, but
- 15:01it's looking at sensitive data.
- 15:03Where is this sensitive data? What sensitive data
- 15:05is out there? And to your point, I
- 15:07was working with one client, and they have
- 15:10certain policies around what should be in SharePoint
- 15:12and what shouldn't be. And this was not
- 15:15even a Copilot exercise. This was just, like,
- 15:17overall data governance.
- 15:18And I used Data Explorer, so we'll tie
- 15:21this in a little bit, Data Explorer in
- 15:23Microsoft three sixty five. But however you do
- 15:25this, it's we found data. We're like, did
- 15:27you know you have these Social Security numbers
- 15:29in your SharePoint environment? We're like, no. We
- 15:31had no idea. So they went in and
- 15:33cleaned that up right away. But that's one
- 15:35of the first things is how do you
- 15:36explore this content? Whether it's Data Explorer in
- 15:39Microsoft three sixty five or there's
- 15:42what is it? There's I'm drawing a blank
- 15:44on it. It's is it part of Azure
- 15:46Information Explorer? It's,
- 15:49you can use it on a file share
- 15:50to actually explore the file share and scan
- 15:53all your content on a file share, and
- 15:55it has some ties into Purview. Azure Data
- 15:57Explorer. Yeah. And then Yeah. That ties into
- 15:59this weird
- 16:00weird I mean, it is what it is.
- 16:02Its name's like per Purview,
- 16:04Activity Explorer, something like that, but that's that
- 16:07kinda large data volume. Hey. Let me go
- 16:10and scan that thing. So it's part of
- 16:11Purview and the compliance stack. Yeah. So there's
- 16:14that. And then the next one is just
- 16:16oversharing.
- 16:17And again, Microsoft three sixty five,
- 16:20I talk about the data access governance insights.
- 16:23This one's another one. There's some PowerShell commandlets.
- 16:26It's start SPO
- 16:29data access governance insight. We'll put links to
- 16:31this PowerShell commandlet in the show notes. But
- 16:34you can go run this particular
- 16:36report and look at OneDrive for business
- 16:40and look at SharePoint and
- 16:42spit out a summary
- 16:45of how many different types of sharing links
- 16:49exist in your environment. I was looking at
- 16:51one client. We looked at OneDrive. We found
- 16:53out this particular individual
- 16:55had content in their OneDrive, and one of
- 16:57the aspects of this report is how many
- 16:59people it's shared with. He had content shared
- 17:01with almost 2,500
- 17:04different people
- 17:05hosted in his OneDrive. There's also some data
- 17:08access governance reports in the SharePoint admin center
- 17:10that get included with Copilot now. I've written
- 17:12some custom PowerShell scripts where
- 17:15it actually goes through and looks at all
- 17:17the content in SharePoint and spits out sharing
- 17:19links and URLs and the title of the
- 17:21files and all of that. But this is
- 17:23really going back to
- 17:25where is content shared
- 17:27with people that shouldn't have access to it,
- 17:30whether it was laziness and just putting in
- 17:33I mean, not a file share, putting in,
- 17:34oh, we'll just share this with domain users
- 17:36and then not realizing
- 17:38what people have maybe dropped in that particular
- 17:41folder that shouldn't be there
- 17:43or forgetting that it was shared with everybody
- 17:46or somebody meant to do it at a
- 17:48subfolder and accidentally did it at the parent
- 17:50folder.
- 17:50All those same things apply to file shares,
- 17:53to SharePoint.
- 17:54I mean, technically, it can apply to Dropbox,
- 17:57Box.
- 17:57Anywhere where you have content is really thinking
- 18:00through,
- 18:01and how do you report on where is
- 18:04content shared more broadly than it should be,
- 18:06or where are folders? This is the other
- 18:08interesting one. Where are folders shared more broadly
- 18:11than they should be? And people can just
- 18:13drop content into it, and all of a
- 18:14sudden it becomes shared because they just dropped
- 18:17it in a folder or a SharePoint site
- 18:19Mhmm. Or a Teams SharePoint site, any of
- 18:22those.
- 18:26Do you feel overwhelmed by trying to manage
- 18:28your Office three sixty five environment? Are you
- 18:30facing unexpected issues that disrupt your company's productivity?
- 18:34IntelliJunk is here to help. Much like you
- 18:36take your car to the mechanic that has
- 18:38specialized knowledge on how to best keep your
- 18:40car running, Intelligent helps you with your Microsoft
- 18:43cloud environment because that's their expertise. Intelligent keeps
- 18:47up with the latest updates in the Microsoft
- 18:49cloud to help keep your business running smoothly
- 18:51and ahead of the curve. Whether you are
- 18:53a small organization with just a few users
- 18:55up to an organization of several thousand employees,
- 18:55they want to partner with you to
- 18:56implement
- 19:00and administer your Microsoft cloud technology. Visit them
- 19:05at inteligink.com/podcast.
- 19:08That's intelligink.com/podcast
- 19:15for more information or to schedule a thirty
- 19:17minute call to get started with them today.
- 19:19Remember, Intelligink focuses on the Microsoft cloud so
- 19:22you can focus on your business.
- 19:26So that was one of,
- 19:28configuration
- 19:29changes, again, where somebody accidentally changes permissions,
- 19:32sets up permissions the wrong way. One interesting
- 19:35thing that came out, I hadn't thought of
- 19:36this before,
- 19:38but somebody else brought it up at the
- 19:40conference and I was like, oh, that's an
- 19:41interesting one, is comparing sites or duplicate content.
- 19:45How many companies have you been in, Scott,
- 19:47where, like, somebody creates a file and then
- 19:49creates that file v two and v three
- 19:51and v four and v five and v
- 19:52six and v seven, all the way up
- 19:54to whatever, and now you have, like, 20
- 19:56copies of a nearly identical file all out
- 19:59there? Guess what gets really confused
- 20:02about pulling accurate information when you have 10
- 20:04or 20 nearly identical files? Doctor. Nearly identical
- 20:08and also mixed in with identical identical, right?
- 20:12Doctor. Right.
- 20:13Doctor. I do this sometimes
- 20:15where
- 20:16somebody writes a paper and I'm like, Oh,
- 20:18I want to save that as an example
- 20:19for later. So I take that and put
- 20:21it in my OneDrive and it's still like
- 20:23the canonical version still sits, but I want
- 20:25like that point in time snapshot maybe to
- 20:27reference back to you later
- 20:28as a doc, a PDF, a PowerPoint, whatever.
- 20:31So my OneDrive is like just
- 20:33absolutely littered with things like that. I can
- 20:36tell you very specifically what does not do
- 20:38a good job here is Copilot notebooks,
- 20:41which we talked about.
- 20:42I actually did this recently where I had
- 20:44a couple iterations of not the same document,
- 20:45but similar documents. It was more like there
- 20:45was a section in this one,
- 20:58limitations of Copilot notebooks
- 21:00because what the notebook was doing was while
- 21:03it was grounded in the information that was
- 21:05available in there, right, I added these, like,
- 21:06I actually went beyond the limit. I had
- 21:08to take docs out because you can only
- 21:11have, like, up to 20
- 21:12documents in a Copilot notebook right now or
- 21:15combination of documents and OneNote
- 21:17and things like that. So I was at,
- 21:19like, 28 or something. So I was really
- 21:20trying to confuse it, but it was getting,
- 21:22like, extra confused because not only were the
- 21:25documents in the Copilot notebook where I'd said,
- 21:27hey. Here they are. Like, here's the canonical
- 21:29version,
- 21:30but other people had copies of them out
- 21:32there, like you said. Like, they had the
- 21:34like, they've done the thing I did, right,
- 21:36where they made a copy in their own
- 21:38space. But when they made a copy in
- 21:39their own space, like, some folks put those
- 21:41in other public areas that I have access
- 21:43to, or they might have emailed it to
- 21:45me. So, like, figuring out how to wrangle
- 21:47the prompts and get things to where, like,
- 21:49oh, I actually can do what I wanna
- 21:51do with this, super hard to do. I
- 21:52wasted more time in the Copilot notebook trying
- 21:55to get it to behave the right way
- 21:56when I literally could've just
- 21:59walked over to my 32 inch monitor and
- 22:01pulled up five docs on the top row
- 22:03and five docs on the bottom row and
- 22:04just started, like, scrolling through.
- 22:06I I would've been better off for the
- 22:08amount of time that I was trying to
- 22:10fight that process and have it come through.
- 22:12But it was a good lesson for me,
- 22:13like, hey. Right tool for the right job.
- 22:15Here's the limitation of this thing.
- 22:17But it it did kinda
- 22:20get the back of my head tingling, like
- 22:21the Spidey sense going, right, to say, like,
- 22:23I wonder, like, what happens to other people
- 22:27or how this is out here. So it
- 22:29it was one of those things I saw
- 22:30it in the presentation here. I was like,
- 22:32like, good. Ben Ben's thought about this too.
- 22:34I'm not crazy. Doctor. I'm thinking about this,
- 22:36and this is a tool I recently found
- 22:38out. It's the site policy comparison tool in
- 22:41the SharePoint admin center, and it'll go I've
- 22:43never even heard of that one, but I
- 22:45haven't I haven't spent a lot of yeah.
- 22:46I haven't spent a lot of time in
- 22:47SharePoint lately. The downside is it doesn't necessarily
- 22:50look for duplicate
- 22:52files, but it will tell you if you
- 22:54have two sites
- 22:56where over 70%
- 22:57of the content on the sites is duplicated.
- 23:01So it's like if somebody took a copy
- 23:03of a site or copied all the contents
- 23:05of a site to another site, it would
- 23:07be nice to maybe see it expanded in
- 23:09the future to look for just duplicate files.
- 23:12Like, do a file comparison of how many
- 23:14nearly duplicate files do I have across my
- 23:17environment. I imagine it that takes a little
- 23:19bit more processing power, but it's it's definitely
- 23:23a thing. And then
- 23:25I wrapped up here too when I was
- 23:26giving this presentation with just a few tools
- 23:28and examples of
- 23:30using custom PowerShell
- 23:32to look for some of these things. Microsoft
- 23:33has reports.
- 23:35They're not always as detailed as you need,
- 23:37and that's where I wrote some of these
- 23:39reports to pull a list of all my
- 23:41files and all my sharing links across all
- 23:43of SharePoint. I need to go tweak it.
- 23:46I looked ran this against a site that
- 23:48had, like, millions of items. I think the
- 23:50PowerShell script was running for, like, three weeks.
- 23:53Takes a hot minute to enumerate that much
- 23:55data. Yeah. Yeah. But then I had a
- 23:57CSV from all of the sites in the
- 23:59environment with all of the sharing links, and
- 24:01I went and threw them out in Azure
- 24:02Data Explorer, And then I could do a
- 24:04bunch of KQL to go help narrow it
- 24:07down, like, how many organizational wide sharing links
- 24:10do I have? Which sites have the most
- 24:12sharing links?
- 24:13Where are all my links that don't have
- 24:16expiration dates on them, and they've just been
- 24:18shared indefinitely for years and years?
- 24:20So just a couple different ways there to
- 24:23help dig through the content a little bit
- 24:25more. I think it's generally manageable and goes
- 24:27back to the a little bit of, like,
- 24:29hey. Like, this stuff is known, but you
- 24:31as a customer need to go out and
- 24:34spend that time, do that research,
- 24:37and figure out what that is. Like, a
- 24:39lot of the things you're talking about here,
- 24:40like, maybe like a PowerShell script for that
- 24:42discovery aspect, like, these things exist. There's a
- 24:45bunch of community examples,
- 24:46blog posts, stuff on GitHub from community contributors,
- 24:50from Microsoft themselves. Right? But
- 24:53you don't have to reinvent the wheel, but
- 24:55you do gotta do some work along the
- 24:56way. From there, then it's, okay, now I
- 24:58know what I have. How do you go
- 25:00in and
- 25:02fix it all? And
- 25:04this is where I get a ton of
- 25:05discussion because,
- 25:07for instance,
- 25:08another example, one of my clients, they had,
- 25:10like, 45,000
- 25:12links
- 25:13across their organization.
- 25:14Like, how do we even begin to
- 25:17fix this or evaluate it? You cross your
- 25:19fingers and you hope for the best. Right?
- 25:21And it's that whole combination of one is
- 25:25we need to get a lot better at
- 25:26permissions in SharePoint. I'm guilty of this, Scott.
- 25:29I have examples. I can think of examples
- 25:31with clients
- 25:32where I totally did the whole security by
- 25:34obscurity. Mhmm. Again, maybe not a big deal
- 25:37because
- 25:38a lot of times when I did this,
- 25:39it's, yeah, we don't necessarily
- 25:42want people to just stumble across it. If
- 25:44they find it, it's not the end of
- 25:46the world.
- 25:47We just wanna make it a little bit
- 25:49more difficult. Well, with Copilot, that difficulty becomes
- 25:52a lot less. So I think you
- 25:54you definitely want to be thinking about permissions
- 25:56a lot more in SharePoint, avoiding the whole
- 25:59security by obscurity and doing security the right
- 26:01way. There's these opportunities, right, to go and
- 26:04think about these things. Yep. The thing I
- 26:05always think about in the back of my
- 26:08head I'm a little spoiled here, right? Like
- 26:10like my employer kinda just has every capability
- 26:14lit up, and
- 26:16everything's available to me there as a user,
- 26:19as a developer, as an admin, like I
- 26:21can go make all those things happen and
- 26:23play in the playground, and it's all hunky
- 26:26dory and great. But
- 26:27I think there is a step for customers
- 26:30to rationalize along the way, things like licensing.
- 26:32Right? Like,
- 26:34now not only do I need to evaluate
- 26:36if I need the feature, now I need
- 26:37to weigh out, do I need the feature,
- 26:39and
- 26:40can I afford the feature, or does the
- 26:42feature have the right kind
- 26:44of TCO
- 26:45for my company? So that could be things
- 26:47like the ability
- 26:49to
- 26:50apply sensitivity labels, right, and enforce them. It
- 26:53could be
- 26:54some of the Purview components that are out
- 26:56there. Like, those are gonna cost you money
- 26:57for maybe Purview. They might cost you money
- 27:00per API call, right, to to come in
- 27:02and figure that. So, like, hey, are you
- 27:04gonna figure out that like, like, how do
- 27:06you figure out, like and sit down. Like,
- 27:08you gotta do some kinda hard modeling and
- 27:10a little bit of work and extrapolation
- 27:12and other things
- 27:14based on your environment, your users, your corpus
- 27:17of data,
- 27:18all that kind of stuff. I will say,
- 27:21generally, like, it feels like the TCO is
- 27:24there and like the juice is worth the
- 27:25squeeze as of right now,
- 27:27but, you know, my thinking, like I said,
- 27:30is kind of colored by just having access
- 27:32to everything all the time.
- 27:33And I don't know that I'm so grounded
- 27:36in,
- 27:37here's like a vanilla tenant. Right? Somebody who
- 27:41never came off, like, e threes or something
- 27:43like that, and they're still in in that
- 27:45world because
- 27:46I've been in different one for a while
- 27:48now, and I think it does, like, change
- 27:50and color my thinking. We could go down
- 27:51a whole licensing
- 28:05features that you pay for. If you use
- 28:08everything that's in the license,
- 28:10I can't I feel like it's worth it.
- 28:12I'm also a small company. You work for
- 28:14the company that owns it all. It is
- 28:16absolutely expensive.
- 28:18I'm not gonna deny that either. I look
- 28:20at some of these bills where you get
- 28:22into eight, ten thousand person companies
- 28:25spending
- 28:26$50
- 28:27on an e five. I mean, that's, yeah,
- 28:3050.
- 28:31You're hundreds of thousands or millions of dollars
- 28:33a year in investment, and then there are
- 28:35companies that are still using other third parties.
- 28:37I was on with one today, and they're
- 28:39using a different antivirus. They're using something else
- 28:41for MDM. And I'm like Mhmm. Do I
- 28:43think you could use e five? Yeah. Is
- 28:45it a little harder to justify it when
- 28:47you're not gonna use all the features because
- 28:49you're using other third party features?
- 28:51Absolutely. Mhmm. Do you need to make that
- 28:53choice of where you want it to sit?
- 28:55I think it's part of, like, the rationalization.
- 28:57Right? So once you've onboarded to these things,
- 29:00kind of opened a little bit your talk
- 29:02track around
- 29:03maintenance and governance and ongoing kinds of things,
- 29:07these are certainly part of that conversation. So
- 29:09you might start off your journey at license
- 29:11level a,
- 29:13and then you sit and you hear about
- 29:15like a new capability or something that might
- 29:17be in a license, it might be a
- 29:18one off feature you can buy, so you're
- 29:20kind of on this constant path of evaluation.
- 29:23I I used to think about this all
- 29:24the time when I was doing
- 29:26SharePoint and Office three sixty five
- 29:29consulting
- 29:30and kind of administration
- 29:32for organizations
- 29:33and things like that, like,
- 29:35is
- 29:36your role goes from
- 29:38hugging servers and managing infrastructure
- 29:41to changing a lot into
- 29:43just rationalizing
- 29:44ROI for your organization,
- 29:47what's your total cost of ownership. So, like,
- 29:49you know, that ten hours a week that
- 29:51you used to spend patching servers, well, guess
- 29:53what? You're spending ten hours a week now
- 29:54maybe doing, like, comparative research and going out
- 29:57there, and may maybe doing things like lighting
- 29:59this up in, like, test environments
- 30:02and really trying to figure it out. So
- 30:05the world is changing rapidly. I think we
- 30:06all kinda see that, right? Like, it's all
- 30:08moving at a kind of a crazy pace
- 30:10going
- 30:11in different directions and often feels like diverging
- 30:14directions. Like,
- 30:15all of a sudden, you were going to
- 30:16the right and you were on a path,
- 30:17and you're like, no. I gotta turn the
- 30:19car around, do a one eighty, and go
- 30:20back the other way, and drive just as
- 30:22far as you just came, but in the
- 30:23opposite direction, and then some kind of thing.
- 30:26So
- 30:27it is important
- 30:28to think through this stuff to go back
- 30:31and look at it, and kind of figure
- 30:33out and weigh it. And is that justification
- 30:38there along the way for you? And then
- 30:40even once the justification's there, there's still all
- 30:42the hard work
- 30:44of what's now like, hey. Great. I got
- 30:46access to, I don't know, sensitivity labels. Like,
- 30:50how am I gonna configure those? What part
- 30:52of the stack am I gonna do it
- 30:53in? Like, you still have to go and
- 30:54evaluate the corpus of data in your environment,
- 30:56understand how your users talk to it, understand
- 30:59the impacts of maybe applying things like that,
- 31:01what type of training you need to give,
- 31:03and all that stuff. So it's a
- 31:06it's
- 31:07a lot, but it also keeps us all
- 31:09employed, which is kinda fun.
- 31:11Pays the bills. Anyways, that was, like, permissions.
- 31:14The other thing I've seen, people created a
- 31:16lot of public sites, and that's especially in
- 31:18or public teams
- 31:20in Microsoft three sixty five groups,
- 31:22especially initially
- 31:23without thinking through
- 31:25or maybe even realizing it sometimes that if
- 31:28it's public, anybody can go grant themselves access
- 31:31to that group and just get access to
- 31:33all the content in it. So another one
- 31:36of those,
- 31:37I think people really need to think about
- 31:39where do we need to either move content
- 31:41out of public groups or
- 31:43create private groups going forward as the default.
- 31:47Mhmm. That's something to think about. Correctly configure
- 31:49default sharing links. This is becoming one of
- 31:52my pet peeves. People that leave org wide
- 31:55Nobody does this.
- 31:57They don't. Maybe they do, and I'm I'm
- 31:59just not seeing it. I see it a
- 32:01lot in customers.
- 32:04It it it's kinda fun to go through,
- 32:06like, the Office three sixty five subreddit and
- 32:09things like that and just see some of
- 32:11the,
- 32:12the issues that pop up over time to
- 32:14ultimately, like, what's a low hanging fruit configuration
- 32:18task, but I get it takes time. Like,
- 32:20again, like, you can't just shut it off
- 32:22wholesale without understanding how your users are using
- 32:24it and and what's going on out there.
- 32:25And, like, all of a sudden, like, that
- 32:27little thing where it's like, yeah, let me
- 32:29change that configuration item turns into, like, a
- 32:31project or something that requires
- 32:34a little bit
- 32:35a little bit more long term thinking, but
- 32:38it is funny how that's kinda ends up
- 32:40being the
- 32:41just the default state
- 32:43in a lot of places. And then these
- 32:45are often the things that you hear about
- 32:46in the news, right? Like when somebody gets
- 32:48quote unquote hacked, and it's like, no, they
- 32:50didn't get hacked. They were just configured wrong.
- 32:52They were wide open from the start. Yeah.
- 32:54Your Facebook account wasn't hacked. You just stayed
- 32:56signed in on a device someone else had
- 32:58access to. Mhmm. 100%. And
- 33:01if you leave it as org wide, guarantee
- 33:03it's nothing people are doing intentionally. They just
- 33:05click share content and click the copy link
- 33:07button. They don't even realize what they're doing.
- 33:09So I also place some of the blame
- 33:11here on people that just roll this out
- 33:12without training their end users on how to
- 33:15properly share. Org wide is easy. You still
- 33:17need to train your users. Don't click org
- 33:20wide only or organizational link. This is what
- 33:23it does. One nice thing I do, Microsoft
- 33:25is coming out I don't know if you've
- 33:27seen this on the roadmap, with the hero
- 33:29links coming the end of this year, where
- 33:32right now when you go share it, it
- 33:34actually creates multiple links. Every time you share
- 33:37it, it creates
- 33:38another link. So you have one organizational wide
- 33:41link, and then you have an edit link,
- 33:42and then you have a view link, you
- 33:43know, all of this.
- 33:44It is changing so that in December, when
- 33:47this new hero link comes out, it creates
- 33:49one link, and then you're actually just able
- 33:51to adjust permissions
- 33:53on a single link. So you don't need
- 33:55to go back and clean up a whole
- 33:56bunch of links. You're just gonna have one
- 33:58link. You're gonna have to manage permissions on
- 34:00it.
- 34:00The other thing
- 34:02that is going to be part of this,
- 34:05even better than hero links, is changing the
- 34:07default
- 34:08right now, and I've heard a lot of
- 34:10people complain about this. You can't set the
- 34:12default to people with existing access. You can
- 34:15either set it to specific people or set
- 34:17it to org wide. You can set it
- 34:19to just by default create a link, but
- 34:22only people that have access already are gonna
- 34:25use this link. That's kinda bundled in this
- 34:27hero links is setting that default now to
- 34:30existing people only, so you're not Yes. It
- 34:34makes it a lot easier to share a
- 34:36link and not have it change permissions
- 34:38than kind of that experience today. That's another
- 34:41one. The SharePoint indexes,
- 34:43you can remove stuff from Copilot by just
- 34:46turning off the search index. Downside is it.
- 34:48Also, it turns off the search index. You
- 34:50remove a search. Yeah. Securing content with policies,
- 34:53sensitivity labels, setting DLP. We're gonna run out
- 34:55of time here, Scott. We might have to
- 34:57do part two. And then the other one
- 34:59I wanna mention here, there's a button now
- 35:01in the SharePoint admin center that says restrict
- 35:03content from Copilot on each site. I can
- 35:06go into a site, click the little radio
- 35:08button that says restrict content or restrict access
- 35:11to Copilot. I want Microsoft to change the
- 35:13verbiage on this. This is very deceptive to
- 35:16me because
- 35:17the way it reads, I would think, oh,
- 35:19I click this. This site's not gonna be
- 35:21included in Copilot. If you click on the
- 35:23little information
- 35:25bubble and hover over it and then click
- 35:27on learn more, and maybe it even has
- 35:29it in the bubble,
- 35:30this is not just remove it from Copilot.
- 35:33This is
- 35:34don't return
- 35:35content from this site in Copilot or in
- 35:38search if it hasn't been recently accessed by
- 35:41the user. So if a user goes to
- 35:43it and clicks on it or interacts with
- 35:46it or somehow
- 35:48accesses that content
- 35:49recently, it's all of a gust setting gonna
- 35:52start showing up in Copilot and SharePoint.
- 35:54Does it help in the cleanup? Yeah. But
- 35:56does it really restrict it from Copilot?
- 36:00They need to make it more clear. It's
- 36:01not what it seems to be. The devil's
- 36:04in the details. So so, you know, that
- 36:06feature is called restricted content discovery.
- 36:10It is not called block content discovery
- 36:12or never do content discovery
- 36:15again. I think
- 36:17the rub with that one is
- 36:20recent interaction.
- 36:21Like if somebody just hears the word recent
- 36:24interaction, right? Like, All right, well, what was
- 36:26a recent interaction for me? Was that
- 36:29thirty days? Was it ninety days?
- 36:32And, you know, however it comes together. And
- 36:35then what do you do with your users
- 36:37who I I think this is the other
- 36:38side of that one, is
- 36:41you turn that feature on, and they have
- 36:42a good experience on day one, which is
- 36:44what you want them to do. Like, you've
- 36:45gone through, you've configured your environment, That so
- 36:48you restricted it. They had the recent interaction.
- 36:49They were able to use it in Copilot
- 36:51and
- 36:52in Teams and business chat, all those things.
- 36:55And then
- 36:56maybe their role is, like, quarterly or biyearly.
- 37:00So they only come back and they touch
- 37:01that thing, and then next time it's horrible.
- 37:03Like, it doesn't give them the same result.
- 37:04It doesn't do the same thing. Features like
- 37:06that are nice, but, like, they're also, like,
- 37:08really hard to rationalize, particularly as a user.
- 37:11Like, why is
- 37:12why is a system that's already nondeterministic
- 37:16already being like, it's being, like, super nondeterministic
- 37:20now?
- 37:21Like, what did it do,
- 37:22and which way did it go? So,
- 37:25yeah, I
- 37:26think, in general, there is a bunch for
- 37:29folks to think about here.
- 37:31We'd love to hear about
- 37:33how you're thinking about securing your environments. Like,
- 37:36do you have any tips and tricks? Maybe
- 37:37you've got, like, a favorite repo of
- 37:40PowerShell scripts or things like that that you're
- 37:43go that you're using for
- 37:45go to management.
- 37:46Maybe you have
- 37:47alternatives for some of these things, like Ben
- 37:49was mentioning
- 37:51finding duplicate files earlier.
- 37:53I know there's third party products that do
- 37:54that. Maybe you're one of these customers who's
- 37:56like a like you said, Ben, you do
- 37:57the Ben thing, like you described, with multiple
- 38:00licenses,
- 38:01lots of ISV tooling, things like that. Like,
- 38:04we'd love to hear more about the ecosystem
- 38:06and your experience with it. So we've
- 38:09contact form on the website, which you can
- 38:12go to. It's pretty easy.
- 38:14M s cloud I t pro podcast dot
- 38:16com, and you'll see a big
- 38:18contact us button there. That just sends Ben
- 38:21an email, and then he usually just loops
- 38:24me in on on on the thread. You
- 38:25can also get us get ahold of us
- 38:27on LinkedIn.
- 38:28The podcast has a page on LinkedIn if
- 38:30you wanna directly ask questions there. Ben's on
- 38:32LinkedIn. I'm on LinkedIn as well. So,
- 38:35like, come back. Give us some feedback. Let
- 38:36us know how you're using it. We're eager
- 38:38to hear. And maybe like you said, Ben,
- 38:40maybe we can kinda come back and do
- 38:42a part two on this one.
- 38:44And
- 38:45or if not, like, finish the conversation because
- 38:48maybe we should come back and talk about
- 38:50some of the,
- 38:52DSPM stuff,
- 38:53some of the reporting aspects,
- 38:56how to do risk assessments,
- 38:58and all that. And that way, we can
- 39:00kind of round out the entire story. Yeah.
- 39:02I think we should do a part two
- 39:03on DSPM for
- 39:05AI and DLP and sensitivity labels and some
- 39:08of that. So we'll come back and talk
- 39:10more about that in a later episode. Alright.
- 39:12Come back and check us out for that
- 39:14one. As always, thanks, Ben. Much appreciate it.
- 39:16Glad to have you back from vacation, and
- 39:19we'll get back on track here. Alright. Thank
- 39:21you, and have a good weekend. Talk to
- 39:23you next time. Thanks, Ben.
- 39:26If you enjoyed the podcast, go leave us
- 39:28a five star rating in iTunes. It helps
- 39:31to get the word out so more IT
- 39:32pros can learn about Office three sixty five
- 39:34and Azure.
- 39:36If you have any questions you want us
- 39:37to address on the show, or feedback about
- 39:40the show, feel free to reach out via
- 39:42our website, Twitter, or Facebook.
- 39:44Thanks again for listening, and have a great
- 39:46day.