I am looking for a way to move/modify the data at the top of a PDF report export. The specific information I would like to move to the bottom of the report is:Report Title, Run Date and Time, Run By, Table Name, Query Condition, Group by and Sort O...
Hi.. from my understanding within the system it defines a week as Monday - Sunday. Is it possible to change this to Friday - Thursday definition
Hello,I'm not sure how to implement this enhancement, if anyone can advise? The business requirement is:When a ticket (incident or catalog task) is reassigned from one group to another, they would like to have a reassignment reason (whether it's beca...
Can any one describe what is ACE report?
Hi All,I have been exporting the data of one of the table into Excel and found that it gave me 95 number of records whereas in the service-now instance it shows only 34 records.From where these extra records are coming from?Need Suggestions please.Re...
Hi,I need to take the sum of resolve time (calendar_stc) in an automated indicator from the distinct incidents achieved from the database view which is the join of incident and task_ci tables where incident_sys_id=task_ci_task. There is a column in t...
Hello Experts,We are facing the long transaction time issues for some users. If they open the incident or problem form and update the ticket, then it is not updating and transaction is running for long period. This is not reproducible if we impersona...
In PA - Scorecards, few of the reports reflects the future date. For example: "Number of open incidents" report shows the date range till 12th Jan'16. It should update on daily, It is showing last updated on Jan 12, 2016 but the date is future date.P...
Hi All,I Would like to know the survey response rate means how many surveys we have sent and how many responses we got . how to do this in single report. i can able to create the report for responses but i need count of rensponses and count of survey...
I have a user table that has 110K plus records. I am trying to get a breakdown of a team by user. When I create a breakdown source off the sys_user table I get the following error: "This breakdown source was automatically disabled because the num...
Hi All,If i wanted to break down the age of open tasks by assignment group, what would be the best way to accomplish this. Currently we have an 'Open tasks by age breakdown' gauge, but it doesn't shows us exactly which groups are carrying these 90+...
Hi,The widgets added on the dashboard are suddenly disappeared. If I am trying to add them again it is only loading I am not able to add them again. I am able to retrieve the scoresheet for the particular automated indicators. But they are not pres...
Hi,Trying to figure out query to show tickets that were open for 8 hours or more without any follow-ups for a specific assignment group ? So for instance, after a ticket is assigned to a specific team/assignment group, I would like to query slips tha...
I was looking through PA Wiki and videos. Is it possible to combine data from multiple tables and create metrics/historical data from that?Example: I want to see how many change requests that are being created from an incident.
I have existing metrics that calculate duration and business duration of certain scripted conditions. I would like performance analytics to help calculate averages and provide charts to visualized these indicators. For example, The metric is Rele...