|
GnarlyCharlie4u posted:The hardware is fine. HP Elite 8300 i7. They get really snappy if you replace the spindle drives, and do just fine with 8gb ram so that's what we're doing. Did you know that you can launch a Litetouch deployment from within windows? You don't have to network boot at all, the scripts will apply the deployment PE image, then restart automatically. Companies that don't do network deployments in TYOL 2017.
|
# ? May 1, 2017 18:42 |
|
|
# ? Jun 13, 2024 06:34 |
|
GnarlyCharlie4u posted:Since we don't have a pxe boot server the fastest way to do this is probably just to set up a deployment environment since you have 300 to do.
|
# ? May 1, 2017 19:06 |
|
The Fool posted:Did you know that you can launch a Litetouch deployment from within windows? You don't have to network boot at all, the scripts will apply the deployment PE image, then restart automatically. I still haven't set up any sort of network deployment at work and I feel ashamed about this constantly.
|
# ? May 1, 2017 19:10 |
|
GnarlyCharlie4u posted:300 or so. A fair number of them are laptops that come and go from our network, seemingly as they please. Just to be clear, you realize that SCCM has a hard requirement for an intrusive client agent, right? Like someone else said, use Powershell to pull the machine list from AD and do a foreach {GWMI -class Win32_ComputerSystem -Computer $_} for whatever you want to pull. Assuming you guys haven't turned off WinRM, that is. Wrath of the Bitch King fucked around with this message at 19:14 on May 1, 2017 |
# ? May 1, 2017 19:11 |
|
You can set up MDT with a discovery image on a USB stick in about 2 hours or so.
|
# ? May 1, 2017 19:12 |
|
GnarlyCharlie4u posted:The hardware is fine. HP Elite 8300 i7. They get really snappy if you replace the spindle drives, and do just fine with 8gb ram so that's what we're doing. Good god, this poo poo is hurting my soul I would push out a powershell script via GPO that gathers the info you need and dumps it to a .csv on the c: drive, and copies it to a network share you setup somewhere. You can combine all csv files into one big csv file pretty easily. Imaging with MDT can be done with an offline media set as well in addition to the aforementioned running Litetouch from the computer itself. We have small remote sites we ship external hard drives or USB sticks to with offline MDT info if a machine needs to be reimaged. This poo poo is turning into goon in a well though. Next you'll tell us you can use GPO's and there's no money for a thumbdrive. Inspector_666 posted:I still haven't set up any sort of network deployment at work and I feel ashamed about this constantly. Not the end of the world as long as you don't spend a dumb amount of time re imaging things. I used fat images a decade ago when I was a support guy for a building that had 100% of the same make/model computers. Once we got 3 different models and 6 different images I moved to a proper imaging solution and never looked back. gently caress fat images. skipdogg fucked around with this message at 19:18 on May 1, 2017 |
# ? May 1, 2017 19:15 |
|
Japanese Dating Sim posted:You can set up MDT with a discovery image on a USB stick in about 2 hours or so. Man half that time is just going to be downloading and installing the ADK.
|
# ? May 1, 2017 19:18 |
|
Wrath of the Bitch King posted:Just to be clear, you realize that SCCM has a hard requirement for an intrusive client agent, right? Which we already have installed on the computers. The boss is distrustful of 3rd party applications. Particularly ones we haven't evaluated yet. Thanks Ants posted:to set up a deployment environment since you have 300 to do. The Fool posted:Did you know that you can launch a Litetouch deployment from within windows? You don't have to network boot at all, the scripts will apply the deployment PE image, then restart automatically. But yeah I agree. I try to make the case about once every couple months and inevitably get shutdown "because reasons." skipdogg posted:Good god, this poo poo is hurting my soul We have money for a thumbdrive, we just also have a boss who thinks he knows better than his sysadmins. GnarlyCharlie4u fucked around with this message at 19:44 on May 1, 2017 |
# ? May 1, 2017 19:36 |
|
GnarlyCharlie4u posted:Which we already have installed on the computers. The boss is distrustful of 3rd party applications. Particularly ones we haven't evaluated yet. Sorry, I must have misunderstood. If that's the case you're already done; use some of the builtin canned hardware reports in SCCM to pull the info. It's already prepped for you assuming you've got all the correct stuff enabled in your Hardware Inventory WMI checklist.
|
# ? May 1, 2017 19:56 |
|
They just fired one of our remote workers I am not surprised, our manager has been gunning for him for a while, but he's a smart guy (also he's the SME on a product we use and it's going to be difficult to pickup management of it), he just doesn't communicate well and his work has been a little sloppy lately. He's got a lot of poo poo going on in his life so I'm not surprised he was sloppy, from what I heard his wife left him, he's got 3 kids etc etc and now he doesn't have a job. I'm sad, need dog.
|
# ? May 1, 2017 19:58 |
|
Opinion time: is a 6600u with 8gb of RAM getting bogged down on a 10850 row, 53 column Excel sheet (all formulas) with source data sheets holding the same rows and then some for about 45 seconds per update a lovely computer, lovely optimization, or both? I'm thinking both.
|
# ? May 1, 2017 22:43 |
|
22 Eargesplitten posted:Opinion time: is a 6600u with 8gb of RAM getting bogged down on a 10850 row, 53 column Excel sheet (all formulas) with source data sheets holding the same rows and then some for about 45 seconds per update a lovely computer, lovely optimization, or both? I'm thinking both. Surely to god there's software or a database for this.
|
# ? May 1, 2017 22:45 |
|
22 Eargesplitten posted:Opinion time: is a 6600u with 8gb of RAM getting bogged down on a 10850 row, 53 column Excel sheet (all formulas) with source data sheets holding the same rows and then some for about 45 seconds per update a lovely computer, lovely optimization, or both? I'm thinking both. Why the gently caress is an Excel sheet being used here.
|
# ? May 1, 2017 22:53 |
|
You would think so, but it's a Budget/Actual report for a project nowhere near done. Technically the source data is in the ERP database, but there's no way to plug it in that I know of. We're going to be doing some SQL work soon, my boss mentioned using SQL in Excel, so maybe we're just making GBS threads something out for the steering committee to keep them happy while we do it right.
|
# ? May 1, 2017 22:55 |
|
That data should be processed by something that isn't Excel.
|
# ? May 1, 2017 23:01 |
|
I guess I didn't realize that huge Excel sheets like that were so unusual. At one of my jobs the tax accountant had sheets that were literally hundreds of thousands of rows. The only reason this is even taking so long is that I'm having to fill in holes in our documentation as I go. This is the first report this company has ever had, before this the (former) VPs said "I think we need about this much money and will make about this much money." Welp, mine is not to question why, mine but to do and die (of old age waiting on this thing). 22 Eargesplitten fucked around with this message at 23:17 on May 1, 2017 |
# ? May 1, 2017 23:14 |
|
22 Eargesplitten posted:I guess I didn't realize that huge Excel sheets like that were so unusual. At one of my jobs the tax accountant had sheets that were literally hundreds of thousands of rows. That's the kind of thing Excel supports because bad users demand it, so Microsoft has to code support in, not something Excel is good for.
|
# ? May 1, 2017 23:16 |
|
22 Eargesplitten posted:I guess I didn't realize that huge Excel sheets like that were so unusual. At one of my jobs the tax accountant had sheets that were literally hundreds of thousands of rows. Huge excel sheets like that aren't exactly unusual (hell they probably spawned at least 1 of the 3 IT bitching threads), but they do not work well, as you see, and whatever you're doing with them should be pushed to a DB of some kind because then hours of your life aren't wasted waiting for excel to stop dying.
|
# ? May 1, 2017 23:29 |
|
Let's be honest, I'm wasting those hours of my life on the forums. Thankfully even if we can't hook it into a database (Thanks departed employees for buying a second completely unrelated program that uses a sectional database and doesn't talk with anything else), once I reverse engineer all of the poo poo that should have been written down years ago, it will be a 15-20 minute job even with tracking down the new details that should have been written down.
|
# ? May 1, 2017 23:48 |
|
Has anyone else just had an issue with Fortinet's provided DNS service, 208.91.112.53 and 208.91.112.52, just going down?
|
# ? May 2, 2017 00:53 |
|
22 Eargesplitten posted:Let's be honest, I'm wasting those hours of my life on the forums. What exactly are you doing with this ERP system? I'm essentially a Business Systems Analyst so if it's doing something remotely normal I might be able to offer some suggestions.
|
# ? May 2, 2017 00:55 |
|
22 Eargesplitten posted:Opinion time: is a 6600u with 8gb of RAM getting bogged down on a 10850 row, 53 column Excel sheet (all formulas) with source data sheets holding the same rows and then some for about 45 seconds per update a lovely computer, lovely optimization, or both? I'm thinking both. I am also dealing with this although I have mostly washed my hands of it. Basically people entire job's are dealing with data in excel in some depts yet they aren't people who know excel very well. I have stated more than multiple times that this isn't a hardware issue and that its a knowledge issue with those manipulating data. I have also stated that excel isn't cutting it anymore and that we are becoming a big data company and we need professionals who can work with it. Basically the best course has been throwing hardware, windows 10, and office 2016 at the issue and its been corrected for now.
|
# ? May 2, 2017 00:56 |
|
Sickening posted:I am also dealing with this although I have mostly washed my hands of it. Basically people entire job's are dealing with data in excel in some depts yet they aren't people who know excel very well. I have stated more than multiple times that this isn't a hardware issue and that its a knowledge issue with those manipulating data. I have also stated that excel isn't cutting it anymore and that we are becoming a big data company and we need professionals who can work with it. Thankfully the IT management group at my company says that all we're responsible for is to make sure Excel installs and runs. If they make a spreadsheet that won't run because of crazy rear end formulas it's on the end user. Unfortunately that doesn't work for most people at their jobs
|
# ? May 2, 2017 01:02 |
|
Vargatron posted:Thankfully the IT management group at my company says that all we're responsible for is to make sure Excel installs and runs. If they make a spreadsheet that won't run because of crazy rear end formulas it's on the end user. Unfortunately that doesn't work for most people at their jobs I have taken an extensive amount of time in meetings going over speedsheets and the kinds of things that are in them. Our CFO was very skeptical when I said that excel freezing up wasn't because excel was having problems. He use to be CTO of a few companies with large programming departments so when i showed him the raw data of some of these excel spreadsheets and exactly how much code was involved he finally took notice. It also took a little time to get him to realize that big data folks are rare and expensive.
|
# ? May 2, 2017 01:08 |
|
Sickening posted:I have taken an extensive amount of time in meetings going over speedsheets and the kinds of things that are in them. Our CFO was very skeptical when I said that excel freezing up wasn't because excel was having problems. He use to be CTO of a few companies with large programming departments so when i showed him the raw data of some of these excel spreadsheets and exactly how much code was involved he finally took notice. I'm not super well versed in big data, but it's something that has just recently become a mainstream field based on my experience. I would say for the majority of company's, having a relational database backend with a frontend is probably the best way to handle things like Excel. It's not a tool for planning your operation, it's for data analysis.
|
# ? May 2, 2017 01:12 |
|
Vargatron posted:Thankfully the IT management group at my company says that all we're responsible for is to make sure Excel installs and runs. If they make a spreadsheet that won't run because of crazy rear end formulas it's on the end user. Unfortunately that doesn't work for most people at their jobs We're currently dealing with poo poo where the person in charge of Finance is complaining about Excel crashing. Can't tell us anything about the spreadsheet and also refuses to show them to us because they have sensitive financial info in them. The CTO doesn't really understand how we're supposed to resolve the issue.
|
# ? May 2, 2017 01:34 |
|
Vargatron posted:I'm not super well versed in big data, but it's something that has just recently become a mainstream field based on my experience. I would say for the majority of company's, having a relational database backend with a frontend is probably the best way to handle things like Excel. It's not a tool for planning your operation, it's for data analysis. We have database backends that are fine(or at least seem that way), the problem is that we don't have people to take the data from there all the way to data analysis endgame. There just is anyone with any respectable expertise in the entire company.
|
# ? May 2, 2017 01:38 |
|
Vargatron posted:What exactly are you doing with this ERP system? I'm essentially a Business Systems Analyst so if it's doing something remotely normal I might be able to offer some suggestions. Budgets and actuals. The thing is that our budget and some actuals come out of a completely different (piece of poo poo) system that one portion of the company uses. That system has minimal reporting options and no way to plug its database into any external program. You can't even get a report of each entry, you can only get an aggregate by cost code. I'm wondering if it's possible to pull that data into our ERP system like we do hours entered into the piece of crap. I'd have to ask the accountant who does that. My boss is hoping to get rid of it eventually, but who knows if or when that will happen.
|
# ? May 2, 2017 04:36 |
|
Excel used to, and probably still does, exhibit some weirdness on hyper-threaded processors. I don't know if this is the problem you're having, or where the setting is for the maximum processes it will spawn, but maybe that's the band-aid you need. edit: should probably mention that I've never run into this problem and it may just be weirdos on the internet.
|
# ? May 2, 2017 05:23 |
|
Also if it's using a ton of RAM it might be worth looking at the 64-bit version. Unless you use some plugins that don't run in 64-bit.
|
# ? May 2, 2017 07:56 |
|
Still being told in 2017 that we don't need an imaging server Built MDT+WDS anyway. Boss noticed it. and said that it was unnecessary. Just do it manually. Showed him hard data and just the amount of imaging that was done the last 3 months and the amount of time it has saved so far. He replied with; I guess it doesn't hurt to have it.
|
# ? May 2, 2017 10:37 |
|
Sefal posted:Still being told in 2017 that we don't need an imaging server Weird, currently in the middle of trying to get a MDT+WDS build as soon as I have the time. Boss keep's telling me its really important and that it needs to be done, but every time I fence off a couple of hours to just get started with it, it gets cancelled with "important poo poo". Guess it's never getting done.
|
# ? May 2, 2017 12:14 |
|
22 Eargesplitten posted:Budgets and actuals. The thing is that our budget and some actuals come out of a completely different (piece of poo poo) system that one portion of the company uses. That system has minimal reporting options and no way to plug its database into any external program. You can't even get a report of each entry, you can only get an aggregate by cost code. Hmm, is it a SQL backend? If it were possible I'd write a stored procedure that does as much of the data processing as possible then dump that out into a secondary table where all the finished data lives. Then they can hook Excel into that table where mos of the work is already done. I've written a few data processing routines that are very taxing to the database, but are ran in off hours. Database servers are better equipped for complex operations than Excel. Though I completely understand if this isn't possible with your system.
|
# ? May 2, 2017 13:23 |
|
dogstile posted:Weird, currently in the middle of trying to get a MDT+WDS build as soon as I have the time. Boss keep's telling me its really important and that it needs to be done, but every time I fence off a couple of hours to just get started with it, it gets cancelled with "important poo poo". No, you're just supposed to stay late every day until it's finished. Right?
|
# ? May 2, 2017 15:40 |
|
Yeah they can gently caress off
|
# ? May 2, 2017 16:18 |
|
Vargatron posted:Hmm, is it a SQL backend? If it were possible I'd write a stored procedure that does as much of the data processing as possible then dump that out into a secondary table where all the finished data lives. Then they can hook Excel into that table where mos of the work is already done. Yeah, it's a SQL backend. I'll think about it. That might work if I could just feed the data directly into the sheet so it's not using so many volatile functions. Unrelated, holy crap. First thing in the morning I find out they let five people go for performance issues effective immediately. Including the one person on my team that actually knows the ERP system.
|
# ? May 2, 2017 17:13 |
|
So, Microsoft essentially made their own XPS 13 clone, overpriced it by $200, put a gimped version of Windows on it and thinks this is going to stop encroachment of Chromebooks on the EDU space? I mean, I do love the look of the hardware, but the Surface Laptop seems to be a complete and utter misfire from every other perspective.
|
# ? May 2, 2017 17:27 |
|
Eh, It's more like a Windows MacBook? Which isn't that bad at all? Edit: Probably going to buy one. Gucci Loafers fucked around with this message at 17:33 on May 2, 2017 |
# ? May 2, 2017 17:29 |
|
bull3964 posted:So, Microsoft essentially made their own XPS 13 clone, overpriced it by $200, put a gimped version of Windows on it and thinks this is going to stop encroachment of Chromebooks on the EDU space?
|
# ? May 2, 2017 17:33 |
|
|
# ? Jun 13, 2024 06:34 |
|
bull3964 posted:So, Microsoft essentially made their own XPS 13 clone, overpriced it by $200, put a gimped version of Windows on it and thinks this is going to stop encroachment of Chromebooks on the EDU space? Hardware looks great but yeah I'm just gonna get a new Chromebook :|
|
# ? May 2, 2017 17:36 |