Which table are the user details stored in?

[lszb]

I wonder which table stores the information about a user (name, username etc.) in the MSSQL server? I can't trace it with the MSSQL profiler.

 

[cdiross]

calldetailrecords of the publisher server.

 

[AdmanOK]

That information is not stored in a SQL table. It's stored in the DC Directory LDAP database.

 

[cdiross]

go in to query analyzer and connect to the ccm server. Go to the object browser select the CM030x db. Click on user tables to expand. click to expand the dbo.device. Now you can see all of your fields. Click the dbo drop down and select CM030X.
Now type in the query window
Select * from device where name is NOT NULL
Now click the green arrow to run
Depending on how you have your output set up is how you will get your records.
Mine is set up to "Grid" Click on the upper left corner to highlight all data
rightclick on the data and save as. Save it as a csv whereever. Voila. Names and associations.

 

[lszb]

THX for everybody.
I think AdmanOK is right.
I'm actually don't work with CM, I just have to synchronize all the user inventory databases like AD, CM etc. to maintain consistency.

 

[whykap]

Then you'll need to run the AD integration plug-in on call manager. It will then use your AD as the user database and not the local DC directory.
Careful as that will also change access to the call manager server using AD rights and not the previous local authentication rights.

It is simple just make sure you are aware of all the dependencies if you decide to do AD integration and most important make sure your AD environment is SOLID.


Good luck