Resolved! Change data format for Scheduled Email of Report
Hi everyone, I'm using Scheduled Email of Report, but How can change date format of data fields from yyyy-MM-dd to dd/MM/yyyy? Thanks, Gaetano
Forum Posts
Resolved! PA script time difference from now
Script I have:var diff=function(x,y){return y.dateNumericValue() - x.dateNumericValue();};var mins=function(x,y){return diff(x,y)/(24*60*1000);};mins(current.opened_at, current.now);I need something to replace the now that will give me the time diffe...
Record count in database view
How to create a record count in database view? I can't do this with core reports. The record should include these fieldsHeader 1Header 2Header 3Header 4Header 5QuestionDatePersonResult= yesResult= No
Resolved! Is it possible to create a report which shows all ticket types?
Hello Everyone, Is it possible to create a report which shows all ticket types? When I try to create a report, I can only select one table for each report. I would like to create a report which will show all the tickets (incidents, requests, etc) our...
Predictive Intelligence getting unauthorized state in solutions
Hi,I'm trying to train machine with pre-defined solution definition in my PDI.all solution are going to Unauthorized state.I have admin role, checked credentials and service worker user is active too.Kindly help me with the issue, I'm getting same is...
Resolved! How can a report be built to show the previous full 3 months?
Seems like a simple request but I'm having trouble getting the previous full 3 months. Using these conditions: Created <relative> at or after 3 months ago AND Created <before> this month I am getting November (partial), all of Dec and all of Jan. Mis...
Resolved! Map Report - ERROR: Cannot generate the report. Chart series summary generation failed null
We have a filed on our incident form called affected location. It is of type list and references the cmn_location table. I have the latitude and longitude set on the location and created a map source but I get the "ERROR: Cannot generate the report...
How to create an interactive filter on multiple target columns in the same target table?
Hi all, I am trying to create an interactive filter on Incident table with multiple column. Basically I am trying to create an interactive filter for daily, weekly, monthly resolved and closed incidents. for eg, I am trying to replicate this conditi...
Resolved! Database view filter for 'is not null'
Hello,I'm looking for the syntax for how to filter a database view for a field is not null. Example&& inc_major_incident_state="rejected"-If a database view using the incident table had the above filter condition added to the where clause it would re...
Is it possible to report on when a state changed (in the worknotes), not the state itself?
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...
Resolved! Scheduled Email of Report throwing error: Illegal use of while loop in sandbox scope: org.mozilla.javascript.Parser.whileLoop
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...
Resolved! Is there a way to see where PA widgets are being used? (ex: what dashboards)
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...
Resolved! How to Report a set of Catalog Task (SCTASK) and their variables together in a report?
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.
Resolved! How to Create a MS SQL Database to Instance Relationship 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...
Time Since Now() in a Function Field in a Report
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...
