Application Portfolio Management - Data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-22-2023 06:13 AM
Our organisation is looking at implementing application portfolio management. We have it installed in a temp environment to test out. This is a broad question but - what I would like to know is what are the various data points are that give the useful metrics for this application?
Obviously some are on the business application records itself, but is there any way someone can give a summary of what tables, fields etc that apm uses to gather the data points that it uses in its, dashboards, the app itself to present meaningful data in app?
From what I can see, the servicenow docs, videos online dont quite get into this information, and it would be good to know. Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2023 04:43 AM
Hi @anfield
Application Portfolio Management (APM) in ServiceNow uses various data points to provide useful metrics.
Here's a summary of the key tables, fields, and data points that APM uses:
1. **Business Application [cmdb_ci_appl]:** This is the main table where all the business applications are stored. Key fields include name, description, business owner, business criticality, lifecycle status, etc.
2. **Application Service [cmdb_ci_service]:** This table stores the services provided by the applications. Key fields include name, description, business owner, business criticality, lifecycle status, etc.
3. **Application Indicator [apm_application_indicator]:** This table stores the indicators for each application. Key fields include name, description, weight, target, actual, etc.
4. **Application Indicator Score [apm_application_indicator_score]:** This table stores the scores for each indicator. Key fields include application, indicator, score, date, etc.
5. **Application Suite [cmdb_ci_appl_suite]:** This table stores the application suites. Key fields include name, description, business owner, business criticality, lifecycle status, etc.
6. **Demand [dmn_demand]:** This table stores the demands for each application. Key fields include name, description, business owner, business criticality, lifecycle status, etc.
7. **Project [pm_project]:** This table stores the projects for each application. Key fields include name, description, business owner, business criticality, lifecycle status, etc.
8. **Risk [risk]:** This table stores the risks associated with each application. Key fields include name, description, business owner, business criticality, lifecycle status, etc.
9. **Cost [cost]:** This table stores the costs associated with each application. Key fields include name, description, business owner, business criticality, lifecycle status, etc.
10. **Vendor [core_company]:** This table stores the vendors for each application. Key fields include name, description, business owner, business criticality, lifecycle status, etc.
These tables and fields are used by APM to gather data points for its dashboards and to present meaningful data in the app.
Hope this info helps you.