Git Product home page Git Product logo

turbot / steampipe-plugin-ldap Goto Github PK

View Code? Open in Web Editor NEW
9.0 11.0 1.0 274 KB

Use SQL to instantly query users, groups, OUs and more from LDAP. Open source CLI. No DB required.

Home Page: https://hub.steampipe.io/plugins/turbot/ldap

License: Apache License 2.0

Makefile 0.29% PLSQL 3.40% Go 96.31%
sql postgresql steampipe steampipe-plugin postgresql-fdw ldap active-directory hacktoberfest backup etl

steampipe-plugin-ldap's Issues

ldap plugin can not list all the operational attributes in the results

ldap plugin can not list all the operational attributes in the results

**for example, without the '+' i can not see the operational attributes
ldapsearch -b 'ou=users,dc=example,dc=net' 'user=me' but with '+' i can
ldapsearch -b 'ou=users,dc=example,dc=net' 'user=me' '+'

So I tried '["memberof"]' and '["+"]' didn't work.

function getOrganizationUnit crash if DN does not contains OU and no results will returned

Describe the bug
getOrganizationUnit crash if DN does not contains OU

func getOrganizationUnit(dn string) string {
	return dn[strings.Index(strings.ToUpper(dn), "OU"):]  // Here the function will crash in case OU not exists
}

Proposal is to change to logic like

func getOrganizationUnit(dn string) string {
	index := strings.Index(strings.ToUpper(dn), "OU")
	if index > -1 {
		return dn[index:]
	} else {
		return ""
	}
}

Error: unsupported Unicode escape sequence (SQLSTATE 22P05)" when querying Active directory

Hello I get the error: "Error: unsupported Unicode escape sequence (SQLSTATE 22P05)" when querying Active directory
How can I solve it?

select a.mail 
from ldap_user a 
where dn in (
  select 
    jsonb_array_elements_text(attributes -> 'manager')
  from adgroup.ldap_user where sam_account_name='matteo');

The single queries work fine

select  jsonb_array_elements_text(attributes -> 'manager')
from
  adgroup.ldap_user where sam_account_name='matteo';
+------------------------------------------------------------------------------------------------------------------+
| jsonb_array_elements_text                                                                                        |
+------------------------------------------------------------------------------------------------------------------+
| CN=Pippo,DC=redaelli,DC=com |
+------------------------------------------------------------------------------------------------------------------+

 select a.mail 
from ldap_user a where dn  in ('CN=..');
+---------------------------+
| mail                      |
+---------------------------+
| [email protected] |
+---------------------------+

Add table ldap_computer

Many Ldap servers ( active directory) contains "computer" objects: for instance all windows workstations and servers that are joined to the Windows Domain.

It would be nice to have a table ldap_computer (filtered with "(objectclass=computer)" ?)

Sample fields

dn: CN=7WK011,OU=DESKTOPS,DC=example,DC=com
objectClass: top
objectClass: person
objectClass: organizationalPerson
objectClass: user
objectClass: computer
cn: 7WK011
distinguishedName: CN=7WK011,OU=DESKTOPS,DC=example,DC=com
name: 7WK011
operatingSystem: Windows 7 Enterprise
operatingSystemVersion: 6.1 (7601)
operatingSystemServicePack: Service Pack 1
dNSHostName: 7WK011.example.com

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.