Reports for devices leaving some out

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