Hi All,

here are some helpful resources that support the System Admin Advanced content:

Update Sets

Q: How can I know which tables are monitored by the Update Set functionality?

A: Go to the Dictionary and filter for type "Collection" (= table definition). Every table that has the attribute "update_synch=true" is being monitored and each new or changed record is being reflected in the Update Set.

Q: Can I add the "update_synch=true" attribute on my own tables?

A: No, ServiceNow does not support that. BUT: you can exclude dedicated columns from being added to an Update Set by adding the "update_synch=false" attribute to that column's dictionary.

Coding and Debugging Best Practices:

Server side: https://developer.servicenow.com/dev.do#!/guides/orlando/now-platform/tpb-guide/scripting_technical_...

Client side: https://developer.servicenow.com/dev.do#!/guides/orlando/now-platform/tpb-guide/client_scripting_tec...

Debugging: https://developer.servicenow.com/dev.do#!/guides/orlando/now-platform/tpb-guide/debugging_best_pract...

Logs: https://developer.servicenow.com/dev.do#!/guides/orlando/now-platform/tpb-guide/logs_and_queues_best...

Data Lookup Definitions (building your own lookup table):

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/field-administration/reference/r_CreateCustomDataLookups.html

ServiceNow URLs - understand how to construct URLs:

you can always address a table directly from the URL - either in form or list view:

/incident.do

/incident_list.do

then you extend this with different parameters.

Examples (especially about the page parameters): https://docs.servicenow.com/bundle/orlando-platform-user-interface/page/use/navigation/reference/r_N...

Navigate to records: https://docs.servicenow.com/bundle/orlando-platform-user-interface/page/use/navigation/task/navigate...

For the Service Portal: https://docs.servicenow.com/bundle/helsinki-servicenow-platform/page/build/service-portal/concept/na...

Exporting Data through processors (via URL):

Also these so-called Export Processors can be extended with parameters like "sysparm_query="

https://docs.servicenow.com/bundle/helsinki-platform-administration/page/administer/exporting-data/r...

Export processor	URL syntax	Export limits	Description
CSV	?CSV	10,000 rows	Exports table records as a comma-separated value text file.
Excel	?EXCEL	10,000 rows	Exports table records as a Microsoft Excel spreadsheet.
XML	?XML	10,000 rows	Exports table records as an XML document.
PDF	?PDF	5,000 rows	Exports table records as a Portable Document Format file.
Schema	?SCHEMA	N/A	Exports the database schema for the table.
XSD	?XSD	N/A	Exports the table structure in XSD format.

Table names and prefixes in ServiceNow:

https://community.servicenow.com/community?id=community_article&sys_id=1801cf4cdb33fb485ed4a851ca961...

ServiceNow Youtube Channels (great content):

ServiceNow Demo/Support https://www.youtube.com/user/servicenowdemo

ServiceNow Developer Program https://www.youtube.com/channel/UCdXorgCT87YlFRN9n8oJ7%5FA

ServiceNow Community https://www.youtube.com/user/ServiceNowCommunity