DX Infrastructure Manager

Expand all | Collapse all

UIM Alarm Reporter v1.9

Jump to Best Answer
  • 1.  UIM Alarm Reporter v1.9

    Posted 11-04-2019 04:04 AM

    In attachment a Perl tool that can report on the:

    - nas_transaction_log (detailed log)

    - nas_transaction_summary (1 line per alarm)

    tables and produce reports in html or csv format.

     

    - Sample detail report (html format)

     

    - sample overview report:

     

     

    - sample open alarm report:

     

     

    A doc file is in the attached zip file.

     

    Quick start (without customizing nimsoft_generic.dat):

    - if Perl is installed copy nimsoft_alarm_reporter.pl, nimsoft_generic.pm and nimsoft_generic.dat to a local directory

    - if perl is not installed copy nimsoft_alarm_reporter.exe and nimsoft_generic.dat/pm to a local directory

    (you are not required to customize the nimsoft_generic.dat file, but than you need to use the -r, -u and -p options)

    - execute: perl nimsoft_alarm_reporter.pl -r"sql_servername" -u"sa" -p"sql_psw" -b"1"

     

    Quick start (with customizing nimsoft_generic.dat)

    - copy the files in a directory

    - edit the file: nimsoft_generic.dat and change all settings/variables

    - the passwords in this file must be encrypted by: nimsoft_crypt.exe your_password

      (the output will be the encrypted password that you copy in nimsoft_generic.dat)

    - execute:  nimsoft_alarm_reporter -b"1"

      (this will generate a report of all detail alarms of the last hour in c:\temp)

     

    Any comment or idea is very welcome.

     

    Version 1.3:

    - filter on level

    - filter on acknowledged_by

    - filter on assigned_by and assigned_to

    - use sql trusted connection to connect to mssql

    Version 1.4:

    - can also report on nas_transaction_summary table, this table creates only 1 record for an alarm, even if it's generated every 5 minutes.

    Version 1.5:

    - can run on Windows with MSSQL or Mysql

    - can run on Linux with Mysql/Mariadb

    - can run on a standalone (no perl or sql client) Linux and Windows with the compiled version

    - documented how to create your own Perl environment to run this tool

    Version 1.9:
    - add use_https in nimsoft_generic.dat/pm
    - add sql_driver  in nimsoft_generic.dat/pm (TLS 1.2)
    - -mm: report on a month (o: current month, 1: previous month)
    - -bm: report on the xx last minutes
    - -bh or -b for the last xx hours
    - tested with UIM 9.20



  • 2.  RE: UIM Alarm Reporter v1.9

    Broadcom Employee
    Posted 11-04-2019 10:14 AM
    thanks for sharing

    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------



  • 3.  RE: UIM Alarm Reporter v1.9

    Broadcom Employee
    Posted 11-04-2019 11:09 AM
    Thanks Luc!

    ------------------------------
    [Designation]
    [City]
    ------------------------------



  • 4.  RE: UIM Alarm Reporter v1.9

    Posted 05-05-2020 12:02 PM
    Hello Luc, Its possible with this to do a summay alerts by sourse or alert type of the last x time? i understand that gives a report of coun alerts by sours OR by probe but not both in 1 list

    I wil read the doc to understan better how it works but its a great add taking in count that UIM dont have anything like this


  • 5.  RE: UIM Alarm Reporter v1.9
    Best Answer

    Posted 05-06-2020 03:53 AM
    Hi Ignacio,
    In attachment a test version with an extra overview report based on the source and probe.
    You can mail me directly if you have some questions, problems or ideas for this tool (luc.christiaens10@telenet.be)


  • 6.  RE: UIM Alarm Reporter v1.9

    Broadcom Employee
    Posted 05-11-2020 07:50 AM
    Very good, tks Luc!

    ------------------------------
    Technical Support Engineer
    Broadcom
    ------------------------------