ITSM forum
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

How Do I Report On Aggregates and Calculated Fields

I'm hoping someone can point me to documentation on how to do more complex types of reports.   I'm out of the SQL Server world and need to be able to produce reports where the query might look something like this:SELECT a.FieldA, SUM(a.FieldB) TotalB...

johnfeist by Mega Sage
  • 3992 Views
  • 2 replies
  • 1 helpfuls

Resolved! Add Time to date field

Hi I have to add time to date field. Please help me on how to achieve thisExample, I have below two fields:( Date Type field ) EventDate : 09/11/2017(Time Field) EventTime : 13:00:00Now I have to calculated the StartDateTime and EndDateTime Values:St...

pdom by Mega Expert
  • 5415 Views
  • 3 replies
  • 1 helpfuls

Resolved! Fields are made invisible using UI policy on form. But when try to open the popup from list view using reference icon these fields are still visible. Is it a bug?

Fields are made invisible using UI policy on form. But when try to open the popup from list view using reference icon these fields are still visible. Is it a bug?Attached screen shot. After mouse hover the popup opens and the field outage planned dur...

shivanagouda by Kilo Contributor
  • 3667 Views
  • 9 replies
  • 3 helpfuls

Resolved! Providing access to the Private Task Table

Good Morning-I have a user who needs to report on how many PTasks there currently are in the system.   I created a report with a count and added this to their dashboard.   Everything works, except when they click in and see the list view.   This give...

wmitchell by Kilo Contributor
  • 5751 Views
  • 3 replies
  • 4 helpfuls

How to use ui action in service portal

Hi,I have a requirement in service portal where in the normal GUI i have a client callable ui action which in turn would render the ui page and from that ui page a call is made to another ui page. The same ui action functionality should be available ...

Set up FTP Data Source

Hi,I'm sure this will be obvious, but I need to set up my _first_ FTP data source to retrieve a file from a server and import it to ServiceNow. I've reviewed the SNOW sites and Community and am having a hard time figuring out what needs to be set up....

jmoore by Mega Expert
  • 3694 Views
  • 2 replies
  • 2 helpfuls

How to execute ping command from scheduled job?

Hello I am new bee to scripting in SNOW. We are on Jakarta. I have following snippet from a scheduled job and need to run a ping command on a host to find out if the host responses or not. If ping fails I set host to retired. I have some vision that ...

find_real_file.png
Rajanmehta by Mega Guru
  • 3241 Views
  • 4 replies
  • 1 helpfuls

What does the "parent"column in sys_ui_list table mean?

the sys_ui_list records of same view (such as default ) of same table (such as default list views of incident) have a column called "parent" which is normally filled with data such as "change_request" or "incident" or empty .What do these mean and wh...

find_real_file.png
prasanna11 by Mega Guru
  • 1941 Views
  • 1 replies
  • 0 helpfuls

Export list to Excel from Portal

Hi community, I am using a Data Table from Instance Definition With to display Incidents on the Service Portal, with the following columns:But when I export the list as Excel, the following fields\ columns are missing           - Product           -...

find_real_file.png find_real_file.png
lexdiaz by Giga Contributor
  • 4005 Views
  • 1 replies
  • 2 helpfuls

Worknotes getting posted twice in activity log

I am trying to enable hyperlinks in work notes by using a business rule that recognizes a regular expression. Business rule enables the hyperlinks and that hyperlink enabled worknotes we enter are getting posted in activity log.Along with that, OOB w...

sri-nidhi by Kilo Contributor
  • 1070 Views
  • 1 replies
  • 0 helpfuls

Article for g_uri,g_request

Hi ,I was unable to find any relevant information for 'g_uri','g_request' objects .Also I needed some more in depth info for 'Navigation Handler' .Please let me know if there are existing articles for the same , If somehow I might have overlooked. Pl...