Resolved! How to Import PC Assets into Service Now
I'm looking for either some assistance or a basic course on how into import PC assets from an excel spreadsheet into Service Now please.
Forum Posts
Shows incidents created between two hours in a period
Hi, I need to create a report that shows incidents created between two hours, for example between 1 o'clock and two o'clock in the period 1 January to 30 January.Is it possible to do in PA?/Peter
Resolved! Access to scoped reports
Hello..I have the following 5 reports below created by ServiceNow contained with Application scopes. When I try to view these as an ITIL user using the 'Reports > View/Run' application and module they do not display. Same for me as an Admin unles...
Resolved! Problem with indicator score
Hello,I have created an indicator and when running a job against it, it distributes the total count of an incident across each month, meaning it displays somewhat the same values across each month. Below are the additional information:Indicator Sourc...
Resolved! Multiple Dataset Report, how to eliminate or rename the label of the first data point?
In creating a standard report, using the "Multiple Dataset" feature offered by PA Premium, I find that the original dataset inherits the name of the table that it is created against. Any ideas on how to change that? My first dataset is named "Inc...
how to use GROUP BY clause in database views
i have created one database view to join incident and sys_journal_field table. If i put a condition as t1_element_id=inc_sys_id, then i am getting response. However if we have "y" number of comments on "x" incident, then that "x" incident is coming "...
YTD and MTD results
Our team is attempting to produce an indicator that calculates the 'average number of incidents created per day for a given month', and the 'average number of incidents created per day for a given YEAR'. Requirements stipulate that we need to displ...
Resolved! Performance Analytics for Incidents
Hello, How are you using Performance Analytics for Incidents? PS. What's the difference (technical view) between Performance Analystics and normal Reporting module available OOTB?
SCTASK - reporting on the assignment history
HelloI have created a nice report against the Incident_Metric table. This allows me to query on when a ticket was transferred to a group and to show it as an opened ticket based on the transfer date. This means if a ticket was opened in August and wi...
How to pull the report based on Assigned Date
Hello,I need to pull a report based the assigned date to any Assignment Group, we need a report where tickets are not updated since last 5 days these 5 days should be based on assigned dateI am able to pull the report but not able to filter as per th...
How would you link the question_answer table to the change_request table
We have a variable set with Questions for Change Risk Assessment when Changes are logged via the Service Poirtal. The questions and answers are added to the Change form in the 'Change Varaible Editor'The Change Manager would like to extract teh Quest...
Resolved! Should the "Context Sensitive Analytics" dashboards contain widgets out of the box?
We've recently purchased Performance Analytics Premium and activated several of the context sensitive analytics plugins. When we try the "Context Sensitive Analytics - Change" dashboard (and the ones for Incident and Problem), we get no content. ...
Scorecards are empty
Hi!I've created numerous indicators and none of them seem to show any results on the scorecard. I've created autometed and formulated indicators and none of them show data. Can somebody help me understand why? I' have indicator sources and a job coll...
How to clear Indicator scores ?
Dear Experts, I want to change the indicator source in indicator, When i try to change indicator source,I got pop message "Indicator Source cannot be changed because this indicator has scores ". I have used this indicator in many of the widgets and d...
Resolved! Reports in Dashboard - Display data table (+) Icon missing
Hi,I have created few reports using Trend chart. We don't want the data table to be expanded in the dashboard since it consumes more space but we want the data table to be compressed in the dashboard. When the users need to view they will click on th...
