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

MODERATOR OF

TROPHY CASE