Cisco Works Custom Report

[Russell Bovaird]

Is there a way that I can create a report in Cisco Works RME that allows me to run an adhoc command.

ie: I want to report on the following for all my selected devices:

     show inventory | include SX|LX|LH

The output on an individual switch gives me:

Switch# show inventory | include SX|LX|LH

NAME: "GigabitEthernet1/1", DESCR: "1000BaseSX"

NAME: "GigabitEthernet1/2", DESCR: "1000BaseSX"

NAME: "GigabitEthernet3/1", DESCR: "1000BaseSX"

NAME: "GigabitEthernet3/2", DESCR: "1000BaseSX"

NAME: "GigabitEthernet3/3", DESCR: "1000BaseSX"

NAME: "GigabitEthernet3/4", DESCR: "1000BaseSX"

NAME: "GigabitEthernet3/5", DESCR: "1000BaseSX"

NAME: "GigabitEthernet3/6", DESCR: "1000BaseSX"

NAME: "GigabitEthernet4/1", DESCR: "1000BaseSX"

NAME: "GigabitEthernet4/2", DESCR: "1000BaseSX"

NAME: "GigabitEthernet4/3", DESCR: "1000BaseSX"

NAME: "GigabitEthernet4/4", DESCR: "1000BaseSX"

NAME: "GigabitEthernet4/5", DESCR: "1000BaseSX"

NAME: "GigabitEthernet4/6", DESCR: "1000BaseSX"

NAME: "GigabitEthernet5/1", DESCR: "1000BaseLH"

NAME: "GigabitEthernet5/2", DESCR: "1000BaseSX"

I have gone through all the custom template inventory groups and attributes, but non of them have the DESCR information.

The Interface:Name rule gives me the GigabitEthernet#/# information. 

Is that the right "thing" that I want for this report?

Does anyone know how to do this?  Or at least give me a clue where to investigate further

Any help gratefully received.

Currently running the following:

NameVersion

CiscoWorks Common  Services3.3.0

Campus Manager5.2.1

CiscoView6.1.9

CiscoWorks  Assistant1.2.0

Device Fault  Manager3.2.0

Internetwork Performance  Monitor 4.2.0

Integration  Utility1.9.0

LMS Portal1.2.0

Resource Manager  Essentials4.3.1




Thanks

Kind regards

Russ

[yjdabear]

You can execute that as an adhoc commmand in a "NetShow" job, either "scheduled" if you want to query more than 10 devices, or run it immediately if there's fewer than 10 devices.

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_resource_manager_essentials/4.3/user/guide/netshow.html

[Russell Bovaird]

Thanks for the info yjdabear.  I'd like to have the output in a report rather than having to click on each individual device to see the results - we have hundreds of devices that we are wanting this information from.

Is there any way get the information into a report?

eg:

Switch 1

NAME: "GigabitEthernet1/1", DESCR: "1000BaseSX"

NAME: "GigabitEthernet1/2", DESCR: "1000BaseSX"

NAME: "GigabitEthernet3/1", DESCR: "1000BaseSX"

NAME: "GigabitEthernet3/2", DESCR: "1000BaseSX"

NAME: "GigabitEthernet3/3", DESCR: "1000BaseSX"

NAME: "GigabitEthernet3/4", DESCR: "1000BaseSX"

NAME: "GigabitEthernet3/5", DESCR: "1000BaseSX"

NAME: "GigabitEthernet3/6", DESCR: "1000BaseSX"

NAME: "GigabitEthernet4/1", DESCR: "1000BaseSX"

NAME: "GigabitEthernet4/2", DESCR: "1000BaseSX"

NAME: "GigabitEthernet4/3", DESCR: "1000BaseSX"

NAME: "GigabitEthernet4/4", DESCR: "1000BaseSX"

NAME: "GigabitEthernet4/5", DESCR: "1000BaseSX"

NAME: "GigabitEthernet4/6", DESCR: "1000BaseSX"

NAME: "GigabitEthernet5/1", DESCR: "1000BaseLH"

Switch 2

NAME: "GigabitEthernet1/1", DESCR: "1000BaseSX"

NAME: "GigabitEthernet1/2", DESCR: "1000BaseSX"

NAME: "GigabitEthernet2/1", DESCR: "1000BaseSX"

NAME: "GigabitEthernet2/2", DESCR: "1000BaseSX"

NAME: "GigabitEthernet2/3", DESCR: "1000BaseSX"

NAME: "GigabitEthernet2/4", DESCR: "1000BaseSX"

NAME: "GigabitEthernet2/5", DESCR: "1000BaseLX"

NAME: "GigabitEthernet2/6", DESCR: "1000BaseLX"

NAME: "GigabitEthernet3/1", DESCR: "1000BaseLH"

Thanks

Kind regards

Russ

[yjdabear]

I thought it's possible to grab the aggregate output of all the devices in the GUI, but maybe not.

Alternatively, perhaps the CLI equivalent could display all the results. Specifically:

     cwcli netshow jobresults -u Username -p Password -id "Job ID 1" , "Job ID 2" , "Job ID 3"

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_resource_manager_essentials/4.3/user/guide/cwcli.html#wpxref43283