DX Unified Infrastructure Management

 View Only
  • 1.  UIM Alarm Reporter v1.9

    Posted Jun 21, 2022 09:22 AM
    Edited by Ashish Aggarwal Jul 07, 2022 12:58 AM
      |   view attached

    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 -sr, -su and -sp options)

    - execute: perl nimsoft_alarm_reporter.pl -sr"sql_servername" -su"sa" -sp"sql_psw" -bh"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
    Version 1.9.2:
    - add overview report based on source & probe # of alarms
    Version 1.9.4:
    - tested with UIM 20.4 and Perl 5.32
    - nimsoft_generic.pm and nimsoft_generic.dat can be in same directory as perl source (or in perl/lib)
    - add sql WHERE clause parameters: -lg (origin), -lh (hostname), -lo (probe), -lm (message), -lt (robot) and -lu (hub)
    - add selected sql and regex filters in report header and in Field Explanation
    - changed the column source with hostname in report (source is sometimes ip address and hostname is translated name)
    - -fq can strip fqdn domain name for the hostname column y: strip n: keep original, default: y
    - added origin in default -co report columns
    - for a first run without nimsoft_generic.dat, you can use -sr (sql server), -su (sql user) and -sp (sql password)

    #tool #alarm #report #uim #perl #commandline

    Removing attachment flagged as dangerous. @jason mcclellan



    nimsoft_alarm_reporter_1.9.zip   28.02 MB 1 version

  • 2.  RE: UIM Alarm Reporter v1.9

    Broadcom Employee
    Posted Nov 04, 2019 10:14 AM
    thanks for sharing

    Gene Howard
    Principal Support Engineer

  • 3.  RE: UIM Alarm Reporter v1.9

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


  • 4.  RE: UIM Alarm Reporter v1.9

    Posted May 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 May 06, 2020 03:53 AM
      |   view attached
    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 May 11, 2020 07:50 AM
    Very good, tks Luc!

    Technical Support Engineer