Hello all, good day! I am confuse with the table use for incident resolution time calculation, there is two way i see so far , but i am not sure which one i should use , which is correct one. Report 1: Table = Incident [incident]Aggregation = Average...
Hello. I want to create a report that should show me all incidents that have been created the last 31 days. Conditions should be, group by CI(Customer ID), and it should only show groups with 5 or more Incidents in them. Anyone have any tips for me...
Hello there! We have a UI action button called 'Close Task' on sc_task table. But just for one Catalog Item Task, I want this to be renamed as 'Close/Approve' (something like - if catalog item is xyz, then label should be 'close/approve' else remain ...
I deleted a view today and I need too recreate it, but when I try to create the view I get a message saying that "table name xxxx already exists" (where xxx is the view table name). I can not find this view in the list view, or in the dictionary; but...
Hi All, I wanted to create the standard change template from workflow. The workflow is triggering for one of the catalog item where all the required information are captured. I have created the below script to create standard change template and temp...
Build: London I have service catalog tasks [sc_task]. Which are children of my request items [sc_req_item]. Which themselves are children of requests [sc_req]. In the OOTB instance, an SCTASK has a reference field, which allows for lookups and it h...
Hi, In several of my workflows i have an approval user step that triggers an approval to the assigned person. This can be for changes/incidents/KB articles etc. What im trying to understand is where is it dictated which email is sent. This is for a ...
Client want to auto populate Deliver to address for the user. Currently it is empty in Service Portal.This is working from navpage , Isssue only with Service Portal.I tried to modify SC Shopping Cart Widget, it is working when we change requested for...
How can I create an OnSubmit catalogue client script (applies to a cat. item, UI type: Mobile/SP), but ONLY when let's say variable A has value X, and variable B has value Y on this cat. item? Technically I need a script that is first OnCondition and...
Is there a script where I can take the value that user enters in Requested Item variable and populate that value in a sc_req_item field Thanks
I need to access "sys_user_grmember" table for user being part of a specific group, if so return the user and match requested_for user. I'm having problem when a user is part of multiple groups, then the script only checks for first group and returns...
Hello Team, Need to understand regarding CMDB CIs Related Items field (Application : Server relationship) status change ("In Use" to "Retired".) While changing the status of a Server CI items (Servers->Linix, Windows, AIX, Solaris etc..) , what are t...
I have 2 business rule businesss rule with order 100:in This one i made state to Resolved whenever child case complete Buisness rule with 0rder 150:In this i made state to work in progress whenever child case complete Which one will excute first and ...
Hi All, Seeking assistance how to get the assignment group from the Standard Change Template and use that as the same assignment group in the Standard Change Proposal? That CAB Approval assignment group is in the template and I want to get that same...
I need to convert closed date into epoch seconds and put the value in other field. Any help is appreciated.
