https://community.checkpoint.com/t5/Scripts/ONELINER-cpview-2-prometheus/m-p/270025#M1457 <P>Hi CheckMates,<BR /><BR /></P> <P>This one-liner script converts the output of<SPAN>&nbsp;</SPAN><CODE>cpview -m</CODE><SPAN>&nbsp;</SPAN>(monitoring metrics) into standardized Prometheus format.</P> <P><STRONG>Use Case:</STRONG><SPAN>&nbsp;</SPAN>When integrating Skyline with SIEM systems like Prometheus, troubleshooting may require comparing the data that Skyline receives from cpview with what's actually queryable in Prometheus using PromQL. This script transforms the cpview JSON output into Prometheus metrics with labels and values.</P> <P><STRONG>How it works:</STRONG></P> <UL> <LI>Reads cpview monitoring data in JSON format</LI> <LI>Converts metric IDs to Prometheus-compatible names (dots to underscores)</LI> <LI>Extracts labels and formats them as<SPAN>&nbsp;</SPAN><CODE>metric_name{label1="value1",label2="value2"} value</CODE></LI> <LI>Filters out empty datasets</LI> </UL> <P><STRONG>Usage:</STRONG></P> <DIV class="code" data-code="id#24"> <DIV class="interactive-result-code-block no-vulns" data-keybinding-context="43"> <DIV class="interactive-result-editor" data-keybinding-context="44" data-mode-id="shellscript"> <DIV class="monaco-editor no-user-select showUnused showDeprecated vs-dark" role="code" data-uri="vscode-chat-code-block://dnnjb2rllwnoyxqtc2vzc2lvbjovl2xvy2fsl09uttnaakzpwwpjde5etmlnatawwkdznexuzznovfv0wtjvmll6smhar0k1wlrbdw/response_00d9ca7e-2989-421e-a324-576508f42342/0#%7B%22references%22%3A%5B%5D%7D"> <DIV class="overflow-guard" data-mprt="3"> <DIV class="margin" role="presentation" aria-hidden="true">&nbsp;</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <LI-CODE lang="markup">cpview -m | jq -r '.metrics[] | .["metric-id"] as $metric | ($metric | split(".") | join("_")) as $metric_name | if (.data | length) &gt; 0 then .data[] | (to_entries | map(select(.key != "value")) | map("\(.key)=\"\(.value)\"") | join(",")) as $labels | if $labels != "" then "\($metric_name){\($labels)} \(.value)" else "\($metric_name) \(.value)" end else empty end'</LI-CODE> <P><BR />Examples:<BR /><BR /></P> <LI-CODE lang="markup">cpview -m | jq -r '.metrics[] | .["metric-id"] as $metric | ($metric | split(".") | join("_")) as $metric_name | if (.data | length) &gt; 0 then .data[] | (to_entries | map(select(.key != "value")) | map("\(.key)=\"\(.value)\"") | join(",")) as $labels | if $labels != "" then "\($metric_name){\($labels)} \(.value)" else "\($metric_name) \(.value)" end else empty end' | grep system_cpu_count system_cpu_count 42 </LI-CODE> <P><BR /><BR /></P> <LI-CODE lang="markup"> cpview -m | jq -r '.metrics[] | .["metric-id"] as $metric | ($metric | split(".") | join("_")) as $metric_name | if (.data | length) &gt; 0 then .data[] | (to_entries | map(select(.key != "value")) | map("\(.key)=\"\(.value)\"") | join(",")) as $labels | if $labels != "" then "\($metric_name){\($labels)} \(.value)" else "\($metric_name) \(.value)" end else empty end' | grep system_cpu_utilization system_cpu_utilization{cpu="0",state="idle",type="OTHER"} 69 system_cpu_utilization{cpu="1",state="idle",type="OTHER"} 70 system_cpu_utilization{cpu="2",state="idle",type="OTHER"} 72 system_cpu_utilization{cpu="3",state="idle",type="OTHER"} 67 system_cpu_utilization{cpu="4",state="idle",type="OTHER"} 69 system_cpu_utilization{cpu="5",state="idle",type="OTHER"} 68 system_cpu_utilization{cpu="6",state="idle",type="OTHER"} 68 system_cpu_utilization{cpu="7",state="idle",type="OTHER"} 73 system_cpu_utilization{cpu="8",state="idle",type="OTHER"} 70 system_cpu_utilization{cpu="9",state="idle",type="OTHER"} 70 </LI-CODE> <P><BR />&nbsp;</P> Mon, 09 Feb 2026 07:48:26 GMT Vincent_Bacher 2026-02-09T07:48:26Z https://community.checkpoint.com/t5/Scripts/ONELINER-cpview-2-prometheus/m-p/270025#M1457 <P>Hi CheckMates,<BR /><BR /></P> <P>This one-liner script converts the output of<SPAN>&nbsp;</SPAN><CODE>cpview -m</CODE><SPAN>&nbsp;</SPAN>(monitoring metrics) into standardized Prometheus format.</P> <P><STRONG>Use Case:</STRONG><SPAN>&nbsp;</SPAN>When integrating Skyline with SIEM systems like Prometheus, troubleshooting may require comparing the data that Skyline receives from cpview with what's actually queryable in Prometheus using PromQL. This script transforms the cpview JSON output into Prometheus metrics with labels and values.</P> <P><STRONG>How it works:</STRONG></P> <UL> <LI>Reads cpview monitoring data in JSON format</LI> <LI>Converts metric IDs to Prometheus-compatible names (dots to underscores)</LI> <LI>Extracts labels and formats them as<SPAN>&nbsp;</SPAN><CODE>metric_name{label1="value1",label2="value2"} value</CODE></LI> <LI>Filters out empty datasets</LI> </UL> <P><STRONG>Usage:</STRONG></P> <DIV class="code" data-code="id#24"> <DIV class="interactive-result-code-block no-vulns" data-keybinding-context="43"> <DIV class="interactive-result-editor" data-keybinding-context="44" data-mode-id="shellscript"> <DIV class="monaco-editor no-user-select showUnused showDeprecated vs-dark" role="code" data-uri="vscode-chat-code-block://dnnjb2rllwnoyxqtc2vzc2lvbjovl2xvy2fsl09uttnaakzpwwpjde5etmlnatawwkdznexuzznovfv0wtjvmll6smhar0k1wlrbdw/response_00d9ca7e-2989-421e-a324-576508f42342/0#%7B%22references%22%3A%5B%5D%7D"> <DIV class="overflow-guard" data-mprt="3"> <DIV class="margin" role="presentation" aria-hidden="true">&nbsp;</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <LI-CODE lang="markup">cpview -m | jq -r '.metrics[] | .["metric-id"] as $metric | ($metric | split(".") | join("_")) as $metric_name | if (.data | length) &gt; 0 then .data[] | (to_entries | map(select(.key != "value")) | map("\(.key)=\"\(.value)\"") | join(",")) as $labels | if $labels != "" then "\($metric_name){\($labels)} \(.value)" else "\($metric_name) \(.value)" end else empty end'</LI-CODE> <P><BR />Examples:<BR /><BR /></P> <LI-CODE lang="markup">cpview -m | jq -r '.metrics[] | .["metric-id"] as $metric | ($metric | split(".") | join("_")) as $metric_name | if (.data | length) &gt; 0 then .data[] | (to_entries | map(select(.key != "value")) | map("\(.key)=\"\(.value)\"") | join(",")) as $labels | if $labels != "" then "\($metric_name){\($labels)} \(.value)" else "\($metric_name) \(.value)" end else empty end' | grep system_cpu_count system_cpu_count 42 </LI-CODE> <P><BR /><BR /></P> <LI-CODE lang="markup"> cpview -m | jq -r '.metrics[] | .["metric-id"] as $metric | ($metric | split(".") | join("_")) as $metric_name | if (.data | length) &gt; 0 then .data[] | (to_entries | map(select(.key != "value")) | map("\(.key)=\"\(.value)\"") | join(",")) as $labels | if $labels != "" then "\($metric_name){\($labels)} \(.value)" else "\($metric_name) \(.value)" end else empty end' | grep system_cpu_utilization system_cpu_utilization{cpu="0",state="idle",type="OTHER"} 69 system_cpu_utilization{cpu="1",state="idle",type="OTHER"} 70 system_cpu_utilization{cpu="2",state="idle",type="OTHER"} 72 system_cpu_utilization{cpu="3",state="idle",type="OTHER"} 67 system_cpu_utilization{cpu="4",state="idle",type="OTHER"} 69 system_cpu_utilization{cpu="5",state="idle",type="OTHER"} 68 system_cpu_utilization{cpu="6",state="idle",type="OTHER"} 68 system_cpu_utilization{cpu="7",state="idle",type="OTHER"} 73 system_cpu_utilization{cpu="8",state="idle",type="OTHER"} 70 system_cpu_utilization{cpu="9",state="idle",type="OTHER"} 70 </LI-CODE> <P><BR />&nbsp;</P> Mon, 09 Feb 2026 07:48:26 GMT https://community.checkpoint.com/t5/Scripts/ONELINER-cpview-2-prometheus/m-p/270025#M1457 Vincent_Bacher 2026-02-09T07:48:26Z