Contents

Introduction

Prerequisites

Components Used

Problem

Solution

Schedule Widget

URL Widget with Dashboard Permalink

Widget that Exceeds Dashboard Canvas Size Limit

Excel and XML Permalink Widget Type

Dashboard with 11 Widgets or more

Introduction

This document describes additional validation procedure for Cisco Unified Intelligence Center (CUIC) server upgrade to version 11.6. It contains a set of database queries that list unsupported dashboard widgets to be dropped after the upgrade.

Prerequisites

Components Used

The information in this document is based on CUIC version 11.5.

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, ensure that you understand the potential impact of any command.

Problem

After Cisco Unified Intelligence Center server upgrade from previous versions to 11.6 version all unsupported dashboard widgets are discarded without explicit notification to the system administrator. In order to prevent loss of the widgets the document suggests and provide guidance on how to validate the existing widgets.

Note: A valid backup ensures that all of the configuration can be restored, so it is always recommended to take a backup before an upgrade.

Solution

Schedule Widget

Use this SQL query to list all dashboards with scheduled type widgets.

Note: All the lines of the query in bold font must be entered to get the output. The backslash character is used for better query presentation.

admin:run sql SELECT dw.parentdashboardid,d.name dashboard,dw.name widget \

FROM cuic_data:cuicdashboardwidget dw \

INNER JOIN cuic_data:cuicdashboard d \

ON d.id=dw.parentdashboardid \

WHERE widgettype='SCHEDU'

parentdashboardid                dashboard                       widget

================================ =============================== ==================

09BCDE8D1000015E0000005A0A302F8E case1_validate_scheduled_widget scheduled_widget_1

The widgets of this type are unsupported in CUIC version 11.6 and are discarded after the upgrade.

URL Widget with Dashboard Permalink

URL widgets with a permalink to another dashboard are called nested dashboards.

The widgets of this type are unsupported in CUIC version 11.6 and arediscardedafter the upgrade.

This article does not have specific SQL queries to list dashboards and widgets of this type.

Widget that Exceeds Dashboard Canvas Size Limit

The widgets of this type are unsupported in CUIC version 11.6 and arediscardedafter the upgrade.

This article does not have specific SQL queries to list dashboards and widgets of this type.

Excel and XML Permalink Widget Type

Use this SQL query to list all dashboards and widgets with XML and Excel types of permalinks.

admin:run sql SELECT dw.parentdashboardid,d.name dashboard,dw.name widget \

FROM cuic_data:cuicdashboardwidget dw \

INNER JOIN cuic_data:cuicdashboard d \

ON d.id=dw.parentdashboardid \

WHERE url LIKE '%linkType=excelType%' OR url LIKE '%linkType=xmlType%'

parentdashboardid                dashboard                 widget

================================ ========================= =================

09C13E6A1000015E0000006F0A302F8E case4_excel_xml_permalink url_permlnk_xml

09C13E6A1000015E0000006F0A302F8E case4_excel_xml_permalink url_permlnk_excel

AfterCUIC server upgrade to version 11.6 alldashboard widgets with excel and XML type permalinks will be converted to HTML permalinks.

Dashboard with 11 Widgets or more

Use this SQL query to list all dashboard that has more than 10 widgets associated.

admin:run sql SELECT dw.parentdashboardid,d.name dashboard,COUNT(dw.parentdashboardid)AS widget_count \

FROM cuic_data:cuicdashboardwidget dw \

INNER JOIN cuic_data:cuicdashboard d \

ON d.id=dw.parentdashboardid \

GROUP BY parentdashboardid,d.name \

HAVING 10<COUNT(parentdashboardid)

parentdashboardid                dashboard            widget_count

================================ ==================== ============

09A902BB1000015E000000070A302F8E case5_10plus_widgets 12

AfterCUIC server upgrade to version 11.6 all dashboards with more than 10 widgets are preserved, but you cannot make changes to them.