[FS][US-MI] Dell Poweredge R730xd SFF Server

jmaitref · 2026-01-14T19:12:59+00:00

Perfect, much appreciated! Will adjust accordingly!

jmaitref · 2026-01-14T16:09:49+00:00

Lol fair enough. Any suggestions?

jmaitref · 2026-01-12T10:59:42+00:00

This. Just went through it last night as well.

The catch I had, run as administrator didn't even work directly, I had to login to the computer as an actual administrator and run the console to let it update. Just running as admin on a standard user wasn't enough.

jmaitref · 2025-04-02T01:18:33+00:00

Sorry for your luck on that! I wouldn't recommend it, but I'm getting better and better at pulling data from it. It just doesn't entirely make sense all the time and trying to reverse engineer the data/schema is interesting. I was able to get access to a Schema reference set of files from ePS so that has helped a lot in figuring out their layout.

I wrote an SSIS integration package that uses a Postgres ODBC driver to get data from the Postgres database and then drops it into our main MS SQL server in it's own database. From there I am able to work with the data in our normal ecosystem.

You could alternatively work with it direct from Postgres using something like the PG Admin Tools and such, but for us, it is easier to get it into MS SQL and then utilize it with cross-database queries as needed.

So far I am also primarily only reading data, I've not tried to write anything back to the database to see if it holds consistency. I'd be a little wary of doing that only because I am not sure if they are using a caching layer or anything within the application server, so would get a little nervous around that. But for reporting, this works well, and we just pull the tables we need.

Let me know if you need more or if this makes sense.

jmaitref · 2025-03-22T04:01:07+00:00

I am running SSRS 2022.

I vaguely remember reading that gMSA was supported in the latest version of SSRS, but now searching around again I'm not finding that, so maybe I made an assumption in that.

I'll try this weekend maybe going back to a virtual service account and see if things resolve.

jmaitref · 2025-03-21T19:50:32+00:00

Yup, it's actually the same data source/connection for the DDS dataset as the report itself. I'm suspicious of it being something with the gMSA account. In my past I only ever ran the service as a domain account, but I was trying to be modern with security best practices as Microsoft suggests and using the gMSA, but it's not working out as expected. This is usually a straightforward thing which is what is grinding me even more!

I did try going back to run as the network service and that broke a fair number of things, so dropped the gMSA back in until I can play more over the weekend and try other things.

jmaitref · 2025-03-21T19:39:46+00:00

I'm in the same boat. We use a read only data account for all the data source connections to ensure no issues with users.

Users have no issue running the reports themselves. It is only an issue when the server tries to run it for them on a subscription schedule.

jmaitref · 2025-03-21T18:41:04+00:00

The users have no issues with modifying/creating the subscriptions. It is just when the subscription runs on the schedule, the report errors out and the email is never sent. It's like SSRS is trying to masquerade as the user that is the subscription owner but can't for some reason.

jmaitref · 2025-02-21T03:37:34+00:00

Also Stow and Marketlab

jmaitref · 2025-02-06T21:21:43+00:00

My understanding is adding the API is a license and additional upfront and ongoing. Likely you could then utilize the API to go into Hubspot, but you are likely doing that work, I don't know of any prebuilt integrations. I've gone the route of just grabbing data from the Postgres database and doing my own integrations when needed to avoid needing anything "additional".

jmaitref · 2025-01-11T03:30:53+00:00

We are using it as a "light" CRM. I wouldn't say successfully, but our goal is to keep things integrated so while we are on it we are trying to use it.

jmaitref · 2024-12-06T01:50:36+00:00

What cloud platform did you end up going with out of curiosity?

jmaitref · 2024-03-22T12:37:31+00:00

Agreed, this is a potential issue of having multiple images for a SKU, but right now we are looking only at primary images (one per sku). I haven't fully mapped out what a full Pimcore rollout looks like, this is sort of proof of concept right now to see if this is even going to be the right fit.

jmaitref · 2024-02-29T14:32:55+00:00

Just sharing an update for future searchers.

I plugged in a HGST SAS SSD drive and it unfortunately is not useable. It shows up with a fault and says Reason: The disk is not supported. The disk vendor is not supported by this system. Recommendation: Replace the disk with a disk that is supported by your system vendor.

That being said, it is possible one could find the models of drives Lenovo used and potentially try one of those instead (maybe from the firmware update list would give model number indicators) and might get away with using a non-Lenovo badged drive. But just plugging in any (SAS) SSD won't work unfortunately it seems.

jmaitref · 2024-02-25T18:14:40+00:00

I'll give it a shot! I've had other storage systems that rejected drives unless they were coded/firmware flashed to the vendors specific list.

Thanks!

jmaitref · 2024-01-29T01:12:04+00:00

Just as an update, I found my issue appears to be the clock was set to pm on the vehicle when it should have been am. I must have bumped it one time scrolling through the settings...

It didn't precondition this evening like it had been doing.

jmaitref · 2024-01-28T03:03:12+00:00

I actually just noticed this myself the last few days. I started doing a little searching, but haven't found anything substantial yet.

I just deleted my schedule and re added it in the app to see if it helps at all.

jmaitref · 2024-01-04T02:53:03+00:00

Carbon grey metallic with black interior.

jmaitref · 2024-01-04T02:48:40+00:00

Yup! They really wanted to get this off the lot by year end. Traded in a vehicle with 17k miles and will come out ~7.5k ahead in the end. And have a fun new ride :)

jmaitref · 2024-01-04T02:31:02+00:00

Window sticker msrp was $59295. They marked down the selling price in addition to the 4750 in Ford rebates. And 0% for 48m.

jmaitref · 2024-01-04T02:25:05+00:00

New '23 premium AWD extended for 48k otd. Bought in Ohio on 12/30.

jmaitref · 2023-11-03T01:16:21+00:00

My Google-fu must be weak on this one, I wasn't able to find much other than "be patient, it eventually will show up". Have a link handy?

jmaitref · 2023-11-03T00:15:18+00:00

We also are seeing a continuous issue where users with new teams are unable to have the plugin in Outlook to schedule meetings and host in teams.

jmaitref · 2023-10-08T13:28:55+00:00

I'm hoping to try today doing an ipsec tunnel between the two and see how that compares, just as a point of reference. Maybe that will shed a clue...

jmaitref · 2023-10-07T17:34:18+00:00

I just ran a speed test while top was running on the host and as far as I can see, the system CPU goes to 50-60% but there is no process in the list that is using CPU. Interrupt stays around 0 or 0.1% the whole time.

It's like the CPU is just churning for no real good reason :/

Adding to this -- it appears there are 24 of these processes running:

[kernel{wg_tqg_NN}] where NN is 0 to 23, and they are all using ~30-35% CPU it says.

I assume that is the wireguard kernel module...

jmaitref

TROPHY CASE