{
"dashboards": {
"dashboard-1635466474666": {
"name": "Salesforce Analysis",
"description": "Shows the Salesforce Latency Test",
"publish": true,
"system": false,
"sort_order": "100",
"grid": [
{
"x": 0,
"y": 0,
"width": 6,
"height": 2,
"vid": 1635474586331,
"wid": "widget-1635474660679"
},
{
"x": 6,
"y": 0,
"width": 6,
"height": 11,
"vid": 1635466532856,
"wid": "widget-1635391824183"
},
{
"x": 0,
"y": 2,
"width": 2,
"height": 2,
"vid": 1635477676159,
"wid": "widget-1635477491911"
},
{
"x": 2,
"y": 2,
"width": 2,
"height": 2,
"vid": 1635478304575,
"wid": "amchart_bar-1635478414934"
},
{
"x": 4,
"y": 2,
"width": 2,
"height": 2,
"vid": 1635478303886,
"wid": "amchart_bar-1635478083853"
},
{
"x": 0,
"y": 4,
"width": 6,
"height": 7,
"vid": 1635474518470,
"wid": "table-1635474389140"
}
],
"id": "dashboard-1635466474666",
"apistring": "",
"autoload": true,
"lastsave": 1635484786946,
"header": {
"creator": "dbieneman",
"creatorid": 182,
"lastupdated": 1636096138961,
"created": 1635466530138
},
"status": "saved"
}
},
"widgets": {
"widget-1635474660679": {
"type": "html",
"options": {
"type": "html",
"options": "simple",
"html": "Use the table data to identify possible UX issues for Users accessing Salesforce.com. Use the graph to visualize the User, Machine, Application accessing Salesforce.com resources.
To Focus the SanKey Graph and Table on a Specific User, Machine, IP, etc.:
1. Click the Search on the MAIN dashboard toolbar.
2. Enter in a search term into the appropriate lookup basis.
3. Click GO.
"
},
"title": "Salesforce Analysis",
"description": "Use the table data to identify possible UX issues for Users accessing Salesforce.com.\nUse the graph to visualize the User, Machine, Application accessing Salesforce.com resources.",
"group": "db",
"lastsave": 1635479672140,
"header": {
"creator": "dbieneman",
"creatorid": 182,
"lastupdated": 1635483518370,
"created": 1635483518370
}
},
"widget-1635391824183": {
"type": "amchart_sankey",
"options": {
"apistring": "{\n\"sort_col\":\"pn_avg_ping_latency_ms\",\n\"pn_remote_domain\":\"*salesforce.com*\",\n\"only_process\":\"user\",\n\"filter\":\"user_name not ilike 'no_login_user'\"\n}",
"type": "sankey",
"basis1": "pn_remote_domain",
"basis2": "pn_remote_ip",
"basis3": "process_name",
"basis4": "owner_name",
"limit": "50",
"datasort": "none",
"chartStyle": "solid",
"addExport": true,
"hideLabels": false,
"showSortMetric": true
},
"title": "Salesforce Slowest Latency - Domain > IP > Process > User - Max 50 ",
"system": "false",
"description": "Shows the relationship and distribution of Machines to destination domain Salesforce.com and it's IP addresses.",
"group": "db",
"datasource": "data-1635379088424",
"sort_order": "2",
"locked": true,
"override": true,
"lastsave": 1637741437315,
"header": {
"creator": "dbieneman",
"creatorid": 182,
"lastupdated": 1637741729677,
"created": 1637741729677
}
},
"widget-1635477491911": {
"type": "amchart_bar",
"options": {
"apistring": "{\n\"ping_name\":\"salesforce.com\",\n \"only_process\":\"user\",\n \"resolution\":\"day-hour\",\n \"unbasis\": \"users,machines,machine_groups,user_groups,vm_type,external_ip\",\n \"sort_col\":\"end_date\",\n \"filter\":\"(ping_avg_ms gt 0) and (user_name not ilike 'no_login_user')\"\n\n}",
"type": "bar",
"info": true,
"barColor": "#3d93cb",
"negBarColor": "#bf807e",
"stacked": false,
"dcolumn2": "",
"barColor2": "#33cc95",
"dcolumn3": "",
"barColor3": "#a433cc",
"good_label": "GOOD",
"fair_label": "FAIR",
"poor_label": "POOR",
"good_txtcolor": "#94c894",
"fair_txtcolor": "#cdc782",
"poor_txtcolor": "#bf807e"
},
"title": "Salesforce.com Latency (Avg)",
"system": "false",
"description": "Shows the desktop network latency to Salesforce.com.",
"group": "db",
"datasource": "data-1606944256685",
"dcolumn": "ping_avg_ms",
"scolumn": "ping_avg_ms",
"sort_order": "2",
"displaycols": [
"end_date",
"ping_avg_ms",
"ping_min_ms",
"ping_peak_ms",
"ping_packets_sent_sum",
"ping_packets_lost_sum",
"ping_packet_lost_percent",
"node_count",
"user_count"
],
"h_limit": "0",
"m_limit": "0",
"l_limit": "0",
"locked": true,
"override": true,
"lastsave": 1635836106263,
"header": {
"creator": "dbieneman",
"creatorid": 182,
"lastupdated": 1635881552063,
"created": 1635881552063
}
},
"amchart_bar-1635478414934": {
"type": "amchart_bar",
"options": {
"apistring": "{\n\"ping_name\":\"salesforce.com\",\n \"only_process\":\"user\",\n \"resolution\":\"all\",\n \"unbasis\": \"machine_groups,user_groups,vm_type,external_ip\",\n\"sort_col\":\"ping_avg_ms\",\n\"filter\":\"ping_avg_ms gt 0\"\n}",
"type": "bar",
"info": true,
"barColor": "#85b0dd",
"negBarColor": "#f04040",
"stacked": false,
"dcolumn2": "",
"barColor2": "#33cc95",
"dcolumn3": "",
"barColor3": "#a433cc",
"good_label": "GOOD",
"fair_label": "FAIR",
"poor_label": "POOR",
"good_txtcolor": "#5cb85c",
"fair_txtcolor": "#f0ad4e",
"poor_txtcolor": "#d9534f"
},
"title": "Salesforce.com Latency (User)",
"system": "false",
"description": "Shows the desktop network latency to Salesforce.com.",
"group": "db",
"datasource": "data-1606944256685",
"dcolumn": "ping_avg_ms",
"scolumn": "ping_avg_ms",
"sort_order": "2",
"displaycols": [
"ping_avg_ms",
"ping_min_ms",
"ping_peak_ms",
"ping_packets_sent_sum",
"ping_packets_lost_sum",
"ping_packet_lost_percent",
"node_count",
"user_count",
"cid_seconds_avg",
"cid_seconds",
"up_time_percent",
"record_count"
],
"h_limit": "0",
"m_limit": "0",
"l_limit": "0",
"locked": true,
"override": true,
"lastsave": 1635539552358,
"header": {
"creator": "dbieneman",
"creatorid": 182,
"lastupdated": 1635539656092,
"created": 1635539656092
}
},
"amchart_bar-1635478083853": {
"type": "amchart_bar",
"options": {
"apistring": "{\n\"ping_name\":\"salesforce.com\",\n \"only_process\":\"user\",\n \"resolution\":\"all\",\n \"unbasis\": \"machine_groups,user_groups,vm_type,external_ip\",\n \"sort_col\":\"ping_packet_lost_percent \",\n \"filter\":\"(ping_packet_lost_percent gt 0) and (user_name not ilike 'no_login_user')\"\n\n\n}",
"type": "bar",
"info": true,
"barColor": "#bf807e",
"negBarColor": "#85b0dd",
"stacked": false,
"dcolumn2": "",
"barColor2": "#33cc95",
"dcolumn3": "",
"barColor3": "#a433cc",
"good_label": "GOOD",
"fair_label": "FAIR",
"poor_label": "POOR",
"good_txtcolor": "#5cb85c",
"fair_txtcolor": "#f0ad4e",
"poor_txtcolor": "#d9534f"
},
"title": "Salesforce.com Packet Loss (User)",
"system": "false",
"description": "Shows the desktop network packet loss to Salesforce.com.",
"group": "db",
"datasource": "data-1606944256685",
"dcolumn": "ping_packet_lost_percent",
"scolumn": "ping_packet_lost_percent",
"sort_order": "2",
"displaycols": [
"ping_packets_lost_sum",
"ping_packet_lost_percent"
],
"h_limit": "0",
"m_limit": "0",
"l_limit": "0",
"locked": true,
"override": true,
"lastsave": 1635834390251,
"header": {
"creator": "dbieneman",
"creatorid": 182,
"lastupdated": 1635881622446,
"created": 1635881622446
}
},
"table-1635474389140": {
"type": "table",
"options": {
"apistring": "{\n\"pn_remote_domain\":\"*salesforce.com*\",\n\"only_process\":\"user\"\n}\n",
"sortable": true,
"condensed": true,
"searching": true,
"enable360": true,
"limithighlight": true,
"good_bgcolor": "#94c894",
"good_txtcolor": "#ffffff",
"fair_bgcolor": "#cdc782",
"fair_txtcolor": "#ffffff",
"poor_bgcolor": "#bf807e",
"poor_txtcolor": "#ffffff",
"reverse": false
},
"title": "Salesforce - Owner > Process > Domain > IP",
"system": "false",
"description": "Shows the Users (Owners), Processes and Applications that accessed Salesforce.com. ",
"group": "db",
"datasource": "data-1635379088424",
"dcolumn": "pn_avg_ping_latency_ms",
"scolumn": "pn_avg_ping_latency_ms",
"sort_order": "2",
"displaycols": [
"pn_avg_ping_latency_ms",
"pn_jitter_avg",
"pn_total_io_kb",
"pn_total_send_kb",
"pn_total_receive_kb",
"pn_byte_loss_percent",
"pn_pkt_loss_percent",
"pn_send_count_total_sum",
"pn_receive_count_total_sum",
"desk_app_process_elevated",
"os_count",
"owner_count",
"pid_count",
"score",
"rank_score",
"sum_pr_seconds",
"pr_seconds"
],
"h_limit": "250",
"m_limit": "125",
"l_limit": "0",
"locked": true,
"override": true,
"lastsave": 1636522921793,
"header": {
"creator": "dbieneman",
"creatorid": 182,
"lastupdated": 1636522989465,
"created": 1636522989465
}
}
},
"datasources": {
"data-1635379088424": {
"title": "Application Name Process Network IP",
"system": "false",
"description": "Queries the Application names with destination \"remote\" IPs and the related TCP IO metrics.",
"group": "db",
"apistring": {
"inspector": "1",
"basis": "users,owner_name,machines,machine_groups,user_groups,external_ip,application_name,application_version,process_name,pn_remote_domain,pn_remote_ip",
"unbasis": "users,application_name,application_version,machine_groups,user_groups,external_ip",
"xpn_remote_port": "!=0",
"sort_col": "pn_avg_ping_latency_ms",
"sort_order": "2",
"only_process": "both",
"date": "Today",
"resolution": "All",
"limit": "1000",
"columns": "pn_avg_ping_latency_ms,pn_jitter_avg,pn_total_io_kb,pn_total_send_kb,pn_total_receive_kb,pn_byte_loss_percent,pn_pkt_loss_percent,pn_send_count_total_sum,pn_receive_count_total_sum,desk_app_process_elevated,os_count,owner_count,pid_count,score,rank_score,sum_pr_seconds,pr_seconds",
"rating": "2"
},
"lastsave": 1635953472443,
"header": {
"creator": "dbieneman",
"creatorid": 182,
"lastupdated": 1635967873524,
"created": 1635967873524
}
},
"data-1606944256685": {
"title": "Latency Test",
"system": "false",
"description": "Shows the Latency Test metrics.",
"group": "db",
"apistring": {
"inspector": "0",
"basis": "ping_name,ping_ip,machines,users,machine_groups,user_groups,vm_type,external_ip",
"unbasis": "machine_groups,user_groups,vm_type,external_ip",
"date": "today",
"columns": "ping_avg_ms,ping_min_ms,ping_peak_ms,ping_packets_sent_sum,ping_packets_lost_sum,ping_packet_lost_percent,node_count,user_count,cid_seconds_avg,cid_seconds,up_time_percent,record_count",
"sort_col": "record_count",
"sort_order": "2",
"rating": "2",
"percents": "1",
"units": "1",
"commas": "1",
"resolution": "All"
},
"lastsave": 1649708468087,
"header": {
"creator": "dbieneman",
"creatorid": 182,
"lastupdated": 1649780489505,
"created": 1649780489505
}
}
}
}