How to get catalog item variables in report or db view?

[Fathima6]

How to get catalog item variables by joining sc_req_item and sysapproval_approver tables to get requested items that are approved by users from a particular team and raised by using a particular item. I need record fields with that particular item fields along with sc_req_item and sysapproval_approver table fields. I tried in report and database view but can't able to get catalog item variables in the report . Please, can anyone, help me in this?

Thanks in advance 

[Ankur Bawiskar · Accepted solution]

Hi,

check this out of box feature

https://docs.servicenow.com/bundle/london-performance-analytics-and-reporting/page/use/reporting/concept/rep-service-catalog-variables.html

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

[Ankur Bawiskar]

Hi Fathima,

Any update on this?
Can you mark my answer as correct, helpful if you were able to achieve the requirement & close the thread. Thanks in advance.

Regards
Ankur

[Ankur Bawiskar]

Hi Fathima,

Any update on this?

Can you mark my answer as ✅ correct, 👍 helpful if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards
Ankur

[Adam43]

Fathima- i'm curious if you ever solved this- i'm in the same use case.  We're on sandiego, moving to Tokyo soon.  I don't see where Ankur's links to PA docs is much help- nothing specific in the product about this use case.  

I've created a database view that links sysapproval_approver with sc_request and sc_req_item.  now i'm working on getting the variables from the ritm into it.  the Item Option and Variable Ownership tables (sc_item_option and sc_item_option_mtom) are involved, but i'm struggling.

this post has been guiding me: https://www.servicenow.com/community/now-platform-blog/report-on-item-variables-in-the-service-catal...