Resolved! Database View
Can we create database views without reference fields? or is it mandatory to have reference fields available to join tables, kindly assist, Thanks!
Can we create database views without reference fields? or is it mandatory to have reference fields available to join tables, kindly assist, Thanks!
Hi Team,I would need help, i need to run the report and fetch incident ticket data for 149 assignment groups. I don't see any such option available in report section for adding multiple assignment group. Appreciate your help. Regards,Garvit
Hi,I need help regarding the below scenario. Can anyone please help me? In the portal when we are filling out a form for the request by selecting the particular service category (as shown in the attached picture ) the Excel sheet should be populated ...
Hi All, Once request is submitted, RITM will be created. I am generating report (in PDF format )for catalog item variables filled or selected when user will submit Service Request.I have created report on table "sc_item_option_mtom". If the Question ...
Hi All,I have a requirement Actually in record producer, i am using a Variable set , in that , three fields, " Selected user(Reference field), type of leave and time of period ", So here the field 'leave type' was only visible , when the user(Selec...
Hi Experts, I have created a after insert business rule on [sys_audit] table. But it is not working.
Hi community, I've tried a 3rd party tool that has an endpoint of /api/now/table/task As far as I know the task table is a parent table of incident, case, change, problem since the external users can access the case table to get their cases through t...
I have tried using a get method using an endpoint of /api/now/table/task I don't know what is the logic or the default filter for it, is it getting all the records of the user can access to? I thought it would be just like the /api/now/table/sn_custo...
Hello everyone, We are currently facing an issue where the Requested Item (RITM) is not waiting for request approval as intended. In our scenario, the desired behavior is that upon requesting approval, the RITM's execution should only start after the...
I have created an email template that auto populates the body with a sign off template. I have set the conditions and this seems to work seemingly on the sn_customerservice_case table but not on the sn_customerservice_task table. I recreated the same...
I have created workflow as per requirement if after creation of catalog task to fulfillment group Servicenow group up to here is fine. After that I have kept the If condition Please help me how to kept the if condition for this requirement.catalog ta...
What is the use of sys_attachment_doc table.when I trying to copy attachment from ritm to sc_task I found a code in community where they copied attachment to both sys_attachment table and sys_attachment_doc table.*Can anyone explain me thislink to co...
Hi, Requirement - once the incident is resolved, resolved email notification is triggered to the user where in email body , smiley images from dissatisfied to satisfied images should be present . Once the user clicks an emoji for e.g . Satisfied e...
If any user having ITIL License and not logged into Smart Desk system for more than 45 days then remove the ITIL License.Create Schedule job to check the Last Login of users having ITIL Role.Send Notification to user on 30th day copying Group Manager...
As an ITIL User, I would like to have access to a dashboard that easily provides me information about the Incidents that are assigned to me and my groups so that I can efficiently manage my workload throughout the day. The ITIL User dashboard should ...
