Anju
Feb 05, 2021Altostratus
Network map to excel
Hi Folks, How can we get network map info - VIPs, Pool, nodes etc. in a spreadsheet? I need to make a spreadsheet for complete configuration of the device, any quicker way to do it?
Hi Anju,
I think you missed part of the instructions. First you run
tmsh create cli script virtual-details
in order to create the script. Then you paste from line 52 to the end of the code snippet.
Next you run
tmsh list cli script virtual-details
to verify the script was created successfully.
And then you run.
tmsh run cli script virtual-details > /var/tmp/virtual-details.csv
This will write the results to the CSV.
As for your question regarding K44010967... as far as my memory reaches back, 'grep' and 'awk' are always available. I cannot recall a BIG-IP version that would not have 'awk' in bash. Also you cannot replace them with the another. The 'grep' command searches for lines matching a regex pattern while 'awk' is for string, arithmetic, and time manipulation.
Hi Daniel,
Tried the script as suggested, its giving the error - command not found. The below was found when tried on common partition -
01020036:3: The requested shell script (/Common/virtual-details) was not found.
when tried in bash, found the below error-
bash: cli: command not found
virtual-details: script failed to complete:
script "virtual-details" does not contain a "script::run" procedure
script did not successfully complete, status:1
Need to know what am i doing wrong here?
Apologies, maybe I was not 100% clear. With this snippet you create the script.
tmsh create cli script virtual-details
Next switch to tmsh and run:
root@(awaf)(cfg-sync Standalone)(Active)(/Common)(tmos)# edit cli script virtual-details
Here is a screenshot:
Now a vi-style editor will open you must paste from line 52 to line 88 the end of the code snippet. Verify that copy&paste worked. In my test, the proc from line 52 was not pasted, I had to type it manually.
Also exit this editor in vi-style with :wq. You will additionally be prompted whether you want to save the script.
Now run this command to verify your changes were saved.
tmsh list cli script virtual-details
If everything looks good, run the script. Here is a screenshot from a successful run:
One more thing... this is how the script editor looks in my environment after I pasted the script. I tested on 15.1.2.