01-22-2010 03:11 PM
Hi,
I need to replicate the functionality of the Cisco's User Tracking Utility via a WEB based tool (cgi with perl), I can do it via calls to campus/bin/ut -cli but I was wondering if the Cisco's UTU uses some kind of SOAP / xmlrpc calls to the CM, which I could use?
Thanks
Solved! Go to Solution.
01-22-2010 03:41 PM
Does the solution *have to* use xmlrpc/SOAP? Without that as a hard requirement, empirically speaking, it seems that one could potentially just adapt the Perl sample code "Accessing Database Using ODBC Access Method" to query the LMS DB from a remote server against the End_Hosts view, which is equivalent to what UTU provides (in my perception).
After you have copied the required files from CiscoWorks Server to remote server and created DSNs, you can access the CiscoWorks database from a remote server.
See the following sections for the sample code to access the CiscoWorks database:
•Accessing Database Using Jconnect JDBC Access Method
•Accessing Database Using iAnyWhere JDBC Access Method
•Accessing Database Using ODBC Access Method
Table 1 lists the database views or tables that are exposed in CiscoWorks applications.
CiscoWorks Application | Name of Views or Tables |
---|---|
Common Services (CS) Views | Network_Devices |
Job_Details | |
Campus Manager (CM) Views | End_Hosts |
The End_Hosts view displays the end host details from Campus Manager application, as explained in Table 4.
01-22-2010 03:23 PM
UTU talks to a servlet named UTBandServlet.
I also did some investigations to make use of this feature but currently have no time to follow-up on this
01-22-2010 03:41 PM
Does the solution *have to* use xmlrpc/SOAP? Without that as a hard requirement, empirically speaking, it seems that one could potentially just adapt the Perl sample code "Accessing Database Using ODBC Access Method" to query the LMS DB from a remote server against the End_Hosts view, which is equivalent to what UTU provides (in my perception).
After you have copied the required files from CiscoWorks Server to remote server and created DSNs, you can access the CiscoWorks database from a remote server.
See the following sections for the sample code to access the CiscoWorks database:
•Accessing Database Using Jconnect JDBC Access Method
•Accessing Database Using iAnyWhere JDBC Access Method
•Accessing Database Using ODBC Access Method
Table 1 lists the database views or tables that are exposed in CiscoWorks applications.
CiscoWorks Application | Name of Views or Tables |
---|---|
Common Services (CS) Views | Network_Devices |
Job_Details | |
Campus Manager (CM) Views | End_Hosts |
The End_Hosts view displays the end host details from Campus Manager application, as explained in Table 4.
01-22-2010 03:53 PM
Thanks for the feedbacks, I'm terrified by the LMS DBs (had to reinitialize different DBs in the past due to some corruptions), would prefer to stay away from the direct DB access
01-22-2010 07:10 PM
The direct database access in LMS 3.2 is perfectly safe. In fact, the actual tables which contain the data are not exposed to users. Instead, new read-only views are created to provide the documented data.
01-24-2010 12:58 PM
Checked the http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_campus_manager/5.2/user/guide_pb/dee.html
and it had the info on the servlet that can be accessed remotely (a wrapper for cwexport / ut), I just realized that they have a common issue, which is I cannot request the info for a particular host / user, instead they will provide all the hosts / users and then the client will have to sort it out, the problem is with the amount of data. It looks like the access to the DB would be the most appropriate way
Thanks
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: