plugin tables

[Kim Kronborg]

Hi,

Are there more plugin tables besides the sys_plugins table ?

I can see that all plugins are active in sys_plugins but if I look at the Plugins module from the navigator then a lot are not installed.

Thanks

[Jon Smith]

I have pretty much the same question. Right now we have emails that are sent to people but not everyone is on all the emails and nobody has time to subscribe to all the plugins that we want to track and if they leave the person that takes over for them now needs to get emails?

Use Case: 

• Plugins that come out with an update should have a ticket created and assigned to the SN Admin team
• Admin Team does research to determine if we should take the plugin update or not.
• If we are good to take it we assign it out to a Business Associate to work with the Process Owner to let them know about the update and discuss new features and timeframe for upgrade.
• If the plugin upgrade is decided to not be taken we have a documented reason why it isn't taken.

[jotinpro]

This is EXACTLY what I am trying to accomplish right now. I'm trying to figure out how to be able to either get a link to the store, how to get the data for the plugin into an approval task for the process owners, and then allow them to schedule the install. I've been working with my rep's at ServiceNow and they let me know that the API to get the information from the store such as the release notes and changes is locked down. 

I'm now trying to, instead, give Process Owners access to the Application Manager with read only access. Then when an update is available, an approval task is generated to their team with a link to that plugin in the Application Manager so they can review and approve or reject. The trigger to generate this approval is that the available version is higher than the installed version for the plugin. 

Finding a place to consistently show all the plugins in a table with their versions  and names so we can build the trigger is proving difficult. 

[Paul Curwen]

Table v_plugin will show all plugins and is searchable

[jotinpro]

Paul,

I'm not sure that this is accurate. v_plugin does not show something as basic as  UI builder, unless I'm searching for it incorrectly.