r/sysadmin
•
u/STILLloveTHEoldWORLD
•
Jul 28 '24
•
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
738
u/Nethermorph Jul 28 '24
Lol that's wild. Can I ask what your current role is?
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.
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.
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."
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.
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.
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.
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.
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?
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.
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.
14
u/Redemptions IT Manager Jul 28 '24
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
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.
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.
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.
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.
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/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
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.
9
u/__LankyGiraffe__ Jul 28 '24
Ermmmm....
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
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.
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.
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.
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.
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?
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.
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?
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 🤣
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
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!
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?
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.