question Report generation for plugins in Developer forum

Report generation for plugins

Kevin Paul — Wed, 17 May 2023 07:53:06 GMT

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.

Re: Report generation for plugins

Manmohan K — Thu, 18 May 2023 07:51:10 GMT

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

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

Re: Report generation for plugins

Maximilian Dign — Wed, 06 Mar 2024 13:00:04 GMT

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

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