I’ve had this problem mostly in the context of working for a consultancy company, but most of the job being on a client’s site. So I have two computers, two networks, two inboxes, etc.
In that particular situation, everything was just mashed together and my index told me where stuff was. So 11.01 might have been on the consultancy’s network, and 11.02 on the client’s. This worked, for me, because I was the only one using it.
Also at the start I didn’t design that system. I just had to get on with the job. So things were smashed together out of necessity.
If you have the luxury of thinking about it, I think an approach like yours makes a lot of sense. I can’t help but feel that there’ll be exceptions, and handling those will need to be part of your plan.
What if someone stores a blue thing in Teams? 'Cos they’re gonna, you know they are.
An index is absolutely critical in this situation.
I certainly feel your pain. In the modern workplace there are so many places that a thing can be. And I’m talking top-line places; we haven’t even gone down a folder level yet. It’s madness.
Anecdote. My mate Alex was talking to a guy he used to work with. He said how he’d been on this Teams session with one of those Microsoft 80" TV whiteboard things, like a giant iPad. They’re cool, I like them.
So they draw all this useful stuff, and the meeting ends. And now where is that stuff? Nobody had any idea. When he spoke to Alex, days later, they still hadn’t found it.
(In the SharePoint folder for that particular Teams session is likely the answer. But you have to know that that exists, and how to get to it.)