{ "dashboards": { "dashboard-1659627000741": { "name": "DLA User Trending", "description": "Review and analyze any customer trends within the environment to enhance customer experience within VDI \n\nDate/Time of week, month during the day that certain process, applications and people use specific software or procedures to cause the increased strain on resources.", "publish": true, "system": false, "sort_order": "-90", "grid": [ { "x": 0, "y": 0, "width": 3, "height": 2, "vid": 1659627047375, "wid": "widget-1659651408710" }, { "x": 3, "y": 0, "width": 3, "height": 2, "vid": 1659627048348, "wid": "widget-1659651413644" }, { "x": 6, "y": 0, "width": 3, "height": 2, "vid": 1659627110471, "wid": "widget-1659651418505" }, { "x": 9, "y": 0, "width": 3, "height": 2, "vid": 1659627111414, "wid": "widget-1659651422775" }, { "x": 0, "y": 2, "width": 3, "height": 3, "vid": 1659726536958, "wid": "multitable-1659725791125" }, { "x": 3, "y": 2, "width": 3, "height": 3, "vid": 1659726537994, "wid": "widget-1659726231265" }, { "x": 6, "y": 2, "width": 3, "height": 3, "vid": 1659726538469, "wid": "widget-1659726335397" }, { "x": 9, "y": 2, "width": 3, "height": 3, "vid": 1659726538867, "wid": "widget-1659726378645" }, { "x": 0, "y": 5, "width": 3, "height": 3, "vid": 1659652931727, "wid": "widget-1659822158642" }, { "x": 3, "y": 5, "width": 3, "height": 3, "vid": 1659650693819, "wid": "widget-1659822196545" }, { "x": 6, "y": 5, "width": 3, "height": 3, "vid": 1659650694182, "wid": "widget-1659822219173" }, { "x": 9, "y": 5, "width": 3, "height": 3, "vid": 1659650693493, "wid": "widget-1659822243707" } ], "id": "dashboard-1659627000741", "apistring": "", "autoload": true, "lastsave": 1659800158824, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1659822761948, "created": 1659627036451 }, "status": "saved" } }, "widgets": { "widget-1659651408710": { "type": "amchart_bar", "options": { "apistring": "{\n\"unbasis\": \"users,machines,machine_groups,user_groups,current_host,datastore,datastore_type,o_s_version\",\n\"resolution\":\"day\",\n\"sort_col\":\"end_date\"\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": "CPU % by Day (Follows Date)", "system": "false", "description": "Trends machine CPU usage", "group": "DLA Trending", "datasource": "data-1510958638475", "dcolumn": "cpu_used_percent", "scolumn": "cpu_used_percent", "sort_order": "2", "displaycols": [ "cpu_used_percent", "cpu_used_mhz", "cpu_queue_length_avg", "total_cores_cpus", "sum_total_cores_cpus", "sum_cpu_allocated_mhz", "node_count", "user_count" ], "h_limit": "80", "m_limit": "20", "l_limit": "0", "locked": true, "override": true, "lastsave": 1659656147865, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1660233635657, "created": 1660233635657 } }, "widget-1659651413644": { "type": "amchart_bar", "options": { "apistring": "{\n\"unbasis\": \"users,machines,machine_groups,user_groups,current_host,datastore,datastore_type,o_s_version\",\n\"resolution\":\"day\",\n\"sort_col\":\"end_date\"\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": "Memory % by Day (Follows Date)", "system": "false", "description": "Trends machine Memory usage", "group": "DLA Trending", "datasource": "data-1510958638475", "dcolumn": "memory_used_percent", "scolumn": "memory_used_percent", "sort_order": "2", "displaycols": [ "memory_used_percent", "memory_allocated_mb", "memory_used_mb", "sum_memory_allocated_mb", "sum_memory_used_mb", "node_count", "user_count" ], "h_limit": "80", "m_limit": "20", "l_limit": "0", "locked": true, "override": true, "lastsave": 1659656184674, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1660233664878, "created": 1660233664878 } }, "widget-1659651418505": { "type": "amchart_bar", "options": { "apistring": "{\n\"unbasis\": \"users,machines,machine_groups,user_groups,current_host,datastore,datastore_type,o_s_version\",\n\"resolution\":\"day\",\n\"sort_col\":\"end_date\"\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": "Disk IO KBs by Day (Follows Date)", "system": "false", "description": "Trends machine Disk usage", "group": "DLA Trending", "datasource": "data-1510958638475", "dcolumn": "total_io_bps", "scolumn": "total_io_bps", "sort_order": "2", "displaycols": [ "disk_utilization_percent_avg", "total_io_bps", "total_iops", "disk_queue_avg", "disk_response_time_ms_avg", "node_count", "user_count", "disk_count" ], "h_limit": "80", "m_limit": "20", "l_limit": "0", "locked": true, "override": true, "lastsave": 1659656216557, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1660233697766, "created": 1660233697766 } }, "widget-1659651422775": { "type": "amchart_bar", "options": { "apistring": "{\n\"unbasis\": \"users,machines,machine_groups,user_groups,current_host,datastore,datastore_type,o_s_version\",\n\"resolution\":\"day\",\n\"sort_col\":\"end_date\"\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": "Network IO KBs by Day (Follows Date)", "system": "false", "description": "Trends machine Network usage", "group": "DLA Trending", "datasource": "data-1510958638475", "dcolumn": "net_total_bps", "scolumn": "net_total_bps", "sort_order": "2", "displaycols": [ "net_total_bps", "network_latency_ms_avg", "failed_connects", "node_count", "user_count", "nic_count" ], "h_limit": "80", "m_limit": "20", "l_limit": "0", "locked": true, "override": true, "lastsave": 1659656203233, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1660233728193, "created": 1660233728193 } }, "multitable-1659725791125": { "type": "multitable", "options": { "tables": [ "widget-1659655563661", "widget-1659650259201", "widget-1659652359948" ] }, "title": "CPU Trending", "description": "Shows CPU Top Users Following Date, Trending Last 7 & Last 90", "group": "DLA Trending", "lastsave": 1659824795655, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1659824901662, "created": 1659824901662 } }, "widget-1659655563661": { "type": "table", "options": { "apistring": "{\n\"unbasis\": \"users,machines,machine_groups,user_groups,current_host,datastore,datastore_type,o_s_version\",\n\"resolution\":\"hourly\",\n\"sort_col\":\"end_date\"\n}", "sortable": true, "pagination": false, "plimit": false, "condensed": true, "searching": false, "enable360": true, "limithighlight": true, "good_bgcolor": "#eaeaea", "good_txtcolor": "#000000", "fair_bgcolor": "rgba(255,161,0,0.53)", "fair_txtcolor": "#000000", "poor_bgcolor": "rgba(230,137,134,0.76)", "poor_txtcolor": "#000000", "reverse": false }, "title": "0042. CPU Trending Hourly (Follows Date)", "system": "false", "description": "Shows CPU information trended hourly", "group": "DLA Trending", "datasource": "data-1510958638475", "dcolumn": "cpu_used_percent", "scolumn": "cpu_used_percent", "sort_order": "2", "displaycols": [ "cpu_used_percent", "cpu_used_mhz", "cpu_queue_length_avg" ], "h_limit": "90", "m_limit": "80", "l_limit": "0", "locked": true, "override": true, "lastsave": 1659823064442, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1659823848934, "created": 1659823848934 } }, "widget-1659650259201": { "type": "table", "options": { "apistring": "{\n\"unbasis\": \"users,machines,machine_groups,user_groups,current_host,datastore,datastore_type,o_s_version\",\n\"date\":\"Last 7 days\",\n\"resolution\":\"dow\",\n\"sort_col\":\"end_date\"\n}", "sortable": true, "pagination": false, "plimit": false, "condensed": true, "searching": false, "enable360": true, "limithighlight": true, "good_bgcolor": "#eaeaea", "good_txtcolor": "#000000", "fair_bgcolor": "rgba(255,161,0,0.53)", "fair_txtcolor": "#000000", "poor_bgcolor": "rgba(230,137,134,0.76)", "poor_txtcolor": "#000000", "reverse": false }, "title": "0044. CPU Trending Last 7 Days", "system": "false", "description": "Shows CPU information trended by day last 7 days", "group": "DLA Trending", "datasource": "data-1510958638475", "dcolumn": "cpu_used_percent", "scolumn": "cpu_used_percent", "sort_order": "2", "displaycols": [ "cpu_used_percent", "cpu_used_mhz", "cpu_queue_length_avg" ], "h_limit": "90", "m_limit": "80", "l_limit": "0", "locked": true, "override": true, "lastsave": 1659821928895, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1659823083227, "created": 1659823083227 } }, "widget-1659652359948": { "type": "table", "options": { "apistring": "{\n\"unbasis\": \"users,machines,machine_groups,user_groups,current_host,datastore,datastore_type,o_s_version\",\n\"date\":\"last 90 days\",\n\"resolution\":\"month\",\n\"sort_col\":\"end_date\"\n}", "sortable": true, "pagination": false, "plimit": false, "condensed": true, "searching": false, "enable360": true, "limithighlight": true, "good_bgcolor": "#eaeaea", "good_txtcolor": "#000000", "fair_bgcolor": "rgba(255,161,0,0.53)", "fair_txtcolor": "#000000", "poor_bgcolor": "rgba(230,137,134,0.76)", "poor_txtcolor": "#ffffff", "reverse": false }, "title": "0045. CPU Trending 90 Days", "system": "false", "description": "Shows CPU information trended by month last 90 days", "group": "DLA Trending", "datasource": "data-1510958638475", "dcolumn": "cpu_used_percent", "scolumn": "cpu_used_percent", "sort_order": "2", "displaycols": [ "cpu_used_percent", "cpu_used_mhz", "cpu_queue_length_avg" ], "h_limit": "90", "m_limit": "80", "l_limit": "0", "locked": true, "override": true, "lastsave": 1659821941567, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1659823094571, "created": 1659823094571 } }, "widget-1659726231265": { "type": "multitable", "options": { "tables": [ "widget-1659655567262", "widget-1659650265058", "widget-1659652366969" ] }, "title": "Memory Trending", "description": "Shows Memory Top Users Following Date, Trending Last 7 & Last 90", "group": "DLA Trending", "lastsave": 1659824754267, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1659824910893, "created": 1659824910893 } }, "widget-1659726335397": { "type": "multitable", "options": { "tables": [ "widget-1659655569795", "widget-1659650268826", "widget-1659652371026" ] }, "title": "Disk Trending", "description": "Shows Disk Top Users Following Date, Trending Last 7 & Last 90", "group": "DLA Trending", "lastsave": 1659824739391, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1659824919275, "created": 1659824919275 } }, "widget-1659726378645": { "type": "multitable", "options": { "tables": [ "widget-1659655572586", "widget-1659650271563", "widget-1659652375023" ] }, "title": "Network Trending", "description": "Shows Network Top Users Following Date, Trending Last 7 & Last 90", "group": "DLA Trending", "lastsave": 1659824691320, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1659824928695, "created": 1659824928695 } }, "widget-1659822158642": { "type": "multitable", "options": { "tables": [ "widget-1659652064941", "widget-1659823927417", "widget-1659650259201", "widget-1659652359948" ] }, "title": "CPU by User & Trending", "description": "Shows CPU Top Users Following Date, Yesterday, Last 7 & Last 90", "group": "DLA Trending", "lastsave": 1659824257529, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1659824560633, "created": 1659824560633 } }, "widget-1659822196545": { "type": "multitable", "options": { "tables": [ "widget-1659652075189", "widget-1659823933165", "widget-1659650265058", "widget-1659652366969" ] }, "title": "Memory by User & Trending", "description": "Shows Memory Top Users Following Date, Yesterday, Last 7 & Last 90", "group": "DLA Trending", "lastsave": 1659824308137, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1659824552298, "created": 1659824552298 } }, "widget-1659822219173": { "type": "multitable", "options": { "tables": [ "widget-1659652093810", "widget-1659823939168", "widget-1659650268826", "widget-1659652371026" ] }, "title": "Disk by User & Trending", "description": "Shows Disk Top Users Following Date, Trending Last 7 & Last 90", "group": "DLA Trending", "lastsave": 1659824360448, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1659824541564, "created": 1659824541564 } }, "widget-1659822243707": { "type": "multitable", "options": { "tables": [ "widget-1659652097317", "widget-1659823944690", "widget-1659650271563", "widget-1659652375023" ] }, "title": "Network by User & Trending", "description": "Shows Network Top Users Following Date, Trending Last 7 & Last 90", "group": "DLA Trending", "lastsave": 1659824412109, "header": { "creator": "dbieneman", "creatorid": 182, "lastupdated": 1659824534068, "created": 1659824534068 } } }, "datasources": { "data-1510958638475": { "title": "User Name Details", "system": true, "description": "Queries an extended set of metrics from User, Machine, Current vHost, Datastore.", "group": "Default User Name", "apistring": { "inspector": "0", "date": "Today", "resolution": "All", "basis": "users,machines,machine_groups,user_groups,current_host,datastore,datastore_type,o_s_version,vhost", "unbasis": "machines,machine_groups,user_groups,current_host,datastore,datastore_type,o_s_version", "sort_col": "rank_score", "sort_order": "2", "columns": "score,rank_score,overall_fit_rating_avg,overall_ux_rating_avg,login_delay_avg,application_load_time_avg,non_responding_apps,gpu_percent_used,d_gpu_mem_used_percent,cpu_used_percent,memory_used_percent,page_used_percent,disk_utilization_percent_avg,disk_used_percent,cpu_allocated_mhz,cpu_used_mhz,cpu_sys_mhz,cpu_user_mhz,memory_allocated_mb,memory_used_mb,cache_memory_used_mb,page_allocated_mb,page_used_mb,disk_size_gb,disk_used_gb,total_io_bps,total_iops,net_total_bps,network_latency_ms_avg,avg_inc_nrt,failed_connects,cpu_queue_length_avg,cpu_context_switching_avg,total_cores_cpus,cpu_io_wait_avg,gdi_objects,swap_page_faults,page_faults,disk_queue_avg,disk_response_time_ms_avg,nfs_read_latency_avg,nfs_write_latency_avg,gpu_decoder_percent_avg,gpu_encoder_percent_avg,gpu_encoder_percent_max,gpu_decoder_percent_max,d_fanspeed,d_framebuffer,d_availmemavg,d_gpu_mem_used,d_thermalavg,sum_total_cores_cpus,sum_cpu_allocated_mhz,sum_cpu_used_mhz,sum_cpu_sys_mhz,sum_cpu_user_mhz,sum_memory_allocated_mb,sum_memory_used_mb,sum_page_allocated_mb,sum_page_used_mb,sum_disk_size_gb,sum_disk_used_gb,sum_total_io,sum_net_total_bytes,sum_nic_count,sum_disk_count,peak2_cpu_percent,peak2_cpu_used_mhz_percent,peak2_cpu_used_mhz,peak2_cpu_used_mhz_count,peak2_memory_percent,peak2_memory_used_mb,peak2_memory_used_mb_percent,peak2_memory_used_mb_count,peak2_total_iops,peak2_total_iops_percent,peak2_iops_count_combo,peak2_read_iops,peak2_read_iops_percent,peak2_read_iops_count,peak2_write_iops,peak2_write_iops_percent,peak2_write_iops_count,peak2_total_io_bps,peak2_total_io_percent,peak2_io_count_combo,peak2_read_io_bps,peak2_read_io_percent,peak2_read_io_count,peak2_write_io_bps,peak2_write_io_percent,peak2_write_io_count,peak2_receive_bps,peak2_receive_percent,peak2_receive_count,peak2_send_bps,peak2_send_percent,peak2_send_count,vh_cpu_usagemhz_megahertz_average,vh_cpu_usage_percent_avg,vh_cpu_ready_millisecond_summation,vh_cpu_costop_millisecond_summation,vh_cpu_latency_percent_average,vh_mem_active_kilobytes_average,vh_mem_usage_percent_average,vh_mem_swapin_kilobytes_average,vh_mem_swapout_kilobytes_average,vh_mem_swapinrate_kilobytespersecond_average,vh_mem_swapoutrate_kilobytespersecond_average,vh_net_usage_kilobytespersecond_average,vh_net_bytestx_kilobytespersecond_average,vh_net_bytesrx_kilobytespersecond_average,vh_net_packetsrx_number_summation,vh_net_packetstx_number_summation,vh_net_droppedrx_number_summation,vh_net_droppedtx_number_summation,vh_net_errorsrx_number_summation,vh_net_errorstx_number_summation,vmhost_count,login_count,logout_count,node_count,user_count,disk_count,nic_count,ip_addr_count,is_vm_count,cid_version_count,date_count,cid_seconds_avg,cid_seconds,up_time_percent,record_count", "limit": "100", "commas": "1", "percents": "1", "units": "1", "rating": "2" }, "lastsave": 1556141354913, "header": { "lastupdated": 1617391237373, "creator": "ssadmin", "creatorid": 2, "created": 1617391237373 }, "publish": true } } }