Susana, I think a quick (and very dirty way) to accomplish this might in fact be CLI. I assume your Nagios is run on a Unix box of any type - so it might be the easiest way to allow a user on this machine to remotely run the CLI commands (connect, show, ...) on the SPECTRUM box (I've done this before). If your naming scheme for devices is the same in SPECTRUM an Nagios, do something like the following. Keep in mind that this might not work with Windows - I never ran SPECTRUM on Windows and have no idea if there is still a Nutcracker environment or anything or even if Windows nowadays supports Unix style rcommands ;-)
1. Add the Nagios machine's hostname or IP address along with the
executing user on it to spectrum's (or whatever your administrative
SPECTRUM account is) .rhosts file
2. Implement a script on the SPECTRUM machine that takes a device's
hostname as parameter #1, looks up the corresponding model handle in the
knowledge base and outputs its condition attribute's value
3. Execute rsh, followed by the usual rcommand stuff (hostname, username,
...), (if necessary a shell interpreter's binary and) the script's name as
well as the device name, on the Nagios machine
4. Interpret the output according to the condition attribute's enumeration
scheme
A spaghetti script that does part 2 in one line could for instance be
(ksh):
export CLISESSID=$$; export CLIMNAMEWIDTH=70; $SPECROOT/vnmsh/connect;
show attributes attr=0x1000a mh=`$SPECROOT/vnmsh/show models|grep "$1
"|awk '{print $1}'`|tail -1|awk '{print $3}'; $SPECROOT/vnmsh/disconnect
The script is not tested and might or might not work this way. The generel
idea, however, should be clear. Of course, any CORBA or API driven
interface is loads better and more reliable. Also notice that there is no
fault handling at all in my oneliner above.
Freundliche Grüße / Best regards
Christian Fieres
Mainova AG
Planung und Betrieb Infrastruktur (M3-ON2)
Service Operation Center
Solmsstraße 38
60623 Frankfurt
Telefon / Phone (069) 2 13-2 36 17
Mobil / Mobile (0170) 5 60 15 63
Telefax / Facsimile (069) 2 13-9 62 36 17
E-Mail [email protected]
Mainova Aktiengesellschaft • Solmsstraße 38 • D-60623 Frankfurt am Main
Vorsitzende des Aufsichtsrates: Oberbürgermeisterin Dr. h. c. Petra Roth •
Vorstand: Dr. Constantin H. Alsheimer (Vorsitzender), Lothar Herbst, Dr.
Marie-Luise Wolff, Joachim Zientek
Sitz der Aktiengesellschaft: Frankfurt am Main • Amtsgericht Frankfurt HRB
7173 • USt-ID-Nr. DE 114184034
Müssen Sie diese E-Mail wirklich ausdrucken? - fragt der Mainova
Energiecoach.
Mehr Tipps und Antworten zum Thema Energieeffizienz unter
http://www.mainova-energiecoach.de
Jiménez Gallego, Susana <[email protected]>
22.12.2009 12:11
Bitte antworten an
Jiménez Gallego, Susana <[email protected]>
An
"spectrum" <[email protected]>
Kopie
spectrum <[email protected]>
Thema
RE: [spectrum] NAGIOS make queries to SPECTRUM database?
Hello,
Really, the attribute witch I look for is the "condition" (0x1000a), when
they have problems with any server, query if the "condition" of a device
is suppressed or critical to Spectrum. The problem is how to do
it…..because they will not connect with OneClick. Perhaps with the CLI
Spectrum command I get it ….
Thanks!!!
Susana
De: haihong ren [mailto:[email protected]]
Enviado el: martes, 22 de diciembre de 2009 10:14
Para: spectrum
CC: spectrum
Asunto: Re: [spectrum] NAGIOS make queries to SPECTRUM database?
Susana
You might be interested in the FlashGreen attribute of the model and the
following KB should help too.
Solution ID: TS26660
How can SPECTRUM OneClick be used to show which models alarmed after an
alarm has cleared?
SPECTRUM has an attribute called FlashGreen (attribute id of 0x00011a58)
that is used to inform users of alarms that have occurred but have since
been automatically cleared. This attribute needs to be set to TRUE (or
Yes) in the Attribute Editor on all models that you would like to be
notified about. Once this is enabled, you will need to create a Global
Collection that has the following parameters:
Acknowledged = False
Condition = Normal(0)
FlashGreen = Yes
This will produce a result set that will show all models that have the
FlashGreen attribute enabled that have alarmed and the alarms have already
cleared.
Please keep in mind the following:
1. The default update interval for Global Collections is 24 hours. You
will need to increase this interval if you want the collection to update
more frequently.
2. The only way to clear the Flash Green setting is to Acknowledge it the
same way you would Acknowledge an alarm. The Acknowledge functionality is
only available in the Alarms tab.
Cheers
Haihong
On Tue, Dec 22, 2009 at 5:32 PM, Jiménez Gallego, Susana <
[email protected]> wrote:
Hello, Robert and list,
Nagios is a tool used by another department, when they have issues in some
service they need to know if the network devices are the source of these
problems. And….yes, the easiest is that they connect to OneClick to know
the status of the network, but they do not want to do it that way, they
want only when needed, with a script, a query, command, or whatever, ask
about the status of a device to Spectrum.
Regards!
Susana
PD: merry christmas
De: [email protected] [mailto:[email protected]]
Enviado el: lunes, 21 de diciembre de 2009 14:53
Para: Jiménez Gallego, Susana
Asunto: SV: [spectrum] NAGIOS make queries to SPECTRUM database?
DDM DB does only contain statistics and events. Object statuses are
located in the SSdb which is a "Berkley SleepyCat DB".
Why would you integrate Nagios into Spectrum?
/Roberth
Roberth Edberg
Global Network & Availaility Mgmnt - Senior Architect
SEB / Group IT
Web:
http://www.seb.se
Systems Management
E-mail:
[email protected]
Rissneleden 110
Voice:
+46 8 639 30 42
SE-106 40 Stockholm
Mobile:
+46 70 509 30 42
Fax:
+46 8 706 60 25
- "Did you know that the first Matrix was designed to be a perfect human
world, where none suffered; where everyone would be happy. It was a
disaster. No one would accept the program. Entire crops were lost. Some
believed that we lacked the programming language to describe your perfect
world, but I believe that as a species, human beings define their reality
through misery and suffering. So the perfect world we dreamed, but your
primitive cerebrum kept trying to wake up from. Which is why The Matrix
was redesigned to this...the peak of your civilization."
/ Agent Smith {The Matrix}
Från: Jiménez Gallego, Susana [mailto:[email protected]]
Skickat: den 21 december 2009 14:33
Till: spectrum
Ämne: RE: [spectrum] NAGIOS make queries to SPECTRUM database?
In the future we hope to create a CMDB with a SPECTRUM CMDB information
witch use all the Management tools, at the moment we only need the Nagios
when needed it, make a query in the SPECTRUM DDM of the state of a
particular device (UP, DOWN, SUPPRESS).
Thank for your help!!!!
Susana
De: nikhil mehra [mailto:[email protected]]
Enviado el: lunes, 21 de diciembre de 2009 14:05
Para: spectrum
CC: spectrum
Asunto: Re: [spectrum] NAGIOS make queries to SPECTRUM database?
Not sure if there is a connector or not available for out of box
integration but one possible solution is to use SDK Corba API for spectrum
to write your own piece of code to do following after a defined interval
of time:
1. Connect to database
2. Export the configuration info from database to a standard output file
3. Import in Nagios.
On Mon, Dec 21, 2009 at 7:24 AM, Jiménez Gallego, Susana <
[email protected]> wrote:
Is it possible that a second management tool, like NAGIOS, make queries
about the status of the devices in the SPECTRUM database?
Este correo electrónico y cualquiera de sus ficheros anexos son
CONFIDENCIALES. Si usted no es el destinatario (o responsable de remitirlo
a la persona indicada), agradeceríamos lo notificase / reenviase
inmediatamente al emisor. No revele estos contenidos a ninguna otra
persona, no los utilice para otra finalidad, ni almacene y/o copie esta
información en medio alguno. Los correos electrónicos son susceptibles de
ser alterados por terceras personas y por tanto, Metro de Madrid, S.A.
declina toda responsabilidad si el mensaje ha sido alterado o falsificado,
así como opiniones o conclusiones que deban ser entendidas como exclusivas
del emisor y no como expresión de una decisión Corporativa.
This electronic mail and any of its annexed files are CONFIDENTIAL. If you
are not the addressee (or responsible for sending it to the indicated
person), we would be thankful if you notified or sent it immediately to
the sender. Do not reveal these contents to any other person, do not use
them for another purpose, do not store or copy this information. The
electronic mails are susceptible to alteration by third parties and
therefore, Metro de Madrid, S.A. declines all responsibility if the
message has been altered or falsified, as well as opinions or conclusions
that may be understood are the exclusive rights of the sender and not the
result of a Corporative decision.
--To unsubscribe from spectrum, send email to [email protected] with the
body: unsubscribe spectrum [email protected]
--
Nikhil Mehra
"The only Constant in Life is CHANGE!"
"Whether it is mainframe, client-server, distributed, grid or web services
computing — none of it works without the network."
--To unsubscribe from spectrum, send email to [email protected] with the
body: unsubscribe spectrum [email protected]
Este correo electrónico y cualquiera de sus ficheros anexos son
CONFIDENCIALES. Si usted no es el destinatario (o responsable de remitirlo
a la persona indicada), agradeceríamos lo notificase / reenviase
inmediatamente al emisor. No revele estos contenidos a ninguna otra
persona, no los utilice para otra finalidad, ni almacene y/o copie esta
información en medio alguno. Los correos electrónicos son susceptibles de
ser alterados por terceras personas y por tanto, Metro de Madrid, S.A.
declina toda responsabilidad si el mensaje ha sido alterado o falsificado,
así como opiniones o conclusiones que deban ser entendidas como exclusivas
del emisor y no como expresión de una decisión Corporativa.
This electronic mail and any of its annexed files are CONFIDENTIAL. If you
are not the addressee (or responsible for sending it to the indicated
person), we would be thankful if you notified or sent it immediately to
the sender. Do not reveal these contents to any other person, do not use
them for another purpose, do not store or copy this information. The
electronic mails are susceptible to alteration by third parties and
therefore, Metro de Madrid, S.A. declines all responsibility if the
message has been altered or falsified, as well as opinions or conclusions
that may be understood are the exclusive rights of the sender and not the
result of a Corporative decision.
--To unsubscribe from spectrum, send email to [email protected] with the
body: unsubscribe spectrum [email protected]
Este correo electrónico y cualquiera de sus ficheros anexos son
CONFIDENCIALES. Si usted no es el destinatario (o responsable de remitirlo
a la persona indicada), agradeceríamos lo notificase / reenviase
inmediatamente al emisor. No revele estos contenidos a ninguna otra
persona, no los utilice para otra finalidad, ni almacene y/o copie esta
información en medio alguno. Los correos electrónicos son susceptibles de
ser alterados por terceras personas y por tanto, Metro de Madrid, S.A.
declina toda responsabilidad si el mensaje ha sido alterado o falsificado,
así como opiniones o conclusiones que deban ser entendidas como exclusivas
del emisor y no como expresión de una decisión Corporativa.
This electronic mail and any of its annexed files are CONFIDENTIAL. If you
are not the addressee (or responsible for sending it to the indicated
person), we would be thankful if you notified or sent it immediately to
the sender. Do not reveal these contents to any other person, do not use
them for another purpose, do not store or copy this information. The
electronic mails are susceptible to alteration by third parties and
therefore, Metro de Madrid, S.A. declines all responsibility if the
message has been altered or falsified, as well as opinions or conclusions
that may be understood are the exclusive rights of the sender and not the
result of a Corporative decision.
--To unsubscribe from spectrum, send email to [email protected] with the
body: unsubscribe spectrum [email protected]
--To unsubscribe from spectrum, send email to [email protected] with the
body: unsubscribe spectrum [email protected]
Este correo electrónico y cualquiera de sus ficheros anexos son
CONFIDENCIALES. Si usted no es el destinatario (o responsable de remitirlo
a la persona indicada), agradeceríamos lo notificase / reenviase
inmediatamente al emisor. No revele estos contenidos a ninguna otra
persona, no los utilice para otra finalidad, ni almacene y/o copie esta
información en medio alguno. Los correos electrónicos son susceptibles de
ser alterados por terceras personas y por tanto, Metro de Madrid, S.A.
declina toda responsabilidad si el mensaje ha sido alterado o falsificado,
así como opiniones o conclusiones que deban ser entendidas como exclusivas
del emisor y no como expresión de una decisión Corporativa.
This electronic mail and any of its annexed files are CONFIDENTIAL. If you
are not the addressee (or responsible for sending it to the indicated
person), we would be thankful if you notified or sent it immediately to
the sender. Do not reveal these contents to any other person, do not use
them for another purpose, do not store or copy this information. The
electronic mails are susceptible to alteration by third parties and
therefore, Metro de Madrid, S.A. declines all responsibility if the
message has been altered or falsified, as well as opinions or conclusions
that may be understood are the exclusive rights of the sender and not the
result of a Corporative decision.
--To unsubscribe from spectrum, send email to [email protected] with the
body: unsubscribe spectrum [email protected]
---
To unsubscribe from spectrum, send email to [email protected] with the body:
unsubscribe spectrum [email protected]
<<image/gif>>
