I want to be able to generate simple repetitive scripts in SQL using Powershell as the scripting language.
For example, If I want to generate a SQL GRANT command for every table in a database, and for every category of user in the database, the generic grant command might look like this:
Here, $privs, $table, and $user are parameters to the Grant command, expressed as powershell variables.
I want to step through a list of data that could be applied to this generic form to produce the actual script. The list of data might look like this:
privs table user
----- ----- ----
ALL Employees DBA
READ Employees Analyst
READ, WRITE Employees Application
ALL Departments DBA
READ Departments Analyst, Application
This should generate five SQL GRANT commands.
Full Disclosure: I am asking this question so as to be able to provide my own answer.
Go to Source
Author: Walter Mitty
I’ve got scripts that collect data on errors and sends them into a ticketing system. If any developments occur regarding an existing ticket, I want to be able to access the email inbox to get the ticket number so that I can include this in the reply. This will result in the ticketing system including the new information in the old ticket instead of creating a new ticket every time. Is this possible?
I’ve been looking online for how I might be able to do this but I haven’t yet found anything that looks like bash commands to access the inbox programmatically and save a message’s information to a variable.
Go to Source
Author: Tom Cayton
I am looking for new ideas on how can I do more better.
Home laptop (home Laptop can access only Linux VM)
Linux VM (This machine can access only jump box)
jump box VM
I can ssh fine from Linux VM to jump box keys are setup.
one user is set up in Linux VM called joe and Joe .bash_profile looks like this.
ssh 10.0.0.1 || ssh 10.0.0.2
Note: There is two nic on jump box if one is down we can use the other nic for login.
Let’s say first nic is down and when I do telnet from my home laptop (telnet Linux VM) and provide user name joe it should automatically connect us to 10.0.0.1 but one is down it’s giving message timeout and taking a long time to connect to other nic.
is there any way when I do telnet and give user name check first ssh connection if down automatically connects to other second one like in 2-3 secs?
Right now it will give us a message
And then it will try to connect the second nic.
I can more clarify if you guys have any more questions for me.
Go to Source
Resolving hosts can add up to the connection attempt, so specifying an IP address directly can shave off some of those precious milliseconds. If it’s only in a local network with the IP addresses all laid out that should not be the case. At least that’s what I think.
Perhaps explicitly setting the ConnectTimeout option to a shorter one. Like so,
ssh -o ConnectTimeout=10 user@host
This can help. Adjust the number to a sweet spot that works for your ssh setup as necessary.