Hello, I'm searching for a solution to create a report that shows all open changes in the state "Plan" where all underlaying change tasks are closed. I'll try to explain the need of this report: In our instance we have the workflow configured that se...
I need to create a report to find all RITMs (parent) that contain no active TASKs (child). I know how to get information about a parent from a child by using things like "Parent.Updated", but not the other way. Is there something like that I can use ...
Good morning, I am trying to figure out how to run a report on how many times certain URL links were clicked on that are in the Solution field, or Body, in Knowledge Articles. We have a Stream Channel set up that contains knowledge article how to vid...
Hello, I uploaded images to the Static HTML Widget and added text on my dashboards. The widget appears as expected for me, showing the images and text as expected. Users I have shared the Dashboard with do not see the images, just the little icon ...
Without creating a database view, is there a way to create a report that will show: User GroupRole For example, the report for me would include multiple lines: UserGroupRoledoormoldChange ManagementcatalogdoormoldChange ManagementitildoormoldService ...
Today, we need 4 separated reports in order to retrieve all the project information which is needed for some governance meetings: One based on pm_project table to get the project state, status and some attributesOne based on the project_status table ...
I'd like to create a pivot table that only has a column for Assignment Group and one column for the Total number of Tasks assigned to each group. It seems that ServiceNow requires to divide the columns with at least one additional field. Is there a w...
I've created a dashboard that includes 3 reports and an interactive filter. The interactive filter uses the company table to filter all three reports. The filter works for itil users but not for business_stakeholders. When I impersonate a business...
Good Day everyone, Thank you in advance for your help. As part of an application I am building, I need to be able to create reports and dashboards automatically once a user fills in a form with the necessary information. Is this possible, are there...
Is there a way to make it so that reports that have not been run in over a year cannot be executed? In addition, on the page of a report that has been disabled this way, would it be possible to display a message saying "this report has been disabled ...
Greetings All, I have a question about the definition of Last 3 Months in reporting. I often will create reports that use Resolved Date On This Year/Last Month/This Month, etc. What I found when I used Last 3 Months however, is that t...
I'm trying to create a view where I can see tasks for demand and tasks for the project table. I works fine when using on only a joint view between the demand task , demand and project table. But, when I try adding the project task table to the equati...
Hi all, I need to create a pie chart, based on Knowledge Articles (table kb_knowledge) that are in the Draft workflow. Some of these KAs have been created based on an incident, others are created from scratch. If a KA is created based on an incident,...
Hi all Keen to hear about any best practice approaches out there when it comes to managing sysevent volumes. When there are too many events being processed typically caused by a rouge source generating and queuing too many events, this can seriously ...
I need/want to use the coalesce function to consolidate data fields from the Demand, Project, and Program fields in order to report on allocated and actual time. The three tables are used in a database view along with resource aggregate monthly, and ...
