how to check assignment group details in servicenow

• Release notes
• Unification
• System & Network Scanning
• Web Application Scanning
• API Scanning
• Phishing & Awareness Training
• Cloud Scanning
• Scanner Appliance
• Device Agent
• Asset Manager
• Remediation
• Continuous Monitoring
• Vulnerability manager
• On-prem deployment
• Vulnerability tests
• Email notifications
• Security Center
• Contact and opening hours
• Security Tools
• Data retention
• Security Badge
• Holm Security VMP
• Troubleshooting
• Policy scanning
• Best practice
• Scanning techniques
• Scan profiles
• Authenticated Network Scanning
• Scan Issues
• Optimization
• Authenticated scanning
• Get started
• Microsoft Azure
• Amazon Web services (AWS)
• Google Cloud Platform (GCP)
• Oracle Cloud
• Whitelisting
• Data privacy
• Getting started
• Ignore and disable
• Notes and conversations
• Unified Vulnerabilities
• Comparison report
• White-labeling
• Monitoring profiles
• Beyond Trust
• Integrations
• Authentication & security
• Personal data
• Sweden, Norway, Finland, India & SAARC (Swedish entity)
• Netherlands & Belgium (Dutch entity)
• Denmark (Danish entity)
• United Kingdom (UK entity)
• Malaysia & SEA (Hong Kong entity)
• Knowledge Base

How do I find Assignment Group id and User id in ServiceNow?

A unique 32-character GUID identifies each record in ServiceNow (Globally Unique ID) called a sys_id.

sys_id of a record is important when writing a script, workflow, or other development tasks.

Here are ten different methods to find the sys_id of a record in ServiceNow:

Right-click or hamburger You can right-click the header bar of most forms and find the sys_id.

To get a sys_id from the header bar:

Navigate to the record where you are looking for a sys_id. 

To get a sys_id from XML

• Navigate to the record where you are looking for a sys_id

Right click the header bar and select Show XML. Alternately you can also click the Hamburger > Show XML

Since the sys_id of a record is always part of the URL for a link to that record, it is possible to retrieve the sys_id by viewing the URL.

To get the sys_id from XML

Right-click the header bar and select Copy URL. Alternately you can also click the Hamburger > Copy URL

For example, an Incident with the following URL:

https://<instance name>.service-now.com/nav_to.do?uri=incident.do sys_id=23dc968f0a0a3c1900534f399927740e

The sys_id is : 23dc968f0a0a3c1900534f399927740e

• Add an onload client script to show a sys_id function onLoad() { var incSysid = g_form.getUniqueValue(); alert(incSysid); }

The sys_id value of a record can be found in a business rule (or any other server-side JavaScript)

The sys_id value of a record can be found in a background script. Note: Test in a development instance first!

Login as an admin

Go to System Definition > Scripts - Background

Paste a script similar to this and click Run Script

By adjusting the url of a record, you can add this URL Parameter to export the sys_id and all fields to CSV

Navigate to the list of records where you want to find the sys_id

Build your filter

Right-click the Filter, and select Copy URL

Paste the URL into a new browser window

Add &CSV&sysparm_default_export_fields=all to the end of the URL

A CSV file with all fields AND the sys_id is exported.

Here is a creative way to use the Easy Import Template to export the sys_id data you are looking for.

Right click the header bar and select Import. Alternately you can also click the Hamburger > Import

Do you want to insert or update data? Update

Do you want to create an Excel template to enter data ? True

Include all fields in the template? True or False, your choice

Click Create Excel Template

Click Download

Open the Excel Spreadsheet

Select Page 1

If you are using the  ServiceNow ODBC Driver  and a reporting tool, you can pull the sys_id field information easily.

If you are using the  ServiceNow Rest API , you can also pull sys_ids

Check this link (external): https://www.servicenowelite.com/blog/2020/9/29/ten-methods-to-find-sysid?rq=sys_ID

Advanced ‘getMyGroups’ Function

I f you’ve taken a look at the ‘My Groups Work’ module (or maybe a particular security rule or report) you may have noticed that the condition or filter for that record makes a function call to return a list of values to compare against the value in the given field. In the case of the ‘My Groups Work’ module under the ‘Service Desk’ application there is a function called ‘getMyGroups’ that is used to identify task records where the assignment group value is one of the groups for which the current user is a member.

The ‘getMyGroups’ function simply returns an array of group sys_id values for the groups that a user belongs to. I saw a forum posting recently that pointed out (correctly) that the ‘getMyGroups’ function only returns group membership, but doesn’t return groups where the user is listed as the manager. The function also doesn’t attempt to return child groups of the groups where a person is a manager or group member. So, if I am the Director of Operations and I want to see a list of all tasks for the Operations group (which I am a manager of) as well as the sub-groups of that group, I would have to be added specifically to each sub-group to have all of the groups that I am interested in tracking be displayed in the list.

With some help from John Andersen, I’ve created the ‘Advanced getMyGroups’ function. This function is designed to give users a better way to display group membership information. It is used in the same way that you would use the ‘getMyGroups’ function, but also includes an optional parameter that allows you to return groups managed by an individual and/or sub-groups of a given group where I am a member or manager. The ‘maxDepth’ parameter returns the values as shown below…

• No maxDepth returns groups where user is a group member (Same as current ‘getMyGroups’ function)
• maxDepth of 0 returns groups where user is a group member or a manager
• maxDepth greater than 0 returns groups where user is a group member or a manager PLUS all child groups up to ‘maxDepth’ levels deep

The most common usage of this function is probably in a filter on a module or a report. So, if I were creating a module to show all tickets where I am a member of the group OR where I am the group manager, PLUS all of the sub-groups up to 5 levels deep I could use the following in my filter…

‘javascript:getMyGroupsAdvanced(5)’

Mark Stanger

Date Posted:

May 4, 2010

Share This:

33 Comments

How do I make this work?

javascript:getMyGroupsAdvanced(5).GetGroupFilter(‘database,network’)

I don’t think that you do. As far as I’ve seen, the ‘GetGroupFilter’ function is used for reference qualifiers but wouldn’t be applied in this way for a module or report filter.

Great script!

thank you for all your work!

Thanks for this, greatly appreciated! Perfect timing too, I started looking for a way to do exactly this on the same day you posted it.

Excellent, thank you very much, Mark! Works great!

I’ve also noticed that getMyGroups returns groups from above, i.e. parents of any groups you are a member of.

I am a member of Problem, which has a parent of SLM

when running getMyGroups I also get tickets assigned to SLM, I’m only interested in Problem group tickets.

Oddly, the filter also displays the parent group as though I’m only filtering on that.

Tasks-ASSIGNMENTGROUPIS SLM

This is great, thanks for this. Kind of weird there is no option in ServiceNow to do this automatically. Any ideas on how we would get this code to work in the report section. i.e. if we give users the ability to create reports for their groups, out of the box they can create reports for their groups and any of the associated parent groups of the child groups they belong to. We need this to be the other way around, i.e. if you are a member of a parent group and you click on the visible to: Group button you should see that parent group and also the parent s children??

The report page is back-end XML so there’s no way to directly manipulate the behavior of that page. You might be able to use a UI script to manipulate the functions there but that would be a pretty significant hack that would probably end up breaking during an upgrade. It’s probably best to request this as an enhancement with ServiceNow support.

Thanks for the reply Mark, I find it strange that this is not something that is easily amended, i.e. to change the search on groups for the user. Im sure this is something that many people have come across. It doesnt make sense not to be able to see the applicable hierarchy you are in, so it really does seem like a big limitation. Thanks again for the information and advice.

This seems to be working, but for some reason along with all the managers groups, it also shows tasks without an assignment group. Anyway to stop this from happening?

p.s. Adding a filter that says Assignment Group is not blank does not seem to work.

Sounds like maybe the issue is with your instance then. Can you reproduce this in the ServiceNow demo instance?

Discovered the actual problem I’m having is that when trying to return closed and open tasks, the open tasks return fine but closed tasks display without details. I haven’t yet discovered how to resolve this.

This did not work at all for me. I also tried it on the demo site and it did not work. The Assignment Group came back blank. Any ideas? Are there any other steps besides creating the function in the Global Business Rules?

Please let me know. Thanks! Jeff

I just tested this at https://demo13.service-now.com and it works fine there. I’ve modified the ‘My Groups Work’ module to use the function. You can validate that it works correctly by impersonating Don Goodliffe. Make sure to check that your business rule is set up on the ‘Global’ table and that the ‘Client callable’ checkbox is checked.

I have a user defined field called Division on my sys_user table, this field is just a reference field back to cmn_department.

I wanted to create a function similar to getMyGroups() & getMyAssignments() to use in filters.

This is not working for me. Here is my getMyDivision business rule: Name = getMyDivision table = Global[global] Client callable = true Active = true Script:

function getMyDivision(){

var MyDivision; var uID = gs.getUserID();

var user = new GlideRecord(‘sys_user’); user.addQuery(‘user’, uID); user.query();

while(user.next()){ MyDivision = user.u_division.toString(); //u_division is simply a reference field back to cmn_department }

return MyDivision; }

All the other examples (getMyGroups) seem to simply return an array of Strings, where each string is the sys_id. That is what I am basically doing here, but my reports don’t seem to work when I use the javascript:getMyDivision()

I have also tried returning an array of Strings, a cmn_department variable, and an array of cmn_department variables nothing works

Is something wrong with my script? I couldn’t seem even find the getMyGroups function to look at that code, but did find some reference that makes me believe that is a server side function tied to the User class.

Any help is greatly appreciated!

I think you could simplify this quite a bit. Try putting this within the ‘getMyDivision’ function.

return gs.getUser().getRecord().getValue(‘u_department’);

Gee thanks! much simpler and the function now works in my filters. So, the getValue function grabs the actual sys_id, where in my script the u_division.toString() was probably not neccessary.

Anyone else having issue with this business rule after Berlin upgrade? It was working fine before upgrading. After upgrading to Berlin, it works only for users with “admin” role. It does not return any groups if the user does not have “admin” role.

This still works for us, but please note, In order to get this to work initially (prior to Aspen or Berlin) I needed remove the following lines:

//Remove any duplicates from group string groupArr = checkDuplicates(groupArr);

Not sure is that will help you or not. good luck!

Thanks Jeff.

I figured what was causing this. The property “glide.script.use.sandbox” was enabled. When I disabled it, the business rule started working again for non-admin users. Are you having this property disabled?

Disabling that property probably isn’t a good idea, and it shouldn’t be necessary if you’ve got the ‘Client callable’ checkbox checked in your global business rule.

The property was enabled before Berlin and the business rule was running fine. After Berlin, the issue started. The ‘client callable’ checkbox was always checked.

I don’t have High Security Settings plugin enabled. Could this be the reason?

It may be due to the lack of High Security, but I doubt it since this solution was in place before High Security was the norm. I just tested this again on my Berlin release (with High Security enabled) and it works fine. You could confirm by testing in a ServiceNow demo instance.

This was working fine for us until we started testing Calgary and then I ran into the same issues discussed above. This only works for users who have the admin role. We currently do NOT have the High Security plugin enabled so that isn’t the issue. I tried commenting out the following line as suggested by Jeff above with no luck:

Did anyone find a solution to this with Berlin?

another note…if I go to demo and put this into an instance with Calgary it works. It seems to be related to the upgrade with this in place.

Hi Mark, I did this in Dublin and it spits out this warning when I save the rule”getMyGroupsAdvanced Business Rule contains code outside of a function. Code which exists outside of a function will run against every transaction; therefore, all code should be within a function and invoked as needed.”. I am a bit hesitant to turn it on now, as it seems serious.

Any ideas? Regards, Howard Elton

I haven’t ever had anyone report an issue related to this. The only code outside of a function are a couple of variable declarations so there shouldn’t be a huge concern.

I’ve just updated this to use a script include instead of a global business rule. That should solve the error you’re getting. Performance should really be the same, but this will follow current best-practice more closely.

We have been successfully using this for a number of years now. We are currently on Calgary testing Eureka. In Eureka when I go to “My Groups Work”, in the assignment group field of the filter it is blank. We have indeed changed the old global Business Rule to the new Script Includes. I know we have a lot of groups that the manager is not an assignee in the group but wants that visibility which this has done. Any thoughts?

I should have dug through the thread better. The problem I was experience was addressed by Ahmed Abdrabalnabi above. After reading the thread I checked and sure enough the issue would not occur if the user had the admin role. So I checked the system property of “glide.script.use.sandbox” and found it was set to true…changed that to false and it now works. I will admit that it still doesn’t make complete sense because that property itself states “If enabled, only those business rules and script includes with the “Client callable” checkbox set to true are available” and as stated, the script includes here has “Client callable” checked. I did confirm that I didn’t miss that. Just a bit strange.

I notice this pulls from the Task table but I need to get a state from the incident table, any suggestions on how I can accomplish this?

I’ve got the same problem on Geneva. If the user is non admin and glide.script.use.sandbox is true then the returned groups from the module ‘My Groups work’ is empty. What is strange is when the same function is called from a script in an application menu is works. I try to set glide.script.use.sandbox to false but I got and error message saying this operation is unsafe.

Finaly I’ve succeeded with the following code :

var GMGA = Class.create(); GMGA.prototype = Object.extendsObject(AbstractAjaxProcessor, { type: ‘GMGA’ }); var maxDepth;

var groupArr = []; var finalArr = [];

GMGA.getMyGroupsAdvanced = function (inputDepth) {

The rest of the code is untouched. For calling the function use : javascript:GMGA.getMyGroupsAdvanced(5)’

For me it’s a kind of black magic!

I tried using a similar script to add a parent group member to child groups upon insert. Do you have a business rule or SI that is similar to accomplish this?

Comments are closed.

Radoslav Ehlenov says:

Bharat Goyal says:

Jacob Kimball says:

• Announcements
• Architecture
• Business rules
• Client scripts
• Content management
• Email Notifications
• General knowledge
• Generative AI
• Graphical workflow
• Integration
• Knowledge Management
• Miscellaneous
• Performance
• Relationships
• Script includes
• Service Portal
• Single Sign-on
• System Definition
• Web Services

Related Posts

Condition Builder Attributes That Pack a Punch

Demystifying Cryptography in ServiceNow: A Comprehensive Guide to Secure Data Transmission

Edge encryption and tokenization explained, fresh content direct to your inbox.

Just add your email and hit subscribe to stay informed.

Since 2009, ServiceNow Guru has been THE go-to source of ServiceNow technical content and knowledge for all ServiceNow professionals.

• CMDB Intelligent Search
• How to Cut Your Storage Footprint (and Bill) by Using Clone Options in ServiceNow
• The C4 model for ServiceNow Solution Design and Documentation

© Copyright 2009 – 2024 | All Rights Reserved

Your browser or one of your plugins is not allowing JavaScript to be run. This is a bummer since the ServiceNow Developers Site is dynamic and depends on JavaScript to function. If you want to visit this site, please disable the plugin, activate this site for JavaScript or use another browser.

Get the Reddit app

Subreddit for ServiceNow users, admins, devs, platform owners, CTOs and everything in between.

First Assignment Group?

Anyone struggling to report off of the first/initial assignment group for incidents? From what I’ve noticed, if the agent does not assign the incident to their assignment group before escalating to another AG, it does not reflect in the track AG which reduces the total volume when reporting. Has anyone solved for this?

Add users to Proactive Service Experience Workflows assignment groups

Add users to Proactive Service Experience Workflows assignment groups so\n that they have the necessary role and can be assigned to resolve network-initiated issues at\n the appropriate escalation level.

Role required: admin

• \n Navigate to All > User Administration > Groups . \n
• Network Coordinators
• L1 Network Engineering
• L2 Network Engineering
• L3 Network Engineering
• \n In the Group Members related list, click Edit . \n
• \n Select one or more names in the Collection list. \n
• \n Click Add . \n
• \n Click Save . \n

• Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers
• Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand
• OverflowAI GenAI features for Teams
• OverflowAPI Train & fine-tune LLMs
• Labs The future of collective knowledge sharing
• About the company Visit the blog

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Get early access and see previews of new features.

how to get Timestamp of Assignment or completion group in servicenow

I want to get Timestamp Assignment Group and Timestamp of completion assignment from service now for a RITM and task.

Could you please tell me the table and field name in service now? Postman queries would be very helpful.

• servicenow-rest-api

• 1 This is not a free coding service. –  Anic17 Commented Aug 18, 2020 at 10:22
• 1 @Anic17 I did not get you, I have paid instance of servicenow. –  Upendra Commented Aug 18, 2020 at 14:20

Know someone who can answer? Share a link to this question via email , Twitter , or Facebook .

Your answer.

Reminder: Answers generated by artificial intelligence tools are not allowed on Stack Overflow. Learn more

Sign up or log in

Post as a guest.

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy .

Browse other questions tagged servicenow servicenow-rest-api or ask your own question .

• The Overflow Blog
• How to build open source apps in a highly regulated industry
• Community Products Roadmap Update, July 2024
• Featured on Meta
• We spent a sprint addressing your requests — here’s how it went
• Upcoming initiatives on Stack Overflow and across the Stack Exchange network...
• Policy: Generative AI (e.g., ChatGPT) is banned
• The [lib] tag is being burninated
• What makes a homepage useful for logged-in users

Hot Network Questions

• Who originated the idea that the purpose of government is to protect its citizens?
• Is arxiv strictly for new stuff?
• common.apex.runtime.impl.ExecutionException: Unrecognized base64 character: [
• Hölder continuity in time of heat semigroup
• A very basic autosegmental tree using forest
• Is there an economic incentive to use p2wsh over p2tr?
• How do I prevent losing the binoculars?
• Sitting on a desk or at a desk? What's the diffrence?
• What’s the highest salary the greedy king can arrange for himself?
• Are there examples of triple entendres in English?
• Geometry question about a six-pack of beer
• Imagining Graham's number in your head collapses your head to a Black hole
• Correlation for Small Dataset?
• Is it possible to arrange the free n-minoes of orders 2, 3, 4 and 5 into a rectangle?
• How to clean up interrupted edge loops using geometry nodes and fill holes with quad faces?
• Moving with a questionable advisor
• How to maintain dependencies shared among microservices?
• Did Tolkien give his son explicit permission to publish all that unfinished material?
• How far back in time have historians estimated the rate of economic growth and the economic power of various empires?
• Old animated film with flying creatures born from a pod
• Why is a game's minor update on Steam (e.g., New World) ~15 GB to download?
• Joint measurability in quantum mechanics
• Is "conversational" used correctly in this context?
• Does the decision of North Korea sending engineering troops to the occupied territory in Ukraine leave them open to further UN sanctions?