Delete QoS metrics via command line tool (version 1.9.3)

[Luc Christiaens]

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 whith  some blank/empty fields
-  reformatted/sorted the generated output/reporting file
-  tested with uim 23.4.2

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

​​​​​​​​

[Gene Howard]

thanks for sharing

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

[Luc Christiaens]

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

[Luc Christiaens]

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.

[Luc Christiaens]

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

[Luc Christiaens]

Version 2.0.2:
- contains a correction for the -dd option to make it more specific

Attachment(s)

nimsoft_qos_delete_2.0.2.zip   29.12 MB 1 version

[erichuang82412668]

thank you for the sharing

[Steve B]

Amazing as always @Luc Christiaens! Thank you :)​

[Ashish Aggarwal]

Thanks @Luc Christiaens for helping the community.

Cheers,
Ashish​

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

[Luc Christiaens]

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.

Attachment(s)

nimsoft_qos_delete_2.0.4.zip   24.72 MB 1 version