Hi,
i am attempting the second alternative. For some reason, the code modifies the sequence of the code. I place [...] after the 1. When I close and return into the code it puts it before the
So below is my code. I am getting the Total average time in the first panel. The second panel segments the average by either virtual machine or physical desktop.
I am trying to get the % delta between the time with a virtual machine compared to a physical desktop.
Thanks
<form>
<label>Smallworld - Performance globale</label>
<fieldset submitButton="true" autoRun="true">
<input type="time" token="field1">
<label></label>
<default>
<earliest>-15m</earliest>
<latest>now</latest>
</default>
</input>
</fieldset>
<row>
<panel>
<title>Smallworld - Temps de charge de l'application (V1)</title>
<single>
<title>Temps moyen de charge - total</title>
<search>
<done>
<set token="tokTotalCount">$result.avg_duration_total$</set>
</done>
<query>index=diag_sw_prod sourcetype="rwa_code_load" load_type="load_module" NOT user_name=swadmin|eval location = coalesce(location,"VM") |search (location="*") (user_name=*) | stats earliest(_time) as start_load_module by user_name session_id | join type=left session_id [|search index=diag_sw_prod sourcetype=rwr_jvm_statistics | stats latest(vm_uptime) as uptime latest(_time) as time by session_id | eval startup_time=time-uptime| fields startup_time session_id] | join type=left session_id [search index=diag_sw_prod sourcetype=rwa_custom_function user_action=startup_profiling handler_class=smallworld_product message="open_database()" message_args=*\\* | stats earliest(_time) as start_open_db by session_id] | join type=left session_id [search index=diag_sw_prod sourcetype=rwa_custom_function user_action=startup_profiling handler_class=smallworld_product message="login()" | stats earliest(_time) as login by session_id]| eval bootstrapping=start_load_module-startup_time , loading_module_time=start_open_db-start_load_module, open_db_time=login-start_open_db, total_time=bootstrapping+loading_module_time+open_db_time |convert ctime(startup_time) | stats avg(total_time) as avg_duration_total</query>
<earliest>$field1.earliest$</earliest>
<latest>$field1.latest$</latest>
<sampleRatio>1</sampleRatio>
</search>
<option name="colorMode">block</option>
<option name="drilldown">all</option>
<option name="height">206</option>
<option name="rangeColors">["0x53a051","0xdc4e41"]</option>
<option name="rangeValues">[300]</option>
<option name="refresh.display">progressbar</option>
<option name="unit">sec.</option>
<option name="useColors">1</option>
</single>
</panel>
<panel>
<title>Smallworld - Temps de charge de l'application - Machine virtuelle vs poste physique</title>
<single>
<title>Machine virtuelle</title>
<search>
<done>
<set token="tokVMCount">$result.avg_duration_VM$</set>
</done>
<query>index=diag_sw_prod sourcetype="rwa_code_load" load_type="load_module" NOT user_name=swadmin|eval location = coalesce(location,"VM") |search (location="VM") (user_name=*) | stats earliest(_time) as start_load_module by user_name session_id | join type=left session_id [|search index=diag_sw_prod sourcetype=rwr_jvm_statistics | stats latest(vm_uptime) as uptime latest(_time) as time by session_id | eval startup_time=time-uptime| fields startup_time session_id] | join type=left session_id [search index=diag_sw_prod sourcetype=rwa_custom_function user_action=startup_profiling handler_class=smallworld_product message="open_database()" message_args=*\\* | stats earliest(_time) as start_open_db by session_id] | join type=left session_id [search index=diag_sw_prod sourcetype=rwa_custom_function user_action=startup_profiling handler_class=smallworld_product message="login()" | stats earliest(_time) as login by session_id]| eval bootstrapping=start_load_module-startup_time , loading_module_time=start_open_db-start_load_module, open_db_time=login-start_open_db, total_time=bootstrapping+loading_module_time+open_db_time |convert ctime(startup_time) | stats avg(total_time) as avg_duration_VM</query>
<earliest>$field1.earliest$</earliest>
<latest>$field1.latest$</latest>
<sampleRatio>1</sampleRatio>
</search>
<option name="drilldown">all</option>
<option name="rangeColors">["0x53a051","0xdc4e41"]</option>
<option name="rangeValues">[300]</option>
<option name="refresh.display">progressbar</option>
<option name="trellis.enabled">0</option>
<option name="trellis.splitBy">_aggregation</option>
<option name="unit">sec.</option>
<option name="useColors">1</option>
</single>
<single>
<title>Poste physique</title>
<search>
<done>
<set token="tokPPCount">$result.avg_duration_PP$</set>
</done>
<query>index=diag_sw_prod sourcetype="rwa_code_load" load_type="load_module" NOT user_name=swadmin|eval location = coalesce(location,"VM") |search (location="Site locations") (user_name=*) | stats earliest(_time) as start_load_module by user_name session_id | join type=left session_id [|search index=diag_sw_prod sourcetype=rwr_jvm_statistics | stats latest(vm_uptime) as uptime latest(_time) as time by session_id | eval startup_time=time-uptime| fields startup_time session_id] | join type=left session_id [search index=diag_sw_prod sourcetype=rwa_custom_function user_action=startup_profiling handler_class=smallworld_product message="open_database()" message_args=*\\* | stats earliest(_time) as start_open_db by session_id] | join type=left session_id [search index=diag_sw_prod sourcetype=rwa_custom_function user_action=startup_profiling handler_class=smallworld_product message="login()" | stats earliest(_time) as login by session_id]| eval bootstrapping=start_load_module-startup_time , loading_module_time=start_open_db-start_load_module, open_db_time=login-start_open_db, total_time=bootstrapping+loading_module_time+open_db_time |convert ctime(startup_time) | stats avg(total_time) as avg_duration_PP</query>
<earliest>$field1.earliest$</earliest>
<latest>$field1.latest$</latest>
<sampleRatio>1</sampleRatio>
</search>
<option name="drilldown">all</option>
<option name="rangeColors">["0x53a051","0xdc4e41"]</option>
<option name="rangeValues">[300]</option>
<option name="refresh.display">progressbar</option>
<option name="trellis.enabled">0</option>
<option name="trellis.size">large</option>
<option name="unit">sec.</option>
<option name="useColors">1</option>
</single>
<single>
<title>Différence de performance</title>
<search>
<query>makeresults | eval Total=$tokTotalCount$, TotalVM=$tokVMCount$, TotalPP=$tokPPCount$ | eval percent= round((abs(TotalVM-TotalPP)/Total)*100,1) | table percent</query>
<earliest>$field1.earliest$</earliest>
<latest>$field1.latest$</latest>
</search>
<option name="drilldown">none</option>
<option name="refresh.display">progressbar</option>
<option name="unit">%</option>
<option name="useThousandSeparators">0</option>
</single>
</panel>
</row>
</form>
... View more