Need help on the Database View

[Malathi3]

Hello Everyone,

Can anyone help on the Database View creation on the below requirement:

To capture content actively utilized by the business, the migration scope will be derived from the system’s navigation logs.

• Data Source: sys_ui_navigator_history
• Parameters: Filter for URLs containing pa_dashboard.do?sysparm_dashboard= with a Updated date within the last 6 months.
• Methodology: Programmatically extract unique Dashboard Sys IDs from the URL strings to establish the migration batch.

[yashkamde]

Hello @Malathi3 ,

You can achieve this with a Database View on sys_ui_navigator_history by filtering URLs that contain pa_dashboard.do?sysparm_dashboard= and restricting sys_updated_on to the last 6 months.

From there, parse the sysparm_dashboard parameter out of the URL string (using a SQL function or scripted field) and select distinct values to get the unique dashboard Sys IDs. This gives you a clean list of actively used dashboards that can serve as your migration batch.

If my response helped mark as helpful and accept the solution.

[Malathi3]

Hello Yashkamde,

I tried creating a Database View in my PDI and have added the condition in Where clause. Not sure whether it is correct?