System Manager 7.0 (How to extract the list of administrators)

[JuanCarman]

Hello folks,

I am trying to get a list of administrators from System Manager 7.0
Is there a way to get a list? At this point I can check the administrators at the web interface, but I need to move that information to an excel file for administrative functions, but it is not a way, other than copy and paste information, but this is not a good option, this takes me a lot of time.

Is there an option to run and get a report with all the information over web interface or command line?

Please let me know your comments,
Thank you very much in advance!!
Regards

 

[kyle555]

Got root?

root >/opt/nortel/cnd/ldapsearch -x -b "ou=People,dc=Nortel,dc=com" -D "uid=juan@carman.com,ou=People,dc=Nortel,dc=com" -w TheUsersPassword cn

Here's what you do. Make admin user juan@carman.com with password Something999** change your password to Something999-- in the webpage. Make sure to use hyphens as the special character because most other special characters are shell variables in Linux and & or % will not be literally interpreted by the shell on a command line. You'd have to have like Something123\&&\ on a CLI to mean a password like Something999&&, so just use hyphens and save yourself the trouble.

If you don't put 'cn' at the end, it'll print the whole LDAP for users in ' -b "ou=People,dc=Nortel,dc=com" ' including hashed passwords and be long and stuff. You can add any LDAP parameter after, like 'givenName, sn, cn' and it'd print "first name, last name, firstlastname" if you put the 3 in that order. That's how the Linux utility ldapsearch works.

There are many ldap-->csv solutions (including sed/grep/awk!) that can manipulate the data. I'm working on one in python for AAM's LDAP with the pythonldap libraries. Anyway, it's an easy way to get data out

http://www.tek-tips.com/viewthread.cfm?qid=1785107

Bonus points for me: /opt/nortel/cnd/ldapsearch is restricted to root.
/var/avaya/geo/backup/quantum/opt/nortel/cnd/ldapsearch can be run by the customer admin user

so you don't even need root!

/var/avaya/geo/backup/quantum/opt/nortel/cnd/ldapsearch -x -b "ou=People,dc=Nortel,dc=com" -D "uid=juan@carman.com,ou=People,dc=Nortel,dc=com" -w TheUsersPassword cn

And yes. In System Manager 7.1, LDAP is still open to localhost on port 389 and the directory is still named Nortel. If ain't broke don't fix it!