For those interested in the CiscoWorks bit, it really is just a direct connection to the AniDB, which gives all end-hosts and what switch and port they connect to. Documentation and SQLAnywhere drivers are available online from Cisco.
On Sat, Feb 26, 2011 at 1:25 AM, david klein <[email protected]> wrote: > 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? > -- 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]
