Shell Programming and Scripting

Drop the sub (...); and post the result.

awk '/JUNOS/ && /boot/ {print devices $5}' *cpe.domain.net/show.version

That gave me the list of software versions.

I see in this '/JUNOS/ && /boot/ how it replaces my grep from my original example.

I'll use this and some time studying AWK to see if I can figure out the rest on my own when I have more time and I will post my results.

Thank you!

That is NOT what I posted. "devices" is not defined and thus the empty string. Pls post the result of

Code:

awk '/JUNOS/ && /boot/ {print FILENAME $5}' *cpe.domain.net/show.version

I apologize, I had assumed FILENAME was something I could change. I went back through what you suggested before, kept FILENAME, fixed the sub string and everything displayed exactly how I wanted it.

awk '/JUNOS/ && /boot/ {sub (/[^\/]* .$/, "", FILENAME); print FILENAME $5}' *cpe.domain.net/show.version

Thanks again for your assistance!

---------- Post updated at 02:38 AM ---------- Previous update was at 02:37 AM ----------

Just wanted to do a follow up since I'm at work and have had more time to play with this.

This script awk '/JUNOS/ && /boot/ {sub (/[^\/]* .$/, "", FILENAME); print FILENAME $5}' *cpe.domain.net/show.version got me started on what the boss wanted me to do.

Output:

Code:

device1-e0.cpe.domain.net/show.version[11.4R8.5]
device2-e0.cpe.domain.net/show.version[11.4R10.3]
device3-e1.cpe.domain.net/show.version[11.4R10.3]
device4-e0.cpe.domain.net/show.version[11.4R10.3]
device5-e1.cpe.domain.net/show.version[11.4R10.3]
device6-e0.cpe.domain.net/show.version[11.4R7.5]
device7-e1.cpe.domain.net/show.version[11.4R7.5]
device8-e0.cpe.domain.net/show.version[11.4R8.5]

From there, I had to change the way this prints so that it shows column 5 of show.version first, followed by a space, then the device name. After that, the boss wanted me to sort by the software version. Lastly, that script above left in some output I wasn't too fond of, particularly in showing /show.version at the end of each device name, so I had to cut that out. Below is the modified script meeting all the requirements, along with a sample of the output.

Script:
awk '/JUNOS/ && /boot/ {sub (/[^\/]* .$/, "", FILENAME); print $5 " " FILENAME}' *cpe.domain.net/show.version | sort -k5 | cut -d / -f 1

Output:

Code:

[10.0R4.7] device1-r0.cpe.domain.net
[10.0R4.7] device2-r0.cpe.domain.net
[10.0R4.7] device3.cpe.domain.net
[10.0R4.7] device4.cpe.domain.net
[10.0S6.1] device5-e0.cpe.domain.net
[10.0S6.1] device6-e0.cpe.domain.net
[10.1R4.4] device7-e0.cpe.domain.net
[10.1S1.3] device8.cpe.domain.net
[10.4R3.4] device9-r0.cpe.domain.net

Thanks again, RudiC! I definitely like the awk approach instead of the one I initially posted. Maybe I can get the boss on board with doing it that way too.

Glad to hear!

You seem a bit undecided if the trailing / should appear in your device string or not after getting rid of the file name. The sub (...) is there for exactly that - remove the show.version part, so your cut should be unnecessary. Obviously, the sub doesn't do what it is expected to. I guess that due to the space that you introduced which was not present in my original proposal. Playing around a bit with the regex in sub might bring you to where you want to be. You could also substitute the exact string : sub ("show.version", "", FILENAME).

I'm somewhat surprised of the key that you use in sort...

I definitely don't need the /show.version to appear. It doesn't hurt anything, I just prefer not to see it.

I don't fully understand what's going on in {sub (/[^\/]* .$/, "", FILENAME), so I don't get how to modify it to do what I want.

I used sort -k5 because the boss needed the list sorted by the software version, so we can easily see which devices need upgraded. If there's a way to do that with sub as well, I'd love to learn how to make that happen.

Also, I've moved on to turning this script into a function called cpever. The problem I'm running into is that I need to be able to run it from anywhere, and I now need to cut out a bunch of stuff before the actual device name and the /show.version at the end.

Example:

Code:

cpever () {
	awk '/JUNOS/ && /boot/ {sub (/[^\/]* .$/, "", FILENAME); print $5 " " FILENAME}' 
~/svn/nw_config_data/*cpe.domain.net/show.version | sort -k5

Output:
[10.0R4.7] /home/clmbn-eng2/a/rwalker/svn/nw_config_data/device-r0.cpe.domain.net/show.version

I need to make /home/clmbn-eng2/a/rwalker/svn/nw_config_data/ and /show.version disappear so my output can go back to looking like this [10.0R4.7] device1-r0.cpe.domain.net

Using the default field separator, there's just two fields in your file, so why use -k5 for sorting?
As you don't show the directory structure, and seem to keep changing targets, I'd suggest to play around with the sub regexes until it fits what you need. Also, I still don't understand why you keep the space in the regex making it pointless.
For your function, why don't you cd into the correct directory at the beginning?