09-16-2019
Thank you @Neo for your reply and suggestion.
I do see the benefit in doing this on each server. From my usecase we won't have this server script on every newly built server and I only scan a certain list of servers based on another report which I then use as my input file. For my usecase I will need to continue with using the script as we've currently written it to reach out to each server, collect data into variables and concatenate this collected data along with other variables from my input file.
I'm hoping there is a way to issue one ssh connection to each server and issue various command line instructions like I do in the script I've provided and collect each result in their own variable.
Thanks in advance for any help anyone can provide me.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear friends,
i need to connect sftp server from my home directory using script .
Please can anyone help me on this. (1 Reply)
Discussion started by: kittusri9
1 Replies
2. Shell Programming and Scripting
HI,
Can't seem to find anything on the forums to fix this.
I have a file, one line within this will not have a specific string at the end.
I have the string, but need to append it to the specific line which has it missing.
I need to use a variable for this, $string - I am using double... (13 Replies)
Discussion started by: mandriver
13 Replies
3. Shell Programming and Scripting
Hey guys, new problem....im not being able to seperate variables.
the code runs like this...
OPTIONS=$(awk '{print $2}' /etc/fstab}
a=$(zenity --list --text "Mount points selection" --radiolist --column "choice" --column "mountpt" FALSE $OPTIONS); echo $a
Note: the result i get is that... (2 Replies)
Discussion started by: dplate07
2 Replies
4. Shell Programming and Scripting
Hi there
I found the Command to send commands to other servers like:
sv01> ssh user@sv02 'ps -ef'
But I cant use Variables from a script i want to execute on another server like:
sv01> ssh user@sv02 'cd $SCRIPTHOME'
although the variable is set on sv01.
How can I run commands on sv02 with... (2 Replies)
Discussion started by: DarkSwiss
2 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I need to execute a SQL via shell script and i am connecting to Oracle DB by this way $USERNAME1/$PASSWORD1@$STRING1 and i need to get username, password and string from someother file stored in the Unix Directory. $Username, $Password and $String is stored in File A in Path A and i want... (1 Reply)
Discussion started by: sathish.tn
1 Replies
6. Shell Programming and Scripting
Requirement:
Run a shell script with below inputs
file name
checksum
path
the script should go to multiple servers (around 35) and verify the input cksum and if there is a mismatch display a simple message to the user that cksum verification failed.
host details, user id /... (1 Reply)
Discussion started by: amicableperson
1 Replies
7. UNIX for Advanced & Expert Users
Hi,
I have script1.sh on 3 servers. I want to collect output report generated by them to a single server and append all the reports. Please tell me how can i do this? (2 Replies)
Discussion started by: pratikm23
2 Replies
8. Shell Programming and Scripting
Hello,
I have access to several linux servers (mostly centos based) located in a DC in another country.
from day to day I need to login to each of them to do some work (they dont have gui/window manager installed, I work only from console), or even to just do a check like df -h for disc usage.... (3 Replies)
Discussion started by: MaRiOsGR
3 Replies
9. Shell Programming and Scripting
Hi,
I am trying to complete my bash script in order to find which SSH servers on LAN are still active with the ssh keys, but i am frozen at this step:
#!/bin/bash
# LAN SSH KEYS DISCOVERY SCRIPT
</etc/passwd \
grep /bin/bash |
cut -d: -f6 |
sudo xargs -i -- sh -c '
&& cat... (11 Replies)
Discussion started by: syrius
11 Replies
10. UNIX for Advanced & Expert Users
Greetings Experts,
I am working for a bank client and have a question on connect-direct and SFTP.
We are using Linux RedHat servers. We use connect-direct to transfer (NDM) files from one server to another server. At times, we manually transfer the files using SFTP from one server to another... (2 Replies)
Discussion started by: chill3chee
2 Replies
LEARN ABOUT DEBIAN
defncopy
defncopy(1) FreeTDS Utilities defncopy(1)
NAME
defncopy - extract procedures and views from a Microsoft server.
SYNOPSIS
defncopy [-U username] [-P password] [-S server] [-D database]
[-i input_file] [-o output_file] [-v]
[owner.]object_name [[owner.]object_name...]
DESCRIPTION
defncopy is a utility program distributed with FreeTDS. It replaces a similar program of the same name distributed by Sybase.
defncopy reads the text of a stored procedure or view, and writes a script suitable for recreating the procedure or view. For tables, it
reads the output of sp_help and constructs a CREATE TABLE statement, complete with CREATE INDEX, too.
OBJECTS
owner is optional if you or the database owner is the owner of the procedure/view being copied.
object_name
is the name of the system object you wish to extract.
OPTIONS
-U username
database server login name.
-P password
database server password.
-S server
database server to which to connect.
-D database
database to use. Optional if the procedure/view being extracted is in your default database.
-i input_file
a script to apply to the database. Not currently implemented.
-o output_file
a file to hold the script, defaults to standard output.
-v Show version information and copyright notice.
NOTES
defncopy is a filter; it reads from standard input, writes to standard output, and writes errors to standard error. The -i and -o options
override these, of course.
defncopy makes use of the db-lib API provided by FreeTDS. This API is of course also available to application developers.
EXIT STATUS
defncopy exits 0 on success, and >0 if the server cannot process the query.
defncopy will report any errors returned by the server, but will continue processing.
HISTORY
defncopy first appeared in FreeTDS 0.63.
AUTHORS
The defncopy utility was written by James K. Lowden <jklowden@schemamania.org>
BUGS
Works only with Microsoft servers and ancient Sybase servers.
Does not create primary keys.
Many options are defined by Sybase that this version does not implement. Feel free to correct this situation.
In theory, defncopy could apply/produce DDL for any system object, but at present only tables, procedures and views are supported, and only
for extraction.
doc 13 November 2011 defncopy(1)