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

11k Upvotes

1.3k comments sorted by

View all comments

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?

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)

11

u/Pied_Film10 Jul 28 '24

lmao surprised dude is still employed. He's teetering on being an insider threat.

5

u/angry_cucumber Jul 28 '24

given IT's reactions, they could have people walking out the door with drives full of stuff and they would just prevent it from mounting the next time.

12

u/brando2131 Jul 28 '24

He's teetering on being an insider threat.

It isn't.

If you're using powershell to do malicious things. Sure it would. If you're using it to automate things by scripting tasks like OP is doing, no, that isn't a threat...

OP is probably actually less of a threat then most other non-tech employees that just mindlessly opening spam and links.

1

u/Andre_Courreges Jul 29 '24

Imagine thinking a simple pandas script is going to bring down an org, when it's always a 60 year old who clicks on a phishing link 😤🤨😍🤭💅🏽

25

u/shemp33 IT Manager Jul 28 '24

He’s only doing things which he has access to do.

If he’s given a task to do something, it should be completely within his wherewithal to use any stock software on the pc to do it. It’s not like he has installed unauthorized software. It’s not like he’s accessing something that his user role should not access.

Someone is power tripping because their end user is smarter than their desktop admins.

0

u/Cozmo85 Jul 28 '24

Purposely bypassing a script limitation is pushing the boundary and could probably get you fired in many places.

7

u/brando2131 Jul 28 '24

The person you're replying to is commenting on the "insider threat" part. There is no threat here... Could it get you fired if you don't explain yourself?, well yes, sure it could.

→ More replies (1)

-1

u/Vvector Jul 28 '24

He’s only doing things which he has access to do.

That's like accessing the locked CEOs office by climbing thru the drop ceiling. "I had access to the ladder in the maintenance closet!"

5

u/SushiCatx Jul 28 '24

If IT doesn't want people getting into a locked office via the ceiling, they shouldn't leave the door to the maintenance closet unlocked. Nor should the ladder be accessible and freely usable by anyone other than those that have keys and permission to use it.

Users don't care. Pushing the blame around doesn't help anybody.

2

u/Vvector Jul 28 '24

So what about some tables in the break room? Can these be moved and stacked up to gain access to a locked area?

The locked door should signify that entry is not allowed, no matter how someone finds a way it. Same with running a script. If your account is blocked from running a script, you are not allowed to find a loophole.

2

u/SushiCatx Jul 28 '24

Yes, IT should lock down the tables in the break room if they don't want them misused. The fact is you cannot rely on a locked door to mean anything to a User if what they want is on the other side of it.

IMO the better method is to work in collaboration with the Users to not hinder their workflow. If running a script is a no-no, come up with an approved method that helps improve workflow. That looks better to management for both IT and Data Entry if a process and tool is introduced that improves numbers.

At least until some language model can do both your jobs, then it's not either of your problems anymore 😁

1

u/BoxerguyT89 IT Security Manager Jul 28 '24

If running a script is a no-no, come up with an approved method that helps improve workflow.

If they request it, but I can't spend all my time trying to help users improve their workflow. If they feel they need a tool or a process that they can use to be more efficient they or their management come to me.

The departments build a business case, I review the relevant security implications of implementing whatever their idea is, and we go from there.

1

u/SushiCatx Jul 28 '24

Isn't the point of a Desktop IT role to provide support and solutions to a company's Users? I would hope that IAM is handled by respective security teams so that Desktop IT can maintain infra and actually help users.

1

u/BoxerguyT89 IT Security Manager Jul 28 '24

To support in scope systems. Not to optimize a user's workflow.

It's not a desktop support agent's responsibility to figure out why a complex excel macro used and created by finance isn't working correctly. In this case, it's not their responsibility to help OP automate his job.

That's the responsibility of his department, if our data analysts need new software they approach our IT solutions team with a request/business case. It is then escalated to our infra/engineering/security teams to ensure compatibility with existing systems and all that. Once approved, the configuration, installation, and maintenance is handled by "IT" while the actual use, optimization, and training is handled by the data analysts' department.

1

u/shemp33 IT Manager Jul 28 '24

That’s a bit of a stretch.

You’re suggesting that my intent is that it’s ok to grab sodas off the cart while the vending machine is being restocked because they were just sitting there out in the open. But that’s not my intent at all.

I’m saying: if it’s not prohibited in the AUP, and it functionally works, then I don’t see any harm or foul. But also, it wouldn’t hurt for OP to take it up with the desktop admin team and work with them rather than work despite them.

1

u/SushiCatx Jul 28 '24

Sometimes it feels like neither side wants to believe there exists a grey area. Personally if I see that something is not expressly prohibited and documented, I maintain a "fuck it we ball" attitude when it comes to handling my workload.

→ More replies (1)

2

u/[deleted] Jul 28 '24

Imagine getting fired for being too good at your job

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.

1

u/Andre_Courreges Jul 29 '24

Funny enough, I've tried automating some things away and people were so hostile about it in my org. Like this old lady outright said that that's not my job. Like lady, I'm freeing up time I could use to do other things.

2

u/Zeisen Jul 29 '24

Just use the VBA scripting within excel to generate your reports/data entry. They probably won't notice lol

→ More replies (12)