Currently, there is no direct way to determine who installed a plugin and when was it installed from a UI. The plugins view on the instance does provide some information but it is derived from the v_plugin table. This table is a virtual table that is built dynamically and it shows the list of all the available plugins in the system. This means that the system field is going to show up as the user who is viewing the plugin and not who installed it. Also, it shows the timestamp as the current date and time. Although this is an expected behavior, the ‘who and when’ data is sometimes required when it comes to plugins. This KB endeavors to address this concern
Frequently Asked Questions
Q2: What are the useful tables related to plugin activation?
Q4: How to know when a plugin was activated?
Q5: How to know who activated a plugin?
Useful tables related to plugin activation
The following tables are helpful to get information about plugins:
How to verify that a plugin was successfully installed?
To verify that a plugin was successfully installed:
- Go to the sys_progress_worker table.
- Provide the name of the plugin in the ‘Name’ column.
- The ‘Message’ column shows that the plugin is activated.
- If there is an error it can be seen in the ‘Error message’ column.
- Also, the ‘State’ column displays the status of the plugin.
(More information here: KB0678767)
How to know when a plugin is activated?
To determine when a plugin was installed, the ID of the plugin or Name of the plugin is needed.
There are a few ways to determine when a plugin was installed:
- xmlstats.do will shows all plugins installed:
E.g. <plugin install_date="2018-10-31 19:03:08" type="" version="5.2.20">com.snc.vulnerability</plugin>
- sys_plugin_log record
- sys_plugins record includes the install_date field:
- sys_package record via created field:
- sys_upgrade_history record via upgrade finished field:
- sys_progress_worker record
How to know who activated a plugin?
There are 2 ways to check who activated a plugin.
1. Open sys_progress_worker table.
2. In the table, filter with the name of the plugin in the ‘Name’ column.
3. The ‘Created By’ field shows who activated the plugin.
1. Install a plugin (for example ‘Appointment Booking’ plugin)
2. Go to the sys_plugins table and provide the name of the plugin in the ‘Name’ column. Note the ID which is unique to every plugin.
3. The ‘Install date’ column shows the date when the plugin was installed.
4. With the install date, the information about who installed the plugin can be found. For this purpose, go to the syslog_transaction table and provide the following filter criteria as seen in the screenshot below.
5. As can be seen in the above screenshot, the URL is the ID of the plugin. For the ‘Created’ provide a duration of time. For example, the ‘Appointment Booking’ plugin was installed on 2018-11-07 10:28:33. So a time duration of before and after the plugin was installed is provided. The ‘Type’ field is optional but it is helpful to filter out other options like REST since the plugin is activated through the form. The following screenshot displays the results of the filter criteria that we supplied. Here the ‘Created By’ column shows who installed the plugin.