Report not displaying variables in database view.

[Balaram7]

Hi all,

I am trying to create a report on RITM and Attachment table by creating a database view.

Iam able to view the attachments and RITM number, but unable to select the variables.

Do i need add another table to database view to get variables information.

or is there any other way to get the following fields in the report.

(Attachment link, Ritm #, variables1, variable2, variable 3.)

please help me if there is any possible ways to get this requirement done.

[Tanushree Maiti]

For variable , you need to add another 2 tables in your database view (joining sc_req_item with sc_item_option & sc_item_option_mtom)

sample

Table                                                         Variable prefix                                     Where clause

sc_req_item                                                    ritm              

sc_item_option_mtom                                mtom                                                  mtom.request_item = ritm.sys_id

sc_item_option                                             option                                                options.sys_id = mtom.sc_item_option

Refer: https://www.servicenow.com/community/sysadmin-forum/ritm-report-with-all-variables-and-approval-deta...