11-16-2017 03:29 PM - edited 03-14-2019 05:44 PM
Hi,I have not done report customization someone point to the document for CUIC customization-How to Create a custom report using custom SQL, Edit View, Edit Filters, and scheduling reports for customers.
11-17-2017 05:23 AM
11-17-2017 06:47 PM
Read the documents.
Create the SQL command in SSMS until it does what you want. All returned variables must be named (no SELECT * FROM).
Work out the WHERE clause. Learn how to replace DateTime with :start and :end then set up the parameters for relative dates. Understand your value lists.
Anonymous Queries are slightly easier than Database Queries as the WHERE clause is not quite so opaque, although once you get the hang of it the DB queries are fine.
Build a report with all the returned values in the view then create a new view to do what you want. Do a few "Save As" on the stock reports and see how Cisco did it. Start with something easy and play with it. ]
Think of it as a fun exercise and don't be disheartened. It's very rewarding. Once you get something working, read the documents again and again.
Regards,
Geoff
07-23-2019 07:52 PM
Hi guys,
How can I create custom value lists and Collections to apply filter in the customized report?
Best regards
07-24-2019 11:38 AM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide