Help Needed: Locating Table of App Updates from Plugins

[CV1]

Hello Everyone,
Question (1)

I'm looking for help identifying a table or list that shows all App Updates available for upgrade from plugins.

I’ve already checked tables like sys_app , sys_store_app, sys_plugins  but haven’t found the specific information I need.

My goal is to create a list view that I can export to Excel for verification after upgrading the instance. Previously, I manually copied each plugin/app name and version into Excel, which was time-consuming.

If anyone knows of a better way to retrieve this data or can point me to the right table/view.

Question (2)

When I navigate to App Updates Available via Plugins > Classic View, I notice that some applications display detailed information under the "App Updates" section (as shown in the first screenshot), while others appear as shown in the "Application Type" screenshot.

Could someone clarify what each of these views represents?

Specifically, does the absence of a "Running Version" indicate that the application or plugin is not currently installed on the instance?

Appreciate any insights.
Thanks in advance,

[kaushal_snow]

@CV1 ,

You can utilize the sys_store_app table. This table contains records for applications installed from the ServiceNow Store, including details such as the application name, version, and whether an update is available.....You can create a list view in this table and export it to Excel for your verification purposes.

Regarding the different views in the App Updates Available section under Plugins > Classic View, the presence or absence of a Running Version indicates the installation status of the application. If the Running Version is displayed, it means the application is currently installed on your instance. Conversely, if it is absent, the application is not installed, and thus no update is applicable....

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.