Help in creating Breakdown on catalog variable referring to Cmdb table

kriti2 · ‎08-31-2019

I need to created a breakdown for a catalog item variable. Need help as the data is not showing up in the breakdown. I am new to PA advance reporting.

I have a variable name as "Server Name" referring to cmdb_win_server the requirement is for created breakdown for this:

Created break down source and mapping :

and the scripted mapping is:

Log 1 and Log 2 is running successfully Log 3 is giving java error:

Can anyone help me on this and guide me 🙂

Thanks in advance.

Ankur Bawiskar · ‎09-01-2019

Hi Kriti,

you are not querying "cmdb_ci_win_server" table in line number 9 properly

change it to below use get method and not getValue() while querying

grChoice.get('name', grReq.variables.u_ci.getDisplayValue());

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

kriti2 · ‎09-08-2019

Hi Adam,

Thanks for sharing the best practice tips. Could you please elaborate on how can the same requirement to achieved by a view without querying? Because this is kind of interesting to know how can this be achieved for a breakdown.

Answer for point 2. This a POC I am trying to do to see how can we create a Breakdown on the catalog variable referring to some service now table.

Your suggestions are welcomed!!

Adam Stout · ‎09-08-2019

It would be very similar to what you need to do to setup Text Analytics. Take a look at this blog post for how to set up the database view: https://community.servicenow.com/community?id=community_blog&sys_id=9c46571ddbf7a7c0fff8a345ca96194e