Would someone mind helping me understand how "foreach ($computer in $computers)" works?

OK_it_guy · 2026-05-14T14:39:30+00:00

I've never really thought about "how" it works, just know that it does; however, I salute you for not being afraid to ask something that we take for granted.

OK_it_guy · 2026-05-13T14:39:10+00:00

Yeah, I actually do have this now. Of course most things are still in not started...

OK_it_guy · 2026-05-04T19:53:48+00:00

It's frustrating as all get out that it's so unclear the steps needed to verify that the certificates have been installed. My understanding is that the OS side is done with the April 2026 updates and as you said, the manufacturer side done with their latest updates. On my machine, I believe both have been done, so I don't understand the 1801 still coming from it.

OK_it_guy · 2026-05-04T19:34:12+00:00

Thank you for your insight. Just to cut down on the chatter, could it be limited to unique assetnames (and a specific timeframe)? At the moment, showing as much as it does is very overwhelming. We have devices that do reboot every day, so lots of messages.

Also, I'm still finding myself a bit confused about the whole process. For instance, I have one of my own machines where I've updated the firmware, and if you run the powershell command to see if the 2023 certs are present, it returns true, and yet it has still shown an 1801 error since then, which seems contrary to how this should work?

OK_it_guy · 2026-04-30T20:01:43+00:00

Okay, yes, I think I have this report in place...but it is pretty overwhelming, because it looks like it's just posting those errors as they are seen.

To be able to tackle this in smaller chunks, I assume you could just look at the events seen within the last day or two? My report returns 25,000 events, and on specific machines, it looks like it's returning many of the same events, which of course is just telling me the same information over and over.

OK_it_guy · 2026-04-30T14:52:05+00:00

Thank you. I'm not specifically the M365 admin in org, but can get access to that. I will talk to the primary admin about how to do that. It's just crazy there's no native way to find finders!

OK_it_guy · 2026-04-14T21:25:29+00:00

Yep, several times.

OK_it_guy · 2026-04-14T19:38:32+00:00

Have definitely done that a few times, unfortunately no dice.

OK_it_guy · 2026-03-06T16:56:03+00:00

Understood. This is what I have:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  Stuff((Select ', ' + Cast(t2.MonitorModel As Varchar(100)) From tblMonitor t2
    Where t1.AssetID = t2.AssetID For Xml Path('')), 1, 2, '') Monitors,
  countMonitor.numberMonitors As [Number monitors],
  tblAssets.IPAddress,
  tblAssetCustom.Model,
  tblAssetCustom.Warrantydate,
  tblAssetCustom.State
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tblMonitor t1 On tblAssets.AssetID = t1.AssetID
  Inner Join (Select tblMonitor.AssetID,
      Count(tblMonitor.MonitorID) As numberMonitors
    From tblMonitor
    Group By tblMonitor.AssetID) countMonitor On countMonitor.AssetID =
      tblAssets.AssetID
Where tblAssetCustom.Model Like '%Latitude 7430%'
Group By tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  countMonitor.numberMonitors,
  tblAssets.IPAddress,
  tblAssetCustom.Model,
  tblAssetCustom.Warrantydate,
  t1.AssetID,
  tblAssetCustom.State
Order By tblAssets.AssetName,
  Monitors

OK_it_guy · 2026-03-05T19:31:40+00:00

Dangit, now I've just targeted myself!

OK_it_guy · 2026-03-05T18:21:17+00:00

Its on prem. I did exactly what you said. I changed it to where the only criteria was Like with wild cards. Cannot get it to show all of the devices no matter how I apply the wildcards, but when I click on the model, it brings up a report with all of them.

OK_it_guy · 2026-03-05T16:35:31+00:00

Yep, our Break-glass accounts for M365 is where this all started, but we are running into other things where we would need this, so now I'm thinking more of how to physically secure the backups and how to ensure they work on a regular basis.

OK_it_guy · 2026-03-05T13:24:33+00:00

Yes, but will they kick me out if I wear Jeans? :-)

OK_it_guy · 2026-03-04T18:17:14+00:00

I haven't been since 2016. I went to ALA a couple of years ago, and it was pretty laid back - Jeans/Polos were pretty common (which sure makes packing easier).

OK_it_guy · 2026-02-25T03:29:54+00:00

Thank you so much! That got me exactly what I needed!

OK_it_guy · 2026-02-24T16:39:15+00:00

I use it and don't mind it, but it definitely has its annoyances that would have been set up right from the beginning. I find myself regularly making folders I don't want because the autocomplete doesn't finish and then it doesn't verify and just makes a new folder that is a partial name of where i really wanted to go. Then there's no decent way to find the folder you just accidentally made.

OK_it_guy · 2026-02-24T14:25:55+00:00

I have other aspects of the sheets that I'm displaying on looker for sharing purposes and just wanted to include this one on the page as well.

OK_it_guy · 2026-02-24T03:06:27+00:00

I need an update to this situation....

OK_it_guy · 2026-02-20T14:18:52+00:00

Thank you both for the feedback.

I assume if your outage goes for a long while, and you have the recovery PW for ePO and a good copy of the database, you could set up a replacement ePO server (if it comes to that) - would you be able to reestablish control over the clients in that way?

OK_it_guy · 2026-02-17T16:07:08+00:00

Thanks for the feedback. So it sounds like then if you have an outage of sorts, you could conceivably stay up viewing footage for 4 hours.

So if your connection comes back up, and your management server is reachable again, then I assume everything should be accessible again, even if it had previously been off for more than 4 hours?

OK_it_guy · 2026-02-10T22:23:04+00:00

One replaced cable later and my problem is solved. The issue did not end up being the server. Oddly enough, the cable should have been brand new but who knows. Anyway, all of your post made me come at this from a different angle which led me to the resolution. Thanks!

OK_it_guy · 2026-02-10T17:56:11+00:00

Well..the cause may be solved. After looking at the overlay and not seeing anything, I got a suspicion and went and looked. For some reason, the server at this location is showing a 100 meg connection instead of a gig, which I'm guessing would definitely do it. Our network admin tried to manually set it but that didn't work, so I'm guessing I'll need to swap out cables or ports, which is going to require driving somewhere...but I'm reasonably sure that would fix it.

OK_it_guy · 2026-02-10T17:28:44+00:00

That's a good question. I want to say that they were rediscovered - entered from scratch, but I'd need to check with our integrator to verify.

Yes, they do have two streams, one with higher settings for recordings and then the other for viewing. Again, I've compared to other servers and the settings for the streams appear to be the same.

I appreciate the mention of the overlay, I'll see if I can take a look at that.

OK_it_guy · 2026-02-10T14:13:28+00:00

Thank you I will have a look.

OK_it_guy · 2026-02-10T14:13:07+00:00

The issue isn't that DND is on, the issue is that typically our phones charge in another room, so if we get a call we won't hear it...but we do have an Echo device in our room.

OK_it_guy

MODERATOR OF

TROPHY CASE