MGS Front End builder extension Find Enabled Users

[geokat]

Hello,

is there a way to find all users that font-end builder is enabled?

Regards,

[gaurav_harsh1 · Accepted solution]

Hello @geokat 

Run below query :

SELECT * FROM DB.eav_attribute where attribute_code = "is_fbuilder_account";

here you will get attribute_id, get the attribute id, for ex: 160

and run below query :

SELECT * FROM DB.customer_entity_int where attribute_id = 160 and value = 1;

here value = 1 means who has access.

now you have custom_id who has access, get all the ID's and run below query :

SELECT * FROM DB.customer_grid_flat where entity_id IN (1734,1749,1953,1818,1962);

(1734,1749,1953,1818,1962) these are the ID which I got from second query.

Hope it helps !

[silaskaile6df4]

 How to use Brand extension in Claue theme on the magento2 ToysRUs Credit Card

[geokat]

Thank you this was really helpful!!!

[Milople]

Hi @geokat,

Identifying users who have enabled a front-end builder in Magento can be challenging because it depends on the implementation details of the front-end builder and how it interacts with user accounts. Here are some general strategies you can try:

• Check User Roles: Some front-end builders create specific user roles. You can check the authorization_role table to see if there are any roles associated with the front-end builder. The role_name column might give you a clue about roles related to the front-end builder.

SELECT * FROM authorization_role WHERE role_name LIKE '%builder%';

• Inspect User Attributes: Front-end builders might set specific user attributes. Check the admin_user table for custom attributes that might be related to the front-end builder.

SELECT * FROM admin_user WHERE custom_attribute = 'front_end_builder_enabled';

Replace 'custom_attribute' with the actual attribute name you are looking for.

• Review User Permissions: Examine the authorization_rule table to check if there are any rules related to the front-end builder.

SELECT * FROM authorization_rule WHERE resource_id LIKE '%front_end_builder%';

Replace 'front_end_builder' with a keyword related to the front-end builder if such information is available.

• Inspect System Configuration Settings: Some front-end builders store settings in the configuration. Check the core_config_data table for specific configuration paths related to the front-end builder.

SELECT * FROM core_config_data WHERE path LIKE '%front_end_builder%';

• Check Logs: Review system logs for any entries related to the front-end builder. Magento logs activities in the log_user and log_visitor tables.

SELECT * FROM log_user WHERE action LIKE '%front_end_builder%';
SELECT * FROM log_visitor WHERE action_name LIKE '%front_end_builder%';

Replace 'front_end_builder' with relevant keywords.

• Inspect Installed Extensions/Themes: If the front-end builder is provided by an extension or theme, check the installed extensions and themes in Magento admin. Some extensions/themes might provide user-specific settings.
• Contact Front-End Builder Provider: If the front-end builder is part of a third-party extension or theme, consider reaching out to the provider for guidance. They might have specific recommendations or ways to identify users using the front-end builder.

If the issue will be resolved, Click Kudos & Accept as a Solution.