|
Chunjee posted:"would it be possible to find out which of these test accounts are disabled?" "Well now none of them thanks"
|
# ? Oct 16, 2017 13:51 |
|
|
# ? Apr 27, 2024 01:26 |
|
Judge Schnoopy posted:"Well now none of them thanks"
|
# ? Oct 16, 2017 14:47 |
|
The Fool posted:I don't understand what kind of report takes 1-4 hours on a weekly basis that hasn't been totally automated. Boss: Please give me XYZ data. Me: Sure, I'll set up a subscription and you'll get the report in your email each week. As many reports as you want. Boss: No, I need it to all be in one spreadsheet and look exactly like this and have lots of obtuse charts going back several years. I won't actually read these charts on a regular basis or have an ongoing need for legacy data, but I'm still going to check each week to confirm that you're producing it. Just in case, right? Me: That's...time consuming. What solution did the previous person who generated these reports use? Boss: She just set aside an entire half workday each month to do it. Me: My last two weeks on the job, she asked me to add yet another worksheet to the report, and I finally said "This does not represent good stewardship of our budget and staff time. I will make the raw data available for your analysis." Edit: It was usually 1 hour weekly, and I did eventually get enough macros going that I could produce that report in well under an hour. But once a month the dreaded help desk/instructor time/class analysis report was the real beast. The Macaroni fucked around with this message at 15:54 on Oct 16, 2017 |
# ? Oct 16, 2017 15:51 |
|
The Macaroni posted:One with a couple dozen cross-tab pivot tables drawing from multiple automated sources, because the boss liked it that way. Which is another fun conversation. I once produced a report that would live update all the data required on launching into a pivot table nicely summarised. You know, the way it should be, and then the report sheet would be made available in a central location so anyone could get data as and when the needed it. The CIO instead asked that it be emailed weekly, with the data saved at that point as a snapshot and all the locations drill downs already clicked on the pivot. There were 17 of them. So I made a macro that would literally just do the equivalent of double clicking the cell, name the launched tab and then sort them. I'm still kind of mad that I got asked to spend time clicking a cell for someone else so they wouldn't have to. So every week an email with 20-30 recipients with an 8 MB attachment was sent out, and then they'd all bitch about running out of inbox space. gently caress that place.
|
# ? Oct 16, 2017 16:36 |
|
One of our clients was unable to open .xlsx files from our program - they kept getting a "no file association" error even though .xls and .xlsx we're definitely assisted with Excel. So after some quality time with procmon, I found out that when the program goes to open .xlsx files, it's instead looking up what program is associated with .xl~ files. So I did the obvious quick and dirty solution and created an association between .xl~ and Excel. I have no idea why our program is doing this and Google is completely useless because googling ".xl~" makes it go "tee hee silly you mean xl right, let me just do a search for xl"
|
# ? Oct 16, 2017 16:44 |
|
quote:various excel reporting horrors Isn’t this the kind of thing PowerBI is made for?
|
# ? Oct 16, 2017 17:07 |
|
quote:Good Morning, This seems incorrect to me.
|
# ? Oct 16, 2017 17:22 |
|
LordVorbis posted:I once produced a report that would live update all the data required on launching into a pivot table nicely summarised. You know, the way it should be, and then the report sheet would be made available in a central location so anyone could get data as and when the needed it. Why was it 8mb if it’s just supposed to be a summary?
|
# ? Oct 16, 2017 17:33 |
|
The Fool posted:Isnt this the kind of thing PowerBI is made for?
|
# ? Oct 16, 2017 17:37 |
|
Ghostlight posted:Every single one of our users who has requested PowerBI has immediately gone quiet but continued to produce and request Excel based reporting. God forbid users need to learn how to use new tools.
|
# ? Oct 16, 2017 18:09 |
|
Last night the CEO started emailing me asking about software to manage his passwords. As usual I made my recommendation and offered to create the account for him and help him install apps/plugins. I say "as usual" because we have been having this same interaction every four months or so for almost three years now. It never goes any farther than this.
|
# ? Oct 16, 2017 18:13 |
|
Dick Trauma posted:Last night the CEO started emailing me asking about software to manage his passwords. As usual I made my recommendation and offered to create the account for him and help him install apps/plugins. Maybe he's just testing you: "Let's see what does Dick Trauma recommend today?"
|
# ? Oct 16, 2017 18:54 |
|
I'll remind you that he once copied me in on an email exchange with his doctor, refilling his prescriptions for ADD meds and Cialis. I can confirm he needs ADD meds. The other need I hope to remain ignorant of.
|
# ? Oct 16, 2017 19:56 |
|
I'm sure one day you'll have a long, hard discussion about it.
|
# ? Oct 16, 2017 19:58 |
|
GreenNight posted:I'm sure one day you'll have a long, hard discussion about it.
|
# ? Oct 16, 2017 20:01 |
|
I mean you have your user name for a reason.
|
# ? Oct 16, 2017 20:02 |
|
2 APC ups on seperate power circuits are registering 30k wiring faults a day collectively. Our general contractor sends an email telling us to unplug the ups's and replug them in. Our electric company basically told us to gently caress off. My boss just sent me a text asking if I had any ideas. I told him "Yes, my idea is to have someone who knows what they hell they are doing to fix it."
|
# ? Oct 16, 2017 21:29 |
|
I swapped a couple of dumb UPSes out at a site with some newer ones that actually had screens and network cards in, and one of them went crazy alerting that live and neutral were reversed. Turns out the circuit had been wired that way since it was installed.
|
# ? Oct 16, 2017 21:34 |
|
We have 200 UPSes that randomly fail because a: networking was made responsible for them and b: the sr networking guy somehow thinks doing a self test every 14 days is a bad idea. Over the weekend we had a LEC dispatch to a site to find out the UPS had battery failures.
|
# ? Oct 16, 2017 22:35 |
|
notwithoutmyanus posted:We have 200 UPSes that randomly fail because a: networking was made responsible for them and b: the sr networking guy somehow thinks doing a self test every 14 days is a bad idea. In all honesty I don't really know who the gently caress does UPS's well. Is it a 3rd party vendor? Is it your facilities people? Network/Sysadmins? Who the hell do the big data centers use? I just setup the alerting email address and setup the self test on each one in a way that makes sense. That is it. I respond to what it tells me. I totally trust what 3rd parties tell me on sizing as well as the generators behind them. I am totally clueless beyond that.
|
# ? Oct 16, 2017 22:44 |
|
APC have a monitoring/maintenance service, StruxtureOn. I imagine it's expensive.
|
# ? Oct 16, 2017 22:55 |
|
Sickening posted:In all honesty I don't really know who the gently caress does UPS's well. Is it a 3rd party vendor? Is it your facilities people? Network/Sysadmins? Who the hell do the big data centers use? We have a team of i think 8 people who do nothing but 24/7 IT infrastructure stuff. They're responsible for all the power/cabling for our DC and remote IT closets, all the HVAC for the DC and said closets, and all the UPS's that power the systems. They have SiteScan set up to email the 24/7 NOC team, who then wakes them up if it's something urgent that needs taken care of outside of their normal hours. Obviously this isn't really feasible for anything short of a company our size (~19,000), but it's very effective and the maintenance gets done.
|
# ? Oct 17, 2017 01:10 |
|
notwithoutmyanus posted:We have 200 UPSes that randomly fail because a: networking was made responsible for them and b: the sr networking guy somehow thinks doing a self test every 14 days is a bad idea. This is why some of them charge so much when they get unnecessarily dispatched. We have customers that will demand a dispatch when their office goes down for the weekend, SHOW UP TO LET THE TECH IN THE BUILDING, and find out theres a power outage. Because they don't want to go onsite to confirm power or reboot anything first. And then they have the temerity to argue over who has to pay the nff dispatch fee.
|
# ? Oct 17, 2017 04:30 |
|
Sickening posted:2 APC ups on seperate power circuits are registering 30k wiring faults a day collectively. Our general contractor sends an email telling us to unplug the ups's and replug them in. Our electric company basically told us to gently caress off. Just block the emails from the APCs to suppress alerts! If they are still working with all those errors there clearly isn't an actionable problem.
|
# ? Oct 17, 2017 04:33 |
|
It's insane to use consumer kit like Buffalo for business use. But how actually are Buffalos for home use? I'm in need of a home NAS and going "ouch" at the price tag on a QNAP.
|
# ? Oct 17, 2017 12:49 |
|
Dick Trauma posted:I'll remind you that he once copied me in on an email exchange with his doctor, refilling his prescriptions for ADD meds and Cialis.
|
# ? Oct 17, 2017 13:30 |
|
divabot posted:It's insane to use consumer kit like Buffalo for business use. But how actually are Buffalos for home use? I'm in need of a home NAS and going "ouch" at the price tag on a QNAP.
|
# ? Oct 17, 2017 14:58 |
|
divabot posted:It's insane to use consumer kit like Buffalo for business use. But how actually are Buffalos for home use? I'm in need of a home NAS and going "ouch" at the price tag on a QNAP. I don’t know how they compare price wise, but synology has some good home units.
|
# ? Oct 17, 2017 15:14 |
|
The Fool posted:I don’t know how they compare price wise, but synology has some good home units. Synology hardware is good, but honestly I think you're better off building your own and then running http://xpenology.me/ which is basically a bootloader for running the Synology OS on your own hardware. This is what I ended up doing after awhile due to the box I had not having enough processing power or enough memory to do the things I wanted. Now I have an i5 with 16GB of ram and 6 hard drives in a Node 304 case. It's way overkill but it allows me to do a lot more things on it and you have control of the quality of hardware in it. Griffith86 fucked around with this message at 15:37 on Oct 17, 2017 |
# ? Oct 17, 2017 15:34 |
|
[quote="“divabot”" post="“477457928”"] It’s insane to use consumer kit like Buffalo for business use. But how actually are Buffalos for home use? I’m in need of a home NAS and going “ouch” at the price tag on a QNAP. [/quote] Another vote for rolling your own. There's plenty of good options for free NAS OSes out there and you get the hardware upgradability, performance and expandability you want/need at the price point you want. Just stay the gently caress away from RAID-0 and you'll be fine.
|
# ? Oct 17, 2017 15:52 |
|
Has anyone done a Raspberry Pi NAS, or does the cost of the external RAID card negate the price savings of the Pi? How bad is software RAID 1 for home applications?
|
# ? Oct 17, 2017 16:34 |
|
RAID 1 is fine if you only have 2 or 3 disks, any more disks than that and you might as well go with a higher RAID level. Also here's a good video about fun things to do with RAID 0 arrays.
|
# ? Oct 17, 2017 16:36 |
|
Do JBOD and if you have an important file, copy it twice.
|
# ? Oct 17, 2017 16:38 |
|
Hardware raid is cancer. Always use software raid.
|
# ? Oct 17, 2017 16:38 |
|
I have a QNAP I got from work. It's pretty nice but one of the drive bays is dead, so 3 out of the 4 work. I backup everything to an external drive nightly if the entire unit ends up making GBS threads itself.
|
# ? Oct 17, 2017 16:42 |
|
Methanar posted:Hardware raid is cancer. Always use software raid. You should be tarred and feathered sir.
|
# ? Oct 17, 2017 16:46 |
|
Hardware RAID makes no sense when you're hobbying and don't have a support contract that can get you the same card running the same firmware when it blows up.
|
# ? Oct 17, 2017 16:47 |
|
I suppose I can understand that, but when drives start dying and you run into weird poo poo with your software RAID you have a much higher chance of having a non-recoverable situation (or extremely annoying/lengthy recovery) than you would with a hardware RAID
|
# ? Oct 17, 2017 16:52 |
|
22 Eargesplitten posted:Has anyone done a Raspberry Pi NAS, or does the cost of the external RAID card negate the price savings of the Pi? Software RAID 1 running on a Raspberry Pi is going to have pretty bad performance, but you already have pretty bad performance trying to run multiple disks and a network connection at once through the single USB 2.0 hub they'll all be hooked up to on the device. Similarly, any sort of USB external RAID controller you'd manage to get going with the Pi would still have performance rendered slow by the way the Pi works.
|
# ? Oct 17, 2017 16:57 |
|
|
# ? Apr 27, 2024 01:26 |
|
Ah, okay. I was under the impression it had a USB 3 port, which at least hypothetically gets faster performance than SATA? I’ve never tested it, maybe there’s a gotcha to that. I didn’t think a NAS would need much processing power, but I will freely admit I have never worked on one so I guess I’m wrong. Maybe I should just just get an older computer from the college surplus store and a RAID controller card? There’s plenty of Optiplexes with older i5s and 8GB for $150-200. I really only would need RAID 1, I don’t have a ton of stuff. Maybe 1 - 1.5TB between all three of our computers. Doesn’t seem to make sense to buy three disks when two 3-4TB disks would be easily enough for the foreseeable future. 22 Eargesplitten fucked around with this message at 17:07 on Oct 17, 2017 |
# ? Oct 17, 2017 17:04 |