What is the difference between sys_plugins and v_plugin table.

[rajesh58]

Hi Team,

 As per my understanding sys_plugin and v_plugin both tables stores meta-data of plugins, but there is major difference in number of activated plugins . If we talk about London release, v_plugin shows 394 activated plugins but sys_plugins shows 623 activated plugins. Why the difference is too high?

How can we find actual list of active and inactive plugins and which table should i use for the same. If there is any other table to get active and inactive plugins , please let me know.

Thanks,

Rajesh Singh    

[Ankur Bawiskar]

Hi Rajesh,

v_plugin (System Definition > Plugins) module is used to determine which plugins are active on your instance. That module lists only plugins available through self-service & is recommended not to rely to understand the list of plugins been active.

On the other hand, you can assure the active plugins by entering sys_plugins.list in the navigation filter and searching for the plugin. This list includes all plugins that are active on the instance, whether they were activated by default when the instance was new or upgraded, through self-service, or by ServiceNow personnel at your request.

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[rajesh58]

Hey Ankur, 

   I think you have just pasted an answer of earlier asked question i.e what is diff between sys_plugin.list and v_plugin.list right?

But my question is different?

Thanks for responding.   

[Harsh Vardhan]

sys_plugins table will give you the plugins details , example: table details or script details has been used in perticular plugins , but if you will go to the v_plugin then you will find the plugins details as well as you will able to activate it . 

i believe sys_plugins stores all the plugins available in service-now, some of them are accessible from service-now and some of them are accessible through hi request. 

now coming to the question you had asked to get the list of active plugins , now in servicenow it has new page which show the plugins or you can categories them base on modules or active or inactive. 

screenshot below. 

[rajesh58]

Hi Harshvardhan,

  Actually i am working on integration,  questions are below.

 1- Is there any web API to get all active plugins on my instance.   

 2- Is there any web API to get all inactive plugins on my instance.

 3- Is there any web API to get total number of plugins that is offered by London instance service-now whether those are active/inactive

Thanks.