Where role are stored?
Hi All, Can any one confirm because I have some doubt on the below: Role are stored in : sys_user_role (table) User's role are stored in : sys_user_has_role (table)
Forum Posts
Can I insert more than one import set record using/consuming the native REST API for import sets?
I'm facing an scenario where an organization wants to use a REST web service living in Servicenow to create more than one asset in one call. Analyzing the capabilities of the REST API for import sets, I understand only import set record can be create...
Mail script to get Approval Comments
Hello Im trying to create a mail script that I can use on the approval of a knowledge article that will contain the comments added to the approval record but it doesn't seem to work. this is what I am trying to grab This is my script: (function run...
Resolved! ClassCastException When Instantiating Script Include in Transform Map Script
Hello! I am trying to use a script include I've written to make an API call to populate a field during an import and I keep getting "Import set: ISETXXXXX transform stopped due to error: com.glide.rest.outbound.scriptable.ScriptableRESTResponse canno...
Resolved! Why is the typeahead search widget not showing knowledge articles?
When the user searches in the typeahead search widget, only service catalog options appear, and no knowledge articles. If we press enter, and complete the search the knowledge articles DO appear on the search page. I'd like for them to also show o...
Automated Test Framework (ATF) preserving configuration after Clone
Hello, We are seeing an issue after we clone where some of the ATF test steps are not being preserved in our Test instance. In the screenshot below I have highlighted the field that is being wiped: After the clone this field is empty and is required...
Resolved! I wanted to give Write Access to only one field on form using ACL but its not working?
Hi, I wanted give write access to only one field on a form and read access to all fields on the same form. I am doing this, But not working properly. 1. Created record-read-table-none ACL. No role was used, so that all users can read. 2. Create...
Resolved! Unable to get multiple values in List Collector based on other list collector variable
Hi, I have 3 List collector type variables (i.e Organization, Host Groups, Hosts) on the form. I should be able to select multiple options for each variable. Host Group list collector options should be available based on the selection of the organiz...
Resolved! Scheduled Report - not working with condition
Hi all, I would like to send a report every hour between 15:00 and 20:00, every day except for Sunday. The scheduled report is configured like so: I have the following condition in a scheduled report (based on @Brian Lancaster 's answer here; thanks...
Resolved! Glide Records : My insert script inserts multiple(100+) records in table
Instead of single record below script is adding multiple records in table. var s=new GlideRecord('u_empdata');s.initialize();s.setValue('u_first_name','John');s.insert()
Resolved! Cart API - Is GlideGuid.generate(null) really needed when using Cart API?
I would like to understand the Cart API better and I want to know if it is release necessary to execute GlideGuid.generate(null)? Version #1: var cartId = GlideGuid.generate(null); var cart = new Cart(cartId); Version #2: var cart = new Cart(); Can...
Resolved! Cannot Delete Column in Scoped Application Table
I created a scoped application in our Dev environment in which we created some of our own custom tables in. We then installed this application in our Test environment.I went back and updated one of our custom tables in this scoped application. Ba...
Resolved! Public Knowledge Base Using Service Portal
Hello all,We received a request to make knowledge base public so any user can access knowledge without authenticating in ServiceNow.A couple of months back someone suggested using the Service Portal, but we were still on Fuji. Now we have upgraded to...
Service Portal with wizard-like order guide/record producers
Hi, I’m looking for a solution to provide a wizard-like order guide in a service portal widget. I’ve noticed that a few community members have asked the question and have yet to find a concrete answer. I attempted to use the SC Order guide widget, b...
Resolved! Script - Check the list of active users in an Assignment Group and when was the last INC record was assigned to user
I am trying to find a script that will give me the list of active users within an Assignment Group and when was the list time an INC record was assigned to the user. I can't find an OOB field in the [incident] table that stores the data. Hope someone...
| User | Count |
|---|---|
| 100 | |
| 65 | |
| 19 | |
| 18 | |
| 18 |
