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!!!