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
- Find 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!
Enterprise Security Content Update (ESCU) | New Releases
In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...
Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?
(This is the first of a series of 2 blogs).
Splunk Enterprise Security is a fantastic tool that offers robust ...
Index This | What are the 12 Days of Splunk-mas?
December 2024 Edition
Hayyy Splunk Education Enthusiasts and the Eternally Curious!
We’re back with another ...
