turbot / steampipe-plugin-ldap

Use SQL to instantly query users, groups, OUs and more from LDAP. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/ldap
Apache License 2.0
9 stars 1 forks source link

Add table ldap_computer #4

Closed matteoredaelli closed 2 years ago

matteoredaelli commented 2 years ago

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
e-gineer commented 2 years ago

@matteoredaelli Agree it would be great to add this table - thanks for the suggestion!

Is there a standard set of field names with descriptions that we can look to implement? Feels like something that may vary a lot between LDAP / AD / etc provider, so would be great to have some "definitive" source to base our implementation on...

matteoredaelli commented 2 years ago

In any LDAP implementations you can extend their schema adding with new objectclass... About the objectClass "Computer" for M$, you can find the fields at https://docs.microsoft.com/en-us/windows/win32/adschema/c-computer The most useful / populated fields (in the AD server I use) are listed at the top of the "issue"

Thanks Matteo

github-actions[bot] commented 2 years ago

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

github-actions[bot] commented 2 years ago

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

github-actions[bot] commented 2 years ago

This issue was closed because it has been stalled for 90 days with no activity.