DX Unified Infrastructure Management

 View Only
Expand all | Collapse all

Delete QoS metrics via command line tool (version 1.9.3)

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

    Posted Feb 04, 2020 07:47 AM
    Edited by Luc Christiaens 4 days ago

    The tool: nimsoft_qos_delete version 2.0.4 will:

    - by default only list the selected QoS metrics
    - give you the possibility, based on several flexible sql & 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"

    Example_2: probe overview report 

    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
    Version 2.0.4:
    added option -qh (hub overview), -lh (sql select hub), -hi/-he (regex hub include/exclude)

    -  changes sql query to include by default also qos metrics with some fields not filled in
    -  reformatted/sorted the generated output/reporting file
    -  tested with uim 

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

    #uim #qos #delete #perl #report #commandline #list #metric 

    ​​​​​​​​



  • 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
    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


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

    Posted May 21, 2021 03:00 AM
    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.


  • 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
    Version 2.0.2:
    - contains a correction for the -dd option to make it more specific


  • 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]
    ------------------------------



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

    Posted 4 days ago

    Version 2.0.4:
    -  added option -qh (hub overview), -lh (sql select hub), -hi/-he (regex hub include/exclude)

    -  changes sql query to include by default also qos metrics with some fields not filled in
    -  reformatted/sorted the generated output/reporting file
    -  tested with uim 23.4

    MD5 hash of nimsoft_qos_delete_2.0.4.zip: 
    26fba47e0ee5163cd997db9180ca2b13
    CertUtil: -hashfile command completed successfully.