Useful code to generate a HTML table from a GlideRecord Query. This is especially useful for when you need to embed content in an email notification. Script Include Example: Mail Script Example: Call Mail Script in Notification: Results

Useful code to get the number of records based on a query. Script Include Example: Mail Script Example: Call Mail Script in Notification: Results (combined with GlideRecord HTML Table – Reusable Code)

If you ever need to query what reports are shared with a particular user(s) or group(s), you can query the sys_report_users_groups table. instanceName.service-now.com/sys_report_users_groups_list.do The table provides the following details:

Vancouver Upgrade Kit

GlideEncrypter API provides methods to encrypt and decrypt strings using the Triple DES algorithm. This API can be used in server scripts. *** Script: Encryped string = ZQ16PA3pnx8dhJxgrQZNxiBFhdtrslmP*** Script: Decrypted string = MyServiceNowStuff.com This can also be used to decypt certain password fields (like on Data Sources). Example: Documentation: https://developer.servicenow.com/dev.do#!/reference/api/vancouver/server_legacy/GlideEncrypterAPI Update: I’m happy to learn that…

A very useful table for viewing the status of all outbound HTTP / REST API requests is the Outbound HTTP Logs [sys_outbound_http_log] table. You can navigate to System Logs > Outbound HTTP Requests instanceName.service-now.com/sys_outbound_http_log_list.do In these records, you can view very useful information such as URL hostname/endpoint, MID Server, response status, response time, source table, source record, etc.…

Great article from ServiceNow. Linking it here for easy reference.

Recent selections on reference fields are stored in this table (sys_ui_recent_selection). instanceName.service-now.com/sys_ui_recent_selection_list.do For example: here are the recent selections for the Assigned to field on the Incident table for user System Administrator To reset this, simply delete the records on the sys_ui_recent_selection table. Reference: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0747334

When exporting large data sets, you get an option to “Mail it” or “Wait for it”. Within this modal, there is an option to “Remember my decision”. If you accidential click “Remember my decision”, or wish to change this option, this can be reset through the User Preference: “export_warn”. Simply delete “email” from the preference…

Quick POC I put together to demonstrate a seamless integration between UI16/Polaris and workspace forms.