Tag: ldap

SQL query to run LDAP query to return AD listing of active users and then groups they are assigned to that start with GRP-XP%

I am trying to write a sql statement to control a report header selection of multiple database by user groups a user is assigned to. This is to limit the database selection security when running an SSRS report so that they can’ only select their branch or group of branches they have access to. So far I can return the

php/mysql: get data from one table, convert and insert in another table

ldap mysql php sql sql-server

Ok I will try to explain, (I am Portuguese lol). I have a Database where I have the fallowing MySQL: Database: ad Table: notebooks Fields: ID, tag, so, lastlogon, lastlogh My ldap query gets data from ldap server (active directory) and stores it in my MySQL database (ad/notebooks). I get tag which is tag number is unique. I get so