Average CPU usage for MID Server Dashboard

[Kazuma Akita]

A component is available to monitor CPU utilization on the MID Server Dashboard in the Performance Analytics Workspace. As you can see in the picture, the average maximum memory usage is displayed from both Linux/WindowsOS MID servers, but the average CPU usage is only displayed for Linux. Then, I would like to ask how to display Windows OS as well.

[rkolosky]

I have not been able to get the performance dashboard to display any data. I verified there is data in the ecc_agent_scalar_metric table, but nothing appears on the dashboard. Are there PA jobs that need to be run? The documentation makes it sound like it should just be working. 

[Dan Franko1]

Did you ever solve this? I'm seeing the same thing.

[Pravin13]

@rkolosky @Dan Franko1  Do you guys able to resolve the Performance tab issue in MID server dashboard as we also facing the same issue? Kindly advise.

[rkolosky]

Yes. We raised a support case, and the logged PRB1754230 for the issue. I have verified this works in the customer instance having the issue. So please let me know if this does not work for you.

The fix is to go to https://<<yourinstance>>.service-now.com/now/nav/ui/classic/params/target/sys_ux_macroponent.do%3Fsy...

And go to the "Data" field on this record and replace the JSON with this:

[ {"cachePolicy" : null,"definition" : {"id" : "b997a84053021010cbc2ddeeff7b1228","type" : "COMPOSITE"},"dependencies" : { },"elementId" : "mid_server_records_pagination","elementLabel" : "MID Server Records Pagination","eventMappings" : [ {"eventMappingId" : "cldysiiauccaaccihhddbhhuwhcjjzlbee","isConfiguration" : false,"offRowStorageId" : null,"sourceEventApiName" : "sn_uxf.DATA_FETCH_SUCCEEDED","sourceEventCorrelationId" : null,"sourceEventDefinition" : {"apiName" : "sn_uxf.DATA_FETCH_SUCCEEDED","id" : null,"type" : "UXEVENT"},"sourceEventSysId" : null,"targets" : [ {"broker" : null,"clientScript" : null,"conditional" : null,"declarativeAction" : null,"event" : {"apiName" : "sn_uxf.MACROPONENT_STATE_UPDATE_REQUESTED","payload" : {"type" : "MAP_CONTAINER","container" : {"propName" : {"type" : "JSON_LITERAL","value" : "mid_servers_pagination"},"value" : {"type" : "DATA_OUTPUT_BINDING","binding" : {"address" : [ "mid_server_records_pagination", "results" ]}}}},"sysId" : "32408b42ff7a10109046e490703bf176"},"operation" : null,"targetId" : "cldysiiauccaacciiiddbhhuiarrxttq","type" : "EVENT"}, {"broker" : null,"clientScript" : {"sysId" : "ba893ec153a121101423ddeeff7b1270"},"conditional" : null,"declarativeAction" : null,"event" : null,"operation" : null,"targetId" : "clfeejjghgjjaaccvbddbhhucjpwfddiff","type" : "CLIENT_SCRIPT"} ]} ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "ecc_agent"},"encodedQuery" : {"type" : "STATE_BINDING","binding" : {"address" : [ "search_query" ]}},"returnFields" : {"type" : "JSON_LITERAL","value" : "name"},"orderBy" : {"type" : "JSON_LITERAL","value" : "name"},"sortType" : {"type" : "JSON_LITERAL","value" : "asc"},"limit" : {"type" : "STATE_BINDING","binding" : {"address" : [ "mid_servers_page_size" ]}},"offset" : {"type" : "STATE_BINDING","binding" : {"address" : [ "mid_servers_pagination_offset" ]}},"queryCategory" : {"type" : "JSON_LITERAL","value" : ""},"returnFieldMetadata" : {"type" : "JSON_LITERAL","value" : false}},"readEvaluationMode" : "EAGER"}, {"cachePolicy" : null,"definition" : {"id" : "b997a84053021010cbc2ddeeff7b1228","type" : "COMPOSITE"},"dependencies" : { },"elementId" : "mid_server_latest_upgrade","elementLabel" : "MID Server Latest Upgrade","eventMappings" : [ {"eventMappingId" : "cleiggzciqaacclhhddbhhtgkzpyuaar","isConfiguration" : false,"offRowStorageId" : null,"sourceEventApiName" : "sn_uxf.DATA_FETCH_SUCCEEDED","sourceEventCorrelationId" : null,"sourceEventDefinition" : {"apiName" : "sn_uxf.DATA_FETCH_SUCCEEDED","id" : null,"type" : "UXEVENT"},"sourceEventSysId" : null,"targets" : [ {"broker" : null,"clientScript" : null,"conditional" : null,"declarativeAction" : null,"event" : null,"operation" : {"dataBrokerId" : "546cccd25310101024e5ddeeff7b123b","operationName" : "REFRESH","parentResourceId" : "mid_server_upgrade_start_count","payload" : {"type" : "JSON_LITERAL","value" : { }}},"targetId" : "cleiggzciqaaccliiddbhhtffiiyydrke","type" : "DATABROKER_OP"}, {"broker" : null,"clientScript" : null,"conditional" : null,"declarativeAction" : null,"event" : null,"operation" : {"dataBrokerId" : "546cccd25310101024e5ddeeff7b123b","operationName" : "REFRESH","parentResourceId" : "mid_server_upgrade_completed_count","payload" : {"type" : "JSON_LITERAL","value" : { }}},"targetId" : "cleiggzngffaaccljjddbhhtccxbbjjhhhhnii","type" : "DATABROKER_OP"} ]} ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "ecc_agent_upgrade_history"},"encodedQuery" : {"type" : "JSON_LITERAL","value" : ""},"returnFields" : {"type" : "JSON_LITERAL","value" : ""},"orderBy" : {"type" : "JSON_LITERAL","value" : "sys_created_on"},"sortType" : {"type" : "JSON_LITERAL","value" : "desc"},"limit" : {"type" : "JSON_LITERAL","value" : "1"},"offset" : {"type" : "JSON_LITERAL","value" : null},"queryCategory" : {"type" : "JSON_LITERAL","value" : ""},"returnFieldMetadata" : {"type" : "JSON_LITERAL","value" : false}},"readEvaluationMode" : "EAGER"}, {"cachePolicy" : null,"definition" : {"id" : "546cccd25310101024e5ddeeff7b123b","type" : "GRAPHQL"},"dependencies" : { },"elementId" : "mid_server_upgrade_start_count","elementLabel" : "MID Server Upgrade Start Count","eventMappings" : [ ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "ecc_agent_upgrade_history_stage"},"encodedQuery" : {"type" : "CLIENT_TRANSFORM","transform" : {"operands" : {"type" : "LIST_CONTAINER","container" : [ {"type" : "JSON_LITERAL","value" : "upgrade_historyDYNAMIC"}, {"type" : "DATA_OUTPUT_BINDING","binding" : {"address" : [ "mid_server_latest_upgrade", "results", "0", "sys_id", "value" ]}} ]},"operator" : "CONCAT"}},"groupBy" : {"type" : "JSON_LITERAL","value" : "mid_server"},"orderBy" : {"type" : "JSON_LITERAL","value" : ""},"having" : {"type" : "JSON_LITERAL","value" : null},"sumField" : {"type" : "JSON_LITERAL","value" : ""},"maxField" : {"type" : "JSON_LITERAL","value" : ""},"minField" : {"type" : "JSON_LITERAL","value" : ""},"avgField" : {"type" : "JSON_LITERAL","value" : ""},"queryCategory" : {"type" : "JSON_LITERAL","value" : null},"returnRowCount" : {"type" : "JSON_LITERAL","value" : true}},"readEvaluationMode" : "EXPLICIT"}, {"cachePolicy" : null,"definition" : {"id" : "546cccd25310101024e5ddeeff7b123b","type" : "GRAPHQL"},"dependencies" : { },"elementId" : "mid_server_upgrade_completed_count","elementLabel" : "MID Server Upgrade Completed Count","eventMappings" : [ ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "ecc_agent_upgrade_history_stage"},"encodedQuery" : {"type" : "CLIENT_TRANSFORM","transform" : {"operands" : {"type" : "LIST_CONTAINER","container" : [ {"type" : "JSON_LITERAL","value" : "stage=MidUpgraded^state=Completed^upgrade_historyDYNAMIC"}, {"type" : "DATA_OUTPUT_BINDING","binding" : {"address" : [ "mid_server_latest_upgrade", "results", "0", "sys_id", "value" ]}} ]},"operator" : "CONCAT"}},"groupBy" : {"type" : "JSON_LITERAL","value" : "mid_server"},"orderBy" : {"type" : "JSON_LITERAL","value" : ""},"having" : {"type" : "JSON_LITERAL","value" : null},"sumField" : {"type" : "JSON_LITERAL","value" : ""},"maxField" : {"type" : "JSON_LITERAL","value" : ""},"minField" : {"type" : "JSON_LITERAL","value" : ""},"avgField" : {"type" : "JSON_LITERAL","value" : ""},"queryCategory" : {"type" : "JSON_LITERAL","value" : null},"returnRowCount" : {"type" : "JSON_LITERAL","value" : true}},"readEvaluationMode" : "EXPLICIT"}, {"cachePolicy" : null,"definition" : {"id" : "1a44737f532201104096ddeeff7b12f5","type" : "REST"},"dependencies" : { },"elementId" : "ecc_queue_pending_jobs","elementLabel" : "ECC Queue Pending Jobs","eventMappings" : [ ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "ecc_queue"},"filterQuery" : {"type" : "JSON_LITERAL","value" : "agentSTARTSWITHmid.server^queue=output^state=ready^sys_created_on>=javascript&colon;gs.beginningOfYesterday()^topic!=SystemCommand"},"aggregateFunction" : {"type" : "JSON_LITERAL","value" : "COUNT"},"aggregateField" : {"type" : "JSON_LITERAL","value" : ""},"trendBy" : {"type" : "JSON_LITERAL","value" : ""},"trendInterval" : {"type" : "JSON_LITERAL","value" : ""},"trendMinuteInterval" : {"type" : "JSON_LITERAL","value" : 15},"groupBy" : {"type" : "JSON_LITERAL","value" : [ ]},"numberOfGroups" : {"type" : "JSON_LITERAL","value" : 10},"showOther" : {"type" : "JSON_LITERAL","value" : true},"sortBy" : {"type" : "JSON_LITERAL","value" : "value"},"sortOrder" : {"type" : "JSON_LITERAL","value" : "desc"},"filterConfigurations": {"type": "JSON_LITERAL","value": []},"cacheExpirationTime": {"type": "JSON_LITERAL","value": "86400"},"invalidateCacheEntry": {"type": "JSON_LITERAL","value": false},"useDataCache": {"type": "JSON_LITERAL","value": false},"additionalKey": {"type": "JSON_LITERAL","value": ""}},"readEvaluationMode" : "EAGER"}, {"cachePolicy" : null,"definition" : {"id" : "1a44737f532201104096ddeeff7b12f5","type" : "REST"},"dependencies" : { },"elementId" : "ecc_queue_processing_jobs","elementLabel" : "ECC Queue Processing Jobs","eventMappings" : [ ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "ecc_queue"},"filterQuery" : {"type" : "JSON_LITERAL","value" : "agentSTARTSWITHmid.server^queue=output^state=processing^sys_created_on>=javascript&colon;gs.beginningOfYesterday()^topic!=SystemCommand"},"aggregateFunction" : {"type" : "JSON_LITERAL","value" : "COUNT"},"aggregateField" : {"type" : "JSON_LITERAL","value" : ""},"trendBy" : {"type" : "JSON_LITERAL","value" : ""},"trendInterval" : {"type" : "JSON_LITERAL","value" : ""},"trendMinuteInterval" : {"type" : "JSON_LITERAL","value" : 15},"groupBy" : {"type" : "JSON_LITERAL","value" : [ ]},"numberOfGroups" : {"type" : "JSON_LITERAL","value" : 10},"showOther" : {"type" : "JSON_LITERAL","value" : true},"sortBy" : {"type" : "JSON_LITERAL","value" : "value"},"sortOrder" : {"type" : "JSON_LITERAL","value" : "desc"},"filterConfigurations": {"type": "JSON_LITERAL","value": []},"cacheExpirationTime": {"type": "JSON_LITERAL","value": "86400"},"invalidateCacheEntry": {"type": "JSON_LITERAL","value": false},"useDataCache": {"type": "JSON_LITERAL","value": false},"additionalKey": {"type": "JSON_LITERAL","value": ""}},"readEvaluationMode" : "EAGER"}, {"cachePolicy" : null,"definition" : {"id" : "b997a84053021010cbc2ddeeff7b1228","type" : "COMPOSITE"},"dependencies" : { },"elementId" : "mid_server_capabilities","elementLabel" : "MID Server Capabilities","eventMappings" : [ ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "ecc_agent_capability"},"encodedQuery" : {"type" : "JSON_LITERAL","value" : ""},"returnFields" : {"type" : "JSON_LITERAL","value" : ""},"orderBy" : {"type" : "JSON_LITERAL","value" : "capability"},"sortType" : {"type" : "JSON_LITERAL","value" : "asc"},"limit" : {"type" : "JSON_LITERAL","value" : ""},"offset" : {"type" : "JSON_LITERAL","value" : null},"queryCategory" : {"type" : "JSON_LITERAL","value" : ""},"returnFieldMetadata" : {"type" : "JSON_LITERAL","value" : false}},"readEvaluationMode" : "EAGER"}, {"cachePolicy" : null,"definition" : {"id" : "546cccd25310101024e5ddeeff7b123b","type" : "GRAPHQL"},"dependencies" : { },"elementId" : "mid_server_capability_mapping","elementLabel" : "MID Server Capability Mapping","eventMappings" : [ ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "ecc_agent_capability_m2m"},"encodedQuery" : {"type" : "JSON_LITERAL","value" : ""},"groupBy" : {"type" : "JSON_LITERAL","value" : "capability"},"orderBy" : {"type" : "JSON_LITERAL","value" : null},"having" : {"type" : "JSON_LITERAL","value" : null},"sumField" : {"type" : "JSON_LITERAL","value" : ""},"maxField" : {"type" : "JSON_LITERAL","value" : ""},"minField" : {"type" : "JSON_LITERAL","value" : ""},"avgField" : {"type" : "JSON_LITERAL","value" : ""},"queryCategory" : {"type" : "JSON_LITERAL","value" : null},"returnRowCount" : {"type" : "JSON_LITERAL","value" : true}},"readEvaluationMode" : "EAGER"}, {"cachePolicy" : null,"definition" : {"id" : "1a44737f532201104096ddeeff7b12f5","type" : "REST"},"dependencies" : { },"elementId" : "mid_server_top5_avg_cpu_usage","elementLabel" : "MID Server Top 5 Avg CPU Usage","eventMappings" : [ ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "ecc_agent_scalar_metric"},"filterQuery" : {"type" : "JSON_LITERAL","value" : "name=cpu.use^sys_created_onONLast 7 days@javascript&colon;gs.beginningOfLast7Days()@javascript&colon;gs.endOfLast7Days()"},"aggregateFunction" : {"type" : "JSON_LITERAL","value" : "AVG"},"aggregateField" : {"type" : "JSON_LITERAL","value" : "mean"},"trendBy" : {"type" : "JSON_LITERAL","value" : ""},"trendInterval" : {"type" : "JSON_LITERAL","value" : ""},"trendMinuteInterval" : {"type" : "JSON_LITERAL","value" : 0},"groupBy" : {"type" : "JSON_LITERAL","value" : [ "agent" ]},"numberOfGroups" : {"type" : "JSON_LITERAL","value" : 5},"showOther" : {"type" : "JSON_LITERAL","value" : false},"sortBy" : {"type" : "JSON_LITERAL","value" : "value"},"sortOrder" : {"type" : "JSON_LITERAL","value" : "desc"},"filterConfigurations": {"type": "JSON_LITERAL","value": []},"cacheExpirationTime": {"type": "JSON_LITERAL","value": "86400"},"invalidateCacheEntry": {"type": "JSON_LITERAL","value": false},"useDataCache": {"type": "JSON_LITERAL","value": false},"additionalKey": {"type": "JSON_LITERAL","value": ""}},"readEvaluationMode" : "EAGER"}, {"cachePolicy" : null,"definition" : {"id" : "1a44737f532201104096ddeeff7b12f5","type" : "REST"},"dependencies" : { },"elementId" : "mid_server_top5_avg_max_memory_usage","elementLabel" : "MID Server Top 5 Avg Max Memory Usage","eventMappings" : [ ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "ecc_agent_memory_metric"},"filterQuery" : {"type" : "JSON_LITERAL","value" : "name=memory.use^sys_created_onONLast 7 days@javascript&colon;gs.beginningOfLast7Days()@javascript&colon;gs.endOfLast7Days()"},"aggregateFunction" : {"type" : "JSON_LITERAL","value" : "AVG"},"aggregateField" : {"type" : "JSON_LITERAL","value" : "max_used_pct"},"trendBy" : {"type" : "JSON_LITERAL","value" : ""},"trendInterval" : {"type" : "JSON_LITERAL","value" : ""},"trendMinuteInterval" : {"type" : "JSON_LITERAL","value" : 0},"groupBy" : {"type" : "JSON_LITERAL","value" : [ "agent" ]},"numberOfGroups" : {"type" : "JSON_LITERAL","value" : 5},"showOther" : {"type" : "JSON_LITERAL","value" : false},"sortBy" : {"type" : "JSON_LITERAL","value" : "value"},"sortOrder" : {"type" : "JSON_LITERAL","value" : "desc"},"filterConfigurations": {"type": "JSON_LITERAL","value": []},"cacheExpirationTime": {"type": "JSON_LITERAL","value": "86400"},"invalidateCacheEntry": {"type": "JSON_LITERAL","value": false},"useDataCache": {"type": "JSON_LITERAL","value": false},"additionalKey": {"type": "JSON_LITERAL","value": ""}},"readEvaluationMode" : "EAGER"}, {"cachePolicy" : null,"definition" : {"id" : "1a44737f532201104096ddeeff7b12f5","type" : "REST"},"dependencies" : { },"elementId" : "mid_server_top5_lifecycle_event","elementLabel" : "MID Server Top 5 Lifecycle Event","eventMappings" : [ ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "mid_server_event"},"filterQuery" : {"type" : "JSON_LITERAL","value" : "sys_created_onONLast 7 days@javascript&colon;gs.beginningOfLast7Days()@javascript&colon;gs.endOfLast7Days()"},"aggregateFunction" : {"type" : "JSON_LITERAL","value" : "COUNT"},"aggregateField" : {"type" : "JSON_LITERAL","value" : ""},"trendBy" : {"type" : "JSON_LITERAL","value" : ""},"trendInterval" : {"type" : "JSON_LITERAL","value" : ""},"trendMinuteInterval" : {"type" : "JSON_LITERAL","value" : 0},"groupBy" : {"type" : "JSON_LITERAL","value" : [ "agent" ]},"numberOfGroups" : {"type" : "JSON_LITERAL","value" : 5},"showOther" : {"type" : "JSON_LITERAL","value" : false},"sortBy" : {"type" : "JSON_LITERAL","value" : "value"},"sortOrder" : {"type" : "JSON_LITERAL","value" : "desc"},"filterConfigurations": {"type": "JSON_LITERAL","value": []},"cacheExpirationTime": {"type": "JSON_LITERAL","value": "86400"},"invalidateCacheEntry": {"type": "JSON_LITERAL","value": false},"useDataCache": {"type": "JSON_LITERAL","value": false},"additionalKey": {"type": "JSON_LITERAL","value": ""}},"readEvaluationMode" : "EAGER"}, {"cachePolicy" : null,"definition" : {"id" : "1a44737f532201104096ddeeff7b12f5","type" : "REST"},"dependencies" : { },"elementId" : "mid_server_custom_average_cpu_usage","elementLabel" : "MID Server Custom Average CPU Usage","eventMappings" : [ ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "ecc_agent_scalar_metric"},"filterQuery" : {"type" : "CLIENT_TRANSFORM","transform" : {"operands" : {"type" : "LIST_CONTAINER","container" : [ {"type" : "JSON_LITERAL","value" : "name=cpu.use^agent.nameIN"}, {"type" : "STATE_BINDING","binding" : {"address" : [ "selected_mid_servers" ]}}, {"type" : "JSON_LITERAL","value" : "^sys_created_onBETWEEN"}, {"type" : "STATE_BINDING","binding" : {"address" : [ "picker_selected_date" ]}} ]},"operator" : "CONCAT"}},"aggregateFunction" : {"type" : "JSON_LITERAL","value" : "AVG"},"aggregateField" : {"type" : "JSON_LITERAL","value" : "mean"},"trendBy" : {"type" : "JSON_LITERAL","value" : "sys_created_on"},"trendInterval" : {"type" : "JSON_LITERAL","value" : "date"},"trendMinuteInterval" : {"type" : "JSON_LITERAL","value" : 0},"groupBy" : {"type" : "JSON_LITERAL","value" : [ "agent" ]},"numberOfGroups" : {"type" : "JSON_LITERAL","value" : 0},"showOther" : {"type" : "JSON_LITERAL","value" : false},"sortBy" : {"type" : "JSON_LITERAL","value" : "value"},"sortOrder" : {"type" : "JSON_LITERAL","value" : "desc"},"filterConfigurations": {"type": "JSON_LITERAL","value": []},"cacheExpirationTime": {"type": "JSON_LITERAL","value": "86400"},"invalidateCacheEntry": {"type": "JSON_LITERAL","value": false},"useDataCache": {"type": "JSON_LITERAL","value": false},"additionalKey": {"type": "JSON_LITERAL","value": ""}},"readEvaluationMode" : "EAGER"}, {"cachePolicy" : null,"definition" : {"id" : "1a44737f532201104096ddeeff7b12f5","type" : "REST"},"dependencies" : { },"elementId" : "mid_server_custom_average_max_memory_usage","elementLabel" : "MID Server Custom Average Max Memory Usage","eventMappings" : [ ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "ecc_agent_memory_metric"},"filterQuery" : {"type" : "CLIENT_TRANSFORM","transform" : {"operands" : {"type" : "LIST_CONTAINER","container" : [ {"type" : "JSON_LITERAL","value" : "agent.nameIN"}, {"type" : "STATE_BINDING","binding" : {"address" : [ "selected_mid_servers" ]}}, {"type" : "JSON_LITERAL","value" : "^sys_created_onBETWEEN"}, {"type" : "STATE_BINDING","binding" : {"address" : [ "picker_selected_date" ]}}, {"type" : "JSON_LITERAL","value" : "^name=memory.use"} ]},"operator" : "CONCAT"}},"aggregateFunction" : {"type" : "JSON_LITERAL","value" : "AVG"},"aggregateField" : {"type" : "JSON_LITERAL","value" : "max_used_pct"},"trendBy" : {"type" : "JSON_LITERAL","value" : "sys_created_on"},"trendInterval" : {"type" : "JSON_LITERAL","value" : "date"},"trendMinuteInterval" : {"type" : "JSON_LITERAL","value" : 0},"groupBy" : {"type" : "JSON_LITERAL","value" : [ "agent" ]},"numberOfGroups" : {"type" : "JSON_LITERAL","value" : 0},"showOther" : {"type" : "JSON_LITERAL","value" : false},"sortBy" : {"type" : "JSON_LITERAL","value" : "value"},"sortOrder" : {"type" : "JSON_LITERAL","value" : "desc"},"filterConfigurations": {"type": "JSON_LITERAL","value": []},"cacheExpirationTime": {"type": "JSON_LITERAL","value": "86400"},"invalidateCacheEntry": {"type": "JSON_LITERAL","value": false},"useDataCache": {"type": "JSON_LITERAL","value": false},"additionalKey": {"type": "JSON_LITERAL","value": ""}},"readEvaluationMode" : "EAGER"}, {"cachePolicy" : null,"definition" : {"id" : "1a44737f532201104096ddeeff7b12f5","type" : "REST"},"dependencies" : { },"elementId" : "mid_server_custom_lifecycle_event","elementLabel" : " MID Server Custom Lifecycle Event","eventMappings" : [ ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "mid_server_event"},"filterQuery" : {"type" : "CLIENT_TRANSFORM","transform" : {"operands" : {"type" : "LIST_CONTAINER","container" : [ {"type" : "JSON_LITERAL","value" : "agentIN"}, {"type" : "STATE_BINDING","binding" : {"address" : [ "selected_mid_servers" ]}}, {"type" : "JSON_LITERAL","value" : "^sys_created_onBETWEEN"}, {"type" : "STATE_BINDING","binding" : {"address" : [ "picker_selected_date" ]}} ]},"operator" : "CONCAT"}},"aggregateFunction" : {"type" : "JSON_LITERAL","value" : "COUNT"},"aggregateField" : {"type" : "JSON_LITERAL","value" : ""},"trendBy" : {"type" : "JSON_LITERAL","value" : "sys_created_on"},"trendInterval" : {"type" : "JSON_LITERAL","value" : "date"},"trendMinuteInterval" : {"type" : "JSON_LITERAL","value" : 0},"groupBy" : {"type" : "JSON_LITERAL","value" : [ "agent" ]},"numberOfGroups" : {"type" : "JSON_LITERAL","value" : 0},"showOther" : {"type" : "JSON_LITERAL","value" : false},"sortBy" : {"type" : "JSON_LITERAL","value" : "value"},"sortOrder" : {"type" : "JSON_LITERAL","value" : "desc"},"filterConfigurations": {"type": "JSON_LITERAL","value": []},"cacheExpirationTime": {"type": "JSON_LITERAL","value": "86400"},"invalidateCacheEntry": {"type": "JSON_LITERAL","value": false},"useDataCache": {"type": "JSON_LITERAL","value": false},"additionalKey": {"type": "JSON_LITERAL","value": ""}},"readEvaluationMode" : "EAGER"}, {"cachePolicy" : null,"definition" : {"id" : "546cccd25310101024e5ddeeff7b123b","type" : "GRAPHQL"},"dependencies" : { },"elementId" : "mid_server_count","elementLabel" : "MID Server Count","eventMappings" : [ {"eventMappingId" : "clfdiiapggzaaddjjpddbhhudfixueyw","isConfiguration" : false,"offRowStorageId" : null,"sourceEventApiName" : "sn_uxf.DATA_FETCH_SUCCEEDED","sourceEventCorrelationId" : null,"sourceEventDefinition" : {"apiName" : "sn_uxf.DATA_FETCH_SUCCEEDED","id" : null,"type" : "UXEVENT"},"sourceEventSysId" : null,"targets" : [ {"broker" : null,"clientScript" : null,"conditional" : null,"declarativeAction" : null,"event" : {"apiName" : "sn_uxf.MACROPONENT_STATE_UPDATE_REQUESTED","payload" : {"type" : "MAP_CONTAINER","container" : {"propName" : {"type" : "JSON_LITERAL","value" : "mid_server_count"},"value" : {"type" : "DATA_OUTPUT_BINDING","binding" : {"address" : [ "mid_server_count", "output", "data", "GlideAggregate_Query", "0", "count" ]}}}},"sysId" : "32408b42ff7a10109046e490703bf176"},"operation" : null,"targetId" : "clfdiiapggzaaddjjqddbhhuiipxjjudtii","type" : "EVENT"} ]} ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "ecc_agent"},"encodedQuery" : {"type" : "STATE_BINDING","binding" : {"address" : [ "search_query" ]}},"groupBy" : {"type" : "JSON_LITERAL","value" : ""},"orderBy" : {"type" : "JSON_LITERAL","value" : ""},"having" : {"type" : "JSON_LITERAL","value" : null},"sumField" : {"type" : "JSON_LITERAL","value" : ""},"maxField" : {"type" : "JSON_LITERAL","value" : ""},"minField" : {"type" : "JSON_LITERAL","value" : ""},"avgField" : {"type" : "JSON_LITERAL","value" : ""},"queryCategory" : {"type" : "JSON_LITERAL","value" : null},"returnRowCount" : {"type" : "JSON_LITERAL","value" : true}},"readEvaluationMode" : "EAGER"}, {"cachePolicy" : null,"definition" : {"id" : "b997a84053021010cbc2ddeeff7b1228","type" : "COMPOSITE"},"dependencies" : { },"elementId" : "mid_server_records_refresh_helper","elementLabel" : "MID Server Records Refresh Helper","eventMappings" : [ {"eventMappingId" : "clfjxhhddlkaaccqiddbhhulcrmlhhgo","isConfiguration" : false,"offRowStorageId" : null,"sourceEventApiName" : "sn_uxf.DATA_FETCH_SUCCEEDED","sourceEventCorrelationId" : null,"sourceEventDefinition" : {"apiName" : "sn_uxf.DATA_FETCH_SUCCEEDED","id" : null,"type" : "UXEVENT"},"sourceEventSysId" : null,"targets" : [ {"broker" : null,"clientScript" : {"sysId" : "8b561b64537921101423ddeeff7b12b5"},"conditional" : null,"declarativeAction" : null,"event" : null,"operation" : null,"targetId" : "clfjxhhddlkaaccqjddbhhublwccqaafft","type" : "CLIENT_SCRIPT"} ]} ],"inputValues" : {"table" : {"type" : "JSON_LITERAL","value" : "ecc_agent"},"encodedQuery" : {"type" : "JSON_LITERAL","value" : ""},"returnFields" : {"type" : "JSON_LITERAL","value" : "name"},"orderBy" : {"type" : "JSON_LITERAL","value" : "name"},"sortType" : {"type" : "JSON_LITERAL","value" : "asc"},"limit" : {"type" : "JSON_LITERAL","value" : "1"},"offset" : {"type" : "JSON_LITERAL","value" : null},"queryCategory" : {"type" : "JSON_LITERAL","value" : ""},"returnFieldMetadata" : {"type" : "JSON_LITERAL","value" : false}},"readEvaluationMode" : "EAGER"} ]