Report generation for plugins

Kevin Paul
Mega Guru

Hi All,

 

I am working on an report generation of customized Plugins that are installed in instance.

Below are the reports that I need to generate:

  • Total Plugins installed
  • Plugins installed but not updated
  • Plugins installed and updated
  • Owner of each plugin
  • Plugins installed and disabled

Kindly help in pointing where I can get these report data from

 

Thanks in advance.

2 REPLIES 2

Manmohan K
Tera Sage

Hi @Kevin Paul ,

 

Total Plugins installed - Go to System Definition>Plugin Installation history and apply below filter. Right click on "To" column and select Group by "To" and then right click on any column and choose export  - excel or pdf

ManmohanK_0-1684395951635.png

 

Plugins installed but not updated and Plugins installed and updated - There is no way you can know that a particular plugin is updated or not updated because the data whether plugin update is available or not is not maintained in any table. So you cannot generate report on this criteria

 

Owner of each plugin - There is no owner data maintained so again this report cannot be generated

 

Plugins installed and disabled - After a plugin is activated, you cannot disable or deactivate it. If needed, you can hide the functionality. So this case is not possible

 

Hope this helps in your queries

Regards,

Manmohan

Maximilian Dign
Tera Contributor

Hi @Kevin Paul,

 

i would report on the "sys_store_app" table where data is stored which may help your problem.

  • Total Plugins installed

Just count the records. If you want the same number as in the plugin store, you can use the following filter

"hide_on_ui=false"

  • Plugins installed but not updated

to identify which plugin needs to be updated use the following filter

"update_available=true"

The table shows only installed plugins, so there is no additional filter needed.

You can combine this filter with the first one to get the exact number/plugins as in the plugin store

MaximilianDign_0-1709729487053.pngMaximilianDign_1-1709729513258.png

  • Owner of each plugin

The "Vendor" field comes close to an owner but is rarely mantained

  • Plugins installed and disabled

As @Manmohan K already mentioned once a plugin has been installed, you cannot uninstall it. You can propably filter for active plugins, which i wouldn't rely on.

 

You might need to add the table name to the property "glide.ui.permitted_tables" in order to report on it, if it doesn't show up in the Report Designer.

 

Hope this helps you

Regards,

Max