How can I find a user's "department" in the DB files?

[lindaibarra]

Seems like an easy quest.

I can find some information about users in the deviceNumPlanMap table in cmm300 db and I can find all kinds of stuff in the CDR DB in the callDetailRecord table but I need to cough up reports sorted by department for management.

I know the field is in there somewhere, because it is availabe to the config screens. But when I look at the asp code for those it gives me a stomach ache.

:(

Can anyone help a programmer avoid suicide by just telling her where the department field is hiding in the data files?

[gogasca]

The user info is not in SQL, you need to do an LDAP query into the directory.

Or you can find users info into CorporateDirectory.txt or Autogenerated.txt file in the Attendantconsole folder in the CallManager Server folders. (c:\Program Files\Cisco\ ) I believe is CallmanagerAttendant