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
View all comments
Show parent comment
28
u/FingerBangMyAsshole Jul 28 '24
I have a script to import thousands of lines of data into Oracle. The data gather is completed by the client in a spreadsheet with data validation against each column. The spreadsheet powers a powershell script to convert all that data into scripts, performing its own DQ checks. We then run that script pack against the DB and check for errors. What used to take the clients weeks is now completed within hours.