DX Unified Infrastructure Management

 View Only
  • 1.  Delete QoS metrics via command line tool (version 1.9.3)

    Posted Feb 04, 2020 07:47 AM
    Edited by Luc Christiaens Jan 09, 2023 04:24 AM
      |   view attached
    The tool: nimsoft_qos_delete version 2.0.2 will:
    - give you the possibility, based on several flexible regex filters to delete obsolete/unneeded QoS metrics.
    - delete qos entries that are obsolete (-dm)
    - delete duplicate qos entries (-dd)
    - run by default in simulation mode
    - generate several qos overview reports
    - create detailed logging file
    - included in zip: perl source, compiled version and doc file

    Example_1: delete all qos metrics containing "cpu_usage" for robot "bgbulab00"

    nimsoft_qos_delete_example1
    Example_2: probe overview report 

    nimsoft_qos_delete_example2

    Zip file contains:
    - perl source
    - compiled exe version 
    - doc file

    Note: this tool was written for maximum flexibility via a combination of sql and rexeg filters.

    Version 1.9.7:
    - 4 new parameters that will be used in the SQL WHERE clause to improve the performance:
        -ls: like source 
        -lo: like origin 
        -lq: like qos 
        -lp: like probe 
    - -qm"y" will list all qos metrics without an update last 10 days

    Version 1.9.8:
    - -cs"y" will make your filters case sensitive (by default they are case insensitive)

    Version 2.0.1:
    - add -ni/ne: nim_origin include/exclude (= original origin)
    - add -dd: delete duplicate qos (see doc chapter 1.3.2)
    - add -pd: this will indicate what info you will receive in execution output screen and in the logging file 
    - using -db"y" will write used sql query into logging file
    - nimsoft_generic.pm can be in same directory as this tool or copied into perl/lib

    Version 2.0.2:
    - contains a correction to the -dd (delete duplicate) option to make it more specific

    => last version see attachments in an update at the end (found no possibility to update the attachment)

    #uim #qos #delete #perl #report #commandline
    ​​​​​​​​

    Attachment(s)

    zip
    nimsoft_qos_delete_1.9.3.zip   16.59 MB 1 version


  • 2.  RE: Delete QoS metrics via command line tool (version 1.9.3)
    Best Answer

    Broadcom Employee
    Posted Feb 04, 2020 09:34 AM
    thanks for sharing

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



  • 3.  RE: Delete QoS metrics via command line tool (version 1.9.3)

    Posted Mar 03, 2020 07:01 AM
      |   view attached
    Attachment for version 1.9.7:
    - 4 new parameters that will be used in the SQL WHERE clause to improve the SQL Select performance:
        -ls: like source
        -lo: like origin
        -lq: like qos
        -lp: like probe
    - -qm"y" will list all qos metrics without an update last 10 days

    Attachment(s)

    zip
    nimsoft_qos_delete_1.9.7.zip   16.60 MB 1 version


  • 4.  RE: Delete QoS metrics via command line tool (version 1.9.3)

    Posted May 21, 2021 03:00 AM
      |   view attached
    Attachment for version 1.9.8
    In case you need case sensitive filters you can use the extra parameter -cs"y".
    By default all filters are case insensitive.

    Attachment(s)

    zip
    nimsoft_qos_delete_1.9.8.zip   29.01 MB 1 version


  • 5.  RE: Delete QoS metrics via command line tool (version 1.9.3)

    Posted Jun 08, 2022 08:20 AM
    Version 2.0.1:
    - add -ni/ne: nim_origin include/exclude (= original origin)
    - add -dd: delete duplicate qos (see doc chapter 1.3.2)
    - add -pd: this will indicate what info you will receive in execution output screen and in the logging file
    - using -db"y" will write used sql query into logging file
    - nimsoft_generic.pm can be in same directory as this tool or copied into perl/lib


  • 6.  RE: Delete QoS metrics via command line tool (version 1.9.3)

    Posted Jun 20, 2022 05:19 AM
      |   view attached
    Version 2.0.2:
    - contains a correction for the -dd option to make it more specific

    Attachment(s)

    zip
    nimsoft_qos_delete_2.0.2.zip   29.12 MB 1 version


  • 7.  RE: Delete QoS metrics via command line tool (version 1.9.3)

    Posted Aug 28, 2020 10:42 AM
    thank you for the sharing


  • 8.  RE: Delete QoS metrics via command line tool (version 1.9.3)

    Posted Nov 29, 2022 05:38 AM
    Amazing as always @Luc Christiaens! Thank you :)​


  • 9.  RE: Delete QoS metrics via command line tool (version 1.9.3)

    Broadcom Employee
    Posted Nov 30, 2022 12:39 AM
    Thanks @Luc Christiaens for helping the community.

    Cheers,
    Ashish​

    ------------------------------
    [JobTitle]
    [CompanyName]
    ------------------------------