List of database objects for the MS SQL Server universe
The following default database objects are created and used by BMC Analytics for BSM:
Tables
- ANA_ALL_ENUM_VALUES
- ANA_MIDTIER
- CLIENT_ENV
- ANA_REPORT_LOCALE
- ANA_REPORT_TRANSLATION
- ANA_TIMEZONE_INFO
- ANA_TZ_DSTTIME
- DENORMALIZE_BSM_RELATIONSHIPS
Views
- ANA_FISCAL_CALENDAR
- ANA_TZ_DSTTIME_VW
- ANA_UNRESTRICT_USER_VW
- ANA_FIELD_ENUM_VALUES
- ANA_RPT_OBJECTS_VW
- ANA_BASEELEMENT_VW
- ANA_ASSET_CONTRACTS_VW
- ANA_SR_BUSINESSSERVICE_VW
- ANA_VIRTUAL_SYSTEMS_VW
- ANA_WOI_WORKORDER_VW
- ANA_AST_ENUM_VW
- ANA_CDM_ENUM_VW
- ANA_CHG_ENUM_VW
- ANA_CLM_ENUM_VW
- ANA_HPD_ENUM_VW
- ANA_PBM_ENUM_VW
- ANA_RKM_ENUM_VW
- ANA_SLM_ENUM_VW
- ANA_SRM_ENUM_VW
Procedures
- ANA_POPULATE_TIMEZONE_DST
- POPULATE_FISCAL_CALENDAR
- PC_BSM_RELS_TRAVERSAL_CHILD
- PC_BSM_RELS_TRAVERSAL_PARENT
- PC_DENORMALIZE_BSM_RELS_CHILD
- PC_DENORMALIZE_BSM_RELS_PARENT
- ANA_POPULATE_ENUMS
Functions
- FN_ADJUSTED_DATE
- FN_GETNEXTDATE
- ANA_DENORM_UNODENAME
- ANA_DENORM_WITH_FN
Related topics
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*