08-27-2008 12:57 AM
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
Solved! Go to Solution.
08-28-2008 08:53 AM
There are no other supported ways to do what you want.
08-27-2008 08:44 AM
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.
08-28-2008 03:49 AM
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
08-28-2008 08:53 AM
There are no other supported ways to do what you want.
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: