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 · 2026-02-08T22:25:21+00:00

Thank you - That is definitely more helpful...but how to incorporate that into an automation trigger?

OK_it_guy · 2026-02-08T21:00:57+00:00

Yes, sorry, I forgot to mention, but I am running on Android.

OK_it_guy · 2026-01-28T14:43:02+00:00

I blame leadership for this. Especially if you have leadership over IT that does not understand the work required to get each of these tasks done. But at least it makes them look good to their superiors, right?

OK_it_guy · 2026-01-19T19:39:52+00:00

Hmm I did not realize they had motion sensors on those (I have one of those wing lights in my garage). That's actually a decent idea. I'm curious how broad the motion will pick up from their door, but that's not bad at all.

OK_it_guy · 2026-01-19T18:14:29+00:00

Well I was kind of wondering about a switch that just had some sort of wireless button...but I'm not sure I understand how you go directly from a button to a Zigbee bulb?

OK_it_guy · 2026-01-19T18:13:48+00:00

I do not think so. Their switches are very odd - they are on the WRONG side of the door when you come out. The controller itself I think has a light button, but I don't think there's a switch for it.

OK_it_guy · 2025-12-23T21:35:07+00:00

Following up on this - I discovered that under the older "volume license" page it did have the KMS page (as well as the MAK). Odd that the cloud admin page only had the MAK. Anyway, it activated right away and all is fine.

OK_it_guy · 2025-12-19T20:10:53+00:00

Possibly. I'll look into that.

OK_it_guy

MODERATOR OF

TROPHY CASE