I need to login into multiple servers thru a script run couple commands and run find command as root. I only have ssh access to the servers as a user than I can "su" to root. If you have a similar script please post it. Also if you can suggest commands that I should consider please let me know.
... (1 Reply)
Hi All,
I am a total noob to the Unix world, and i hope to learn a lot from this wonderful community. Here's my first post and question , i am trying to SCP a file to multiple servers (multiple destinations) through this little script :
#!/bin/ksh
# copy files
# File to be copied... (7 Replies)
Hi guys , i have 1 problem and no find what is the problem...:confused:, and .netrc is configured and correct permissions...
REMOTE="/home/user"
LISTADO=`cat /root/home/user/LISTADO.txt`
MACHINE=$(echo $i|awk 'FS="|" {print $1}')
for i in $LISTADO
do
ftp $MACHINE <<TER
passive
prompt... (2 Replies)
Hi Everybody,
I am bit new to shell scripting. I need some help in my script.
I have to login into 15 servers and check some logs daily. For that I've written one shell script, somewhere it is having some problems. After log into the first server, the script is not going with the next steps.... (6 Replies)
Hello,
I am a Unix newbie and I need a script in which I can run a command on multiple servers at work. The command is to start a storage process and I am sick of doing it manually on all servers..
Here's the command:
/opt/bss/bin/snmptable -CB -v2c -c P67LzuBm hostname hrStorageTable... (4 Replies)
HI all,
I want to script where all the server names will be in a text file like
server1
server2
server3 . and the script should take servernames from a text file and perform copy of files if the files are not present on those servers.after which it should take next servername till the end of... (0 Replies)
Experts,
Im trying to remote into a server, run a script that resides on that server and capture the information displayed & store in a local file.
I struggled with this yesterday & finally that script is working now.
Now, here is a scope creep and the script that I wrote for 1 remote... (2 Replies)
I have ssh password less auth enable & script does the job well as well
#/bin/bash
for i in `cat ip`
do
scp /etc/resolv.conf root@$ip
done
But I need to take backup of the file i will overwrite .. is there any simple way ?
Kindly respond (5 Replies)
I need to run a script on a bunch of remote servers. how can this be done without ssh into each individual server and run it
its under /sbin/script.sh on each server (1 Reply)
Hi
I did the following script to ping multiple servers, but I keep on receiveing duplicate emails for one server that is down:
#!/bin/bash
date
cat /var/tmp/servers.list | while read output
do
ping -c 1 "$output" > /dev/null
if ; then
echo "node $output is up"
else
... (10 Replies)
Discussion started by: fretagi
10 Replies
LEARN ABOUT PHP
sqlsrv_fetch
SQLSRV_FETCH(3)SQLSRV_FETCH(3)sqlsrv_fetch - Makes the next row in a result set available for readingSYNOPSIS
mixed sqlsrv_fetch (resource $stmt, [int $row], [int $offset])
DESCRIPTION
Makes the next row in a result set available for reading. Use sqlsrv_get_field(3) to read the fields of the row.
PARAMETERS
o $stmt
- A statement resource created by executing sqlsrv_query(3) or sqlsrv_execute(3).
o $row
- The row to be accessed. This parameter can only be used if the specified statement was prepared with a scrollable cursor. In
that case, this parameter can take on one of the following values:
oSQLSRV_SCROLL_NEXT
oSQLSRV_SCROLL_PRIOR
oSQLSRV_SCROLL_FIRST
oSQLSRV_SCROLL_LAST
oSQLSRV_SCROLL_ABSOLUTE
oSQLSRV_SCROLL_RELATIVE
o $offset
- Specifies the row to be accessed if the row parameter is set to SQLSRV_SCROLL_ABSOLUTE or SQLSRV_SCROLL_RELATIVE. Note that the
first row in a result set has index 0.
RETURN VALUES
Returns TRUE if the next row of a result set was successfully retrieved, FALSE if an error occurs, and NULL if there are no more rows in
the result set.
EXAMPLES
Example #1
sqlsrv_fetch(3) example
The following example demonstrates how to retrieve a row with sqlsrv_fetch(3) and get the row fields with sqlsrv_get_field(3).
<?php
$serverName = "serverNamesqlexpress";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
$sql = "SELECT Name, Comment
FROM Table_1
WHERE ReviewID=1";
$stmt = sqlsrv_query( $conn, $sql);
if( $stmt === false ) {
die( print_r( sqlsrv_errors(), true));
}
// Make the first (and in this case, only) row of the result set available for reading.
if( sqlsrv_fetch( $stmt ) === false) {
die( print_r( sqlsrv_errors(), true));
}
// Get the row fields. Field indeces start at 0 and must be retrieved in order.
// Retrieving row fields by name is not supported by sqlsrv_get_field.
$name = sqlsrv_get_field( $stmt, 0);
echo "$name: ";
$comment = sqlsrv_get_field( $stmt, 1);
echo $comment;
?>
SEE ALSO sqlsrv_get_field(3), sqlsrv_fetch_array(3), sqlsrv_fetch_object(3).
PHP Documentation Group SQLSRV_FETCH(3)