Report Creation in Zurich - stuff changed???

[terrieb]

I am trying to create a Requested Item report and chose columns from the catalog item variable.  This has always worked in the past (before Zurich).

Now, however, when I run the report, those columns are showing blank?

Did something change in Zurich that is NOT in the release notes?

Does anyone know how to get variables from a catalog item populate in reports now???

See screen shot attached.

[Dr Atul G- LNG]

Hi @terrieb I don’t think it has changed, but yes, ServiceNow recommends using the platform natively now instead of legacy reporting.

[terrieb]

Is there any documentation on how to use the platform natively now instead of legacy reporting that I can read to see how to create reports now?

Thank you

[terrieb]

OK I attempted to create a platform analytics new visualization and even though I put in conditions and added variables to the column below I get this:

Returns ALL records, not just the VPN ones

The Variables column is still blank

see screen shot attached

[Tanushree Maiti]

Hi @terrieb ,

There is no change in Zurich release for creating report on catalog variable.

Refer: https://www.servicenow.com/docs/r/now-intelligence/reporting/rep-service-catalog-variables.html

 

Probable Cause:

1. The variables data is stored on table "question_answer" 

2. The Out of the Box ACL  "question_answer==>read" will grant access only if user is admin or has a "catalog_admin" role.

3. Any users without these (admin or catalog_admin) will not be able to view the variables data on the list report

 

Probable Resolution:

Solution is to create a read ACL on table "question_answer" to provide access to the user / group of user , having a specific role as per business requirement.

refer: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0826409