r/sysadmin • • Jul 28 '24 • Take My Silver 1

got caught running scripts again

about a month ago or so I posted here about how I wrote a program in python which automated a huge part of my job. IT found it and deleted it and I thought I was going to be in trouble, but nothing ever happened. Then I learned I could use powershell to automate the same task. But then I found out my user account was barred from running scripts. So I wrote a batch script which copied powershell commands from a text file and executed them with powershell.

I was happy, again my job would be automated and I wouldn't have to work.

A day later IT actually calls me directly and asks me how I was able to run scripts when the policy for my user group doesn't allow scripts. I told them hoping they'd move me into IT, but he just found it interesting. He told me he called because he thought my computer was compromised.

Anyway, thats my story. I should get a new job

11.4k Upvotes

1.3k comments sorted by

738

u/Nethermorph Jul 28 '24

Lol that's wild. Can I ask what your current role is?

641

u/STILLloveTHEoldWORLD Jul 28 '24

data entry

282

u/Nethermorph Jul 28 '24

Got it. I assume IT is cracking down because you're skipping the part where, by automating your tasks, you're supposed to be checking for errors/cleaning the data?

56

u/STILLloveTHEoldWORLD Jul 28 '24

well I would manually check everything first, and if it was all good to be entered then i would have the process of it being entered automated. i did still have to manually do some work if everything wasnt all squared away, which i did without the script.

→ More replies (42)

211

u/Uncommented-Code Jul 28 '24

Highly unlikely.

My priorities when something like that happens are, in order:

  1. Did the security alert get triggered by a malicious process or was it on accident by the user?

  2. If the user did it, what did they do?

  3. Is it an issue that the user did that?

  4. If yes, tell them to stop doing that and, if I have time, ask them what they were trying to achieve and find out if there are other ways to achieve what they wanted to do without having to resort to circumventing IT policies.

How people do their job is absolutely none of my business and they know how to do it, while I don't. I'm not stupid enough to tell people how they should do their jobs, unless they work in the same role and I hold authority over, or when I see someone being neglient.

→ More replies (22)

177

u/binaryhextechdude Jul 28 '24

I use powershell to reduce human error in my role.

→ More replies (34)

164

u/sylfy Jul 28 '24

A competent ETL engineer knows where you should be automating tasks, creating tests cases, and checking the results.

An incompetent one just does everything manually because “you’re supposed to be doing data entry and checking”.

→ More replies (14)

10

u/exzow Jul 28 '24

IT almost certainly doesn’t care about this. They usually don’t care how or if you do your job. They—do—care if you compromise your system or if your system is compromised. If the behavior of your computer shows signs of compromise they might step in.

If they identify something which could permit an attacker to use your machine to pivot they are likely to modify permissions deemed unnecessary for your role. This sounds like the latter.

→ More replies (14)

8

u/lev400 Jul 28 '24

Sounds like a role suited to automation

15

u/thatgrumpydude Jul 28 '24

I’m on the systems side of this. We would do a similar thing. Skunkworks is one of our biggest things to chase. People do this and put it into “production.” Then they go on vacation and take their laptop. Shop floor halts. Oops. Say nothing of the risk of us allowing unsigned scrips in the first place :)

Now, we would be open to (and do) onboarding the scripts to source control and ansible. You could try asking. Think of it as reaching into a strangers fridge and taking their beer without asking, kind of a party foul.

5

u/OkPepper_8006 Jul 28 '24

Surprised you weren't fired tbh

1

u/botmarshal Jul 29 '24

Do you live in USA? I like your style and I'll recommend you to my current gig.

→ More replies (1)
→ More replies (35)
→ More replies (4)

6

u/samuelma Jul 30 '24

it took me ten years of working in IT and grumbling about how everything could be automated and improved if i just had that little bit more access, slightly better local admin rights. a login to that specific server that sends me a csv each week. Then after a lot of grumping you get to a point where you have to sit on change advisories, respond to edr alerts, justify risk surfaces for improvements and write in try/catches you never even thought of and it all becomes a bit clearer why your boss 5 years ago was pissed at you using autohotkey to make a spreadsheet no one looked at twice as fast.

Most of the takes in this thread are right, IT being a bit brisk but also you're not playing by the rules of the game you chose to play. Even if you have to explain it to 25 people all of who say not to use it, eventually it adds up to a lot of experience you can use in a CV or the relevant people at your work noticing that you are striving to make stuff better. Trying to avoid the legitimate routes to getting tools approved and trying to outsmart IT can feel like a valiant fight to take on but it will slow you down in terms of career progression. Automating things because you find them repetitive is a lot of peoples routes into IT but you're engaging with people who at some point have to justify their actions to directors/government bodies and insurance companies. I was in your exact shoes not so long ago but ultimately its entirely appropriate that you shouldn't be allowed to execute scripts no one in IT has looked at.

2

u/STILLloveTHEoldWORLD Jul 30 '24

this is the probably the most thoughtful and realistic comment i have read on this post, and youre right, thank you

1.2k

u/largos7289 Jul 28 '24

See i don't know how to feel here, either it's, i'm low key impressed or you're one of those end users that know just enough to be dangerous.

15

u/scubafork IT Manager Jul 28 '24

The correct stance is that OP should be having their manager fight this battle for them. OP is potentially saving the company money in labor hours(which ironically could cost their job) and the manager should be getting IT's approval to help save the company money. IT should vet the script and modify it as necessary.

IT is a service industry, no matter how much you abstract it away. Our entire existence within the company is predicated on the idea thar we help the company save money.with better tools.

0

u/[deleted] Jul 28 '24

[deleted]

11

u/STILLloveTHEoldWORLD Jul 28 '24

i was hoping that they could either see i have a better utility than just entering data, for growth, and if not, at least i can relax and work on my own stuff (on my own computer)

→ More replies (6)
→ More replies (1)

354

u/jwphotography01 Jul 28 '24

The same users that come in the end and tell you theire system doesnt work anymore. Yeah, you manipualted the registry

208

u/Expensive_Plant_9530 Jul 28 '24

Oop. We have a user at my work who likes to “customize his Windows”, and that includes a lot of reg editing. Shockingly, his computer also frequently has weird issues.

48

u/jj-michigan42 Jul 28 '24

User accounts can modify their own user hive, just not anywhere else ie HKLM

→ More replies (94)
→ More replies (6)

212

u/snorkel42 Jul 28 '24

That’s why it is important for IT to assist this employee rather than just delete their shit. At its core level, IT exists to help staff use technology to be productive. This employee is doing that and IT is stopping them. That’s the wrong stance.

64

u/zipline3496 Jul 28 '24

For every power user like OP there’s a 1:100 ratio of other guys named Mike who will inundate the Helpdesk with requests for support when their scripts error or cause issues on their system. I’ve worked for some of the largest international companies in the world it’s flat out industry standard to disallow scripting on most end users computers. Literally every company hundreds of Janet and Joe’s hear stories of automating their day with Powershell or some other tool and immediately ask for it.

Anyone else can put in some sort of exception request and sign policy surrounding it, but I absolutely can see a few dozen reasons why the average end user in data entry isn’t allowed to run scripts by policy.

OP has a clear path here in bringing this cost saving to his boss if he wants to potentially open that door, but he posted on Reddit instead.

46

u/snorkel42 Jul 28 '24 edited Jul 28 '24

I completely agree. I am in no way advocating for blanket allowing script execution. I am saying that this user has shown proficiency and they are clearly trying to use technology to increase their productivity. IT should enable that, not fight it.

I agree that OP is being a bit ridiculous in trying to find ways around IT restrictions rather than working with mgmt and IT to find a solution. Hell, OP is really playing with fire as they are actively trying to sidestep security policy.

BUT… I still think a good IT department would see the intent here and work with the user rather than shutting them down without a discussion.

If absolutely nothing else this is an opportunity for IT to explain why these restrictions are here and how OP should appropriately go about working with IT rather than trying to go around them.

→ More replies (26)
→ More replies (7)

5

u/The-WinterStorm Jul 28 '24

I guess it depends on the IT role. I can understand from a security stance they may not want users running scripts and bypassing security controls set by the company.

→ More replies (1)
→ More replies (36)

24

u/BrainWaveCC Jack of All Trades Jul 28 '24

I default to impressed in these cases.

Yes, there are some reckless employees, but the OP does not appear to be one such. I've had a number of good power users over the years (and a few bad ones), and we worked out deals that were mutually beneficial.

OP, see if you can get your IT department to give you enough room to get what you need done, without undermining their ability to keep the environment secure.

It will be a worthy exercise anyway, in building trust with teams that have an agenda not directly aligned with your own at specific levels.

I agree with another poster that if you have to go through official channels in your own department to make this happen, it will be worse for you. Try to build this since a professional relationship angle...

→ More replies (5)

2

u/KiNgPiN8T3 Jul 28 '24

We have one of these guys but he is actually in IT. He’d only been with the company a short time when his laptop flagged up with a virus alert. Turns out he downloaded some software to Mac’ify his windows laptop. From some dodgy source that turned out to be riddled with dodgyness… He’s still employed by us which is more shocking to be honest. Haha!

→ More replies (1)

2

u/Ronnie_Dean_oz Jul 29 '24

Any time IT blocks automation they are working against the company. Nothing like making people do things manually because you are too shit to actually help them do it properly. I have to wait 6-12 months to get a report written. Do something myself and IT instantly has all the time in the world to stop it.

→ More replies (17)

2

u/stromm Jul 28 '24

I didn’t read all comments, but what I have shows me lots of people are ignoring one important statement.

That OP is trying to automate the main thing they do, so they can get paid for the job they aren’t actually doing.

This isn’t a “I need this script to allow me to do other work, while that work gets done”.

It’s a “I don’t want to work but I still want them to pay me”.

2

u/[deleted] Jul 29 '24

Your IT doesn't want you running scripts to automate your job? Huh. Sounds like pretty good job security, actually.

**"**I just stare at my desk, but it looks like I'm working. I do that for probably another hour after lunch too, I'd say in a given week I probably only do about fifteen minutes of real, actual, work."

1

u/STILLloveTHEoldWORLD Jul 29 '24

office space is a big inspiration for me actually lol

46

u/psychedelic-barf Jul 28 '24

The obvious next step would be to buy an Arduino, some motors or whatever and create a program that can mechanically type on the keyboard for you to do the entries.

17

u/[deleted] Jul 28 '24

Rube Goldberg has entered the chat…

10

u/ZippyTheRoach Jul 28 '24

Nah, the next easiest step would be a keyboard that stores macros in an internal memory. Literally doesn't run on the PC, it just sees keyboard input 

IT will have to put keystroke limits in place next >_<

5

u/milanove Jul 29 '24

Use Arduino Leonardo to do this. It can act as a USB keyboard and mouse.

→ More replies (1)

5

u/milanove Jul 29 '24

Skip the motors and just use an Arduino Leonardo. The ATmega32u4 chip on it has built in USB communication capability, so it can act as a USB keyboard or mouse when plugged into the PC.

Just load it up with your keystroke or mouse movement macros, based on whatever task OP is trying to automate, plug it into the work machine, and let it rip.

The work PC won’t disable/block it, because it appears as a normal USB keyboard.

3

u/punklinux Jul 29 '24

We had a work-from-home data entry guy who admitted, post-work, they he used a gaming keyboard that stored macros normally used for various game moves. The laptop in question was pretty locked down, but not for keyboards, and this keyboard could be programmed on one system, then unplugged and replugged onto the locked down laptop. Control + special key + F8 or whatever was "Fill in all relative fields with the same data," because half of his data was always the same text. The all he had to do was tab around and fill in the other data. Each macro could store up to 256 characters, IIRC, which was insane. But good for him.

669

u/ReptilianLaserbeam Sysadmin Jul 28 '24

Dude you work in a company, that’s not high school. You don’t need to hide behind the building to smoke your cigarettes. Instead of trying to find loopholes raise a ticket with a business case explaining why do you need to use scripts or a scripting language. Get an approval and added to the exception. If you keep playing bad boy you’ll end up in HR.

122

u/caughtmeaboot Jul 28 '24

Yeah exactly. He even knows why IT blocked him, they thought his computer was compromised. If the ticket had been raised and he got an approval for the exception, this would've been avoided cause IT would know why he's running the scripts.

→ More replies (16)

24

u/YetAnotherGeneralist Jul 28 '24

OP mentions not having to work as much being a positive. If a business case is presented and approved, now his manager will know he has more time in the day and get more tasks. I don't necessarily support the goal, but less work time is the goal.

→ More replies (3)

21

u/lurker86753 Jul 28 '24

Because then he’s automated himself out of a job. You can’t very well script your entire job and then goof off all day while getting paid if you have to go through 3 departments and your boss explaining how you need the ability to run scripts.

Now if he were smart, he’d split the difference. Tell his boss he can automate a small portion of his job if only he could have Python installed. Do that, share it with the whole team and look like a hero. Then automate the rest and keep that to himself.

5

u/RedAero Jul 29 '24

And if he's really smart he'll start working as a contractor so he can get more work with his newfound time.

→ More replies (1)

8

u/tes_kitty Jul 28 '24

The result is then 'You automated that part of your job? Great! Here's some more work for you to do! More money? Sorry, no budget.'

→ More replies (2)

73

u/yeti-rex IT Manager (former server sysadmin) Jul 28 '24

Propose the business case and be successful.

If they deny it, then it's time to find a new employer.

Do you need a new job? Obviously your skills have exceeded your current role. They should be trying to put you against bigger challenges.

→ More replies (18)

5

u/redblade13 Jul 28 '24

I'm a SOC guy and we allow certain users to run scripts because they're sysadmins or some data entry guys that use some weird Excel Macros. We know who they are and they go through the approvals and our management tells us "Hey they're good" so we ignore alerts and loosen restrictions if needed. Sure if they run stuff at 2AM we'd still get alerted like wtf but for the most part we know the why and it isn't a big deal. Everyone in our company knows this so they all come to us when some script gets block which makes it easier for us to figure out what's this alert this time

13

u/[deleted] Jul 28 '24

This is the answer.

Eventually this job will be automated like you're doing or with AI or with both.

Why not say, hey, I can do a thing and save the company money. Give me more things to do that are like this and I'll save you a bundle!

Or, keep it to yourself and disguise the fact you're using scripts until you get caught and fired or worse.

Or...get another job.

16

u/butter_lover Jul 28 '24

Possible that op is just using scripts he made with chatgpt and doesn't understand what he's running on the systems. Kind of hard to make a business case off that.

→ More replies (3)
→ More replies (4)

3

u/[deleted] Jul 29 '24

Ph you'd be surprised how many mofos think they are in a highschool while at work. Gossip, bullying, and childish behavior are all around. I'm convinced some people never grow up mentally.

2

u/formthemitten Jul 28 '24

Out of every take I’ve read, I think you have the best answer.

2

u/25nameslater Jul 29 '24

Meh… I do stuff like that a lot. I read the maintenance specs on the machines I run and figured out a lot of my set up could be achieved with 3 key strokes.

When I was training everyone taught me to do it manually, it was fairly labor intensive and sometimes took 2 hours. I reduced my scrap rate 60% by putting the settings in a batch file that the system can recall from memory. Usually the system makes all the adjustments to its logic within 18 minutes. Everything is done in 30 minutes at most.

I also redid all the paperwork and created a tie in to several reports on excel, and a text script that reads the data from the original excel sheets and runs auto entry in our inventory system. Now instead of entering half a dozen reports i just put it in one spreadsheet and the system I built automatically inputs the other 7 and adjusts inventory automatically.

Showed my boss after I was done and it’s been taken company wide.

→ More replies (3)
→ More replies (11)

85

u/TrippTrappTrinn Jul 28 '24

As a sysadmin I have given scripts to users to help them eliminating silly manual tasks. Luckiky our organization encourage automation and efficiency.

7

u/Sasataf12 Jul 28 '24

The difference is, you're the one writing the scripts. Not the employees.

→ More replies (28)
→ More replies (5)

28

u/S70nkyK0ng Jul 28 '24

If the script is that handy, then there are many ways to safely incorporate it into your company’s business systems.

Suggest mapping out the process, organizing your thoughts, and presenting it to the appropriate people. You may need to present more than once.

This could be an opportunity for you.

5

u/Reverent Security Architect Jul 29 '24

Good opportunity to introduce script signing within source control. You have a need to automate with scripts? Great, stick them in source control, they'll get signed by the pipeline, now we have security controls, your script is fully documented, and we have a written business case why you get to use it.

4

u/V-Rixxo_ Jul 29 '24

Or they’ll just use his script and let him off for performance reasons

16

u/izvr Jul 28 '24

Working in 'IT' usually doesn't require much technical skills. What it requires is being able to follow guidelines and policies. You don't seem to be able to do that, so doubt you'd get hired.

Also, if you're getting your work done better by automating things, maybe talk to your supervisor instead of trying to fight back with workarounds?

7

u/STILLloveTHEoldWORLD Jul 28 '24

my boss personally doesnt care if i automate the tasks. IT does because it flags them. i told him about the newest script and he said, "theyre gonna find it"

15

u/RealisticPossible792 Jul 28 '24

They're likely just getting alerts from their monitoring software - if you speak to them show them what the scripts do and they see it's no threat they should be able to whitelist those scripts from their alerting tools.

We went through the same process with some of the accounts teams who were using specific macros when I started locking down the use of macros in our environment.

29

u/actionfactor12 Jul 28 '24

Outright blocking things that make the business side more efficient isn't really a great approach. Your boss should approach IT and see if there is a way to secure the environment but still allow the scripts.

→ More replies (1)
→ More replies (13)

24

u/RealisticPossible792 Jul 28 '24

I work in IT specialising in a security oriented role but with a lot of infrastructure administration and deployment and I love it when people say "IT doesn't require much technical skills" after years of studying and on the job experience and knowledge gained.

Like any job you have low level employees that don't have much knowledge but can follow procedures then you have people like me who write those processes and procedures and actually know the ins and outs of our corporate infrastructure and are in charge of securing it and I can assure you my job does in fact require a lot of technical knowledge especially when shit hits the fan.

I don't earn my money when things are running smoothly my money is earned when things actually go wrong and we need quick resolutions - a low level tech who only knows how to follow procedures wouldn't know where to start yet alone resolve issues involving an Exchange DB corruptions or SQL DB going down things I've had to deal with this past year.

→ More replies (4)

4

u/flecom Computer Custodial Services Jul 28 '24

Working in 'IT' usually doesn't require much technical skills.

I've seen some incredibly bad takes on /r/sysadmin but this one takes the cake

→ More replies (1)
→ More replies (19)

20

u/mikeone33 Linux Admin Jul 28 '24

As IT Security I would have seen how you were able to run the script. We would also determine if the script was malicious. Last we would check if you were in a group that allowed access to PoweShell or Python. ( You would be blocked otherwise)

If not in such group we would reach out to you and explain why it was blocked and suggest you put in a ticket to have access approved.

No need to make your job harder.

7

u/Degenerate_Game Director of Cybersecurity Jul 29 '24

How can someone with no PowerShell permissions use a batch script to execute those same PS commands by pulling them from a text file? I'm sus of this post.

4

u/Unable-Entrance3110 Jul 29 '24

You simply replace all your new lines in the script with semicolons and paste the whole thing into the -Command parameter.

This also effectively bypasses any script signing policy as well.

It's a major loophole, actually. Which is why, in my org, I go a step further and just block normal users from running powershell.exe (as well as any executable from user-writable locations)

→ More replies (1)

15

u/bfrd9k Sr. Systems Engineer Jul 28 '24

I've been an admin for well over a decade.

It literally hurts me to watch people do repetative things manually. I would totally work with someone to empower them to automate, whether that be coding for them, building a web app, or allowing them to code safely.

That said, having an end user repeatedly break policy and try to sneak around restrictions is annoying and alarming. We call this "shadow IT" and you can google it to see why this is a problem.

Please speak with your manager and or IT, make your case for why it should be allowed, show them what you're automating. Work with IT and build trust with them, be concerned about the security risks, since that's most likely their biggest concern.

→ More replies (2)

14

u/Redemptions IT Manager Jul 28 '24

I told them hoping they'd move me into IT

Did you apply for an IT role? Have you reached out to the IT Manager/Director seeking opportunities? Because with what you've laid out, you found piles of brush, set them on fire, then put them out, when the fire department showed up you were all "I thought you'd hire me as a firefighter."

28

u/islandsimian Jul 28 '24

Next step: running everything in containers

25

u/sylfy Jul 28 '24

Alternatively, OP does it in VBA and be like, “take away my Excel, I dare you.”

13

u/flecom Computer Custodial Services Jul 28 '24

The amount of people in "IT" that fail to realize how powerful excel can be is really kind of mind boggling

→ More replies (1)

4

u/BatemansChainsaw Husqvarna Jul 28 '24

disables Excel macros with GPO

checkmate

→ More replies (3)

448

u/[deleted] Jul 28 '24

I mean it sounds like you could be good at IT, but you also are demonstrating that you are basically a cowboy who plays by his own set of rules.

You could have avoided all this if you maybe just reached out to someone and said "hey I have some ideas about how I can automate a lot of my tasks, what do you think?" People like that collaborative attitude, instead you put your fingers in someone else's chilli and when they smacked your hand away you found away to dip your toe in it.

159

u/shemp33 IT Manager Jul 28 '24

To be fair, it sounds like no one from the desktop team actually said anything initially. They just played whack a mole, and OP just “fixed” the problem.

107

u/angry_cucumber Jul 28 '24 edited Jul 28 '24

they were worried his computer was compromised, but apparently didn't do anything other than....block scripts? that's not how a competent organization handles a compromise.

20

u/CptQuark Jul 28 '24

As someone that works in secops, I always make sure to contact the people when I feel something needs to be disallowed. User awareness training should always be part of the job. Humans are always the weakest link so the more we can do to help that the more we.reduce our attack vectors.

→ More replies (10)

9

u/moderately-extremist Jul 28 '24

"Well just a second there, professor. We uh, we fixed the glitch. So he won't be receiving a paycheck anymore, so it will just work itself out naturally."

→ More replies (17)

77

u/LDForget Jul 28 '24

In my experience (within IT or outside) any time you ask for permission instead of forgivness, they just shut you down without even reading/listening to it all.

→ More replies (7)

27

u/Floresian-Rimor Jul 28 '24

I’d have that conversation after the first script was blocked. The initial scripting is being resourceful and doing the job, the workaround is where op goes cowboy.

After the first block, it’s time to have the conversation with IT and with OP’s manager “Hiya, this script was really helping reduce my workload, is there a way we can make this compliant with our security setup”?

OP probably wasn’t breaking any policies or agreements that they knew about the first time. IT really should have had a word when they blocked it.

6

u/DavidCP94 Jul 28 '24

The IT management probably reached out to the other managers and department heads to find out if anyone needed to run scripts, or if they could disable them to tighten security. Since OP didn't disclose to their manager what they were doing in the first place, OP's manager would have no reason to believe OP needed this capability.  OP needs to be more transparent. If leadership sees how much more efficient OP is, they would likely be excited to have others start using the same tools. The problem is OP doesn't want to let management know, they want to do as little work as possible and slide under the radar. 

→ More replies (1)

10

u/plazman30 sudo rm -rf / Jul 28 '24

If they installed python for him, what did they expect him to do with it?

→ More replies (2)

26

u/corpius01 Jul 28 '24

"Hey boss, I know how to make my position obsolete.  Let me show you how"

→ More replies (3)

2

u/clownshoesrock Jul 28 '24

Somehow, I'm rooting against both IT and OP, and just sad there will be a "winner"

4

u/Do_TheEvolution Jul 28 '24

Dwight Schrute coworker energy comment. And in the worst possible way one can take it.

→ More replies (37)

13

u/Chaddywackpack Jul 28 '24

On the flip side , shadow IT CAN cause havoc when the intentions are good and the result is well bad.

→ More replies (1)

7

u/FISHFACE30 Jul 28 '24

Why don't you just ask for approval to run these? Security can do a review and if they are benign, then you're in business. Why keep making it hard on yourself?

6

u/wiseleo Jul 28 '24

That’s a nice story to tell at your next interview. You’re in the correct place but in the wrong role. They don’t understand how to use your talent.

Want the ultimate hack? Write your script as a QR code in VBA and use a QR code scanner to execute your code in Excel VBA. Good luck blocking that. ;)

11

u/threwthelookinggrass Jul 28 '24

Ask for a powerautomate license

15

u/Tinysniper2277 Jul 28 '24

Used to work in a SOC, security operations.

We had customer users out side the IT departments running scripts, and nearly every one of them fired of alerts, ransomware, enumeration & discovery, privilege elevation, you name it.

Maybe get permission to run these things, you're probably causing more issues to someone else then you think, if you're not allowed to run scripts, then don't, unless you get them cleared.

10

u/graysky311 Sr. Sysadmin Jul 28 '24

When I worked in data entry a large portion of my job involved cross-referencing information on other systems. It wasn’t the data entry itself that was the slow part, it was looking the data up from another system. I found that the data entry program we were required to use had a programmable macro capability that management probably knew about but never mentioned. It was an official feature of the tool we were required to use so I took advantage of it. As it turned out the tool used a modified version of vbscript so I was right at home. This was back before PowerShell existed. I programmed some shortcuts to more quickly open the windows I needed, find text and copy it to the clipboard and then prompt me for whether or not the data was a good match. If I approved, there was a bunch of data entry that was simply automated. This was dumb stuff like mailing addresses, names phone numbers, emails that were all having to be typed by hand or copy pasted anyway from one system to another. A majority of the other reviewers were using copy & paste so it was an acceptable way to do the work. Only now I had an ace up my sleeve and could complete a lot of the rote data movement and comparisons in less time than anyone else. Instead of each bill taking 20-50 seconds like the other folks, I was cranking these things out in 10-20 seconds with my only real interaction being pushing some macro buttons and a visual inspection and approval of the data that got copied over.

The best part? Not only was my job easier after that but we got scored on speed and accuracy. To qualify for bonuses you had to have your accuracy above some certain percentage that I forget and then the amount of your bonus was based on your performance, or bills per hour. And there was a scoreboard so we could see each other’s performance on a printout at the end of each day. I managed to do just enough to barely get first place for three or so months in a row. My idea was to compete but stay under the radar. Unfortunately this was after several months of struggling. So when my numbers suddenly improved, managers noticed and called me into a meeting and congratulated me on my progress but they wanted to know how I did it. They were hoping to bring the performance of the entire team up and were expecting that it was some simple mindset or earplugs or something that was helping. I lied and told them I had just started taking Adderall for my ADHD and they smiled and dismissed me. Clearly that was not going to help the entire team.

So they just accepted that I was better than everybody else and I got greedy. I wanted more money so I started getting better and better numbers and the bar chart they were posting on the wall was just embarrassing to the other reviewers. I started getting a lot more attention from literally everyone, even IT was down in my department. It felt like cheating even though I knew in my soul this was better for the company. I started looking for other work and when I found another job I put in my two weeks notice. This got everyone off my back because they knew I would be leaving. But I did one final hurrah - a grand finale before I walked out that door.

For two weeks straight I went as fast as possible. I switched my script to disable the manual verification step and just reviewed the data on the destination screen before clicking submit. I completed a record number of bills in record time with record accuracy and the bar chart of performance stopped being posted. If they had shown everyone else what I was doing performance-wise they would have seen I was not just incrementally better. I was several times faster. I was completing each bill in 3-5 seconds and they paid out a bonus (we got paid weekly) that was more than 2x my normal wage. Just before my last day, I deleted all the macros and coding that I had made and never explained to anyone how I did it.

2

u/Material_Mongoose339 Jul 28 '24

Sincerely, I support you in deleting everything and not explaining.

→ More replies (1)

5

u/DOOMD Jul 28 '24

I can relate as I work a support job at a school that's not in IT despite having a degree in IT. I took it during COVID because it had great health insurance and benefits and Id be in a union.

You should see the tickets I sent in requesting software to write and run scripts. WSL, VMWare/VirtualBox to run Ubuntu and write python, Jupiter and notepad++. I'm friends with the IT guy and we kind of joke about it. I remember once he was like "IDK what ever to write in response to some of your crazy requests lol."

5

u/unbearablepancake Jul 28 '24

Depending on what your script actually does (does it move files? does it delete files? does it edit files? does it rename files? - these actions can be picked up as malicious), you could always try to officially ask permission (in writing) that you would like to run scripts. You would also have to provide details what it does and what are your intentions with it.

Random people running scripts is a bad idea. But if everyone knows that you need those scripts, getting approval might not be impossible and you might even get whitelisted. Provided you're not doing something else you need to do.

I've seen people automate the most obscure things with excel and vbscript. For the sake of everyone involved, please be transparent with your IT team with it.

→ More replies (2)

9

u/[deleted] Jul 28 '24

When I worked in IT. I wrote a ton of powershell scripts. Let me tell you. So many IT jobs can be automated away and so many white collared jobs could get automated. I know because I automated away departments in the past.

14

u/kyel566 Jul 28 '24

You should ask your boss to request permissions Toruń the script. Ideally it should prob setup a separate service account for you with permission.

4

u/AlexisFR Jul 28 '24

What kind of job are you doing that it can be entirely automated?

4

u/[deleted] Jul 28 '24

Most jobs.

Literally two guys in my department keep harassing IT that they want a button solution to their tasks, which is wrong on so many levels for bypassing oversight and safety checks and more. They lazily say "aUtOmATiOn" and "mOdErNiZaTiOn" but also fear about being replaced by robots and AI.

I keep telling them if they can be replaced by a button press, they can automate the button press as well.

→ More replies (4)

4

u/hankhillnsfw Jul 28 '24

I would raise a ticket with a business example as well as explain to your manager that IT is actively inhibiting your role without trying to understand why you need to script.

4

u/Rand_alThor_ Jul 28 '24

Why the fuck haven’t you taken IT out to dinner and handled this. What happened to old school low level corruption

2

u/KoalaOfTheApocalypse End User Support Jul 28 '24

Did you make your comment perfect for OP's username on purpose, or did it just work out that way? 😂😂

4

u/eatont9999 Jul 29 '24

Don't expect to get a promotion by breaking the rules. You probably should have asked to have the script approved through the proper channels. It's not your computer, and not your environment. IT has to protect the environment and if they see something that falls outside the norms, a flag gets raised to investigate. I have been in the position where I see unauthorized software running and have to remove it. Usually a report gets sent to management and they deal with the end user. The bigger the company, the less likely you are to get away with stuff like this.

4

u/zchrisb Jul 29 '24

A real IT'er will never scold you for automating your job. That's pretty much what we do or would do if possible.

1

u/traplords8n Jul 28 '24

They're not just going to be like "hey you know scripting? We have an open position you can have immediately"

If that was what you were thinking, lol.

It's worth bringing up to your boss if you'd like to, but it totally depends on if they have any open positions, and even if they do, knowing scripting is only advantageous.

You will need more than scripting to compete in this abysmal market. You're going up against college grad CS majors and others with years of experience in the field. Before the market crashed I could totally see you getting leeway into an IT role that way, but nowadays the market is FLOODED with qualified individuals.

3

u/Megatwan Jul 28 '24

I support you and/or end user empower however cautionary:

Often with overzealous cyber shops "subverting IT security policy" will result in loss of account/fired.

So technically you can when and the org will still punish you if you don't win hearts and minds/do it the semi right way. Dumb policy, officiousness from cyber and shadow IT being shitty aside.

GL OP

3

u/punkwalrus Sr. Sysadmin Jul 28 '24

I once had a boss that said scripts were lazy, and that "all it does it automate mistakes!" I showed him how Red Hat was running shell and perl (this was a long time ago) scripts just to boot up, and he said "those are programs, not scripts!" I don't work there anymore.

3

u/Satoshiman256 Jul 28 '24

This is a funny story. Love your persistence haha. Idiotic they won't let you run scripts.

3

u/TrowaB3 Jul 28 '24

He told me he called because he thought my computer was compromised.

I'm fairly certain if you just sit down with him and explain the use case they will no longer (false) flag you.

If you just keep finding alternate ways around it instead of just actually talking about it, you're just an asshole and they're going to hate you lol.

3

u/L3veLUP L1 & L2 support technician Jul 28 '24

See if you can have a chat with the IT admin. Explain what you're doing and show what it does.

If he's impressed enough he'll leave you alone especially if it makes you more productive. If not you could always moan to your manager however that's risky because they'll try and give you more to make up for the parts you automated

3

u/[deleted] Jul 28 '24

I hope you learned your lesson. Efficiency will not be tolerated.

3

u/SomeoneHereIsMissing Jul 28 '24

I'm not a sysadmin but an application support specialist (super user) for a big place (20000+ employees). I have so many PowerShell scripts for user validation. I can run scripts, but not add commandlets so many AD or system calls are written directly. I manage my Exchange user lists this way. I've even had security specialists from IT ask me to validate my app's users because they found out my scripts are better than their tools.

3

u/Disastrous_Being7746 Jul 28 '24

I can understand why an IT department would do this. While scripting in and of itself should not be a security risk, it is a tool often used by exploits and disallowing scripting (particularly forms that come with the OS like powershell, wsh) could impede exploiting unpatched bugs.

That being said, I still don't like it and would never work for such a company, unless they give me a person to do undesired tasks or tasks with a high probability of human error. Even then, I probably wouldn't do it since the helper is also human and if it made sense for a human to do it, I probably wouldn't be automating it in the first place, unless the errors have no impact on future work.

In my experience, it's a lot cheaper for me to automate something compared to an IT department. The IT department might outsource the task to another company, make it nice and usable for everyone, will probably cost a lot of time and money, and probably will be difficult to change for the next slightly different but similar task, whereas it took me 0.5-1 hours to do the same thing, and it's totally malleable without spending another $10k. The idea will likely get rejected on the time and cost factor and it won't help you right now.

Anyway, thats my story. I should get a new job

I agree!

3

u/isoforp Jul 28 '24

OP isn't as good at writing scripts as he think he is. Hell, there's a comment in this thread that says "OP probably doesn't do error-checking" and OP responds to that to say "I test the script before I run it" ... bruh doesn't even know what "error-checking" means.

→ More replies (1)

3

u/TheDonutDaddy Jul 28 '24

You thought you would be invited to join IT after giving IT the middle finger and saying fuck your rules I do what I want? Interesting

Btw, this is a sub for people who work as sysadmins, not for you randos who don't work in IT to come bitch about your IT department

3

u/Sengfeng Sysadmin Jul 29 '24

We have the opposite problem. Management keeps saying ‘automate’ but let the dweebs in info sec dictate not allowing anyone to have the ability to do shit for scripting. We’ve literally have to re-tool login scripts because… no js, no power shell, no batch files, python is on, because info sec uses that.

What a chore.

3

u/[deleted] Jul 29 '24

Why don’t they condone automating? Software company I work for pleads everyone to try to automate literally everything lol

3

u/WearDifficult9776 Jul 29 '24

You SHOULD BE running scripts. Find another place that will appreciate you

3

u/C-Bskt Jul 29 '24

Ask permissions and coordinate with your boss, don't work around policy. You should probably be ok but you went about this poorly twice.

3

u/Dezvinci Jul 29 '24

I am a Director for an IT agency and i actually encourage my employees to write powershell scripts and applications to simplify their tasks/jobs. It is also my teams responsibility to reach out to other agencies and see what processes can be automated within their business footprint. keep powershelling, its amazing. youll get a job that appreciates your ability to streamline your duties.

3

u/jcork4realz Jul 29 '24 edited Jul 29 '24

I’m T1 helpdesk and I stick basic bat scripts in the DC all the time for specific users, not globally. I still document on my ticket that I did so, even with screenshots. I even leave a note with the ticket number on the folder so my doing was easily traceable. Nobody says a word.

3

u/DifficultyDouble860 Jul 31 '24

As a "Tier 2" IT guy let me just say THIS IS AMAZING!!! You probably spoke to one of the frontline Tier 1 guys, and while they are critical for intake and triage, they might not yet have the experience what a boon this is. As a senior tech, let me tell you:

THANK YOU.

Many users just plod along their keyboard day to day, opening tickets for the smallest issues. "Turn it off and back on" really does fix about 90% of problems. Power Users like you on the other hand are cherished in our realm because they can navigate through most of the daily BS of IT from thee other end of the screen. So, thank you for taking the time to git gud.

Now. What to do?

If you have the expertise to write scripts in no less than three ways (PS, Python, and CMD), first of all: wow, you 1000% have the aptitude for doing most aspects of many OT jobs. It shows that you're already familiar with installing IDE's and updating libraries (OS level stuff) and most importantly: researching stuff and teaching yourself.

A word of warning, though: DO NOT fall to the temptation of LLMs to write your code!!! Use it to learn overall design patterns and Big O, but stick to MSDN and the python reference websites for actual implementation.

If there are openings then you can definitely throw your hat in the ring for Tier 1 support tech stuff or Automation Analyst if you're keen on snagging a couple of certifications on, say, ITIL and SCRUM. These are fairly inconsequential in the real world but they can help get your foot in the door if you lack an IT degree. For perspective, my degree is in Economics, and I do just fine. ITIL and SCRUM will help teach you the lingo, at worst.

When you apply EMPHASIZE hiring internally and highlight the fact that you can bridge the gap between business operations and IT much more easily than bringing in an unknown factor from outside.

Ask about openings. Find out when the Fiscal Years ends, and departments are getting new budgets. More money = more hiring. Might have to wait, but automation done right is ALWAYS a skill in demand so while you wait for FY, continue to add to your resume.

DON'T STOP SCRIPTING!!! :D

Good luck!!

5

u/lonecowboy82 Jul 28 '24

At our org, the issue isn't allowing end users to automate.. the issue we have is they try to create tools for other end users, without IT being involved. We encourage automation and ingenuity but request that users bring it to us so we can do it in a way that is sustainable and can be compliant and supported long term. The end users get frustrated because we have a process and they cannot understand why we take so long on these ideas. They think we can just hammer it out and return same day and when we don't, they do their own thing and that is when there is trouble.

→ More replies (2)

4

u/EastcoastNobody Jul 28 '24

yea if you can automate your task they can just dispense with you

4

u/[deleted] Jul 28 '24

I’m seriously impressed by the IT department / lack of automation in your company. Insane ratio of skill

5

u/brando2131 Jul 28 '24

Have you asked IT if you can be allowed to run scripts? Well initially it doesn't seem so, if they thought your computer was compromised. Sounds like a misunderstanding.

If they push back and say no. Your manager should then go speak to IT to say it's for work purposes...IT shouldn't be a hinderance to work as long as it doesn't compromise something.

5

u/Zelexis Jul 28 '24

Most companies would be glad you automated your job. Then let you go :P.

→ More replies (1)

2

u/le-quack Jul 28 '24

Have you asked IT is there is a process that would allow you to use a specific script? It could just need a security review or go through an approval process.

2

u/Flannakis Jul 28 '24

If there are policies in place and you are actively trying to get around them, this could be a concern. Does anyone peer review your scripts? Are you running these in a prod environment? Anyway no risk no reward I guess, if you are automating manual work, it’s strange the business would be against this in theory

2

u/JacksGallbladder Jul 28 '24

You just need to work with your IT department. Why are you trying to do this shit under the table?

Put a ticket in and be like "Hey, I want to run this automation because it would really help my workflow".

2

u/prodsec Jul 28 '24

Why don’t you just work with IT to do it the right (authorized) way?

→ More replies (1)

2

u/[deleted] Jul 28 '24

Can you write me a bunch of scripts to do my job as well? Lol

2

u/BloodyIron Head of IT Security Jul 28 '24

Why not talk to the IT department and come to some happy medium where you can run scripts in a way they deem safe? Like, it's actually good this hasn't escalated to be a problem with HR. But I think there's opportunity here to address whatever concerns they may have, while also being able to leverage scripts in your work.

Think about it another way, if someone in Finance started using macros in a spreadsheet to do their job more efficiently, and they suddenly stopped getting blocked doing that... well to me it would seem reasonable to discuss between the two parties (IT and whomever in Finance) how to satisfy the interests of both.

I'm not saying you shouldn't stop looking for the next job. But if scripts really do give you that much value, well maybe this could work far better to your benefit just by talking to IT than you realise.

I'd love to hear any outcome from that discussion if you don't mind sharing. :)

2

u/Melodic-Matter4685 Jul 28 '24

Mid Atlantic powershell script senior makes around $200k.

Dunno what u make, but I doubt it's 200k.

Senior usually means 10+ years, but if u can automate what they want, gov will count dog walking as relevant experience.

2

u/After-Vacation-2146 Jul 28 '24

Just make a request for the ability to run scripts. It sounds like you have a legitimate business purpose, stop being shady about it. They can literally control this by giving you a code signing certificate and requiring all scripts to be signed.

2

u/mr_mgs11 DevOps Jul 28 '24

No enterprise level org is going to allow a non-IT person to run scripts. The risk being they will grab something off the internet the don't understand and it will compromise the network. My first job DID have some vb scripts that one job role would have to run, but they were specifically allowed for just those scripts and the script was written by a swe. They also had to have code signing done on them. The Data Science guys at my last place were certainly part of the overall IT org, but regular old data entry people were not.

When you said your role is "data entry" I am assuming you mean a non-technical role. Does your script have proper error checking and logging? If I were you I would ask IT if there is anyone that can go over your script and validate it. Then I would worry about getting shit canned or having my hours reduced, not as punishment but because they realize they can save a few bucks.

2

u/Opposite_Second_1053 Jul 28 '24

That is the funniest shit ever and also you are in the wrong profession lol

2

u/[deleted] Jul 28 '24

This is sad, I automated api calls to than build documentation rather than the human error part and got a promotion from It to Devops. When you write software make it with the goal of making your boss look good, make his job easier not your own than in a big meeting with his boss take all the cred!

2

u/Necessary_Durian_327 Jul 28 '24

IT doesn't like shadow IT. You catch more bees with honey, IE... Work with them not against them.

2

u/dmayan Jul 28 '24

I'm the IT and Networking manager of my company (Medium ISP). I caught a guy doing the same. I'm considering bringing him to IT!

2

u/c_pardue Jul 28 '24

Maybe they are removing the scripts because they think you are getting compromised and an attacker is placing the script.

2

u/Zantoo Jul 28 '24

I would honestly just laugh if a user was going to this length to run scripts and maybe a little proud too. Then proceed to give them a GPO exemption to run scripts.

2

u/ClownTown509 Jul 28 '24

Imagining OP talking to his boss like

2

u/jedipiper Sr. Sysadmin Jul 28 '24

This is why MS built tools like Power Automate. IT shouldn't be scared of it. However, vetting automation should be a part of this process. Get some CYA. Also, start looking for IT jobs. You have the knack.

2

u/Pusibule Jul 28 '24

on my watch, the answer to this is "congrats, you are now promoted to the testing user group"  as any shit we want to test or that potentially may break something, will be deployed to you first, because you seems to be clever enough to provide useful feedback.

and....oh you scripts? no you can't use them btw.

2

u/[deleted] Jul 28 '24

Why don't you just ask IT or your manager to explicitly allow the script if it can improve your work efficiency?

2

u/the__accidentist Jul 28 '24

You’re not IT? This is awesome when people are interested enough to do this!

BUT causes me HUGE issues 5 years later when there’s a random DB no one knows about running on Sally’s computer.

2

u/captkrahs Jul 28 '24

They must have a ton of time on their hands

2

u/killing-me-softly Jul 28 '24

If the job your at doesn’t appreciate and capitalize on your skill, and even worse, tries to make it harder to do you job, then it’s tine to find a job that does

2

u/FabricationLife Jack of All Trades Jul 28 '24

Get a scriptable keyboard next and do it in LUA

2

u/moffetts9001 IT Manager Jul 28 '24

I would be impressed and I would be watching you like a hawk. You’re destined for great things.

2

u/starwarsfan456123789 Jul 28 '24

Odd company- most would happily accept the script and give you additional assignments for your new free time

2

u/mrmattipants Jul 28 '24 edited Jul 28 '24

The IT Admin should have done his research, as there several ways around the one GPO that simply bars users from running PS Scripts.

Of course the following information can always change, but last time I checked, they were still an option.

Firstly, if the User is tech savvy, they can simply Change the Registry Key (unless IT also bars the user account from editing the Registry). This will allow you to Run Scripts again, at least until the GPO is Applied again (typically on the next sign-in or on the next reboot).

Secondly, the User could Download PowerShell 7 and Run it, since the GPO only applies to the "PowerShell.exe" Executable, yet the PS7 Executable is named "pwsh.exe". Even if they are barred from Installing Applications, there is a ZIP Folder Download, that does not require installation.

Executives and certain IT Admins have been scared shitless of PowerShell for the dumbest reasons. The best course of action is for IT to create an Approval Process for PS Scripts, rather than barring them outright. Barring tools that can simplify work related tasks is counterproductive.

Perhaps, allowing only Signed Scripts to Run might be the way to go. IT Admins then hold the Keys, as anyone who wants to write/run scripts needs to go through them, in order to get their Script Approved, Signed, etc. if they reject the Script, this would actually be a good opportunity to explain why and offer suggestions.

Ultimately, it allows everyone to work as a team and promotes trust (as opposed to strangling it, in the cradle).

2

u/Virtual-Baseball159 Jul 28 '24

Depending on the specific task you may be able to use VBA instead. VBA macros are not always blocked and they have limited access to your computer and can be used to work with multiple types of data and connectors. I once used power automate (kinda hate it but it worked) and VBA to automatically pull the data from an HMI over a vnc connection and manipulate it in excel (where the reports needed to be).

2

u/abelabelabel Jul 28 '24

Exit strategy. IT WILL steal this.

2

u/SpaghettiOnTuesday Jul 28 '24

You're first mistake was not first answering any and all questions with "I'm not following."

2

u/grod44 Jul 28 '24

Yea you def freaked out any cybersecurity team. Or anyone who’s supposed to be monitoring. Un approved scripts in a work environment heck no….. you were probably flagging the antivirus software also

2

u/ExcellentGas2891 Jul 28 '24

You should move jobs. If they are too fucking stupid to take advantage of your scripts, they are too stupid know your value.

2

u/[deleted] Jul 28 '24

Isn’t that what you should be doing?! What kind of IT bleh wtf

2

u/AdDry4983 Jul 28 '24

Nah you’d be fired if what you said true.

2

u/HellDuke Jack of All Trades Jul 28 '24

Honestly it would have been a lot easier if you just went straight to IT or if you did not have a line of communication to ask about automating your workflow then you could have spoken with your direct manager. Unless you wanted to avoid anyone finding out that you were going to automate your job and essentially sit there twiddling your thumbs getting paid without getting new assignments. In which case, that's not how you get moved to IT. That's exactly how I got to IT, I automated and optimized the hell out of several of our workflows and got recommended to IT the moment a spot opened up.

→ More replies (1)

2

u/dxrth Jul 28 '24

If the automation is that successful and necessary, wouldn’t any serious discussion just end with your position or department automated away? Risky game, especially if your skill set alone isn’t enough to incentivize saving you a position higher up or laterally.

2

u/mercurygreen Jul 28 '24

This isn't even Shadow IT - it's "learning how to do your job" and someone in I.T. is *supposed* to be helping with automation.

Them deleting it means you have to figure it out and present it to your grand-boss with an estimation of (half) the amount of time you're saving.

2

u/g3n3 Jul 28 '24

You aren’t making sense. On one hand you say you cant run scripts but you proceed to run scripts? I’m buying what you are saying.

2

u/JackfruitJolly4794 Jul 28 '24

Running scripts to automate your job is not the problem. It is doing it outside of all normal processes that is the problem. Find out what your orgs sdlc tools and processes are and start using them. Source control, code review, testing, automation frameworks, change management, etc.. Those exist and are used for a reason. Cowboying outside those processes can have implications such as with audit and compliance

2

u/MasterShogo Jul 28 '24

We have an exotic enough engineering need that my org just has its own engineering IT group. They work with corporate IT, but they facilitate whatever weird, exotic crap is needed by the engineers. The nice part is that many of them are engineers and they do a good job of communicating between the two sides of the coin.

2

u/RaunchyMuffin Jul 28 '24

You need a better job 😂 sounds like wasted talent

2

u/BikerJedi Jul 29 '24

The last time I wrote a script I got fired. I found out I could script all the queries I was making each day to the mainframe. Then I found out I could have them dumped into a .csv file. Then I wrote an access database that imported that file. All of that saved me hours each day - I went from 8 hours to 2-3.

When the boss found out, he took my script and database, gave it to a guy in another state, and cancelled my contract.

2

u/krypticus Jul 29 '24

I would encourage you to ask if there is an open position on their team so that you can join ranks. Get your resume polished up (keep it to 1-page if possible) and go for it!

2

u/LeucisticBear Jul 29 '24

You are beyond the capabilities of at least half the IT staff at your company just being able to write scripts. Definitely get a new job.

2

u/TitsGiraffe Jack of All Trades Jul 29 '24

Seriously, get your manager to ask for an exemption and make it clear you know that what you script is not supported by anyone but yourself. IT isn't there to stop you from being productive, we want you to be able to work efficiently, but in a secure environment. It's very hard to get right.

2

u/[deleted] Jul 29 '24

Shouldn’t you just be getting approval to automate instead of trying to circumvent policy?

→ More replies (3)

2

u/Spazbototto Jul 29 '24

I knew a guy that automated his job using a combination of scripts and powerautomate. The company found out and praised him for the workflows, he even held a few monthly training classes to get others spun up on his creation.

A few months after the training ended they let him go and made his position a collateral duty....using the scripts and workflows he created..

2

u/Baguy21 Jul 29 '24

This is some SILO shit going on here, they don't want you accidentally finding out stuff 🤣

→ More replies (1)

2

u/teeweehoo Jul 29 '24

Next step: External automation. Something like this can do it. https://shop.hak5.org/products/usb-rubber-ducky

Though unfortunately if anyone finds it, you will likely be screwed.

2

u/[deleted] Jul 29 '24

shadow IT, the mortal enemy of all IT personnel and the bane of infosec

2

u/messageforyousir Jul 29 '24

Your IT department has no idea what security is. There are much more i portant things than doing script management wrong like they are. It is way less work to do it properly.

If they're paranoid, they can set PowerShell execution policy to All signed, then give you a signing cert that is only trusted on systems you use.

They should write a simple policy about it, and then they can move on to more important things.

2

u/Ok-Issue8284 Jul 29 '24

…the job is getting done because of the work you did, so you’re technically still doing the job they’re paying you for- why punish you for being efficient??

2

u/AllYourBas Jul 29 '24

TALK to your IT security people when you do this - they (usually) DGAF if you're slacking off or automating your role, only if thier shit is compromised.

Show them how it works and they should whitelist it.

Offer to help them make thier own scripts lol

2

u/10010101110011011010 Jul 29 '24

Why does IT "not allow you to run scripts"?

2

u/DreadSeverin Jul 29 '24

No getting work done for free! This is a business! This is what we do here! We be busy

→ More replies (1)

2

u/upgo4t Jul 29 '24

This sounds like BS, powershell execution is disabled by default. I smell a lie

2

u/LucidZane Jul 29 '24

I feel like you need to talk to IT directly and just tell them you need to be able to run scripts to do your job.

Talk to your boss and say you can be much more efficient by running scripts, maybe don't let on how much more faster though so you don't get a ton more work piled on

2

u/CrimtheCold Jul 29 '24

The new job you should be looking for should be a title similar Robotic Process Automation. A company I worked for had a RPA group as part of its internal IT. They used UIPath. All the things they automated were tedious processes no one wanted to do.

Nobody got automated out of a job because there is always more work to be done. Things the business could have been doing but because of the time cost of the now automated work it couldn't. Whenever they ran out of things to automate they would cross train with other departments. The goal of that cross training was to learn various jobs throughout the company and identify more RPA opportunities.

2

u/RazielLycas Jul 29 '24

Your IT like to bully you... how dumb they are? Insted making a security assessment and help you to automate your job they deny to you the capability to execute scripts.. maybe you could try with logic apps or powerautomate or ask to your IT Manager if signing your scripts with a certificate could be a viable way to make them executable

2

u/Cma1234 Jul 29 '24

did everyone start slow clapping?

2

u/dowlingm Jul 29 '24

As someone who has been on the other end of that call, I would have asked you to have your manager validate that your script was actually compliant with the work product you produce and then we would work with you to create a managed script which we could document and track changes in. But telling your manager would have presumably gotten in the way of the stuff you were looking to do with the time freed up ("my job would be automated and I wouldn't have to work.")

Also, the reason IT didn't make you an offer to move into their group is possibly due to the fact that they couldn't trust you not to abuse privileged access in the way you were doing with unprivileged, and they couldn't trust you to enforce shadow IT policies on colleagues when you yourself don't follow them.

Finally, you shouldn't assume that just because the IT contact didn't flag that this incident would be discussed elsewhere, that it wasn't. They have their own job to look after, and don't owe anything to someone who tries to end run them.

2

u/[deleted] Jul 29 '24

What I have learned about Shadow IT over the years....

Show me a company with Shadow IT and I will show you a deficient IT organization.

Shadow IT exists because IT is simply not close enough to the business to understand their needs and provide the solutions that those "Citizen Programmers" are trying to solve for themselves.

In OPs case the correct response should have been, what are you trying to accomplish, how can we help to improve what you are trying to do.

Those folks that are being called Shadow IT are ITs customers, and if they have to self-serve for greater efficiency then they are NOT being served.

2

u/thortgot IT Manager Jul 29 '24

Getting a new job is one option, getting your scripted solution widely adapted is a better solution. To do so you need to demonstrate that it's safe, supportable and effective.

Doing so "in the dark" so to speak is the issue.

2

u/PalmTreesandTech Jul 30 '24

You probably know more than my help desk guys

2

u/ramuser12258 Jul 30 '24

3 rules 1 know your role 2 speak before action and if you want to get ahead 3 don’t show off you offer assistance if it not accepted except that polices are there for a reason if you don’t know the reason don’t break the policy and expect a reward

2

u/Fatality Jul 30 '24

What a douche, if I was in charge I'd enable people to do their job not block everything.

2

u/IMarvinTPA Jul 30 '24

See if you have access to Microsoft's cloud based automation stuff called power automate. It is pretty powerful no-code automation tool.

2

u/Admin4CIG Jul 30 '24

I told one user not to plug anything that powers a heating element into the battery UPS. I specifically told her, "that heater you have under your desk." She went ahead and plugged in her heater in the UPS. The UPS smoked and burned out. It was now damaged and useless, and it powers her computer as well. She comes over to me, and said she needs a new UPS as the one she had was defective. I went over to look, and pointed out the damaged caused by her heater. "No, that's not the reason." I had to go to the CEO to get him to explain it to her, "Don't ever plug in any heater in any UPS! It'll kill the UPS!" She listened this time.

2

u/QueefToMouth Jul 31 '24

I see this as an opportunity for promotion to another role, unless you'd much rather continuing this work and pretend you're working a large amount of the day

3

u/Alekspish Jul 28 '24

You can run python in excel now. Could give that a go. They never going to ban excel!

→ More replies (1)

3

u/[deleted] Jul 28 '24

This is 100% “shadow IT”. You need to go through proper approval channels and process changes to get this approved. The biggest concern is who is going to support this if something goes wrong? Without a properly documented process what happens when you leave the company?

→ More replies (1)

2

u/craa141 Jul 28 '24

Are you really this foolish?

I got caught cheating at work and so decided to do it again a week later?

Why is my boss mad at me?

2

u/Practical-Alarm1763 Cyber Janitor Jul 28 '24

Why are you hiding scripts?

Those who can automate and script their tasks easily are more valuable to keep over ClickOps plebs.

2

u/Breitsol_Victor Jul 28 '24

If your manager is ok with it, knows that it saves time and reduces data entry errors, they should be talking to IT manglement. You may have an application administrator or programmer that would work with you. As the system admins seem to want to lock it down. They could review the original PoSh script, tweak it, sign it, and allow it. Or, give you an elevated login for running the script.

Those that would lock your account or try to get you fired should be reaching out to understand what is going on. All they see is a script and it scares them. Someone on their team should have an elevated view of the world and recognize the utility and impact, and figure out how to make it work.

I have not done data loads with PoSh yet, but I did a number of HLLAPI projects that did a lot of loading.

2

u/Secret_Account07 VMware Admin Jul 28 '24

Folks, please don’t do this. These type of users are my worst nightmare. They are always breaking shit too, that I have to cleanup.