Station Report

[OCSY]

I would like to know if there is a report that I can generate and print out that will give me the following information? We have a CS1000e switch.

Name, DN, TN, IP and MAC address

Thank you

 

[bignose21]

Not really

Do a TNB use pepedog.com excel convert to get you the DN,TN,Name

Login CLI to you sig servers and do a isetShow on each of them copy into an excel sheet on same document. You will need to do a text to columns and use find and replace to alter the TN's to the same format as the TNB as TNB is "aaa b cc dd" and isetShow is "aaa-bb-cc-dd"

Start a new sheet copy accross the DN, TN, Name from the TNB sheet and then use VLOOKUP on the TN to find the matching TN on the isetShow sheet and give you back the IP and MAC in two seperate columns

The best way after you format the Set TN on the isetShow sheet is to cut and paste it into column A as Vlookup references the first coulmn in the selected area.

 

[GHTROUT]

The file at pepedog has not been updated for many years. firebirdscrambler has taken over the project and the latest version is always here:

[URL unfurl="true"]http://www.ghtrout.com/conversionutility/[/url]

~~
Gene at GHTROUT.com

 

[sullyin]

Were you able to use the Conversion utility at Pepe dog or GH Trout? I have tried both and get runtime error...

 

[jamie2]

Sullyin, what OS and excel version are you using?

 

[bignose21]

On my works laptop i need to enable the Marcos in the trust centre of Excel and also run the program as administrator (Im on windows 7), try those two options if they apply to your version of Excel/OS