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,