- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
is there a way to find all users that font-end builder is enabled?
Regards,
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 !
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 !
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: MGS Front End builder extension Find Enabled Users
How to use Brand extension in Claue theme on the magento2 ToysRUs Credit Card
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: MGS Front End builder extension Find Enabled Users
Thank you this was really helpful!!!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.