I'm working on the report to display Catalog Variables along with Task, Item and Request. I've created a database view to join sc_req_item, sc_task and sc_item_option_mtom tables. The report displays all variables with value in the same row. Is it po...
Hi,I have a before query business rule on a table where the records are displayed to the user depending on the roles. It is working fine for the records in the table. There is a report for the same table. The report needs to display the count of all ...
Hello, Attempting to find a way to adequately report between the wu_appointment, interaction (and/or interaction_related_record), and incident tables. If I create a report from the wu_apointment table, I can obtain WUA and IMS numbers, but cannot fi...
How do I create a widget that would show how many inc tickets were open on a specific day, in Performance Analytics? For example, if I want to show how many tickets were open on the first day of each month for the entire year. Thank you in advanc...
ServiceNow recommends that you have at least 30,000 to 300,000 data. What if we have less than that for predictive intelligence module.
Hi! In incident and Request management we can attach a quick message template using email client. How can I report on which assignment groups used which quick message template/vice versa?
I need to create a report for company table. The report should show company name, total incident reported and total number of users. I am not sure if this is even possible in ServiceNow. Any idea? Report format: Company Name (From core_company table)...
Hi, I’m trying to calculate the average number of incidents we have across each hour in a day, over the last 12 months. So far, I've managed to create a column graph that shows the TOTAL number of incidents we've for each hourly time period across th...
I am trying to write a script using a generic script, however my "Valid To" date is in Date format, not in Date/Time format. The difference between the Valid to - Date field vs Score - Date/Time field is causing issues with the script var diff=functi...
We have implemented a dashboard which data comes from an external link.Is there a way to show time/date of update in the dashboard ? Thanks in advance
Hello, I've been searching high and low and unable to figure out how to set a tab within a dashboard I created to default. I've looked in the dashboard properties, but do not see anything related to default tabs. Thanks!
Hello, I'm facing an reporting issue, which i do not understand. I have tagged several support groups with an tag and made these tag as global visible. After that i was trying to setup a report on all task_sla belongs to groups with this tags. When ...
Hello ServiceNow Community fellows; I am trying to build a report on the Comments that Analysts put inside the Analytics Hub, on specific data points / indicators / breakdown, elements. The comments are stored in a table called pa_score_comments and ...
What is the recommended way to report on watch_list CONTAINS "email address". The default filter UI always assumes a user reference, but we can add emails to watch lists manually. How can I filter and locate specific email addresses OOB? I've had to ...
Investigating the impact of the Report view ACL.How can I check if a report is being viewed?I also want to know if it is used in the dashboard.Since it's a report created by SystemAdministrator, I don't think anyone sees it.RegardsSota
