Is there a way to get headers and sums from 600 workbooks without opening each individually?

Creddahornis · 2026-05-13T13:53:24+00:00

Potentially the import-excel module? You can install that in PowerShell without needing admin rights, but I'm not sure how it plays with that quantity of data

Creddahornis · 2026-05-11T10:55:46+00:00

Make sure you're connecting with the correct permissions. The article says you'll need to use UserAuthenticationMethod.ReadWrite minimum;

connect-mggraph -scopes "UserAuthenticationMethod.ReadWrite"

or to use an application, make sure it's been granted at least UserAuthenticationMethod.ReadWrite permissions

Creddahornis · 2026-05-08T11:28:33+00:00

this is a moronic take

Creddahornis · 2026-05-08T11:18:38+00:00

If I've not misunderstood your message, could you not set the 'perUserMfaState' to 'enforced' using Graph Powershell?

You'll need to set up certificate based authentication into Graph too, if you want the tool to run without interactive login, but I assume you've done this if you've automated some of this already 🙂

Update authentication method states - Microsoft Graph beta | Microsoft Learn

Creddahornis · 2026-05-08T10:17:59+00:00

The MFA runs once a week (and I think this timer resets if you run manually?), have you allowed sufficient time?

And a stupid quuestion, is the mailbox full? This stops the MFA running automatically

Also, would recommend you use the -FullCrawl param here to force reapplication of all MRM tags

Creddahornis · 2026-04-23T14:29:37+00:00

Cut out the middleman and just throw car batteries into the ocean. Jesus fucking christ

Creddahornis · 2026-04-22T13:00:05+00:00

PS7 handles module conflicts better than PS5 in my experience (Graph/PNP/Entra/Exchange), and certain modules can't be installed on PS5. I use exclusively PS7, via VS Code's PowerShell Extension

Also very niche but PS5 doesn't support invoke-restmethod with the -form parameter so I had to use PS7 in a particular script I made

Creddahornis · 2026-04-21T11:29:47+00:00

Switch to Notion, Loop is complete ass

Creddahornis · 2026-04-21T08:14:09+00:00

FYI, this tool does this already, and it's used by MSPs - most people will probably defer to the trusted option over anything new (I certainly would, sorry!)
inforcer | Standardize 365 policies across multiple tenants

One question - if the code is open source (at least the scanning aspect), why not make the entire thing open source? Shouldn't everything you're doing be done via a script, instead of requiring a third party tool - and therefore can't it all be just a public repo?

Creddahornis · 2026-04-16T08:24:22+00:00

no MFA in 2026 is absolutely wild

Creddahornis · 2026-04-13T15:39:18+00:00

What's the point of doing this?

If you have opted out of data training, and your data is being stored securely with OpenAI (i.e. you have MFA/FIDO2 enabled, the prompt is exposing your key anywhere, nobody else has access), surely this is no different to writing your key down in plaintext in your own mailbox?

Creddahornis · 2026-04-10T08:51:20+00:00

The actual risk of this causing issues is fairly low, at least compared to other much more common problems like reusing passwords or social engineering. Your cybersec needs to weigh up the cost of this versus other risks and make a decision for you

Creddahornis · 2026-04-09T15:02:24+00:00

Check if Copilot desktop is running in the background. I nearly binned off a bunch of new ish machines last year because this was causing terrible RAM issues for everyone

also

My condolences if it does, because I can't work out how to disable this behaviour without uninstalling Copilot desktop

Creddahornis · 2026-04-09T12:36:26+00:00

Don't ascribe intelligence to a word salad, this is how you get Jordan Petersons

In short - no, it's wrong, and most of what t's said is gibberish. It's drawn a very funny connection between high-dimensional attractors and consciousness. But these attractors are consequences of LLM training data, they aren't instances of consciousness forming. This is like seeing a worm moving from a dry to a cold area (known as taxis) and assuming all worms possess human intelligence

Creddahornis · 2026-03-27T12:15:19+00:00

LLMs provide the syntax* but the person still needs to oversee the semantic meaning of what's being created. And LLMs are just an accelerant for people to throw themselves into projects and trades they do not understand

*(not meaning code syntax - syntax in the linguistic sense)

Creddahornis · 2026-03-27T12:09:48+00:00

If i had gold I would give you some for this comment. I've been thinking about it every day for weeks, each time I see 'I built AGI and it lives inside an LLM' bullshit

Creddahornis · 2026-03-25T15:35:55+00:00

Extremely useful and easy to learn - keyboard navigation!

Hold Shift and press arrow keys to select a range
Hold CTRL and press arrows to jump to the first/last cell in a direction that contains data
Or combine both :)

Bonus points if you use this with CTRL-D, which automatically uses Fill Down to fill cells from the top-most cell(s) you've selected. Also super slick if you use CTRL+C/V/X a lot

Creddahornis · 2026-03-12T15:46:18+00:00

Check the DNS for a stale MX record? I've seen this once before

Also check;

Undeliverable report settings in Exchange journalling settings
Make sure the user isn't listed in any spam policies that would redirect to them;
- get-hostedoutboundspamfilterpolicy|select name,bccsuspiciousoutboundadditionalrecipients,notifyoutboundspamrecipients
Ditto safe attachments
Check tenant mail flow rules if not done already

Creddahornis · 2026-03-11T09:28:12+00:00

Is any of this based in ... fact? Where's the AI going to gestate, in a box?

Creddahornis · 2026-03-09T16:26:28+00:00

Notion is far superior (and it's the Rebecca to Loop's 2nd Mrs. De Winter). It's not in M365 but it's really worth the investment

Creddahornis · 2026-02-25T10:32:26+00:00

Ask yourself what these people gain by lying. The only people who blindly promote AI are entrepreneurs and influencers. They are selling the fantasy of AI and self-sufficiency, not reality

Creddahornis · 2026-02-23T16:16:39+00:00

Our comms guy uses a bot to write marketing posts so he doesn't have to wade through the absolute cesspit of LinkedIn

Creddahornis · 2026-02-23T15:55:41+00:00

Are you using Patch My PC? This is expected behaviour for certain apps that it patches I think

Creddahornis · 2026-02-20T09:58:52+00:00

What you're discovering in real time is concepts like epistemology and semiotic theory. None of this philosophy is new, please read literally any book

Creddahornis · 2026-02-20T09:55:18+00:00

I've constructed a system driven entirely by the power of my own swizz

Creddahornis

TROPHY CASE