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 "...
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?
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...
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...
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. ...
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...
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...
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...
Hi, I have figured out a script to export report using csv format which is great but i cant export more than 50,000 recordsI have tried the logic of looping through and exporting 50,000 records at a time and combine them at the end but specifying a n...
Hi there - I am working with Dashboards in an older release of ServiceNow, Jakarta. Is it possible to deploy a standard, out-of-the-box calendar widget for my Start and End dates? In other words, a little pop up calendar for a Start date and anothe...
I am attempting to combine the Incident table and the Task table to create a custom report in ServiceNow. When reporting using the Database view I can pull most of the information except the additional comments and work notes don't come over. The...
Hello Everybody,I would like to know how to manage to see my TAGS on a report in 2 différents table (INCIDENT and Req).In fact, in my instance ServiceNow i can see my Tags ( Screenshot below : "Télétravail") directly on the table REQ (Éléments demand...
Hi. I'm very new to ServiceNow, and am working through a few basics. I'm not entirely clear on expected behavior, so please let me know if I'm missing something here. In short, I'm trying to create a very simple iFrame to load static content. T...
Hello,Wish you all a very Happy New Year.I am trying to build an Indicator to calculate the Summed age of Assets (to later find out the Average age). The asset table has the columns for Release Date and Retired Date and I need to calculate their diff...
My company uses a survey that is tied to a questionnaire. I want to pull the responses potential clients give to the survey into a report, but I don't know how to determine which table and column contains that information. Any pointers on how I might...
