Hello All! Second post here, thanks in advance for the help. I had previously written the forums asking for help with querying the cmdb_ci_outage table , piping those results to a flat file. I was able to do so successfully using the ServiceNow ODBC ...
I was curious to see if anyone had created a new getMyGroups() function and if so how they did so. We are running into issues where we want to get a users groups but we do not want to pull back the parent groups. With the current function it will pul...
HI, We are doing the integration of event monitoring tool(CA-SOI) with Service-Now and need to know that is there any specific port number which needs to be enabled at our end in order for them to consume the webservices/ WSDL.
There is an event created on discovery_device_history table. Want to take some action when the event is fired. I have already performed the following steps: 1. Register the event (event is registered in table : sysevent_register)2. Fired the event in...
Hello,I created a UI Action where I query a table from the CMDB and update data on a form with the results on a Catalog Task page. One of the values I am retrieving is a Choice List and I would like to get the display value and populate on the other ...
Hi Everyone,Last time my manager asked me to check if system support Method Overloading concept and I created a business rule with two Methods with different parameters, then I called 1st method in another business rule. but the result was not in sup...
We have 3 instances (prod/test/dev) and I'd like to lock-out all non-admin users in test & dev. Is there any easy way to do so? Sounds like a routine script or option, but the only unhelpful reference to this is in the post-cloning checklist (User Ac...
I Researched, found and loved the SNCGuru Update Set for scheduled report extracts, Until I installed and understood it. Unfortunately, it only supports FTPS and not SFTP. I could not find where the package ftp4che supported any other protocols.Any s...
We are hoping to create an activity log but there are certain activities that we would like to hide from certain viewers. Does anyone know if it is possible to hide certain activities from certain groups? Like an end user not being able to see a spec...
Hello,I have an XML SOAP request that gets sent out regularly to an external vendor. Our vendor is saying that we need to HTML encode our apostrophes in our messages. These show up in user last names such as O'Donnell.I have tried to replace the apos...
Hi,I am trying to create a business rule to get the duration between two fields. I am using below script to get the duration:*******************************************************************stts = current.u_status;if (stts =='Published'){var strt =...
I am trying to duplicated the current "Change Request" application for another organization to use.So so far,I've extended to the Task table, create the "New Change Request" application, build my form, copy all the business rules, client script, noti...
Data sources - what is "Use last run datetime" and how to use it?The documentation on 'Use last run datetime' is a bit unclear.example:table: studentcolumn: namecolumn: is_enrolledcolumn: total_pointsWhat might make a suitable Last Run Table Field?Ho...
Sometimes I want a MID server to start a task on a remote system without doing a discovery probe or a remote data import. Of course this could be run manually or as a cron job on the MID server, but I want to consolidate control on the Service Now in...
I have a field that I need to set in a subject line of an email. The email is coming from the "request" table, and the field is on the "sc_cat_item" table. I have a mail script within the email body, but I need to set the field in the subject. How ca...