Hi, We'd like to report on when a ticket was moved from Assigned or Queued, to Work In Progress. We see these updates are categorized as "Field Updates". We created a db view linking the incident table with the sy_journal_field table, but don't see...
Hello, I'm not sure what I am missing here. Executing Scheduled Email of Report with below condition script. If I hardcode the grList value, it is working. This schedule is var answer=false; var scheduleReport = new GlideRecord('sysauto_report');s...
Doing some clean up and want to remove widgets that aren't being used. I see there is a dashboard count but want to see what dashboards are using the widgets without having to go through each and every dashboard manually. Is there a way to see form a...
How to Report a set of Catalog Task (SCTASK) and their variables together in a report? The fields of SCTask and the variable names should be each column of the report.
Good day Everyone, I would like to ask for your help. I am making a report for all our MS SQL Instance CIs and all the Databases that it contain. I am looking at the following tables in the CMDB (cmdb_ci_db_instance, cmdb_ci_db_mssql_instance, and cm...
I have used the function field feature in reporting. I want to do a function that tells me the number of days (duration) since the last update. This means that I need to know today's date/time - Now(). I cannot use any other functions (other than tho...
Hi, Trying to satisfy a user requirement. They want to find the average number of hours logged as Time Worked on Catalog Tasks, but the answer must be (total number of Time Worked hours) / (number of tasks). The various reports I've tried (based on ...
Hi team, I've created an interactive filter (filtering widgets/reports on company) which I've manually added into each individual TAB. In hindsight, I am sure it would be more intuitive to have one interactive filter (added on the first tab) which th...
Hi, I have a table which contains date/Time field (FieldA) and I want to create a report to show me the records in which the field A is 2 weeks or 2 months from now Purpose is so that we know the date is approaching within this time to act upon.. Wh...
I'm going to preface this by saying i'm a complete novice with ServiceNow, so apologies in advance. I'm interested in creating a report that shows me all tickets logged by users within two weeks of their creation/import date. From what I've read, I ...
Hi guys, This is a simple task I presume but I am not able to accomplish it. Do you guys know how I can transfer a dashboard under my ownership to someone else. As in make him/her the owner? So far I tried with the Dashboard Properties, but it shows ...
Hey everyone, I would like to pull when assigned to field got changed for the first time on the incident table from the history sets table. Is it possible? I would not like to use PA for reporting. Please let me know if anyone can help me with the sc...
I have created a dashboard to display several reports related to my Business Applications. The reports display data from the Business Applications [cmdb_ci_business_app] and Mapped Application Service [cmdb_ci_service_discovered] tables. I am now att...
Hi Everyone, Please guide me on how to create a report to : Show time worked by assigned to for an account by Asset,Product,Contract.How to sum time worked for a particular task. I created a report using Table : Time Worked and an interactive filte...
Hi All, I want to calculate the age of the incidents , requested items and catalog task on the table. Could some one please help me on starting from creating the Age field and till it calculates the age.
