Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Dashboards & Visualizations
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Splunk Answers
- :
- Using Splunk
- :
- Dashboards & Visualizations
- :
- "Search produced no results" using timepicker toke...
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
"Search produced no results" using timepicker token.
wapireso
Explorer
07-28-2016
07:48 AM
Hi Everyone,
I'm using 5 dropdown filter on my dashboard. The dropdown get time value from TIMEPICKER. So, when I changed the timepicker one time or second time, itś work fine.
but, if I change the value on third time, I have the error "Search produced no results".
On my search string, I can set>
index=xxx earliest="$timerange.earliest$" latest="$timerange.latest$"
How I can fix this?
I tried with another browser, same error.
Thanks!!!
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
wapireso
Explorer
07-28-2016
09:02 AM
@masonmorales
That's my XML.
<form refresh="30000">
<label>NET - Analise de serviços - Principal</label>
<description>Analise de serviços</description>
<fieldset submitButton="false" autoRun="true"></fieldset>
<row>
<panel depends="$menu$">
<input type="time" token="timerange" searchWhenChanged="true">
<label>Periodo</label>
<default>
<earliest>0</earliest>
<latest></latest>
</default>
</input>
<input type="dropdown" token="BU" searchWhenChanged="true">
<choice value="*">TODOS</choice>
<default>*</default>
<search>
<query>index=aternity_raw earliest="$timerange.earliest$" latest="$timerange.latest$" $TRANSACTION_NAME$ STATE="$STATE$" (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) ACTIVITY_TYPE="$ACTIVITY_TYPE$" | stats count by CONTAINER_NAME</query>
</search>
<fieldForLabel>CONTAINER_NAME</fieldForLabel>
<fieldForValue>CONTAINER_NAME</fieldForValue>
</input>
<input type="dropdown" token="LOCATION" searchWhenChanged="true">
<label>Lojas / Operação</label>
<choice value="*">Todos</choice>
<search>
<query>index=aternity_raw earliest="$timerange.earliest$" latest="$timerange.latest$" $TRANSACTION_NAME$ CONTAINER_NAME="$BU$" (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="$ACTIVITY_TYPE$" | stats count by LOCATION</query>
<earliest>0</earliest>
</search>
<fieldForLabel>LOCATION</fieldForLabel>
<fieldForValue>LOCATION</fieldForValue>
<default>*</default>
</input>
<input type="dropdown" token="STATE" searchWhenChanged="true">
<label>Localização</label>
<search>
<query>index=aternity_raw earliest="$timerange.earliest$" latest="$timerange.latest$" $TRANSACTION_NAME$ CONTAINER_NAME="$BU$" (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) ACTIVITY_TYPE="$ACTIVITY_TYPE$" | stats count by STATE | sort STATE</query>
<earliest>@d</earliest>
<latest>now</latest>
</search>
<fieldForLabel>STATE</fieldForLabel>
<fieldForValue>STATE</fieldForValue>
<choice value="*">TODOS</choice>
<default>*</default>
</input>
<input type="radio" token="LOCATION2" searchWhenChanged="true">
<label></label>
<choice value="=*">Loja / Operação</choice>
<choice value="=Loja*">Loja</choice>
<choice value="!=Loja*">Operação</choice>
<default>=*</default>
</input>
<input type="multiselect" token="TRANSACTION_NAME" searchWhenChanged="true">
<label>Transação</label>
<choice value="*">Todos</choice>
<search>
<query>index=aternity_raw earliest="$timerange.earliest$" latest="$timerange.latest$" $TRANSACTION_NAME$ CONTAINER_NAME="$BU$" (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) | stats count by TRANSACTION_NAME</query>
<earliest>0</earliest>
</search>
<fieldForLabel>TRANSACTION_NAME</fieldForLabel>
<fieldForValue>TRANSACTION_NAME</fieldForValue>
<prefix>(</prefix>
<suffix>)</suffix>
<valuePrefix>TRANSACTION_NAME="</valuePrefix>
<valueSuffix>"</valueSuffix>
<delimiter> OR</delimiter>
<default>*</default>
</input>
<input type="dropdown" token="ACTIVITY_TYPE" searchWhenChanged="true">
<label>Tipo</label>
<choice value="*">Todos</choice>
<search>
<query>index=aternity_raw earliest="$timerange.earliest$" latest="$timerange.latest$" $TRANSACTION_NAME$ CONTAINER_NAME="$BU$" (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) | stats count by ACTIVITY_TYPE</query>
<earliest>0</earliest>
</search>
<fieldForLabel>ACTIVITY_TYPE</fieldForLabel>
<fieldForValue>ACTIVITY_TYPE</fieldForValue>
<default>*</default>
<initialValue>TN-Transaction Response</initialValue>
</input>
<input type="checkbox" token="cabo" searchWhenChanged="true">
<label>Apresentar:</label>
<choice value="true">Cabo</choice>
<default>true</default>
</input>
<input type="checkbox" token="DTH">
<label></label>
<choice value="true">DTH</choice>
<default>true</default>
</input>
<input type="checkbox" token="MOVEL" searchWhenChanged="true">
<label></label>
<choice value="true">Movel</choice>
<default>true</default>
</input>
<input type="text" token="USERNAME" searchWhenChanged="true">
<label>Usuário</label>
<default>*</default>
<prefix>*</prefix>
<suffix>*</suffix>
</input>
<html>
<a href="/app/App_Net/prototipo_main">limpar</a>
</html>
</panel>
</row>
<row>
<panel>
<input type="checkbox" token="menu" searchWhenChanged="true">
<label></label>
<choice value="show">Mostra/Ocultar menu</choice>
<default>show</default>
</input>
</panel>
</row>
<row>
<panel depends="$cabo$">
<title>CABO - Duração | Operações | Usuário(s) | Usuário(s) impactado(s)</title>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-LOGIN"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-LOGIN"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">TN-Login</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Login&CONTAINER_NAME=NetSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Abertura de OC"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Abertura de OC"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">TN-Abertura de OC</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Abertura de OC&CONTAINER_NAME=NetSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Abertura de OS"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Abertura de OS"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<option name="underLabel">TN-Abertura de OS</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Abertura de OS&CONTAINER_NAME=NetSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Atendimento de Retencao"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Atendimento de Retencao"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">TN-Atendimento de Retenção</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Atendimento de Retencao&CONTAINER_NAME=NetSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Emissao de 2a Via de Fatura"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Emissao de 2a Via de Fatura"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">TN-Emissao de 2a Via de Fatura</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Emissao de 2a Via de Fatura&CONTAINER_NAME=NetSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
</panel>
</row>
<row>
<panel depends="$DTH$">
<title>DTH - Duração | Operações | Usuário(s) | Usuário(s) impactado(s)</title>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-LOGIN"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-LOGIN"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">TN-Login</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Login&CONTAINER_NAME=VSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Abertura de OC"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Abertura de OC"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">0</option>
<option name="trendColorInterpretation">inverse</option>
<option name="trendDisplayMode">absolute</option>
<option name="trendInterval">-1h</option>
<option name="underLabel">TN-Abertura de OC</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Abertura de OC&CONTAINER_NAME=VSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Abertura de OS"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Abertura de OS"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">TN-Abertura de OS</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Abertura de OS&CONTAINER_NAME=VSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Abertura de OS" "HIT DE DECODER"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Abertura de OS" "HIT DE DECODER"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">0</option>
<option name="trendColorInterpretation">inverse</option>
<option name="trendDisplayMode">absolute</option>
<option name="trendInterval">-1h</option>
<option name="underLabel">TN-Envio de HIT</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Abertura de OS" "HIT DE DECODER&CONTAINER_NAME=VSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Visualizacao de Fatura"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Visualizacao de Fatura"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">0</option>
<option name="trendColorInterpretation">inverse</option>
<option name="trendDisplayMode">absolute</option>
<option name="trendInterval">-1h</option>
<option name="underLabel">TN-Visualização de Fatura</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Visualizacao de Fatura&CONTAINER_NAME=VSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
</panel>
</row>
<row>
<panel depends="$MOVEL$">
<title>MÓVEL - Duração | Operações | Usuário(s) | Usuário(s) impactado(s)</title>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Login Mobile"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Login Mobile"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">TN-Login Mobile</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Login Mobile&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Login PS8"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Login PS8"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">0</option>
<option name="trendColorInterpretation">inverse</option>
<option name="trendDisplayMode">absolute</option>
<option name="trendInterval">-1h</option>
<option name="underLabel">TN-Login PS8</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Login PS8&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Login WA"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Login WA"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">TN-Login WA</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Login WA&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Login WM"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Login WM"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">0</option>
<option name="trendColorInterpretation">inverse</option>
<option name="trendDisplayMode">absolute</option>
<option name="trendInterval">-1h</option>
<option name="underLabel">TN-Login WM</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Login WM&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Login WPP"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Login WPP"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">0</option>
<option name="trendColorInterpretation">inverse</option>
<option name="trendDisplayMode">absolute</option>
<option name="trendInterval">-1h</option>
<option name="underLabel">TN-Login WPP</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Login WPP&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
</panel>
</row>
<row>
<panel depends="$MOVEL$">
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Geracao de Protocolo"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Geracao de Protocolo"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">TN-Geracao de Protocolo</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Geracao de Protocolo&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Migracao de Cliente Pre para Pos"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Migracao de Cliente Pre para Pos"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">0</option>
<option name="trendColorInterpretation">inverse</option>
<option name="trendDisplayMode">absolute</option>
<option name="trendInterval">-1h</option>
<option name="underLabel">TN-Migracao de Cliente Pre para Pos</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Migracao de Cliente Pre para Pos&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Portabilidade"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Portabilidade"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">TN-Portabilidade</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Portabilidade&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
<single>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="TN-Transaction Response" TRANSACTION_NAME="TN-Ativacao de Linha Pos e Pre Pago"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO
| join [search index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" TRANSACTION_NAME="TN-Ativacao de Linha Pos e Pre Pago"
| strcat USERNAME + " [" + HOSTNAME + "]" iduser | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]
| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0.00</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">0</option>
<option name="trendColorInterpretation">inverse</option>
<option name="trendDisplayMode">absolute</option>
<option name="trendInterval">-1h</option>
<option name="underLabel">TN-Ativacao de Linha Pos e Pre Pago</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
<option name="classField">value</option>
<option name="field">duration</option>
<drilldown>
<link>
<![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Ativacao de Linha Pos e Pre Pago&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
</link>
</drilldown>
</single>
</panel>
</row>
<row>
<panel>
<input type="radio" token="show">
<label>Apresentar por:</label>
<choice value="CONTAINER_NAME TRANSACTION_NAME">BU</choice>
<choice value="TRANSACTION_NAME CONTAINER_NAME">TN</choice>
<default>CONTAINER_NAME TRANSACTION_NAME</default>
</input>
<input type="radio" token="ty" searchWhenChanged="true">
<label>Info</label>
<choice value="| bin _time span=5m | rex mode=sed field=VALUE "s/,/./g" | eval VALUE=tonumber(VALUE) | stats avg(VALUE) as duration first(_time) as _time by TRANSACTION_NAME CONTAINER_NAME | eval duration=duration*1000">media</choice>
<choice value="| rex mode=sed field=VALUE "s/,/./g" | eval VALUE=tonumber(VALUE) | table _time TRANSACTION_NAME CONTAINER_NAME VALUE | rename VALUE as duration | eval duration=duration*1000">real</choice>
<default>| bin _time span=5m | rex mode=sed field=VALUE "s/,/./g" | eval VALUE=tonumber(VALUE) | stats avg(VALUE) as duration first(_time) as _time by TRANSACTION_NAME CONTAINER_NAME | eval duration=duration*1000</default>
<initialValue>| bin _time span=5m | rex mode=sed field=VALUE "s/,/./g" | eval VALUE=tonumber(VALUE) | stats avg(VALUE) as duration first(_time) as _time by TRANSACTION_NAME CONTAINER_NAME | eval duration=duration*1000</initialValue>
</input>
<viz type="timeline_app.timeline">
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" CONTAINER_NAME="$BU$" (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" $TRANSACTION_NAME$ ACTIVITY_TYPE="$ACTIVITY_TYPE$" $ty$
| fields _time $show$ duration</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="timeline_app.timeline.useColors">1</option>
<option name="timeline_app.timeline.colorMode">categorical</option>
<option name="timeline_app.timeline.numOfBins">3</option>
<option name="timeline_app.timeline.maxColor">#DA5C5C</option>
<option name="timeline_app.timeline.minColor">#FFE8E8</option>
<option name="timeline_app.timeline.axisTimeFormat">SECONDS</option>
<option name="timeline_app.timeline.tooltipTimeFormat">SUBSECONDS</option>
</viz>
</panel>
</row>
<row>
<panel>
<html>
<h1 align="center"> SLA </h1>
</html>
</panel>
</row>
<row>
<panel>
<viz type="horseshoe_meter_app.horseshoe_meter">
<title>Disponibilidade CABO</title>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" ACTIVITY_TYPE=Availability (CONTAINER_NAME="NetSMS") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" | stats count(eval(VALUE_BASELINE=0.0)) as Disponivel count(eval(VALUE_BASELINE>0)) as Indisponivel | eval percent=round((Disponivel*100)/(Disponivel+Indisponivel),2) | eval percent=if(isnull(percent), "0.0", percent) | fields percent</query>
<earliest>$timerange.earliest$</earliest>
<latest>$timerange.latest$</latest>
</search>
<option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#fff</option>
<option name="horseshoe_meter_app.horseshoe_meter.dialColor">#d93f3c</option>
<option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
<option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
<option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
<option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">realValue</option>
<option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#d93f3c</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">99.5</option>
<option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
</viz>
</panel>
<panel>
<viz type="horseshoe_meter_app.horseshoe_meter">
<title>Disponibilidade DTH</title>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" ACTIVITY_TYPE=Availability (CONTAINER_NAME="VSMS") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" | stats count(eval(VALUE_BASELINE=0.0)) as Disponivel count(eval(VALUE_BASELINE>0)) as Indisponivel | eval percent=round((Disponivel*100)/(Disponivel+Indisponivel),2) | eval percent=if(isnull(percent), "0.0", percent) | fields percent</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#FFF</option>
<option name="horseshoe_meter_app.horseshoe_meter.dialColor">#555</option>
<option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
<option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
<option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
<option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">percentage</option>
<option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#d93f3c</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">99.5</option>
<option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
</viz>
</panel>
<panel>
<viz type="horseshoe_meter_app.horseshoe_meter">
<title>Disponibilidade Móvel</title>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" ACTIVITY_TYPE=Availability (CONTAINER_NAME="Claro") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" | stats count(eval(VALUE_BASELINE=0.0)) as Disponivel count(eval(VALUE_BASELINE>0)) as Indisponivel | eval percent=round((Disponivel*100)/(Disponivel+Indisponivel),2) | eval percent=if(isnull(percent), "0.0", percent) | fields percent</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#FFF</option>
<option name="horseshoe_meter_app.horseshoe_meter.dialColor">#555</option>
<option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
<option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
<option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
<option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">percentage</option>
<option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#65a637</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">99.5</option>
<option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
</viz>
</panel>
<panel>
<viz type="horseshoe_meter_app.horseshoe_meter">
<title>Disponibilidade Geral</title>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" ACTIVITY_TYPE=Availability (CONTAINER_NAME="*") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" | stats count(eval(VALUE_BASELINE=0.0)) as Disponivel count(eval(VALUE_BASELINE>0)) as Indisponivel | eval percent=round((Disponivel*100)/(Disponivel+Indisponivel),2) | eval percent=if(isnull(percent), "0.0", percent) | fields percent</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#FFF</option>
<option name="horseshoe_meter_app.horseshoe_meter.dialColor">#555</option>
<option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
<option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
<option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
<option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">percentage</option>
<option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#d93f3c</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">99.5</option>
<option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
</viz>
</panel>
</row>
<row>
<panel>
<viz type="horseshoe_meter_app.horseshoe_meter">
<title>Performance CABO</title>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="NetSMS") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" $TRANSACTION_NAME$ | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by ID_TRANSACAO | eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | top controle | search controle="Severidade Normal" | eval percent=round(percent,2) | fields percent</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="charting.chart">radialGauge</option>
<option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#FFF</option>
<option name="horseshoe_meter_app.horseshoe_meter.dialColor">#d0d5d9</option>
<option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
<option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
<option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
<option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">realValue</option>
<option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#f7bc38</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80.1</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">90.1</option>
<option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
</viz>
</panel>
<panel>
<viz type="horseshoe_meter_app.horseshoe_meter">
<title>Performance DTH</title>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="VSMS") (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" $TRANSACTION_NAME$ | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by ID_TRANSACAO | eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | top controle | search controle="Severidade Normal" | eval percent=round(percent,2) | fields percent</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="charting.chart">radialGauge</option>
<option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#FFF</option>
<option name="horseshoe_meter_app.horseshoe_meter.dialColor">#d0d5d9</option>
<option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
<option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
<option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
<option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">realValue</option>
<option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#fbcd2f</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80.1</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">90.1</option>
<option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
</viz>
</panel>
<panel>
<viz type="horseshoe_meter_app.horseshoe_meter">
<title>Performance Móvel</title>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$" (CONTAINER_NAME="Claro" ) (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" $TRANSACTION_NAME$ | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by ID_TRANSACAO | eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | top controle | search controle="Severidade Normal" | eval percent=round(percent,2) | fields percent</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="charting.chart">radialGauge</option>
<option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#FFF</option>
<option name="horseshoe_meter_app.horseshoe_meter.dialColor">#d0d5d9</option>
<option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
<option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
<option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
<option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">realValue</option>
<option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#fbcd2f</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80.1</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">90.1</option>
<option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
</viz>
</panel>
<panel>
<viz type="horseshoe_meter_app.horseshoe_meter">
<title>Performance Geral</title>
<search>
<query>index=aternity_raw USERNAME="$USERNAME$"
(CONTAINER_NAME="*")
(LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ ) STATE="$STATE$" ACTIVITY_TYPE="Activity Response" $TRANSACTION_NAME$
| stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | top controle | search controle="Severidade Normal"
| eval percent=round(percent,2)
| fields percent</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="charting.chart">radialGauge</option>
<option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#FFF</option>
<option name="horseshoe_meter_app.horseshoe_meter.dialColor">#d0d5d9</option>
<option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
<option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
<option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
<option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">realValue</option>
<option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#fbcd2f</option>
<option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80.1</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
<option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">90.1</option>
<option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
</viz>
</panel>
</row>
</form>
Thanks!!!
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
masonmorales
Influencer
07-28-2016
08:40 AM
Can you post the XML source code of your dashboard? It would be helpful in debugging this.
Get Updates on the Splunk Community!
Introducing the 2024 SplunkTrust!
Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!
The ...
Introducing the 2024 Splunk MVPs!
We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...
Splunk Custom Visualizations App End of Life
The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...
