Announcement

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

  • exporting users

    Wish there was some way to easily export the users of the system. Does anyone know how to do this?

  • #2
    never mind figured it out

    Comment


    • #3
      So, don't keep it a secret...

      Comment


      • #4
        exporting users

        so youll need to open excel and create a query under data. enter the url of your conf bridge, it will ask for your admin credentials and allow you to pick what to import.

        If only the Director would allow the same thing, but queries dont see to work with st director. But thats ok. Our server guys are able to copy the database everynight and save it to a diffent folder with date for me. Being able to go back to a spefic date for me is extremly helpfull. Especially if you are working accross different buildings and different states, you can go back to see what phone was assigned to what mac address, and all kinds of other stuff.

        Comment


        • #5
          Has anyone figured out a way to export user information in a neat fashion? I am trying to use SQLyog to export to .csv but it is nasty. This is 9.1

          Comment


          • #6
            This is not for conference bridge it is from director database......

            Comment


            • #7
              my bat file. Options 1-5 are specific, anything else gets you to a custom query, all sent to a text file.

              @echo off

              Echo what drive is Shoreline Communications\ShoreWare server on? ie c for c:
              Echo.
              Echo.
              Set /P drive=

              CLS
              ECHO What information would you like
              Echo.
              Echo 1 Allow Soft Phone
              Echo 2 Is not Personal Call Manager
              Echo 3 Has Mobile Call Manager
              Echo 4 Allows Video Calls
              Echo 5 Is an Administrator
              SET /P number=
              ECHO.
              CLS

              If %number% == 1 goto:softphone
              If %number% == 2 gotocm
              If %number% == 3 goto:mcm
              If %number% == 4 goto:video
              If %number% == 5 goto:admin

              goto:custom

              :softphone
              Echo select UserDN, GuiLoginName from shoreware.users where AllowSoftPhone = '1'; >>"%tmp%\sql.sql"
              "%drive%:\\Program Files\\Shoreline Communications\\Shoreware Server\\MySQL\\MySQL Server 5.0\\bin\\mysql.exe" --user root --password=shorewaredba --database=shoreware <"%tmp%\sql.sql" >"%HOMEDRIVE%\%HOMEPATH%\Desktop\Users.txt"
              del "%tmp%\sql.sql"
              goto:end

              cm
              Echo select UserDN, GuiLoginName from shoreware.users where ClientType > '0'; >>"%tmp%\sql.sql"
              "%drive%:\\Program Files\\Shoreline Communications\\Shoreware Server\\MySQL\\MySQL Server 5.0\\bin\\mysql.exe" --user root --password=shorewaredba --database=shoreware <"%tmp%\sql.sql" >"%HOMEDRIVE%\%HOMEPATH%\Desktop\Users.txt"
              del "%tmp%\sql.sql"
              goto:end

              :mcm
              Echo select UserDN, GuiLoginName from shoreware.users where MCMAllowed = '1'; >>"%tmp%\sql.sql"
              "%drive%:\\Program Files\\Shoreline Communications\\Shoreware Server\\MySQL\\MySQL Server 5.0\\bin\\mysql.exe" --user root --password=shorewaredba --database=shoreware <"%tmp%\sql.sql" >"%HOMEDRIVE%\%HOMEPATH%\Desktop\Users.txt"
              del "%tmp%\sql.sql"
              goto:end

              :video
              Echo select UserDN, GuiLoginName from shoreware.users where AllowVideoCalls = '1'; >>"%tmp%\sql.sql"
              "%drive%:\\Program Files\\Shoreline Communications\\Shoreware Server\\MySQL\\MySQL Server 5.0\\bin\\mysql.exe" --user root --password=shorewaredba --database=shoreware <"%tmp%\sql.sql" >"%HOMEDRIVE%\%HOMEPATH%\Desktop\Users.txt"
              del "%tmp%\sql.sql"
              goto:end

              :admin
              Echo select UserDN, GuiLoginName from shoreware.users where RoleID > '0'; >>"%tmp%\sql.sql"
              "%drive%:\\Program Files\\Shoreline Communications\\Shoreware Server\\MySQL\\MySQL Server 5.0\\bin\\mysql.exe" --user root --password=shorewaredba --database=shoreware <"%tmp%\sql.sql" >"%HOMEDRIVE%\%HOMEPATH%\Desktop\Users.txt"
              del "%tmp%\sql.sql"
              goto:end

              :custom

              CLS
              Echo What Field are you searching for? IE UserDN, FaxSupport?
              Echo.
              SET /P Field=
              CLS
              CLS
              Echo What Variable are you searching for? IE 1,2,0?
              Echo.
              SET /P vr=
              CLS
              CLS
              Echo "Are you looking for '=' '>' or '<'"
              Echo.
              SET /P setting=
              CLS
              Echo select UserDN, GuiLoginName from shoreware.users where %Field% %setting% '%vr%'; >>"%tmp%\sql.sql"
              "c:\\Program Files\\Shoreline Communications\\Shoreware Server\\MySQL\\MySQL Server 5.0\\bin\\mysql.exe" --user root --password=shorewaredba --database=shoreware <"%tmp%\sql.sql" >"%HOMEDRIVE%\%HOMEPATH%\Desktop\Users.txt"
              del "%tmp%\sql.sql"

              :end
              Echo your users are listed in the file located at %HOMEDRIVE%\%HOMEPATH%\Desktop\Users.txt
              "%HOMEDRIVE%\%HOMEPATH%\Desktop\Users.txt"

              Comment


              • #8
                That is awesome! Do you have one that can pull Extension, FirstName, LastName? I am just not confident at all with batch/SQL dipping type stuff.

                Thank you allot!

                Comment


                • #9
                  I can pull extension, and first initial, last name, but not first and last name.

                  Just choose option 6, UserDN, 1, > and you will get all user extensions and guilogin name.

                  Comment


                  • #10
                    If you just want user information as in the system directory, you can just go to your PCM and open the directory. Then right click on an entry and select export all or open as text. If you save as text it concatenates the name, but if you export the list it keep first and last names separate.
                    Last edited by jmccumber; 11-18-2009, 01:23 PM.

                    Comment


                    • #11
                      Old post, but if anyone is using this and wants the extension with Fname and Lname... NOTE: in the code below, I copied the MySQL Server 5.0 files from the server to my desktop, so I could run the Query.bat file from my desktop.

                      :extname
                      Echo SELECT Users.UserDN, Tabaddresses.FirstName, Tabaddresses.LastName FROM Shoreware.Users INNER JOIN Tabaddresses ON Users.AddressID=Tabaddresses.AddressID ; >>"%tmp%\sql.sql"
                      "C:\MySQL Server 5.0\bin\mysql.exe" --host=x.x.x.x --user=(dbusername) --password=(dbpassword) --port=(dbport#) --database=shoreware <"%tmp%\sql.sql" >"%HOMEDRIVE%\%HOMEPATH%\Desktop\Users.txt"
                      del "%tmp%\sql.sql"
                      goto:end

                      Comment

                      Working...
                      X