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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

UTU functionality

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

1 ACCEPTED SOLUTION

Accepted Solutions
Blue

Re: UTU functionality

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).

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/3.2/database_schema/guide/dbviews.html#wp69456

Sample Code to Access Database From a Remote Server

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

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/3.2/database_schema/guide/dbviews.html#wp143337

Exposed Database Views and Tables

Table 1 lists the database views or tables that are exposed in CiscoWorks applications.

Table 1     Exposed Database Views and Tables

CiscoWorks Application
Name of Views or Tables

Common Services (CS) Views

Network_Devices

Job_Details

Campus Manager (CM) Views

End_Hosts

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/3.2/database_schema/guide/dbviews.html#wp136881

End_Hosts View Details

The End_Hosts view displays the end host details from Campus Manager application, as explained in Table 4.

Table 4     End_Hosts Schema Details

Column Name
Column Type
Constraints
Column Description

HostName

varchar(64)

Null

Name of the end host

UserName

varchar(64)

Null

Logged In User name

IPAddress

varchar(15)

Null

IP Address of the end host

SubnetMask

varchar(15)

Null

Subnet mask of the device to which end host is connected

MACAddress

varchar(17)

Null

MAC Address of the end host

DeviceName

varchar(64)

Null

Device Name  (Host Name) to which the end host is connected

Device

varchar(15)

Null

Device IP Address to which the end host is connected

LastSeen

varchar(32)

Null

Time at which end host is last seen

Port

varchar(32)

Null

Name of the port where the end host is connected

VLAN

varchar(32)

Null

VLAN name.

Example: VLAN100

Subnet

varchar(15)

Null

Subnet of the device to which end host is connected

Notes

varchar(255)

Null

Notes entered by the user

PrefixLength

integer

Null

Subnet prefix length

PortDuplex

varchar(32)

Null

Mode of the port to where end host is connected

VTPDomain

varchar(32)

Null

VTP Domain Name of the device where the end host is connected.

VlanId

integer

Null

VLAN ID

Example: 100

PortName

varchar(255)

Null

Port Description entered by the user

IPv6Address

varchar(150)

Null

IPV6 address, if configured

dot1xEnabled

varchar(15)

Null

dot1x enabled status.

The value could be True or False.

associatedRouters

varchar(250)

Null

Comma separated list of routers in the subnet

5 REPLIES

Re: UTU functionality

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

Blue

Re: UTU functionality

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).

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/3.2/database_schema/guide/dbviews.html#wp69456

Sample Code to Access Database From a Remote Server

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

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/3.2/database_schema/guide/dbviews.html#wp143337

Exposed Database Views and Tables

Table 1 lists the database views or tables that are exposed in CiscoWorks applications.

Table 1     Exposed Database Views and Tables

CiscoWorks Application
Name of Views or Tables

Common Services (CS) Views

Network_Devices

Job_Details

Campus Manager (CM) Views

End_Hosts

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/3.2/database_schema/guide/dbviews.html#wp136881

End_Hosts View Details

The End_Hosts view displays the end host details from Campus Manager application, as explained in Table 4.

Table 4     End_Hosts Schema Details

Column Name
Column Type
Constraints
Column Description

HostName

varchar(64)

Null

Name of the end host

UserName

varchar(64)

Null

Logged In User name

IPAddress

varchar(15)

Null

IP Address of the end host

SubnetMask

varchar(15)

Null

Subnet mask of the device to which end host is connected

MACAddress

varchar(17)

Null

MAC Address of the end host

DeviceName

varchar(64)

Null

Device Name  (Host Name) to which the end host is connected

Device

varchar(15)

Null

Device IP Address to which the end host is connected

LastSeen

varchar(32)

Null

Time at which end host is last seen

Port

varchar(32)

Null

Name of the port where the end host is connected

VLAN

varchar(32)

Null

VLAN name.

Example: VLAN100

Subnet

varchar(15)

Null

Subnet of the device to which end host is connected

Notes

varchar(255)

Null

Notes entered by the user

PrefixLength

integer

Null

Subnet prefix length

PortDuplex

varchar(32)

Null

Mode of the port to where end host is connected

VTPDomain

varchar(32)

Null

VTP Domain Name of the device where the end host is connected.

VlanId

integer

Null

VLAN ID

Example: 100

PortName

varchar(255)

Null

Port Description entered by the user

IPv6Address

varchar(150)

Null

IPV6 address, if configured

dot1xEnabled

varchar(15)

Null

dot1x enabled status.

The value could be True or False.

associatedRouters

varchar(250)

Null

Comma separated list of routers in the subnet

New Member

Re: UTU functionality

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

Cisco Employee

Re: UTU functionality

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.

New Member

Re: UTU functionality

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

704
Views
5
Helpful
5
Replies