[Index]
This model defines a resource that exists in the Reporter backend. It describes the fields and how the data can be queried.
Model ref.: data/ReporterResource
The full URL would include the host-proxy name: https://[host-proxy].
Variables are enclosed in square brackets.
{ "$schema": "http://json-schema.org/draft-03/schema", "type": "object", "properties": { "name": { "title": "Name", "type": "string", "required": false }, "description": { "title": "Description", "type": "string", "required": false }, "modelType": { "title": "Model Type", "type": "string" }, "friendlyModelType": { "title": "Friendly Model Type", "type": "string" }, "dateField": { "title": "Date Field", "type": "string", "required": false }, "creationDate": { "title": "Creation Date", "type": "string", "required": false }, "datasourceType": { "title": "Datasource Type", "type": "string", "required": false }, "disableFilterTrim": { "title": "Disable Filter Trim", "type": "boolean", "required": false }, "version": { "title": "Version", "type": "string", "required": false }, "mainTable": { "title": "Main Table", "type": "string", "required": false }, "summary_attrs": { "title": "Summary Attributes", "type": "array", "items": { "type": "string" } }, "filters": { "title": "Filters", "type": "array", "required": false, "items": { "type": "string" } }, "fields": { "title": "Fields", "type": "array", "required": false, "items": { "type": "object", "properties": { "name": { "title": "Name", "type": "string", "required": false }, "groupType": { "title": "Group Type", "type": "integer", "required": false }, "operations": { "title": "Operations", "type": "array", "required": false, "items": { "type": "object", "properties": { "operation": { "title": "Operation", "type": "string", "required": false }, "name": { "title": "Name", "type": "string", "required": false }, "valueType": { "title": "Value Type", "type": "integer", "required": false } } } }, "columnType": { "title": "Column Type", "type": "integer", "required": false }, "lxtIsAggregate": { "title": "Lxt Is Aggregate", "type": "integer", "required": false }, "lxtTransform": { "title": "Lxt Transform", "type": "string", "required": false }, "pattern": { "title": "Pattern", "type": "string", "required": false }, "orderByStr": { "title": "Order By Str", "type": "string", "required": false }, "headersArray": { "title": "Headers Array", "type": "array", "required": false, "items": { "type": "string" } }, "groupingRequired": { "title": "Grouping Required", "type": "boolean", "required": false }, "groupByArray": { "title": "Group By Array", "type": "array", "required": false, "items": { "type": "string" } }, "selectStr": { "title": "Select Str", "type": "string", "required": false }, "table": { "title": "Table", "type": "string", "required": false }, "rule_type": { "title": "Field Type", "type": "integer", "required": false }, "value_type": { "title": "Value Type", "type": "integer", "required": false }, "value_mapping": { "title": "Value Mapping", "type": "string", "required": false }, "filter_operations": { "title": "Filter Operations", "type": "array", "required": false, "items": { "type": "object", "properties": { "filter_operation": { "title": "Operation", "type": "string", "required": false }, "filter_name": { "title": "Name", "type": "string", "required": false } } } }, "isRatio": { "title": "Is Ratio", "type": "boolean", "required": false }, "queryDto": { "title": "Query Dto", "type": "object", "properties": { "table": { "title": "Table", "type": "string" }, "whereStr": { "title": "Where String", "type": "string", "required": false }, "selectStr": { "title": "Select String", "type": "string" } } } } } }, "tableJoins": { "title": "Table Joins", "type": "array", "required": false, "items": { "type": "object", "properties": { "table": { "title": "Table", "type": "string", "required": false }, "table_alias": { "title": "Table_alias", "type": "string", "required": false }, "join": { "title": "Join", "type": "string", "required": false } } } } }, "schema_version": "0.6" }
Task | Call | URL | Parameters | Response |
---|---|---|---|---|
Get the GUI Add form. | GET | /api/data/ReporterResource/add/ |
|
The GUI Add form of data/ReporterResource as JSON |
The API call to the /add/ URL can only be made from a hierarchy that allows the model type to be added. The actions in the response shows the url for the POST API call to create an instance.
Task | Call | URL | Parameters | Payload |
---|---|---|---|---|
Create | POST | /api/data/ReporterResource | hierarchy=[hierarchy] |
|
tool/Transaction/[trans pkid]to inspect the created resource and its instance pkid.
Task | Call | URL | Parameters | Payload |
---|---|---|---|---|
Bulk delete [pkid1],[pkid2]... | DELETE | /api/data/ReporterResource/ | hierarchy=[hierarchy] | {"hrefs":["/api/data/ReporterResource/[pkid1]", "/api/data/ReporterResource/[pkid2]", ...]} |
GET http://[host-proxy]/api/data/ReporterResource/?hierarchy=[hierarchy]&format=json
Task | Call | URL | Parameters | Payload |
---|---|---|---|---|
Get a selected [export_format] of the schema and instances [pkid1], [pkid2],... of data/ReporterResource; optionally with tag_version at [version] and Configuration Template as [configtemplate]. | POST | /api/data/ReporterResource/export/ |
|
{ "hrefs":["/api/data/ReporterResource/[pkid1]", "/api/data/ReporterResource/[pkid2]",...]}} |
For export_format=json, the response is a time stamped zip file of data in JSON as in the system database. Item properties such as strings that are empty or Boolean values that are not set, are not included. The filename in the response is of the format as the example:
Content-Disposition: attachment; filename=export_2013-05-17_14:20:19.186444.json.zip Content-Language:en Content-Type:application/x-zip
For export_format=raw_xlsx, the response is a MS Excel spreadsheet with columns corresponding to the JSON format export and a response filename format:
Content-Disposition: attachment; filename=<resource_type>_<resource_name>_exportedsheet_CCYY-MM-DD_HH-MM-SS.xlsx Content-Language:en Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
For export_format=xlsx, the response is a MS Excel spreadsheet, arranged by any Field Display Policies that apply. The columns correspond with those of a Bulk Load Template export sheet. The response filename format is:
Content-Disposition: attachment; filename=<resource_type>_<resource_name>_exportedsheet_formatted_CCYY-MM-DD_HH-MM-SS.xlsx Content-Language:en Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
The XLSX format can be used to bulk load instances of data/ReporterResource and the JSON format can be used to import instances of data/ReporterResource.
GET http://[host-proxy]/api/data/ReporterResource/?hierarchy=[hierarchy]
Task | Call | URL | Parameters | Response |
---|---|---|---|---|
Get a compressed format of the Bulk Load spreadsheet template for data/ReporterResource | POST | /api/data/ReporterResource/export_bulkload_template/ |
|
The response is an attachment of the format: filetype_bulkloadsheet.xlsx.gz |
Task | Call | URL | Parameters | Response |
---|---|---|---|---|
Configuration Template | GET | /api/data/ReporterResource/configuration_template/ | hierarchy=[hierarchy] |
|
POST http://[host-proxy]/api/data/ConfigurationTemplate/?hierarchy=[hierarchy]
Task | Call | URL | Parameters | Response |
---|---|---|---|---|
Field Display Policy | GET | /api/data/ReporterResource/field_display_policy/ | hierarchy=[hierarchy] |
|
POST http://[host-proxy]/api/data/FieldDisplayPolicy/?hierarchy=[hierarchy]
Task | Call | URL | Parameters | Response |
---|---|---|---|---|
List | GET | /api/data/ReporterResource/ |
|
The data/ReporterResource schema and all instances as JSON. |
(The list will return 0 to 3 data/ReporterResource instances)
{ "pagination": { "skip": 0, "limit": 3, "maximum_limit": 2000, "total": 60, "total_limit": null, "order_by": "name", "direction": "asc", "current": "/api/data/ReporterResource/?skip=0&limit=3&order_by=name&direction=asc&traversal=down" }, "operations": [ "field_display_policy", "update", "help", "remove", "move", "add", "export", "list", "configuration_template", "get", "bulk_update_form", "migration", "transform", "export_bulkload_template" ], "meta": { "model_type": "data/ReporterResource", "summary_attrs": [ { "name": "name", "title": "Name" }, { "name": "description", "title": "Description" }, { "name": "datasourceType", "title": "Datasource Type" }, { "name": "version", "title": "Version" }, { "name": "hierarchy_friendly_name", "title": "Located At", "allow_filtering": true } ], "tagged_versions": [], "tags": [], "title": "", "business_key": { "unique": [ "name" ] }, "api_version": "21.2", "cached": true, "references": { "children": [], "parent": [ { "href": "/api/data/HierarchyNode/6t0ggef2c0deab00hb595101", "pkid": "6t0ggef2c0deab00hb595101" } ], "device": [ { "href": "", "pkid": "" } ], "foreign_key": [] }, "model_specific_actions": [ "get", "list", "add", "update", "remove", "export", "export_bulkload_template", "configuration_template", "field_display_policy", "help" ], "schema_version": "0.6", "actions": [ { "add": { "method": "GET", "class": "add", "href": "/api/data/ReporterResource/add/?hierarchy=[hierarchy]", "support_async": false, "title": "Add" } }, { "remove": { "method": "DELETE", "class": "delete", "href": "/api/data/ReporterResource/?hierarchy=[hierarchy]", "support_async": true, "title": "Delete" } }, { "export": { "method": "POST", "class": "export", "href": "/api/data/ReporterResource/export/?hierarchy=[hierarchy]", "support_async": false, "title": "Export", "view": "/api/view/ExportData/add/?auth_token=[authtoken], "submit": "payload" } }, { "export_bulkload_template": { "method": "POST", "class": "bulkload_template", "href": "/api/data/ReporterResource/export_bulkload_template/?hierarchy=[hierarchy]", "support_async": false, "title": "Export Bulk Load Template" } }, { "configuration_template": { "method": "GET", "class": "config", "href": "/api/data/ReporterResource/configuration_template/?hierarchy=[hierarchy]", "support_async": false, "title": "Configuration Template" } }, { "field_display_policy": { "method": "GET", "class": "display_policy", "href": "/api/data/ReporterResource/field_display_policy/?hierarchy=[hierarchy]", "support_async": false, "title": "Field Display Policy" } }, { "list": { "method": "GET", "class": "list", "href": "/api/data/ReporterResource/?hierarchy=[hierarchy]", "support_async": false, "title": "List" } }, { "help": { "method": "GET", "class": "help", "href": "/api/data/ReporterResource/help?hierarchy=[hierarchy]", "support_async": false, "title": "Help" } } ] }, "resources": [ { "data": { "name": "Automate License Counts", "description": "Automate License Counts", "modelType": "data/LicenseAuditCounts", "friendlyModelType": "", "dateField": "", "creationDate": "2024-06-23T22:06:13.775530Z", "datasourceType": "automate-postgres", "disableFilterTrim": true, "version": "1.0", "mainTable": "data_licenseauditcounts", "summary_attrs": [ "timestamp", "provider", "reseller", "customer", "user_licenses", "users_with_more_than_10_devices", "uccx_user_licenses", "cisco_and_ms_integrated_services", "standalone_devices", "meeting_rooms", "voss_phone_servers", "sites" ], "fields": [ { "name": "timestamp", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 3 }, { "operation": "Select Query", "name": "Select Query", "valueType": 3 }, { "operation": "Partition By", "name": "Partition By", "valueType": 3 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 3 }, { "operation": "Count", "name": "Count", "valueType": 3 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 3, "value_type": 3, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"timestamp\"" } }, { "name": "provider", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"provider\"" } }, { "name": "reseller", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"reseller\"" } }, { "name": "customer", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"customer\"" } }, { "name": "provider_pkid", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"provider_pkid\"" } }, { "name": "customer_pkid", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"customer_pkid\"" } }, { "name": "user_licenses", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"user_licenses\"" } }, { "name": "users_with_more_than_10_devices", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"users_with_more_than_10_devices\"" } }, { "name": "uccx_user_licenses", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"uccx_user_licenses\"" } }, { "name": "cisco_and_ms_integrated_services", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"cisco_and_ms_integrated_services\"" } }, { "name": "standalone_devices", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"standalone_devices\"" } }, { "name": "meeting_rooms", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"meeting_rooms\"" } }, { "name": "voss_phone_servers", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"voss_phone_servers\"" } }, { "name": "sites", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"sites\"" } }, { "name": "msol_users", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"msol_users\"" } }, { "name": "ms_teams_voice_users", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"ms_teams_voice_users\"" } }, { "name": "ms_exchange_users", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"ms_exchange_users\"" } }, { "name": "id", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"id\"" } }, { "name": "automate_ipaddress", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"automate_ipaddress\"" } }, { "name": "hierarchy_path", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"hierarchy_path\"" } }, { "name": "Provider", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"Provider\"" } }, { "name": "Customer", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"Customer\"" } }, { "name": "Site", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"Site\"" } }, { "name": "Reseller", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"Reseller\"" } }, { "name": "IntermediateNode", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"IntermediateNode\"" } } ], "pkid": "667880366db1cf05ba080732", "hierarchy_friendly_name": "sys (System)", "hierarchy_path": "sys" }, "meta": { "model_type": "data/ReporterResource", "summary_attrs": [ { "name": "name", "title": "Name" }, { "name": "description", "title": "Description" }, { "name": "datasourceType", "title": "Datasource Type" }, { "name": "version", "title": "Version" }, { "name": "hierarchy_friendly_name", "title": "Located At", "allow_filtering": true } ], "tagged_versions": [], "tags": [], "title": "Automate License Counts", "business_key": { "unique": [ "name" ] }, "api_version": "21.2", "cached": true, "references": { "parent": [ { "pkid": "6t0ggef2c0deab00hb595101", "href": "/api/data/HierarchyNode/6t0ggef2c0deab00hb595101" } ], "device": [ { "href": "", "pkid": "" } ], "foreign_key": [], "owner": [ { "pkid": "" } ], "self": [ { "href": "/api/data/ReporterResource/667880366db1cf05ba080731/", "pkid": "667880366db1cf05ba080731" } ] }, "path": [ "6t0ggef2c0deab00hb595101", "667880366db1cf05ba080731" ], "schema_version": "0.6", "actions": [ { "update": { "method": "PUT", "class": "update", "href": "/api/data/ReporterResource/667880366db1cf05ba080731/", "support_async": true, "title": "Modify" } }, { "remove": { "method": "DELETE", "class": "delete", "href": "/api/data/ReporterResource/667880366db1cf05ba080731/", "support_async": true, "title": "Delete" } }, { "export": { "method": "GET", "class": "export", "href": "/api/data/ReporterResource/667880366db1cf05ba080731/export/", "support_async": false, "title": "Export", "view": "/api/view/ExportData/add/", "submit": "payload" } }, { "get": { "method": "GET", "class": "get", "href": "/api/data/ReporterResource/667880366db1cf05ba080731/", "support_async": false, "title": "Get" } }, { "help": { "method": "GET", "class": "help", "href": "/api/data/ReporterResource/667880366db1cf05ba080731/help", "support_async": false, "title": "Help" } } ], "summary": "false" }, "pkid": "667880366db1cf05ba080731" }, { "data": { "name": "Cisco CUC Call Handler", "description": "Cisco CUC Call Handler", "modelType": "device/cuc/Callhandler", "friendlyModelType": "device/cuc/Callhandler", "dateField": "", "creationDate": "2024-06-23T22:06:26.213009Z", "datasourceType": "automate-postgres", "disableFilterTrim": true, "version": "1.0", "mainTable": "device_cuc_callhandler", "summary_attrs": [ "DisplayName", "DtmfAccessId", "IsPrimary" ], "fields": [ { "name": "SendPrivateMsg", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"SendPrivateMsg\"" } }, { "name": "VoiceName", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"VoiceName\"" } }, { "name": "PartitionURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"PartitionURI\"" } }, { "name": "PlayPostGreetingRecording", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"PlayPostGreetingRecording\"" } }, { "name": "templateObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"templateObjectId\"" } }, { "name": "CreationTime", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"CreationTime\"" } }, { "name": "CallHandlerOwnerURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"CallHandlerOwnerURI\"" } }, { "name": "EnablePrependDigits", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"EnablePrependDigits\"" } }, { "name": "UseDefaultTimeZone", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"UseDefaultTimeZone\"" } }, { "name": "PhoneSystemURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"PhoneSystemURI\"" } }, { "name": "RecipientDistributionListURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"RecipientDistributionListURI\"" } }, { "name": "TimeZone", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"TimeZone\"" } }, { "name": "DisplayName", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"DisplayName\"" } }, { "name": "VoiceNameURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"VoiceNameURI\"" } }, { "name": "URI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"URI\"" } }, { "name": "PartitionObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"PartitionObjectId\"" } }, { "name": "RecipientSubscriberObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"RecipientSubscriberObjectId\"" } }, { "name": "CallSearchSpaceObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"CallSearchSpaceObjectId\"" } }, { "name": "ObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"ObjectId\"" } }, { "name": "UseCallLanguage", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"UseCallLanguage\"" } }, { "name": "LocalizationKey", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"LocalizationKey\"" } }, { "name": "ScheduleSetObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"ScheduleSetObjectId\"" } }, { "name": "OneKeyDelay", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"OneKeyDelay\"" } }, { "name": "DispatchDelivery", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"DispatchDelivery\"" } }, { "name": "ScheduleSetURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"ScheduleSetURI\"" } }, { "name": "AfterMessageAction", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"AfterMessageAction\"" } }, { "name": "MaxMsgLen", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"MaxMsgLen\"" } }, { "name": "EditMsg", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"EditMsg\"" } }, { "name": "MenuEntriesURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"MenuEntriesURI\"" } }, { "name": "IsPrimary", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"IsPrimary\"" } }, { "name": "PrependDigits", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"PrependDigits\"" } }, { "name": "LocationObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"LocationObjectId\"" } }, { "name": "Language", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"Language\"" } }, { "name": "TransferOptionsURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"TransferOptionsURI\"" } }, { "name": "IsTemplate", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"IsTemplate\"" } }, { "name": "RecipientUserURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"RecipientUserURI\"" } }, { "name": "CallSearchSpaceURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"CallSearchSpaceURI\"" } }, { "name": "PlayAfterMessageRecordingObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"PlayAfterMessageRecordingObjectId\"" } }, { "name": "RecipientContactURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"RecipientContactURI\"" } }, { "name": "PlayAfterMessage", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"PlayAfterMessage\"" } }, { "name": "GreetingsURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"GreetingsURI\"" } }, { "name": "AfterMessageTargetHandlerObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"AfterMessageTargetHandlerObjectId\"" } }, { "name": "TenantObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"TenantObjectId\"" } }, { "name": "SendUrgentMsg", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"SendUrgentMsg\"" } }, { "name": "Undeletable", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"Undeletable\"" } }, { "name": "VoiceFileURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"VoiceFileURI\"" } }, { "name": "AfterMessageTargetConversation", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"AfterMessageTargetConversation\"" } }, { "name": "InheritSearchSpaceFromCall", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"InheritSearchSpaceFromCall\"" } }, { "name": "RecipientContactObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"RecipientContactObjectId\"" } }, { "name": "RecipientDistributionListObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"RecipientDistributionListObjectId\"" } }, { "name": "DtmfAccessId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"DtmfAccessId\"" } }, { "name": "SendSecureMsg", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"SendSecureMsg\"" } }, { "name": "PostGreetingRecordingObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"PostGreetingRecordingObjectId\"" } }, { "name": "UseDefaultLanguage", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"UseDefaultLanguage\"" } }, { "name": "MediaSwitchObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"MediaSwitchObjectId\"" } }, { "name": "LocationURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"LocationURI\"" } }, { "name": "id", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"id\"" } }, { "name": "automate_ipaddress", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"automate_ipaddress\"" } }, { "name": "hierarchy_path", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"hierarchy_path\"" } }, { "name": "Provider", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"Provider\"" } }, { "name": "Customer", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"Customer\"" } }, { "name": "Site", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"Site\"" } }, { "name": "Reseller", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"Reseller\"" } }, { "name": "IntermediateNode", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_callhandler", "selectStr": "\"IntermediateNode\"" } } ], "pkid": "667880436db1cf05ba080780", "hierarchy_friendly_name": "sys (System)", "hierarchy_path": "sys" }, "meta": { "model_type": "data/ReporterResource", "summary_attrs": [ { "name": "name", "title": "Name" }, { "name": "description", "title": "Description" }, { "name": "datasourceType", "title": "Datasource Type" }, { "name": "version", "title": "Version" }, { "name": "hierarchy_friendly_name", "title": "Located At", "allow_filtering": true } ], "tagged_versions": [], "tags": [], "title": "Cisco CUC Call Handler", "business_key": { "unique": [ "name" ] }, "api_version": "21.2", "cached": true, "references": { "parent": [ { "pkid": "6t0ggef2c0deab00hb595101", "href": "/api/data/HierarchyNode/6t0ggef2c0deab00hb595101" } ], "device": [ { "href": "", "pkid": "" } ], "foreign_key": [], "owner": [ { "pkid": "" } ], "self": [ { "href": "/api/data/ReporterResource/667880426db1cf05ba08077f/", "pkid": "667880426db1cf05ba08077f" } ] }, "path": [ "6t0ggef2c0deab00hb595101", "667880426db1cf05ba08077f" ], "schema_version": "0.6", "actions": [ { "update": { "method": "PUT", "class": "update", "href": "/api/data/ReporterResource/667880426db1cf05ba08077f/", "support_async": true, "title": "Modify" } }, { "remove": { "method": "DELETE", "class": "delete", "href": "/api/data/ReporterResource/667880426db1cf05ba08077f/", "support_async": true, "title": "Delete" } }, { "export": { "method": "GET", "class": "export", "href": "/api/data/ReporterResource/667880426db1cf05ba08077f/export/", "support_async": false, "title": "Export", "view": "/api/view/ExportData/add/", "submit": "payload" } }, { "get": { "method": "GET", "class": "get", "href": "/api/data/ReporterResource/667880426db1cf05ba08077f/", "support_async": false, "title": "Get" } }, { "help": { "method": "GET", "class": "help", "href": "/api/data/ReporterResource/667880426db1cf05ba08077f/help", "support_async": false, "title": "Help" } } ], "summary": "false" }, "pkid": "667880426db1cf05ba08077f" }, { "data": { "name": "Cisco CUC User", "description": "Cisco CUC User", "modelType": "device/cuc/User", "friendlyModelType": "relation/Voicemail", "dateField": "", "creationDate": "2024-06-23T22:06:23.031886Z", "datasourceType": "automate-postgres", "disableFilterTrim": true, "version": "1.0", "mainTable": "device_cuc_user", "summary_attrs": [ "Alias", "FirstName", "LastName", "DtmfAccessId", "EmailAddress", "TimeZone" ], "fields": [ { "name": "ExitTargetHandlerObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ExitTargetHandlerObjectId\"" } }, { "name": "Title", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Title\"" } }, { "name": "AddressMode", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"AddressMode\"" } }, { "name": "RingPrimaryPhoneFirst", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"RingPrimaryPhoneFirst\"" } }, { "name": "CommandDigitTimeout", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"CommandDigitTimeout\"" } }, { "name": "VoiceName", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"VoiceName\"" } }, { "name": "EnAltGreetDontRingPhone", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"EnAltGreetDontRingPhone\"" } }, { "name": "SayTimestampAfter", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayTimestampAfter\"" } }, { "name": "Department", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Department\"" } }, { "name": "GreetByName", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"GreetByName\"" } }, { "name": "Address", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Address\"" } }, { "name": "RetainUrgentMessageFlag", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"RetainUrgentMessageFlag\"" } }, { "name": "IsTemplate", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"IsTemplate\"" } }, { "name": "DtmfNameLastFirst", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"DtmfNameLastFirst\"" } }, { "name": "SpeechSensitivity", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SpeechSensitivity\"" } }, { "name": "ConversationTui", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ConversationTui\"" } }, { "name": "CcmId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"CcmId\"" } }, { "name": "LdapType", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"LdapType\"" } }, { "name": "ExternalServiceAccountsURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ExternalServiceAccountsURI\"" } }, { "name": "SaveMessageOnHangup", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SaveMessageOnHangup\"" } }, { "name": "EnableVisualMessageLocator", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"EnableVisualMessageLocator\"" } }, { "name": "RepeatMenu", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"RepeatMenu\"" } }, { "name": "Building", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Building\"" } }, { "name": "UserMailboxURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"UserMailboxURI\"" } }, { "name": "ConversationVui", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ConversationVui\"" } }, { "name": "EmployeeId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"EmployeeId\"" } }, { "name": "ObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ObjectId\"" } }, { "name": "CreationTime", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"CreationTime\"" } }, { "name": "JumpToMessagesOnLogin", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"JumpToMessagesOnLogin\"" } }, { "name": "SaySender", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SaySender\"" } }, { "name": "URI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"URI\"" } }, { "name": "MessageLocatorSortOrder", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"MessageLocatorSortOrder\"" } }, { "name": "MailboxDn", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"MailboxDn\"" } }, { "name": "PhoneNumber", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"PhoneNumber\"" } }, { "name": "CcmIdType", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"CcmIdType\"" } }, { "name": "SynchScheduleURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SynchScheduleURI\"" } }, { "name": "ClientMatterCode", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ClientMatterCode\"" } }, { "name": "ConfirmDeleteDeletedMessage", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ConfirmDeleteDeletedMessage\"" } }, { "name": "EnableSaveDraft", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"EnableSaveDraft\"" } }, { "name": "AlternateNamesURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"AlternateNamesURI\"" } }, { "name": "VoiceFileURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"VoiceFileURI\"" } }, { "name": "Initials", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Initials\"" } }, { "name": "AltFirstName", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"AltFirstName\"" } }, { "name": "ExitCallActionObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ExitCallActionObjectId\"" } }, { "name": "SayMsgNumber", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayMsgNumber\"" } }, { "name": "SayTotalNewVoice", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayTotalNewVoice\"" } }, { "name": "ReadOnly", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ReadOnly\"" } }, { "name": "SaySenderExtension", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SaySenderExtension\"" } }, { "name": "SavedMessageStackOrder", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SavedMessageStackOrder\"" } }, { "name": "SaySenderExtensionAfter", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SaySenderExtensionAfter\"" } }, { "name": "DisplayName", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"DisplayName\"" } }, { "name": "InboxAutoRefresh", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"InboxAutoRefresh\"" } }, { "name": "UseDefaultTimeZone", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"UseDefaultTimeZone\"" } }, { "name": "PhoneSystemURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"PhoneSystemURI\"" } }, { "name": "State", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"State\"" } }, { "name": "AltLastName", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"AltLastName\"" } }, { "name": "AnnounceUpcomingMeetings", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"AnnounceUpcomingMeetings\"" } }, { "name": "MailboxStoreName", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"MailboxStoreName\"" } }, { "name": "SayAni", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayAni\"" } }, { "name": "NewMessageSortOrder", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"NewMessageSortOrder\"" } }, { "name": "TimeLastCall", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"TimeLastCall\"" } }, { "name": "DtmfNameLast", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"DtmfNameLast\"" } }, { "name": "FaxServerObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"FaxServerObjectId\"" } }, { "name": "LocationObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"LocationObjectId\"" } }, { "name": "DtmfNameFirst", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"DtmfNameFirst\"" } }, { "name": "PromptSpeed", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"PromptSpeed\"" } }, { "name": "EnAltGreetPreventSkip", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"EnAltGreetPreventSkip\"" } }, { "name": "ContinuousAddMode", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ContinuousAddMode\"" } }, { "name": "EnhancedSecurityAlias", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"EnhancedSecurityAlias\"" } }, { "name": "PrivateListsURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"PrivateListsURI\"" } }, { "name": "ConfirmDeleteMultipleMessages", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ConfirmDeleteMultipleMessages\"" } }, { "name": "ConversationName", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ConversationName\"" } }, { "name": "EnableMessageBookmark", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"EnableMessageBookmark\"" } }, { "name": "InboxMessagesPerPage", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"InboxMessagesPerPage\"" } }, { "name": "PabLastImported", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"PabLastImported\"" } }, { "name": "PcaHomePage", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"PcaHomePage\"" } }, { "name": "UpdateBroadcastMsg", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"UpdateBroadcastMsg\"" } }, { "name": "SayCopiedNames", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayCopiedNames\"" } }, { "name": "InboxAutoResolveMessageRecipients", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"InboxAutoResolveMessageRecipients\"" } }, { "name": "MwisURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"MwisURI\"" } }, { "name": "UserWebPasswordURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"UserWebPasswordURI\"" } }, { "name": "VideoServiceAccountsURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"VideoServiceAccountsURI\"" } }, { "name": "SkipForwardTime", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SkipForwardTime\"" } }, { "name": "SayMessageLengthAfter", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayMessageLengthAfter\"" } }, { "name": "UseVui", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"UseVui\"" } }, { "name": "SpeechConfidenceThreshold", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SpeechConfidenceThreshold\"" } }, { "name": "FirstDigitTimeout", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"FirstDigitTimeout\"" } }, { "name": "AddressAfterRecord", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"AddressAfterRecord\"" } }, { "name": "MediaSwitchObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"MediaSwitchObjectId\"" } }, { "name": "ExitTargetConversation", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ExitTargetConversation\"" } }, { "name": "SavedMessageSortOrder", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SavedMessageSortOrder\"" } }, { "name": "PartitionURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"PartitionURI\"" } }, { "name": "FirstName", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"FirstName\"" } }, { "name": "UseBriefPrompts", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"UseBriefPrompts\"" } }, { "name": "SkipPasswordForKnownDevice", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SkipPasswordForKnownDevice\"" } }, { "name": "LastName", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"LastName\"" } }, { "name": "MessageTypeMenu", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"MessageTypeMenu\"" } }, { "name": "SkipReverseTime", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SkipReverseTime\"" } }, { "name": "RouteNDRToSender", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"RouteNDRToSender\"" } }, { "name": "VoiceNameURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"VoiceNameURI\"" } }, { "name": "SayTimestampBefore", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayTimestampBefore\"" } }, { "name": "PartitionObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"PartitionObjectId\"" } }, { "name": "SayMsgNumberAfter", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayMsgNumberAfter\"" } }, { "name": "SpeechCompleteTimeout", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SpeechCompleteTimeout\"" } }, { "name": "ForcedAuthorizationCode", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ForcedAuthorizationCode\"" } }, { "name": "EnAltGreetPreventMsg", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"EnAltGreetPreventMsg\"" } }, { "name": "AutoAdvanceMsgs", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"AutoAdvanceMsgs\"" } }, { "name": "AssistantRowsPerPage", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"AssistantRowsPerPage\"" } }, { "name": "templateAlias", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"templateAlias\"" } }, { "name": "EnableMessageLocator", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"EnableMessageLocator\"" } }, { "name": "CreateSmtpProxyFromCorp", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"CreateSmtpProxyFromCorp\"" } }, { "name": "IsSetForVmEnrollment", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"IsSetForVmEnrollment\"" } }, { "name": "UseDynamicNameSearchWeight", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"UseDynamicNameSearchWeight\"" } }, { "name": "UserRoleURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"UserRoleURI\"" } }, { "name": "ClockMode", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ClockMode\"" } }, { "name": "CosObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"CosObjectId\"" } }, { "name": "LdapCcmUserId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"LdapCcmUserId\"" } }, { "name": "SayAniAfter", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayAniAfter\"" } }, { "name": "DtmfNameFirstLast", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"DtmfNameFirstLast\"" } }, { "name": "PostalCode", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"PostalCode\"" } }, { "name": "XferString", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"XferString\"" } }, { "name": "ConfirmationConfidenceThreshold", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ConfirmationConfidenceThreshold\"" } }, { "name": "Undeletable", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Undeletable\"" } }, { "name": "DelayAfterGreeting", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"DelayAfterGreeting\"" } }, { "name": "EncryptPrivateMessages", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"EncryptPrivateMessages\"" } }, { "name": "SayTotalReceipts", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayTotalReceipts\"" } }, { "name": "NewMessageStackOrder", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"NewMessageStackOrder\"" } }, { "name": "NotificationDevicesURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"NotificationDevicesURI\"" } }, { "name": "MailboxStoreObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"MailboxStoreObjectId\"" } }, { "name": "IsVmEnrolled", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"IsVmEnrolled\"" } }, { "name": "Inactive", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Inactive\"" } }, { "name": "EmailAddress", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"EmailAddress\"" } }, { "name": "EnableTts", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"EnableTts\"" } }, { "name": "SearchByExtensionSearchSpaceObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SearchByExtensionSearchSpaceObjectId\"" } }, { "name": "PcaAddressBookRowsPerPage", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"PcaAddressBookRowsPerPage\"" } }, { "name": "LocationURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"LocationURI\"" } }, { "name": "SayDistributionList", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayDistributionList\"" } }, { "name": "City", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"City\"" } }, { "name": "SendBroadcastMsg", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SendBroadcastMsg\"" } }, { "name": "ExitAction", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ExitAction\"" } }, { "name": "VoiceNameRequired", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"VoiceNameRequired\"" } }, { "name": "SearchByExtensionSearchSpaceURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SearchByExtensionSearchSpaceURI\"" } }, { "name": "SmtpProxyAddressesURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SmtpProxyAddressesURI\"" } }, { "name": "MessageHandlersURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"MessageHandlersURI\"" } }, { "name": "SayTotalNewFax", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayTotalNewFax\"" } }, { "name": "CallHandlerObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"CallHandlerObjectId\"" } }, { "name": "TimeZone", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"TimeZone\"" } }, { "name": "SaySenderAfter", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SaySenderAfter\"" } }, { "name": "NameConfirmation", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"NameConfirmation\"" } }, { "name": "SearchByNameSearchSpaceURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SearchByNameSearchSpaceURI\"" } }, { "name": "EnablePersonalRules", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"EnablePersonalRules\"" } }, { "name": "ConfirmDeleteMessage", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ConfirmDeleteMessage\"" } }, { "name": "SynchScheduleObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SynchScheduleObjectId\"" } }, { "name": "Language", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Language\"" } }, { "name": "RecordUnknownCallerName", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"RecordUnknownCallerName\"" } }, { "name": "Manager", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Manager\"" } }, { "name": "CallAnswerTimeout", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"CallAnswerTimeout\"" } }, { "name": "Volume", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Volume\"" } }, { "name": "SayTotalSaved", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayTotalSaved\"" } }, { "name": "InterdigitDelay", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"InterdigitDelay\"" } }, { "name": "CosURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"CosURI\"" } }, { "name": "SmtpAddress", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SmtpAddress\"" } }, { "name": "LocalizationKey", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"LocalizationKey\"" } }, { "name": "Country", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Country\"" } }, { "name": "SayMessageLength", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayMessageLength\"" } }, { "name": "ListInDirectory", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"ListInDirectory\"" } }, { "name": "CallhandlerURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"CallhandlerURI\"" } }, { "name": "SayAltGreetWarning", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayAltGreetWarning\"" } }, { "name": "Alias", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Alias\"" } }, { "name": "PromptVolume", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"PromptVolume\"" } }, { "name": "TenantObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"TenantObjectId\"" } }, { "name": "SayTotalDraftMsg", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayTotalDraftMsg\"" } }, { "name": "SayTotalNew", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayTotalNew\"" } }, { "name": "SayTotalNewEmail", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SayTotalNewEmail\"" } }, { "name": "SpeechIncompleteTimeout", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SpeechIncompleteTimeout\"" } }, { "name": "UserVoicePinURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"UserVoicePinURI\"" } }, { "name": "LdapCcmPkid", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"LdapCcmPkid\"" } }, { "name": "SendMessageOnHangup", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SendMessageOnHangup\"" } }, { "name": "AlternateExtensionsURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"AlternateExtensionsURI\"" } }, { "name": "DialablePhoneNumber", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"DialablePhoneNumber\"" } }, { "name": "IsClockMode24Hour", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"IsClockMode24Hour\"" } }, { "name": "UseShortPollForCache", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"UseShortPollForCache\"" } }, { "name": "DtmfAccessId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"DtmfAccessId\"" } }, { "name": "FaxServerURI", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"FaxServerURI\"" } }, { "name": "BillingId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"BillingId\"" } }, { "name": "SearchByNameSearchSpaceObjectId", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SearchByNameSearchSpaceObjectId\"" } }, { "name": "DeletedMessageSortOrder", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"DeletedMessageSortOrder\"" } }, { "name": "SpeechSpeedVsAccuracy", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"SpeechSpeedVsAccuracy\"" } }, { "name": "UseDefaultLanguage", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"UseDefaultLanguage\"" } }, { "name": "Speed", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Speed\"" } }, { "name": "id", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"id\"" } }, { "name": "automate_ipaddress", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"automate_ipaddress\"" } }, { "name": "hierarchy_path", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"hierarchy_path\"" } }, { "name": "Provider", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Provider\"" } }, { "name": "Customer", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Customer\"" } }, { "name": "Site", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Site\"" } }, { "name": "Reseller", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"Reseller\"" } }, { "name": "IntermediateNode", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "device_cuc_user", "selectStr": "\"IntermediateNode\"" } } ], "pkid": "667880416db1cf05ba08077a", "hierarchy_friendly_name": "sys (System)", "hierarchy_path": "sys" }, "meta": { "model_type": "data/ReporterResource", "summary_attrs": [ { "name": "name", "title": "Name" }, { "name": "description", "title": "Description" }, { "name": "datasourceType", "title": "Datasource Type" }, { "name": "version", "title": "Version" }, { "name": "hierarchy_friendly_name", "title": "Located At", "allow_filtering": true } ], "tagged_versions": [], "tags": [], "title": "Cisco CUC User", "business_key": { "unique": [ "name" ] }, "api_version": "21.2", "cached": true, "references": { "parent": [ { "pkid": "6t0ggef2c0deab00hb595101", "href": "/api/data/HierarchyNode/6t0ggef2c0deab00hb595101" } ], "device": [ { "href": "", "pkid": "" } ], "foreign_key": [], "owner": [ { "pkid": "" } ], "self": [ { "href": "/api/data/ReporterResource/667880416db1cf05ba080779/", "pkid": "667880416db1cf05ba080779" } ] }, "path": [ "6t0ggef2c0deab00hb595101", "667880416db1cf05ba080779" ], "schema_version": "0.6", "actions": [ { "update": { "method": "PUT", "class": "update", "href": "/api/data/ReporterResource/667880416db1cf05ba080779/", "support_async": true, "title": "Modify" } }, { "remove": { "method": "DELETE", "class": "delete", "href": "/api/data/ReporterResource/667880416db1cf05ba080779/", "support_async": true, "title": "Delete" } }, { "export": { "method": "GET", "class": "export", "href": "/api/data/ReporterResource/667880416db1cf05ba080779/export/", "support_async": false, "title": "Export", "view": "/api/view/ExportData/add/", "submit": "payload" } }, { "get": { "method": "GET", "class": "get", "href": "/api/data/ReporterResource/667880416db1cf05ba080779/", "support_async": false, "title": "Get" } }, { "help": { "method": "GET", "class": "help", "href": "/api/data/ReporterResource/667880416db1cf05ba080779/help", "support_async": false, "title": "Help" } } ], "summary": "false" }, "pkid": "667880416db1cf05ba080779" } ] }
(Show the first instance)
{ "data": { "name": "Automate License Counts", "description": "Automate License Counts", "modelType": "data/LicenseAuditCounts", "friendlyModelType": "", "dateField": "", "creationDate": "2024-06-23T22:06:13.775530Z", "datasourceType": "automate-postgres", "disableFilterTrim": true, "version": "1.0", "mainTable": "data_licenseauditcounts", "summary_attrs": [ "timestamp", "provider", "reseller", "customer", "user_licenses", "users_with_more_than_10_devices", "uccx_user_licenses", "cisco_and_ms_integrated_services", "standalone_devices", "meeting_rooms", "voss_phone_servers", "sites" ], "fields": [ { "name": "timestamp", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 3 }, { "operation": "Select Query", "name": "Select Query", "valueType": 3 }, { "operation": "Partition By", "name": "Partition By", "valueType": 3 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 3 }, { "operation": "Count", "name": "Count", "valueType": 3 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 3, "value_type": 3, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"timestamp\"" } }, { "name": "provider", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"provider\"" } }, { "name": "reseller", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"reseller\"" } }, { "name": "customer", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"customer\"" } }, { "name": "provider_pkid", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"provider_pkid\"" } }, { "name": "customer_pkid", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"customer_pkid\"" } }, { "name": "user_licenses", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"user_licenses\"" } }, { "name": "users_with_more_than_10_devices", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"users_with_more_than_10_devices\"" } }, { "name": "uccx_user_licenses", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"uccx_user_licenses\"" } }, { "name": "cisco_and_ms_integrated_services", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"cisco_and_ms_integrated_services\"" } }, { "name": "standalone_devices", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"standalone_devices\"" } }, { "name": "meeting_rooms", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"meeting_rooms\"" } }, { "name": "voss_phone_servers", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"voss_phone_servers\"" } }, { "name": "sites", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"sites\"" } }, { "name": "msol_users", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"msol_users\"" } }, { "name": "ms_teams_voice_users", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"ms_teams_voice_users\"" } }, { "name": "ms_exchange_users", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 }, { "operation": "Value", "name": "Value", "valueType": 1 }, { "operation": "Min", "name": "Min", "valueType": 1 }, { "operation": "Max", "name": "Max", "valueType": 1 }, { "operation": "Avg", "name": "Avg", "valueType": 2 }, { "operation": "Sum", "name": "Sum", "valueType": 1 }, { "operation": "var_samp", "name": "Variance", "valueType": 1 }, { "operation": "stddev_samp", "name": "Stddev", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 1, "value_type": 1, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"ms_exchange_users\"" } }, { "name": "id", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"id\"" } }, { "name": "automate_ipaddress", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"automate_ipaddress\"" } }, { "name": "hierarchy_path", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"hierarchy_path\"" } }, { "name": "Provider", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"Provider\"" } }, { "name": "Customer", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"Customer\"" } }, { "name": "Site", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"Site\"" } }, { "name": "Reseller", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"Reseller\"" } }, { "name": "IntermediateNode", "groupType": 0, "operations": [ { "operation": "Grouping Count", "name": "Grouping Count", "valueType": 1 }, { "operation": "Select Query", "name": "Select Query", "valueType": 1 }, { "operation": "Partition By", "name": "Partition By", "valueType": 1 }, { "operation": "Partition Order", "name": "Partition Order", "valueType": 1 }, { "operation": "Count", "name": "Count", "valueType": 1 } ], "columnType": 0, "lxtIsAggregate": 0, "lxtTransform": "", "groupingRequired": false, "rule_type": 0, "value_type": 0, "isRatio": false, "queryDto": { "table": "data_licenseauditcounts", "selectStr": "\"IntermediateNode\"" } } ], "pkid": "667880366db1cf05ba080732" }, "meta": { "model_type": "data/ReporterResource", "summary_attrs": [ { "name": "name", "title": "Name" }, { "name": "description", "title": "Description" }, { "name": "datasourceType", "title": "Datasource Type" }, { "name": "version", "title": "Version" }, { "name": "hierarchy_friendly_name", "title": "Located At", "allow_filtering": true } ], "tagged_versions": [], "tags": [], "title": "Automate License Counts", "business_key": { "unique": [ "name" ] }, "api_version": "21.2", "cached": false, "references": { "parent": [ { "href": "/api/data/HierarchyNode/6t0ggef2c0deab00hb595101", "pkid": "6t0ggef2c0deab00hb595101" } ], "device": [ { "href": "", "pkid": "" } ], "foreign_key": [], "owner": [ { "pkid": "" } ], "children": [], "self": [ { "href": "/api/data/ReporterResource/667880366db1cf05ba080731/", "pkid": "667880366db1cf05ba080731" } ] }, "path": [ "6t0ggef2c0deab00hb595101", "667880366db1cf05ba080731" ], "schema_version": "0.6", "actions": [ { "update": { "method": "PUT", "class": "update", "href": "/api/data/ReporterResource/667880366db1cf05ba080731/?hierarchy=[hierarchy]", "support_async": true, "title": "Modify" } }, { "remove": { "method": "DELETE", "class": "delete", "href": "/api/data/ReporterResource/667880366db1cf05ba080731/?hierarchy=[hierarchy]", "support_async": true, "title": "Delete" } }, { "export": { "method": "GET", "class": "export", "href": "/api/data/ReporterResource/667880366db1cf05ba080731/export/?hierarchy=[hierarchy]", "support_async": false, "title": "Export", "view": "/api/view/ExportData/add/?auth_token=[authtoken], "submit": "payload" } }, { "get": { "method": "GET", "class": "get", "href": "/api/data/ReporterResource/667880366db1cf05ba080731/?hierarchy=[hierarchy]", "support_async": false, "title": "Get" } }, { "help": { "method": "GET", "class": "help", "href": "/api/data/ReporterResource/667880366db1cf05ba080731/help?hierarchy=[hierarchy]", "support_async": false, "title": "Help" } } ] }, "pkid": "667880366db1cf05ba080731" }
Task | Call | URL | Parameters | Response |
---|---|---|---|---|
Get the on-line Help for data/ReporterResource. | GET | /api/data/ReporterResource/help | hierarchy=[hierarchy] | On-line help of Model ref.: data/ReporterResource as HTML |
Task | Call | URL | Parameters | Payload |
---|---|---|---|---|
Modify | PUT | /api/data/ReporterResource/[pkid] | hierarchy=[hierarchy] | (For payload specification) |
For Bulk modification, refer to the Bulk Modify section.
Task | Call | URL | Parameters | Response |
---|---|---|---|---|
Delete | DELETE | /api/data/ReporterResource/[pkid] | hierarchy=[hierarchy] |
Task | Call | URL | Parameters | Response |
---|---|---|---|---|
Get a selected [export_format] of the schema and a single instance with [pkid] of data/ReporterResource; optionally with tag_version at [version] and Configuration Template as [configtemplate]. | GET | /api/data/ReporterResource/[pkid]/export |
|
The response is an attachment. Refer to the list below. |
For export_format=raw_xlsx, the response is a "raw" MS Excel spreadsheet with columns corresponding to the JSON format export and a response format:
Content-Disposition: attachment; filename=<resource_type>_<resource_name>_exportedsheet_CCYY-MM-DD_HH-MM-SS.xlsx Content-Language:en Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
For export_format=xlsx, the response is a MS Excel spreadsheet, formatted to show all columns and a response format:
Content-Disposition: attachment; filename=<resource_type>_<resource_name>_exportedsheet_formatted_CCYY-MM-DD_HH-MM-SS.xlsx Content-Language:en Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
For export_format=json, the response is a time stamped zip file of data in JSON and a response format:
Content-Disposition: attachment; filename=export_2013-05-17_14:20:19.186444.json.zip Content-Language:en Content-Type:application/x-zip
The XLSX format can be used to bulk load instances of data/ReporterResource and the JSON format can be used to import instances of data/ReporterResource.
For Bulk Export, refer to the Bulk Export section.
Task | Call | URL | Parameters | Response |
---|---|---|---|---|
Get | GET | /api/data/ReporterResource/[pkid] | hierarchy=[hierarchy] | The data/ReporterResource instance with [pkid]. |
Task | Call | URL | Parameters | Response |
---|---|---|---|---|
Help | GET | /api/data/ReporterResource/[pkid]/help | hierarchy=[hierarchy] | The on-line Help for data/ReporterResource. |