asmState pseudo-metric: value is incorrect

[amolari]

Environment

• Telemetry Streaming Version: 1.21
• BIG-IP Version: 14.1.4

Summary

Running the command that produces the output for pseudo-metric "asmState" directly on my system, the output doesn't produce the expected result. Therefor, that pseudo-metric result is not valid.
Please either fix the command:

f5-telemetry-streaming/src/lib/paths.json

Lines 178 to 186 in 4db2b55

	{
	"name": "asmQuery",
	"path": "/mgmt/tm/util/bash",
	"ignoreCached": true,
	"body": {
	"command": "run",
	"utilCmdArgs": "-c \"/bin/mysql -uroot -p$(/bin/perl -MPassCrypt -nle 'print PassCrypt::decrypt_password($_)' /var/db/mysqlpw) PLC -B -e 'select CASE WHEN max(event_time) IS NOT NULL THEN \\\"Pending Policy Changes\\\" ELSE \\\"Policies Consistent\\\" END as asm_state, max(event_time) as last_asm_change from PL_CONFIG_LOG where event_type <> 2 and element_type <> 18 and event_time > (select max(from_date) as asm_last_changed from PL_POLICY_HISTORY)' | sed 's/\\t/,/'\""
	}
	},

or remove that pseudo-metric asmState.

Steps To Reproduce

asmState metric is the output of command
/bin/mysql -uroot -p$(/bin/perl -MPassCrypt -nle 'print PassCrypt::decrypt_password($_)' /var/db/mysqlpw) PLC -B -e 'select CASE WHEN max(event_time) IS NOT NULL THEN "Pending Policy Changes" ELSE "Policies Consistent" END as asm_state, max(event_time) as last_asm_change from PL_CONFIG_LOG where event_type <> 2 and element_type <> 18 and event_time > (select max(from_date) as asm_last_changed from PL_POLICY_HISTORY)' | sed 's/\\t/,/'

My test system has 2 policies which are in PENDING APPLY.

Expected Behavior

Output of command (which is the value of pseudo-metric) should be Pending Policy Changes

Actual Behavior

Output of command (which is the value of pseudo-metric) is:

asm_state       last_asm_change
Policies Consistent     NULL

[dstokesf5]

Thank you for reporting this issue. I have added it to our internal product backlog as AUTOTOOL-2641.

[dstokesf5]

This was resolved with the 1.23.0 release of Telemetry Streaming.