Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • What's the command to query E-mail addresses on Shoretel 14.2?

    What's the command to query E-mail addresses on Shoretel 14.2?

  • #2
    what are you trying to accomplish?

    Comment


    • #3
      For the most part, the information that I'm querying would be used to export and create a directory with. There is some extra information I'm also gathering with the query. Right now the two pieces I want to query that I haven't figured out yet is being able to also query their E-mail address and I'd also like to query the site name.




      SELECT users.UserDN AS `dn`
      , dn.Description AS `Name`
      , users.guiloginname
      , IF(users.LDAPUser = '1', 'True', 'False') AS `LDAPUser`
      , users.anyipphone
      FROM users
      LEFT JOIN dn ON (users.UserDN = dn.DN)
      ORDER BY users.UserDN

      Comment

      Working...
      X