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 ...
Hello, We have a request to add count trend line to a existing column graph, which will help compare average outage time vs. monthly outage count (see pictures below). unfortunately, I have not been able to locate a solution to successfully accompli...
I created an interactive filter on the sys_user_group table which loads up all of the groups that a given user manages as well as the groups of the managers under them. This is accomplished by calling a script include in the interactive filter. Essen...
I have a report where my knowledge base articles numbers repeating putting views separate. I know this is because of newer version are being made, but I need total views for single knowledge base article number. I need it this way because when I send...
I built a report to show all stories in the current sprint but I don't know how to configure it. I want to report total stories per date, that is, the created plus the existing stories.if I choose trend by created it only counts the created stories a...
