Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

User Tracking DataBase unix shell command line queries?

Is it possible to query the user tracking database from the unix shell ? What type of database is this? I need to get a daily output of which devices are connected to which ports in the Cat5000/5509 switches. I know I could write an script to do this, but since CiscoWorks already has the information, I just need a way to make database queries from the shell.

Thanks for any information

6 REPLIES
Blue

Re: User Tracking DataBase unix shell command line queries?

Not possible what you're mentioning above. However can export the UT data:

http://www.cisco.com/warp/public/477/Campus/ut_export_data.html

Community Member

Re: User Tracking DataBase unix shell command line queries?

Any way to do this in an automatic method????

Thanks.

Blue

Re: User Tracking DataBase unix shell command line queries?

You try writing a script which includes the above export CLI command to run frequently.

Community Member

Re: User Tracking DataBase unix shell command line queries?

I'm running the Solaris version. According to the information you mentioned, there it should be a UT(upper case) command under $NMSROOT/CSCOpx/bin. Instead I only have a ut (lower case, for NT) command in that directory. If I run the ut cli command, it works ok and I get what I need from the user track database, but it requires X-Windows to be running. It seems to take an X-Windows dump or something like that. Is this the way is supposed to work? I usually connect to the server thought secure shell and don't have an X session running on my desktop. Kind of hard to cron it.

Again, thanks for any info.

Community Member

Re: User Tracking DataBase unix shell command line queries?

I am going to have the same concern. We are deploying LMS 2.1 and Compus Manager in Nov. As soon as discovery is done, our goal is to extract User Trackering data and to import the data to Tivoli EIMS (inventory system).

Any advise from experts around ? Tks for any info.

Blue

Re: User Tracking DataBase unix shell command line queries?

If you just want to know how to export data from UT CLI, you can refer to:

http://www.cisco.com/warp/public/477/Campus/ut_export_data.html

133
Views
0
Helpful
6
Replies
CreatePlease to create content