Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Assign this to a variable....
Top Forums Shell Programming and Scripting Assign this to a variable.... Post 302365960 by ak835 on Thursday 29th of October 2009 08:03:41 AM
Old 10-29-2009
MySQL
well...i am putting here what i am trying to achieve...

Code:
Family: Host NWStats

DUP:
/usr/bin/netstat -an -f inet |egrep -v "Active|Proto"|awk '{print $1$4}'

Protocol:
A=$(/usr/bin/netstat -an -f inet | awk -F' ' '{if ($1$4 == "@@Host NWStats.DUP@@" ) print $1}')
B=$(echo "$A"|cut -c 1-3)
echo "$B"

Local IP:
A=$(/usr/bin/netstat -an -f inet | awk -F' ' '{if ($1$4 == "@@Host NWStats.DUP@@" ) print $4}')
B=$(echo "$A"|grep "*"|wc -l)
if [ "$B" = 1 ]
then
C=$(echo "$A"|cut -d "." -f1)
echo "$C"
fi

if [ "$B" = 0 ]
then
D=$(echo "$A"|cut -d "." -f1-4)
echo "$D"
fi


For first column Protocol ,i am not getting values as seen when the command is fired...

For Local IP,i am not getting anything...just blanks...

Any guesses? Anything wrong in above lines ? Any better ideas?

Help Appreciated !!

Regards
Abhi

---------- Post updated 10-29-09 at 05:33 PM ---------- Previous update was 10-28-09 at 09:35 PM ----------

Okay..i got where i wrote wrong.... but this code is just tested on AIX hosts .I need to test this on Solaris as well as Linux hosts.

I'll keep posted.

Regards
Abhi


Code:
Family: Host NWStats

DUP:
/usr/bin/netstat -an -f inet |egrep -v "Active|Proto"|awk '{print $1$4$5}'

Protocol:
A=$(/usr/bin/netstat -an -f inet | awk -F' ' '{if ($1$4$5 == "@@Host NWStats.DUP@@" ) print $1}')
B=$(echo "$A"|cut -c 1-3)
echo "$B"

Local IP:
A=$(/usr/bin/netstat -an -f inet | awk -F' ' '{if ($1$4$5 == "@@Host NWStats.DUP@@" ) print $4}')
B=$(echo "$A"|grep "*"|wc -l)
if [ $B = 1 ]
then
C=$(echo "$A"|cut -d "." -f1)
echo "$C"
fi

if [ $B = 0 ]
then
D=$(echo "$A"|cut -d "." -f1-4)
echo "$D"
fi

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

assign to variable

why i can't use this command: echo $arg | cut -c 1,2 | read remainArg or echo $arg | cut -c 1,2 | read $remainArg so that the result will be assign to remainArg. Anyway to do this? :) (1 Reply)
Discussion started by: AkumaTay
1 Replies

2. Shell Programming and Scripting

assign a value to variable

I have to assign a result of a query to a vairable like this how can i do this Query = select count(*) from table x=`db2 ${Query}| sed -n '4p'` but this doesn't work, is there any other way to assign the result without redirecting the result to temp file. . Thanks Mark. (3 Replies)
Discussion started by: markjason
3 Replies

3. Shell Programming and Scripting

assign a value to a variable

I have a list of names in a file. i want to assign those names to a variable in such a manner eg: $cat file.txt pete lisa john var=pete-lisa-john how do i do this in shell scripting? (10 Replies)
Discussion started by: Shivdatta
10 Replies

4. Shell Programming and Scripting

Not able to assign a value to variable

Hi Experts, I am facing some problem while developing the script.My input config.csv file contains the three columns namely pathname,filename,filetype.Based on the file type i have to use ftp command that is if filetype=csv then do ftp. The input file is cat config.csv... (13 Replies)
Discussion started by: Amey Joshi
13 Replies

5. Shell Programming and Scripting

assign awk's variable to shell script's variable?

Dear All, we have a command output which looks like : Total 200 queues in 30000 Kbytes and we're going to get "200" and "30000" for further process. currently, i'm using : numA=echo $OUTPUT | awk '{print $2}' numB=echo $OUTPUT | awk '{print $5}' my question is : can I use just one... (4 Replies)
Discussion started by: tiger2000
4 Replies

6. Shell Programming and Scripting

Shell assign variable to another variable

How can I assign a variable to an variable. IE $car=honda One way I can do it is export $car=honda or let $car=2323 Is there any other ways to preform this task (3 Replies)
Discussion started by: 3junior
3 Replies

7. Shell Programming and Scripting

Assign a variable with awk

I launch 'netstat -a', if string 'ESTABLISHED' found, then VAR=1 #!/bin/bash VAR=0; netstat -a | awk '$6 ~ /ESTABLISHED/ {VAR=1}' I cannot find the right syntax. thanx guys! (3 Replies)
Discussion started by: arpagon
3 Replies

8. UNIX for Beginners Questions & Answers

Need to pass variable in a command and assign value to a variable

Hello All, Hope you're doing well ! I am trying below command to be passed in a shell script, header_date_14 is a variable and $1 is the name of a file I intend to pass as a command line argument, however command line argument is not being accepted. header_date_14=$(m_dump... (8 Replies)
Discussion started by: ektubbe
8 Replies

9. UNIX for Beginners Questions & Answers

How can I assign awk's variable to shell script's variable?

I have the following script, and I want to assign the output ($10 and $5) from awk to N and L: grdinfo data.grd | awk '{print $10,$5}'| read N L output from gridinfo data.grd is: data.grd 50 100 41 82 -2796 6944 0.016 0.016 3001 2461. where N and L is suppose to be 3001 and 100. I use... (8 Replies)
Discussion started by: geomarine
8 Replies

10. UNIX for Beginners Questions & Answers

Assign value to variable

Hi Guys, I need to assign the value of which has rows to a variable, Can you advise how to do that hive --orcfiledump /hdfs_path/ | grep "Rows" Rows: 131554 I need to assign this row count itself to a unix variable count=$(hive --orcfiledump /hdfs_path/ | grep "Rows") Expected ... (6 Replies)
Discussion started by: Master_Mind
6 Replies

LEARN ABOUT PHP

mssql_fetch_field

MSSQL_FETCH_FIELD(3)													      MSSQL_FETCH_FIELD(3)

mssql_fetch_field - Get field information

SYNOPSIS

       object mssql_fetch_field (resource  $result, [int  $field_offset = -1])

DESCRIPTION

       mssql_fetch_field(3) can be used in order to obtain information about fields in a certain query result.

PARAMETERS

	      o $result
		- The result resource that is being evaluated. This result comes from a call to mssql_query(3).

	      o $field_offset
		-  The numerical field offset. If the field offset is not specified, the next field that was not yet retrieved by this function is
		retrieved. The $field_offset starts at 0.

RETURN VALUES

	Returns an object containing field information.

	The properties of the object are:

	      o name - column name. if the column is a result of a function, this property is set to computed#N, where #N is a serial number.

	      o column_source - the table from which the column was taken

	      o max_length - maximum length of the column

	      o numeric - 1 if the column is numeric

	      o type - the column type.

EXAMPLES

       Example #1

	      mssql_fetch_field(3) example

	      <?php
	      // Connect to MSSQL and select the database
	      mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
	      mssql_select_db('php');

	      // Send a select query to MSSQL
	      $query = mssql_query('SELECT * FROM [php].[dbo].[persons]');

	      // Construct table
	      echo '<h3>Table structure for 'persons'</h3>';
	      echo '<table border="1">';

	      // Table header
	      echo '<thead>';
	      echo '<tr>';
	      echo '<td>Field name</td>';
	      echo '<td>Data type</td>';
	      echo '<td>Max length</td>';
	      echo '</tr>';
	      echo '</thead>';

	      // Dump all fields
	      echo '<tbody>';

	      for ($i = 0; $i < mssql_num_fields($query); ++$i) {
		  // Fetch the field information
		  $field = mssql_fetch_field($query, $i);

		  // Print the row
		  echo '<tr>';
		  echo '<td>' . $field->name . '</td>';
		  echo '<td>' . strtoupper($field->type) . '</td>';
		  echo '<td>' . $field->max_length . '</td>';
		  echo '</tr>';
	      }

	      echo '</tbody>';
	      echo '</table>';

	      // Free the query result
	      mssql_free_result($query);
	      ?>

SEE ALSO

       mssql_field_seek(3).

PHP Documentation Group 												      MSSQL_FETCH_FIELD(3)
All times are GMT -4. The time now is 04:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy