Announcement

never mind figured it out

So, don't keep it a secret...

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.

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

This is not for conference bridge it is from director database......

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"

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!

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.

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.

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