How to see all installed plugins and store apps

[andresanche]

I am trying to programmatically identify which plugins and store apps are installed on an instance. I've seen xmlstats.do, however, this lacks information about installed store apps. I've also seen the sys_store_app table, but it isn't available through the table API. Is there another option?

[Sandeep Rajput]

@andresanche As you rightly mentioned, the information is available in sys_store_app if you wish to make this table available via table API, then you need to add this table name in glide.ui.permitted_tables system property. Once added the table would get available via table API.

Hope this helps.

[andresanche]

Thank you for the reply. When updating the property I got a warning message, which I copied below. What are the implications when changing this file for future updates?

Warning: This is a High Risk file that might get updated again in later releases. Do not alter this file unless necessary.

[Rosemary4]

The risk it's calling out is that during future upgrades your changes to that system property might get flagged in the Skip Logs, you'll need to review the changes against any you've made, and make appropriate decisions.

In terms of the risk of exposing system tables for reporting - these tables can store a lot of data, they may not be well indexed (or even if they are, ServiceNow's MariaDB struggles with tables over a million rows), users often don't know how to build efficient queries, and reporting on these tables may impact system performance.

[Rosemary4]

sys_store_app is actually restricted from being queried through Rest API:

If you didn't want to export to excel you'd have to create a custom table that pulls data in from the system table and expose that to Rest API.