Accessing Metric Result (asmt_metric_result) table data through the Tableau Connector?

[graycarper]

Howdy!

I'd like to develop some ticket satisfaction survey reports that integrate data from a number of different tables (incident, sys_user, cmdb_ci, asmt_assessment_instance, asmt_assessment, asmt_metric_result, etc). Everything has gone smoothly so far with one exception: the Tableau Connector doesn't display Metric Result (asmt_metric_result) as an available table. As a way of checking my roles and ACLs, I used the ODBC driver in combination with Tableau Desktop to connect to the same account on the same instance. Tableau Desktop has no problem accessing asmt_metric_result through ODBC.

The account I'm using has the itil, soap_query, survey_admin, snc_read_only, and table_metadata roles. That last one - table_metadata - is a custom role that grants read-only access to the sys_dictionary, sys_db_object, and sys_glide_object tables via ACLs. (This allows for browsing of ServiceNow's database structures and is used, in particular, to make accounts compatible with the Tableau Connector.)

Could the ODBC (SOAP API) be given access to tables that the Tableau Connector (REST API) is not? Seems unlikely, but based on this experiment that's my best guess at the moment. I'm not sure how to troubleshoot that, though.

Any ideas? Am I overlooking something? Has anyone run into this problem before?

Thank you!

-Gray

[graycarper · Accepted solution]

Good news! Thanks to the Tableau engineering team, this issue has been fixed in the latest version of Tableau Desktop's ServiceNow ITSM connector. No need to manually update any client software - just open a new connection and the Metric Results table will be available to you. Big thanks to Drew Loika and the Tableau engineering team for the fix!

-Gray