Hello team, We are working ServiceNow reporting requirement where:
- Create a report on Business Application table(cmdb_ci_business_app)
- Count of Business Apps should be same through out the years
- Report should show the progress in terms of status(Eg. in year 2023 Status is On-Prem, in year 2024 Status will be Migrated, in year 2025 Status will Retired)
As of now, we have tried below approach:
- Create custom Application History table and capture the value of Status and Year. Create a report on this table.
- Create a database view(by joining the Business Application and Application History tables) and generate a report.
The above approaches are not giving expected output.
If you have any other approach, please reach out to me. Also, refer below screen shot to see expected output: (edite
