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. 

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.

you can try with table api and use the table v_plugin to get the list of active,inactive and plugins details. 

Sample Script:

 

var request = new sn_ws.RESTMessageV2();
var headers = request .getRequestHeaders();
request.setEndpoint('https://dev34768.service-now.com/api/now/table/v_plugin?sysparm_query=active%3Dactive');
request.setHttpMethod('GET');


//Eg. UserName="admin", Password="admin" for this code sample.
var user = 'admin';
var password = 'admin';


request.setBasicAuth(user,password);
request.setRequestHeader("Accept","application/json");


var response = request.execute();
gs.print(response.getBody());


gs.print(response.getHeader("X-Total-Count"));

we have tried with v_plugin that show 394 active plugins but sys_plugins shows 623 activate plugins.

why these records are differ from each other. They are not showing equal active plugins.

status of the plugins can only be fetched from v_plugin tables. from sys_plugins you will only get the plugin component details. 

i am assuming here you are using your org instance so i would suggest here to connect with HI Team , because they can give you the exact details.