1. Class Data source (Database)

    Configuration management
    Artikel: AN0002505Aktualisiert: 16.03.2024
    Die vorgegebene Sprachenversion vom Artikeltext wird angezeigt, weil es kein Text von der ausgewählten Sprache und Version gibt.

    Description

    Class contains the Data source (Database) entity of the IT (CMDB) model solution.

    Location and referencing

    Location Code Name
    Model it IT
    Class datasource Data source
    Parent class ci Configuration items
    Child classes    
    Script object OG.ClassDef.GetByCode(OGModel.Id, 'datasource')
    OG.ClassDef.GetByCode('it', 'datasource')

    Automated data import

    This entity can be filled in automatically by means of infrastructure function OG_SQL-DB.

    Columns

    Overview of class columns (excl. system columns, for inhereted columns see parent classes):

    Code Name Type Link information Description
    cl_datasource Data source - HA secondary for Revers class link (multiple) Data source
    (revers)    		 Automatically created column.
    cl-datasource Code table - Data source Revers class link (multiple) Code table
    (revers)    		 Automatically created column.
    cl-datasource-2 Application - Datasource - Data Source Revers class link (multiple) Application - Datasource
    (revers)    		 Automatically created column.
    cl-datasource-3 Table - Data Source Revers class link (multiple) Table
    (revers)    		 Automatically created column.
    cl-datasource-4 File group - Datasource Revers class link (multiple) File group
    (revers)    		 Automatically created column.
    cl-datasource-5 Data entity - Data source Revers class link (multiple) Data entity
    (revers)    		 Automatically created column.
    cl-datasource-6 DB views - Database Revers class link (multiple) DB views
    (revers)    		 Automatically created column.
    cl-datasource-7 DB stored procedures - Database Revers class link (multiple) DB stored procedures
    (revers)    		 Automatically created column.
    cl-datasource-8 DB Functions - Database Revers class link (multiple) DB Functions
    (revers)    		 Automatically created column.
    collation Collation Text   Database collation.
    compatibility-level Compatibility level Text   Compatibility level of the database.
    databasename Database name Text   Database name.
    databaseserver Database server Class link (simple) DB Server Database server hosting the database.
    description Description Text   Database description.
    ha_secondary_for HA secondary for Class link (simple) Data source Reference to the primary database.
    ha_technology HA technology Class link (simple) Technology Database technology used for a high availability (Log shipping, replication...)
    owner Owner User link (simple) User User owning the database.
    last-database-backup Last database back up Date and time   Last back up of the database file.
    last-database-log-backup Last database log back up Date and time   Last back up of the database log.
    recovery-model Recovery model Text   Name of the database server instance.
    size Size (GB) Decimal   Size of the database.
    space-available Space available (MB) Decimal   Free space in the database.
    synchronous_commit Synchronous commit True/untrue   Indicates whether the recording into the secondary database is part of the transaction.

    Quick filter

    In order users can easily filter the records some columns are selected for a Quick filter.

    Buttons

    Icon Code Name Order Description
    db-index-defrag Defragment indexes 100 Defragments indeces in the database.

    Master/detail relations

    Code Column Placement Bookmark name Type
    code_63 Incident - Related CI Below Incidents and Problems Reference to class
    code_64 Problem - Related CI Below Incidents and Problems Reference to class
    code_65 Project - Added configuration items Below Projects Reference to class
    code_66 Project - Modified configuration items Below Projects Reference to class
    code_67 Project - Removed configuration items Below Projects Reference to class
    code_68 Task - Affected CI Below Projects Reference to class
    code_69 Work schedule - Affected CI Below Projects Reference to class
    code_70 Application - Datasource - Data Source Below Used by applications Reference to class
    code_84 Changes - Affected CI Below Changes Reference to class
    code_122 Table - Data Source Below Tables Reference to class
    code_182 File group - Datasource Below Filegroup Reference to class
    code_260 Article - Configuration items Below KB Reference to class

    Potential improvements

    You can improve the solution according to your needs. Here are some tips.

    Add new columns

    Add new columns, if you are going to need them.

    Add buttons

    Add new buttons to automate edits that you would otherwise make one at a time.

    In diesem Artikel
    ×