DX NetOps

Dear We are running Spectrum 10.2.1 in solaris .. core and OC in sperate servers.

Would like to know options available to export the below in to .csv format ( not manual export) as scheduled every one hour and mailing the same tru SANM.

REgards

Thiru

Hi Thiru,

Assuming ISP_LINK_REPORTS is a Global collection, you can use different options here.

1. If you have report manager and CABI installed, use CABI to generate the asset report by group and also can schedule the report.

2. Use the command line options in a script to run the query against the mentioned Global Collection

Commands Example:

Navigate to $SPECROOT/vnmsh/

run the below commands

export CLINAMEWIDTH=120

./connect

./seek -s attr=0x12adb,val=ISP_LINK_REPORTS

Here, the 0x12adb refers Global Collection Name attribute and val contains the value of the attribute (in your case, ISP_LINK_REPORTS)

To further modify the output in the desired format use awk/sed with required options.

Example:  ./seek -s attr=0x12adb,val=ISP_LINK_REPORTS | awk `{print $1 "," $2 "," $3 "," $4;}' > ISP_LINK_REPORTS.csv

You can schedule the script using cron job to get the report at desired timings.

Hope this helps.

Cheers,

Rajashekar

Nice Tips. Thanks!

i will move this thread to the CA Spectrum community, please follow!