We are working on feeding a different CMDB from Spectrum for
infrastructure relationships, and CiscoWorks Campus for edge host to
access-layer connectivity. For the Spectrum portion, this is our
first-pass script, which will create input files to push up to a
drop-box for the CMDB. The XML files from the modelling gateway give
the service assets and their SpecHex unique IDs, and the text-file
from the vnmsh CLI give the relationships which map pretty closely to
the relationships understood by most CMDBs.
#!/bin/bash
cd /opt/spectrum/vnmsh ;
export TIMESTAMP="$(date +%Y%m%d%H%M)" ;
export OUTFILE="/tmp/stuff.txt.${TIMESTAMP}" ;
>${OUTFILE} ;
./connect 2>/dev/null ;
for i in $(./show devices |awk ' $1 !~ /MHandle/ {print $1}') ; do
./show associations mh=${i} |\
awk '$3 ~ /dynamicGlobalCollects/ || $3 ~ /Connects_to/ || $3 ~
/Is_Adjacent_to/ {print}' >>${OUTFILE} ;
done
./disconnect 2>/dev/null ;
for A in $(printf "1 2 3 4") ; do
/opt/spectrum/SS-Tools/modelinggateway -vnm vnm${A}.example.com -cmdb
-e /tmp/vnm${A}.${TIMESTAMP}.XML ;
done
zip -9 /tmp/CMDB-input.ZIP ${OUTFILE} /tmp/vnm[1-4] ;
printf "\nPlease check /tmp/CMDB-input.ZIP for service-assets
relationships.\n\n\n" ;
/usr/bin/scp -i "/opt/spectrum/.ssh/id_rsa" "/tmp/CMDB-input.ZIP"
"[email protected]:" ;
On Fri, Feb 25, 2011 at 4:37 PM, <[email protected]> wrote:
> Hi everybody
>
> Have you done this before? Export Spectrum 9.1 database to CA CMDB 12.1
> ????
>
> Please help.
>
> --
> Ing. Oscar Longinos González
> T Monitor S.A. de C.V.
> Mobile +52 155 25584149
> [email protected]
>
>
>
> ---
> To unsubscribe from spectrum, send email to [email protected] with the body:
> unsubscribe spectrum [email protected]
>
--
david t. klein
Cisco Certified Network Associate (CSCO11281885)
Linux Professional Institute Certification (LPI000165615)
Redhat Certified Engineer (805009745938860)
Quis custodiet ipsos custodes?
---
To unsubscribe from spectrum, send email to [email protected] with the body:
unsubscribe spectrum [email protected]
