Advanced reporting possibilities at Campus User Tracking in LMS3.1

Answered Question
Aug 27th, 2008
User Badges:

Hello ,

I have a question for advanced possibilities in the Campus User Tracking reports.

I use a custom report for each customer to account used ports in a shared environment. I want only account ports which has a connection in the last 30 days. This is possibly with column “Last Seen”. But I use many reports and I don't want to change each month the date for “Last Seen” per GUI for this column.

I didn't want change the deleting interval for the whole Campus User Tracking because for other reports I need a bigger time range.

Now the questions:

1. It there a possibility to change the query text for the reports per script (e.g. python) without the GUI?

2. It there a possibility to use advances SQL statement like GETDATE() an calculate with this?


I use these versions:

CiscoWorks Common Services 3.1.1

Campus Manager 5.0.3


Thanks for feedback,

Markus Weitenberg



Correct Answer by Joe Clarke about 8 years 11 months ago

There are no other supported ways to do what you want.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 3 (1 ratings)
Loading.
Joe Clarke Wed, 08/27/2008 - 08:44
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

Direct database access is not supported. However, there are some UT reporting CLI utilities you can use. The first is the NMSROOT/campus/bin/ut command. This utility will allow you to run custom reports as well as get all of the end hosts. The downside of this is that you can only run custom queries that you have already created in the GUI. However, with the ability to export all end hosts, you could further process the data the way you want.


The second tool is NMSROOT/campus/bin/cmexport. This tool allows you to export the UT data in XML format. Again, you can run custom queries, but only those defined in the GUI. However, the XML format may be more conducive to your scripting.

mweitenberg Thu, 08/28/2008 - 03:49
User Badges:

Hello Mr. Clarke,


thanks for the quick response. The CLI Utilities are well known, but not the "direct" way I want.

Do you have any other ideas?


Bye,

Markus Weitenberg


Correct Answer
Joe Clarke Thu, 08/28/2008 - 08:53
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

There are no other supported ways to do what you want.

Actions

This Discussion