cancel
Showing results for 
Search instead for 
Did you mean: 

MGS Front End builder extension Find Enabled Users

SOLVED

MGS Front End builder extension Find Enabled Users

Hello,

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

Regards,

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: MGS Front End builder extension Find Enabled Users

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 !

 

Problem Solved ? Click on 'Kudos' & Accept as Solution ! Smiley Happy

View solution in original post

4 REPLIES 4

Re: MGS Front End builder extension Find Enabled Users

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 !

 

Problem Solved ? Click on 'Kudos' & Accept as Solution ! Smiley Happy

Re: MGS Front End builder extension Find Enabled Users

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

Re: MGS Front End builder extension Find Enabled Users

Thank you this was really helpful!!!

Re: MGS Front End builder extension Find Enabled Users

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.