Download OpenAPI specification:Download
{- "data": [
- {
- "datasourceType": "lxt-broadsoft-collector-ftp",
- "description": "Remote Broadsoft Collector (FTP)",
- "fields": [
- {
- "key": "host",
- "value": "127.0.0.1",
- "isEditable": true
}, - {
- "key": "port",
- "value": "22",
- "isEditable": true
}, - {
- "key": "username",
- "value": "",
- "isEditable": true
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "password": true,
- "hidden": true,
- "isEditable": true
}
]
}, - {
- "datasourceType": "lxt-druid-lxt",
- "description": "Remote Druid Datastore (lxt)",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "host",
- "value": "127.0.0.1",
- "isEditable": true
}, - {
- "key": "port",
- "value": "8082",
- "isEditable": true
}, - {
- "key": "kafka_ip",
- "value": "10.1.1.1",
- "isEditable": false
}, - {
- "key": "kafka_datasource",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}
]
}, - {
- "datasourceType": "lxt-ndx",
- "description": "Ndx",
- "fields": [
- {
- "key": "ipaddress",
- "value": "127.0.0.1",
- "isEditable": true
}, - {
- "key": "14424",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}
]
}, - {
- "datasourceType": "lxt-postgres-arb",
- "description": "Remote Arbitrator Postgres Database",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "host",
- "value": "localhost",
- "isEditable": true
}, - {
- "key": "port",
- "value": "5432",
- "isEditable": true
}, - {
- "key": "dbname",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "username",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "password": true,
- "hidden": true,
- "isEditable": false
}, - {
- "key": "device_description",
- "value": "arbitrator",
- "isEditable": false
}
]
}, - {
- "datasourceType": "lxt-postgres-ds9-cisco",
- "description": "DS9 Cisco Postgres Database",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "host",
- "value": "localhost",
- "isEditable": true
}, - {
- "key": "port",
- "value": "5432",
- "isEditable": true
}, - {
- "key": "dbname",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "username",
- "value": "lxpublic",
- "isEditable": true
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "password": true,
- "hidden": true,
- "isEditable": true
}, - {
- "key": "device_description",
- "value": "cisco",
- "isEditable": false
}
]
}, - {
- "datasourceType": "lxt-postgres-ds9-snmp",
- "description": "DS9 SNMP Postgres Database",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "host",
- "value": "localhost",
- "isEditable": true
}, - {
- "key": "port",
- "value": "5432",
- "isEditable": true
}, - {
- "key": "dbname",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "username",
- "value": "lxpublic",
- "isEditable": true
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "password": true,
- "hidden": true,
- "isEditable": true
}, - {
- "key": "device_description",
- "value": "snmp",
- "isEditable": false
}
]
}, - {
- "datasourceType": "lxt-postgres-ds9-summary",
- "description": "DS9 SUMMARY Postgres Database",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "host",
- "value": "localhost",
- "isEditable": true
}, - {
- "key": "port",
- "value": "5432",
- "isEditable": true
}, - {
- "key": "dbname",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "username",
- "value": "lxpublic",
- "isEditable": true
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "password": true,
- "hidden": true,
- "isEditable": true
}, - {
- "key": "device_description",
- "value": "summary",
- "isEditable": false
}
]
}, - {
- "datasourceType": "lxt-postgres-ds9-topn",
- "description": "DS9 TOPN Postgres Database",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "host",
- "value": "localhost",
- "isEditable": true
}, - {
- "key": "port",
- "value": "5432",
- "isEditable": true
}, - {
- "key": "dbname",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "username",
- "value": "lxpublic",
- "isEditable": true
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "password": true,
- "hidden": true,
- "isEditable": true
}, - {
- "key": "device_description",
- "value": "topn",
- "isEditable": false
}
]
}, - {
- "datasourceType": "lxt-postgres-impjabber",
- "description": "Postgres IMP Jabber Postgres Database",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "host",
- "value": "localhost",
- "isEditable": true
}, - {
- "key": "port",
- "value": "5432",
- "isEditable": true
}, - {
- "key": "dbname",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "username",
- "value": "",
- "isEditable": true
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "password": true,
- "hidden": true,
- "isEditable": true
}, - {
- "key": "device_description",
- "value": "tcmadb",
- "isEditable": false
}
]
}, - {
- "datasourceType": "lxt-postgres-msteams",
- "description": "Microsoft Teams Online Repository",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "host",
- "value": "localhost",
- "isEditable": true
}, - {
- "key": "port",
- "value": "5432",
- "isEditable": true
}, - {
- "key": "dbname",
- "value": "microsoft",
- "isEditable": true
}, - {
- "key": "username",
- "value": "lxtmsguest",
- "isEditable": true
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "password": true,
- "hidden": true,
- "isEditable": true
}, - {
- "key": "device_description",
- "value": "microsoft",
- "isEditable": false
}
]
}, - {
- "datasourceType": "lxt-postgres-reporter",
- "description": "Remote Dashboard Database",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "host",
- "value": "localhost",
- "isEditable": true
}, - {
- "key": "port",
- "value": "5432",
- "isEditable": true
}, - {
- "key": "dbname",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "username",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "password": true,
- "hidden": true,
- "isEditable": false
}, - {
- "key": "device_description",
- "value": "reporter",
- "isEditable": false
}
]
}, - {
- "datasourceType": "lxt-remote-summary-reporter",
- "description": "Remote Summary Archive Reporter (Requires Port 5432)",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "host",
- "value": "",
- "isEditable": true
}, - {
- "key": "push_interval",
- "options": [
- "hourly",
- "daily",
- "monthly"
], - "value": "hourly",
- "isEditable": true
}, - {
- "key": "max_push_seconds",
- "value": "300",
- "isEditable": true
}, - {
- "key": "port",
- "value": "5432",
- "isEditable": true
}, - {
- "key": "dbname",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "username",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "password": true,
- "hidden": true,
- "isEditable": false
}, - {
- "key": "device_description",
- "value": "reporter",
- "isEditable": false
}
]
}, - {
- "datasourceType": "mssql",
- "description": "Microsoft Sql Server",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "host",
- "value": "localhost",
- "isEditable": true
}, - {
- "key": "port",
- "value": "5432",
- "isEditable": true
}, - {
- "key": "dbname",
- "value": "",
- "isEditable": true
}, - {
- "key": "username",
- "value": "",
- "isEditable": true
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "password": true,
- "hidden": true,
- "isEditable": true
}
]
}, - {
- "datasourceType": "mysql",
- "description": "Mysql Database",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "host",
- "value": "localhost",
- "isEditable": true
}, - {
- "key": "port",
- "value": "5432",
- "isEditable": true
}, - {
- "key": "dbname",
- "value": "",
- "isEditable": true
}, - {
- "key": "username",
- "value": "",
- "isEditable": true
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "password": true,
- "hidden": true,
- "isEditable": true
}
]
}, - {
- "datasourceType": "postgres",
- "description": "Postgres Database",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "host",
- "value": "localhost",
- "isEditable": true
}, - {
- "key": "port",
- "value": "5432",
- "isEditable": true
}, - {
- "key": "dbname",
- "value": "",
- "isEditable": true
}, - {
- "key": "username",
- "value": "",
- "isEditable": true
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "password": true,
- "hidden": true,
- "isEditable": true
}
]
}, - {
- "datasourceType": "sqlite",
- "description": "Sqlite Database",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "dbname",
- "value": "",
- "isEditable": true
}, - {
- "key": "sqlite_dbdir",
- "value": "",
- "isEditable": true
}
]
}, - {
- "datasourceType": "sqlite3",
- "description": "Sqlite3 Database",
- "fields": [
- {
- "key": "driver",
- "value": "_lxt_hidden_",
- "hidden": true,
- "isEditable": false
}, - {
- "key": "dbname",
- "value": "",
- "isEditable": true
}, - {
- "key": "sqlite3_dbdir",
- "value": "",
- "isEditable": true
}
]
}, - {
- "datasourceType": "voss-mongo",
- "description": "Voss Mongo Database",
- "fields": [
- {
- "key": "driver",
- "value": "mongo",
- "isEditable": false,
- "options": null
}, - {
- "key": "ip",
- "value": "localhost",
- "isEditable": true,
- "options": null
}, - {
- "key": "port",
- "value": "27020",
- "isEditable": true,
- "options": null
}, - {
- "key": "db",
- "value": "VOSS",
- "isEditable": true,
- "options": null
}, - {
- "key": "username",
- "value": "admin",
- "isEditable": true,
- "options": null
}, - {
- "key": "authSource",
- "value": "admin",
- "isEditable": true,
- "options": null
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "isEditable": true,
- "password": true,
- "hidden": true,
- "options": null
}, - {
- "key": "ssl",
- "value": "true",
- "isEditable": true,
- "options": [
- "true",
- "false"
]
}, - {
- "key": "hfilter_csv",
- "value": "voss4uc_hierarchy_filters.csv",
- "isEditable": false,
- "hidden": false,
- "options": null
}, - {
- "key": "alias",
- "value": "",
- "isEditable": true,
- "hidden": false,
- "options": null,
- "description": "internal use only"
}
]
}
]
}
{- "data": [
- {
- "guid": "BP2JHJEKX536NMXC1603737241994I3AK5R81G8RCJ0",
- "readOnly": false,
- "name": "PG Microsoft Teams (VOSS Default)",
- "datasource": {
- "datasourceType": "postgres",
- "description": "Postgres Database",
- "fields": [
- {
- "key": "driver",
- "value": "pgsql",
- "isEditable": false,
- "hidden": false,
- "options": null
}, - {
- "key": "host",
- "value": "127.0.0.1",
- "isEditable": true,
- "hidden": false,
- "options": null
}, - {
- "key": "port",
- "value": "5432",
- "isEditable": true,
- "hidden": false,
- "options": null
}, - {
- "key": "dbname",
- "value": "microsoft",
- "isEditable": true,
- "hidden": false,
- "options": null
}, - {
- "key": "username",
- "value": "lxtmsguest",
- "isEditable": true,
- "hidden": false,
- "options": null
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "isEditable": true,
- "hidden": true,
- "options": null
}
]
}
}, - {
- "guid": "IGG9Q8PDLGOPEHDI14744811840034C6HL4Q4PJDNTH",
- "readOnly": false,
- "name": "IMP Push Datasource (Layer X Default)",
- "datasource": {
- "datasourceType": "lxt-postgres-impjabber",
- "description": "Postgres IMP Jabber Database (Arbitrator / Reporter)",
- "fields": [
- {
- "key": "driver",
- "value": "pgsql",
- "isEditable": false,
- "options": null
}, - {
- "key": "host",
- "value": "10.13.37.9",
- "isEditable": true,
- "options": null
}, - {
- "key": "port",
- "value": "",
- "isEditable": false,
- "options": null
}, - {
- "key": "dbname",
- "value": "tcmadb",
- "isEditable": false,
- "options": null
}, - {
- "key": "username",
- "value": "arbguest",
- "isEditable": false,
- "options": null
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "isEditable": false,
- "options": null
}, - {
- "key": "device_description",
- "value": "tcmadb",
- "isEditable": false,
- "options": null
}
]
}
}, - {
- "guid": "LXT0",
- "name": "Local CK Pro Database",
- "readOnly": true,
- "datasource": {
- "datasourceType": "lxt-postgres-reporter",
- "description": "Remote CK Pro Postgres Database",
- "fields": [
- {
- "key": "host",
- "value": "postgres-15-postgresql",
- "isEditable": false
}, - {
- "key": "driver",
- "value": "pgsql",
- "isEditable": false
}, - {
- "key": "dbname",
- "value": "ReporterServices",
- "isEditable": false
}, - {
- "key": "username",
- "value": "insights",
- "isEditable": false
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "isEditable": false
}
]
}
}, - {
- "guid": "LXT1",
- "name": "Local Ndx Search Datasource",
- "readOnly": true,
- "datasource": {
- "datasourceType": "lxt-ndx",
- "description": "Layer X Ndx",
- "fields": [
- {
- "key": "ipaddress",
- "value": "127.0.0.1",
- "isEditable": false
}, - {
- "key": "port",
- "value": "14424",
- "isEditable": false
}
]
}
}, - {
- "guid": "LXT2",
- "name": "tcmadb",
- "readOnly": true,
- "datasource": {
- "datasourceType": "lxt-postgres-impjabber",
- "description": "Postgres IMP Jabber Postgres Database",
- "fields": [
- {
- "key": "host",
- "value": "POSTGRES_DBHOST",
- "isEditable": false
}, - {
- "key": "driver",
- "value": "pgsql",
- "isEditable": false
}, - {
- "key": "dbname",
- "value": "tcmadb",
- "isEditable": false
}, - {
- "key": "username",
- "value": "POSTGRES_USER",
- "isEditable": false
}, - {
- "key": "password",
- "value": "_lxt_hidden_",
- "isEditable": false
}
]
}
}, - {
- "datasource": {
- "fields": [
- {
- "isEditable": false,
- "value": "pgsql",
- "key": "driver"
}, - {
- "isEditable": true,
- "value": "10.13.37.12",
- "key": "host"
}, - {
- "isEditable": false,
- "value": "",
- "key": "port"
}, - {
- "isEditable": false,
- "value": "sca",
- "key": "dbname"
}, - {
- "isEditable": false,
- "value": "arbguest",
- "key": "username"
}, - {
- "isEditable": false,
- "value": "_lxt_hidden_",
- "key": "password"
}, - {
- "isEditable": false,
- "value": "arbitrator",
- "key": "device_description"
}
], - "description": "Remote Arbitrator Postgres Database",
- "datasourceType": "lxt-postgres-arb"
}, - "name": "Arbitrator (Layer X Default)",
- "readOnly": false,
- "guid": "TOBTY8PK4H2LUQMR1407352939052E7RSM4JKSW755W"
}
]
}
Requests widget data for a specific resource.
{
"resource":"arbitrator_ciscocdr",
"resourceGuid":"",
"datasource":"LXT0",
"interval":4,
"timezone":"America/Chicago",
"timezoneOffset":360,"assetIds":[],
"fields": [
{
"guid":"WJDOSP0GRFWIVPTH1610050277189GLN49BS3XJW5XS",
"ruleName":"originalCalledPartyNumber",
"ruleType":0,
"headerName":"originalCalledPartyNumber",
"sort":1,
"operation":"Grouping Count",
"chartType":"line",
"cellFormat":0,
"mapping":null,
"isRatio":false
}
],
"filters":[],
"sorts":[],
"type":16,
"userGuid":"_lxt_created_",
"groupingLimit":10,
"settings":{
"overTime":false,
"dayPagination":true,
"treeTable":false,
"paging":false,
"description":null,"selectionType":0,"hideCount":false,"hideColumns":null,"defaultValue":"","timeFormat":"None","headerVertical":false,"sorting":0,"autoAdjustColumns":0,"paletteType":0,"palettes":[{"column":0,"palette":"_lxt_created_"}],"renderers":[{"guid":"WJDOSP0GRFWIVPTH1610050277189GLN49BS3XJW5XS","fieldName":"originalCalledPartyNumber","operation":"Grouping Count","fieldType":0,"valueType":1,"formatType":0,"chartType":0,"prefix":null,"suffix":null,"colGuid":null,"hideColumn":false,"numType":0,"bbType":0,"dateType":0,"allowEmpty":false,"allowTruthy":false,"floatPrecision":0,"progressMin":0,"progressMax":100,"align":0,"city":null,"region":null,"factor":1,"numberBase":"Base 10 (1000)"}]},"colorPalette":"_lxt_created_","previousJsonFile":"/var/reporter/reports/tmp/widget_2021_01_11_23_05_11_QRQD9TT36W.json","widgetGuid":"XNV6KFN5DORCVIGX16104062921750C2T6UPB85HC0T","widgetName":"sample api","csv_load_file":"/var/reporter/reports/tmp/UJV4EH70OC2KE0OL1610406355769T3VXFT8YUUW0A1.csv"}
userid | string The user id of the user. |
lowerTs | integer The starting timestamp in which to query the data. Expecting an epoch number. |
upperTs | integer The ending timestamp in which to query the data. Expecting an epoch number. |
groupingLimit | integer The data returned may produce too many different groups. Use this parameter to only return the top groups, ordered by count. ie. Top 10. |
limit | integer The data returned may produce too many results. Use this parameter to page through the data. |
offset | integer The data returned may produce too many results. Use this parameter in conjunction with the limit parameter to page through the data. |
chartDto | string ChartInputDto { resource (string): Resource name. This name must match one of the names returned from the "/dashboards/resources" api., userGuid (string): Guid of the user who created the resource., fields (array[FieldDto]): Array of Field Dtos. This list of fields determines the operations performed., filters (array[FieldFilterDto]): Array of Field Filter Dtos. This list of filters defines refines the search to a specific set of values. } FieldDto { ruleName (string): Rule name., operation (string): User selected operation., headerName (string): Custom header name to be displayed to the user. Used in the legend and table columns., sort (integer): Valid values are 0 = Ascending (default), or 1 = Descending., groupBy (boolean): True or False. Set this field to true to show all distinct values in the database. } FieldFilterDto { ruleName (string): Rule name., operation (string): User selected filter operation., filterValue (string): The filter value that was entered by the user. } |
{- "csv_filename": "/var/reporter/reports/tmp/widget__YSEAYVJE9B.csv",
- "csv_load_file": "/var/reporter/reports/tmp/NG3L4NQPESC2QD8A1681271509169PI1HY1VE9CCA0P.csv",
- "data": [
- {
- "data": [
- {
- "key": "Count",
- "value": "3379"
}
], - "fields": [
- "Cisco 7911"
], - "name": "Cisco 7911"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "2077"
}
], - "fields": [
- "Cisco 7941"
], - "name": "Cisco 7941"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "1618"
}
], - "fields": [
- "Cisco Unified Client Services Framework"
], - "name": "Cisco Unified Client Services Framework"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "1365"
}
], - "fields": [
- "Cisco Dual Mode for iPhone"
], - "name": "Cisco Dual Mode for iPhone"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "1016"
}
], - "fields": [
- "Cisco 6911"
], - "name": "Cisco 6911"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "936"
}
], - "fields": [
- "Cisco 7940"
], - "name": "Cisco 7940"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "793"
}
], - "fields": [
- "Cisco 7942"
], - "name": "Cisco 7942"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "497"
}
], - "fields": [
- "Cisco 7931"
], - "name": "Cisco 7931"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "473"
}
], - "fields": [
- "Analog Phone"
], - "name": "Analog Phone"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "290"
}
], - "fields": [
- "Cisco 6921"
], - "name": "Cisco 6921"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "283"
}
], - "fields": [
- "Cisco 9971"
], - "name": "Cisco 9971"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "282"
}
], - "fields": [
- "Cisco 7821"
], - "name": "Cisco 7821"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "257"
}
], - "fields": [
- "Cisco IP Communicator"
], - "name": "Cisco IP Communicator"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "205"
}
], - "fields": [
- "Cisco Dual Mode for Android"
], - "name": "Cisco Dual Mode for Android"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "201"
}
], - "fields": [
- "Cisco 8821"
], - "name": "Cisco 8821"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "201"
}
], - "fields": [
- "Cisco 6941"
], - "name": "Cisco 6941"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "187"
}
], - "fields": [
- "Cisco 8861"
], - "name": "Cisco 8861"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "176"
}
], - "fields": [
- "Cisco 7965"
], - "name": "Cisco 7965"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "125"
}
], - "fields": [
- "Cisco 7961"
], - "name": "Cisco 7961"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "115"
}
], - "fields": [
- "Cisco 7970"
], - "name": "Cisco 7970"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "95"
}
], - "fields": [
- "Cisco 9951"
], - "name": "Cisco 9951"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "80"
}
], - "fields": [
- "Cisco 8851"
], - "name": "Cisco 8851"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "62"
}
], - "fields": [
- "Cisco 7906"
], - "name": "Cisco 7906"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "59"
}
], - "fields": [
- "Cisco 7861"
], - "name": "Cisco 7861"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "58"
}
], - "fields": [
- "Cisco 7841"
], - "name": "Cisco 7841"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "56"
}
], - "fields": [
- "CTI Port"
], - "name": "CTI Port"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "51"
}
], - "fields": [
- "Cisco 8865"
], - "name": "Cisco 8865"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "50"
}
], - "fields": [
- "Cisco 7945"
], - "name": "Cisco 7945"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "49"
}
], - "fields": [
- "Cisco Jabber for Tablet"
], - "name": "Cisco Jabber for Tablet"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "44"
}
], - "fields": [
- "Cisco 7960"
], - "name": "Cisco 7960"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "33"
}
], - "fields": [
- "Cisco 7937"
], - "name": "Cisco 7937"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "30"
}
], - "fields": [
- "Cisco 7975"
], - "name": "Cisco 7975"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "29"
}
], - "fields": [
- "Cisco 8841"
], - "name": "Cisco 8841"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "28"
}
], - "fields": [
- "Cisco VGC Phone"
], - "name": "Cisco VGC Phone"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "16"
}
], - "fields": [
- "CTI Remote Device"
], - "name": "CTI Remote Device"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "15"
}
], - "fields": [
- "Cisco 8945"
], - "name": "Cisco 8945"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "11"
}
], - "fields": [
- "Third-party SIP Device (Basic)"
], - "name": "Third-party SIP Device (Basic)"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "10"
}
], - "fields": [
- "Cisco ATA 186"
], - "name": "Cisco ATA 186"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "10"
}
], - "fields": [
- "Carrier-integrated Mobile"
], - "name": "Carrier-integrated Mobile"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "9"
}
], - "fields": [
- "Cisco 7962"
], - "name": "Cisco 7962"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "7"
}
], - "fields": [
- "Cisco 8961"
], - "name": "Cisco 8961"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "7"
}
], - "fields": [
- "Cisco 6945"
], - "name": "Cisco 6945"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "6"
}
], - "fields": [
- "Cisco 7936"
], - "name": "Cisco 7936"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "6"
}
], - "fields": [
- "Cisco 7912"
], - "name": "Cisco 7912"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "5"
}
], - "fields": [
- "Cisco 7985"
], - "name": "Cisco 7985"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "5"
}
], - "fields": [
- "Cisco 7971"
], - "name": "Cisco 7971"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "4"
}
], - "fields": [
- "Cisco Unified Personal Communicator"
], - "name": "Cisco Unified Personal Communicator"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "4"
}
], - "fields": [
- "Cisco 860"
], - "name": "Cisco 860"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "4"
}
], - "fields": [
- "Cisco 6901"
], - "name": "Cisco 6901"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "3"
}
], - "fields": [
- "Cisco 7905"
], - "name": "Cisco 7905"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "2"
}
], - "fields": [
- "Nokia S60"
], - "name": "Nokia S60"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "2"
}
], - "fields": [
- "Cisco Webex DX80"
], - "name": "Cisco Webex DX80"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "2"
}
], - "fields": [
- "Cisco DX650"
], - "name": "Cisco DX650"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "2"
}
], - "fields": [
- "Cisco ATA 190"
], - "name": "Cisco ATA 190"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "2"
}
], - "fields": [
- "Cisco 8811"
], - "name": "Cisco 8811"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "1"
}
], - "fields": [
- "Third-party SIP Device (Advanced)"
], - "name": "Third-party SIP Device (Advanced)"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "1"
}
], - "fields": [
- "Spectralink IPDECT"
], - "name": "Spectralink IPDECT"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "1"
}
], - "fields": [
- "H.323 Client"
], - "name": "H.323 Client"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "1"
}
], - "fields": [
- "Cisco Cius SP"
], - "name": "Cisco Cius SP"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "1"
}
], - "fields": [
- "Cisco ATA 187"
], - "name": "Cisco ATA 187"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "1"
}
], - "fields": [
- "Cisco 8941"
], - "name": "Cisco 8941"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "1"
}
], - "fields": [
- "Cisco 8831"
], - "name": "Cisco 8831"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "1"
}
], - "fields": [
- "Cisco 7811"
], - "name": "Cisco 7811"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "1"
}
], - "fields": [
- "Cisco 6961"
], - "name": "Cisco 6961"
}, - {
- "data": [
- {
- "key": "Count",
- "value": "1"
}
], - "fields": [
- "Cisco 3905"
], - "name": "Cisco 3905"
}
], - "filename": "",
- "groupingTitle": "ChartDto",
- "interval": 4,
- "is3d": false,
- "isLandscape": false,
- "isOverTime": false,
- "json_filename": "/var/reporter/reports/tmp/widget__YSEAYVJE9B.json",
- "max_timestamp": 0,
- "min_timestamp": 0,
- "query_fields": {
- "Count": {
- "chartType": "line",
- "headerName": "Count",
- "operation": "Sum",
- "ruleName": "count",
- "ruleType": 1
}, - "product": {
- "cellFormat": 0,
- "guid": "Y6WVMGPE5MM1KEH31516898749540JXJ52CYXFORI1K",
- "headerName": "product",
- "isRatio": false,
- "mapping": null,
- "operation": "Grouping Count",
- "ruleName": "product",
- "ruleType": 0,
- "sort": 1
}
}, - "query_max_timestamp": 0,
- "query_min_timestamp": 0,
- "query_results": {
- "rows": [
- {
- "columns": [
- "product",
- "Count"
]
}, - {
- "columns": [
- "Cisco 7911",
- "3379"
]
}, - {
- "columns": [
- "Cisco 7941",
- "2077"
]
}, - {
- "columns": [
- "Cisco Unified Client Services Framework",
- "1618"
]
}, - {
- "columns": [
- "Cisco Dual Mode for iPhone",
- "1365"
]
}, - {
- "columns": [
- "Cisco 6911",
- "1016"
]
}, - {
- "columns": [
- "Cisco 7940",
- "936"
]
}, - {
- "columns": [
- "Cisco 7942",
- "793"
]
}, - {
- "columns": [
- "Cisco 7931",
- "497"
]
}, - {
- "columns": [
- "Analog Phone",
- "473"
]
}, - {
- "columns": [
- "Cisco 6921",
- "290"
]
}, - {
- "columns": [
- "Cisco 9971",
- "283"
]
}, - {
- "columns": [
- "Cisco 7821",
- "282"
]
}, - {
- "columns": [
- "Cisco IP Communicator",
- "257"
]
}, - {
- "columns": [
- "Cisco Dual Mode for Android",
- "205"
]
}, - {
- "columns": [
- "Cisco 8821",
- "201"
]
}, - {
- "columns": [
- "Cisco 6941",
- "201"
]
}, - {
- "columns": [
- "Cisco 8861",
- "187"
]
}, - {
- "columns": [
- "Cisco 7965",
- "176"
]
}, - {
- "columns": [
- "Cisco 7961",
- "125"
]
}, - {
- "columns": [
- "Cisco 7970",
- "115"
]
}, - {
- "columns": [
- "Cisco 9951",
- "95"
]
}, - {
- "columns": [
- "Cisco 8851",
- "80"
]
}, - {
- "columns": [
- "Cisco 7906",
- "62"
]
}, - {
- "columns": [
- "Cisco 7861",
- "59"
]
}, - {
- "columns": [
- "Cisco 7841",
- "58"
]
}, - {
- "columns": [
- "CTI Port",
- "56"
]
}, - {
- "columns": [
- "Cisco 8865",
- "51"
]
}, - {
- "columns": [
- "Cisco 7945",
- "50"
]
}, - {
- "columns": [
- "Cisco Jabber for Tablet",
- "49"
]
}, - {
- "columns": [
- "Cisco 7960",
- "44"
]
}, - {
- "columns": [
- "Cisco 7937",
- "33"
]
}, - {
- "columns": [
- "Cisco 7975",
- "30"
]
}, - {
- "columns": [
- "Cisco 8841",
- "29"
]
}, - {
- "columns": [
- "Cisco VGC Phone",
- "28"
]
}, - {
- "columns": [
- "CTI Remote Device",
- "16"
]
}, - {
- "columns": [
- "Cisco 8945",
- "15"
]
}, - {
- "columns": [
- "Third-party SIP Device (Basic)",
- "11"
]
}, - {
- "columns": [
- "Cisco ATA 186",
- "10"
]
}, - {
- "columns": [
- "Carrier-integrated Mobile",
- "10"
]
}, - {
- "columns": [
- "Cisco 7962",
- "9"
]
}, - {
- "columns": [
- "Cisco 8961",
- "7"
]
}, - {
- "columns": [
- "Cisco 6945",
- "7"
]
}, - {
- "columns": [
- "Cisco 7936",
- "6"
]
}, - {
- "columns": [
- "Cisco 7912",
- "6"
]
}, - {
- "columns": [
- "Cisco 7985",
- "5"
]
}, - {
- "columns": [
- "Cisco 7971",
- "5"
]
}, - {
- "columns": [
- "Cisco Unified Personal Communicator",
- "4"
]
}, - {
- "columns": [
- "Cisco 860",
- "4"
]
}, - {
- "columns": [
- "Cisco 6901",
- "4"
]
}, - {
- "columns": [
- "Cisco 7905",
- "3"
]
}, - {
- "columns": [
- "Nokia S60",
- "2"
]
}, - {
- "columns": [
- "Cisco Webex DX80",
- "2"
]
}, - {
- "columns": [
- "Cisco DX650",
- "2"
]
}, - {
- "columns": [
- "Cisco ATA 190",
- "2"
]
}, - {
- "columns": [
- "Cisco 8811",
- "2"
]
}, - {
- "columns": [
- "Third-party SIP Device (Advanced)",
- "1"
]
}, - {
- "columns": [
- "Spectralink IPDECT",
- "1"
]
}, - {
- "columns": [
- "H.323 Client",
- "1"
]
}, - {
- "columns": [
- "Cisco Cius SP",
- "1"
]
}, - {
- "columns": [
- "Cisco ATA 187",
- "1"
]
}, - {
- "columns": [
- "Cisco 8941",
- "1"
]
}, - {
- "columns": [
- "Cisco 8831",
- "1"
]
}, - {
- "columns": [
- "Cisco 7811",
- "1"
]
}, - {
- "columns": [
- "Cisco 6961",
- "1"
]
}, - {
- "columns": [
- "Cisco 3905",
- "1"
]
}
]
}, - "settings": {
- "aggregation": 0,
- "contrastLabel": true,
- "defaultValue": "",
- "description": null,
- "emptyGroupText": "EmptyGroup",
- "is3d": false,
- "isDoughnut": false,
- "legendPlacement": "bottom",
- "overTime": null,
- "renderers": null,
- "showLabels": true,
- "showLegend": false,
- "showNumbers": true
}, - "summary": {
- "query": "select * from (select * from (select \"voss_device_cucm_phone\".\"product\" as \"product_1_\", count(*) as count from \"voss_device_cucm_phone\" where true group by \"voss_device_cucm_phone\".\"product\") as finalresult order by count DESC, \"product_1_\" DESC limit 100) as finalOrder order by count DESC, \"product_1_\" DESC",
- "stat_count_query_time": "0.000000 seconds",
- "stat_json_time": "0.008613 seconds",
- "stat_parse_time": "0.001307 seconds",
- "stat_query_time": "0.046503 seconds",
- "stat_total_time": "0.057005 seconds",
- "stat_write_time": "0.000457 seconds",
- "total_rows": 65
}, - "title": "",
- "totalCount": 65,
- "type": 1
}
x-lxt-api-token | string Example: {{x-lxt-kapapi-id}} |
{- "guid": "BJ11CD7H1BB5K44Y1660318150121S1F92SJOXBVO1O",
- "name": "Polycom",
- "folderSync": false,
- "dashboards": [
- {
- "guid": "UGOH75RV1SH19W8I1640016343949ETN6IQ0QPT7ND0",
- "name": "Polycom Device Status"
}, - {
- "guid": "DM2GKLJV7PRVJ6691640099514807CNBR4KOFIJ61EH",
- "name": "Polycom other information"
}
], - "dashboardGroups": [ ],
- "users": [
- {
- "guid": "cde050bdeb59139fc6b3c3ae96b773e3b772c3666f30ef3d0006022f89e6dfbd",
- "name": "sratsamy"
}
], - "lastSavedEpoch": 1660686888,
- "userGuid": "lxtrolesmodel",
- "lastSavedDate": 8162022215448,
- "syncOption": "Sync"
}