Is there Query or backgoround Script to collect the city version of the Oracle database- directly

[jeffreyluto]

Is there a Query or Backgoround Script to collect the city version( ServiceNow) off the Oracle database- directly- not from the GUI/Portal/sys_properties/nor the stats or XMLStats.do?

Like to verify it in the tables or tags?

[M Iftikhar]

hi @jeffreyluto, 

Obtaining the ServiceNow "city" version directly from the Oracle database using a query or background script that interacts with database tables is not a supported or recommended method. Direct interaction with the underlying database is generally not permitted for ServiceNow customers.

Instead, the version information can be reliably retrieved using a background script within the ServiceNow platform itself. The glide.war system property stores the instance's version and build details.

To find the specific version of your ServiceNow instance, you can execute the following JavaScript code in a background script:

gs.info(gs.getProperty('glide.war'));

This script will return a string containing the release name, version, and build date, which will allow you to identify the "city" release of your instance. While this method does not directly query the Oracle database, it is the correct and supported approach for programmatically retrieving the ServiceNow version information.

Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution so others can benefit as well.

[jeffreyluto]

Semi helpful but for self-hosted we have more access than Cloud which is good and bad. Because things are be misconfigured by accident.