EN
Español
English
Português
    Customer Views3

    V_CLIENT_EXECUTION DEVICE

    Devices present in the execution of a package

    FIELD GUY NULLABLE DESCRIPTION

    View_execution_projects_ex equation_Id
    Int
    No
    Execution Code.

    View_device_Id
    Int
    No
    Device class.

    execution_status
    Varchar
    Yes
    Status of execution.

    execution_Start_date
    datetime
    Yes
    Date of start of execution.

    execution_finish_date
    datetime
    Yes
    Execution completion date.

    update_date
    datetime
    Yes
    Date of update.



    Existing Relationships Foreign Key

    Table V_CLIENT_EXECUTION_DEVICE with Table V_CLIENT_DEVICES
    Table V_CLIENT_EXECUTION_DEVICE with Table V_CLIENT_PROJECT_EXEC
    View_execution_projects_execution
    _id view_device_Id



    V_CLIENT_PROJECT_EXEC

    List of distribution project executions .

    FIELD GUY NULLABLE DESCRIPTION

    execution_Id
    Int
    No
    Code of execution.

    View_distribution_project_Id    		 Int
    No
    Distribution project code.

    execution_name
    Narchar
    No
    Name of the execution.

    execution_status
    Varchar
    Yes
    Status of execution.

    execution_date
    datetime
    Yes
    Date of execution.

    device_platform
    Varchar
    Yes
    Platform where the execution was carried out.

    execution_type
    Varchar
    Yes    		 Execution type (Install, Uninstall).



    Existing Relationships Primary Key Foreign Key

    Table V_CLIENT_PROJECT_EXEC with Table V_CLIENT_EXECUTION_DEVICE
    Table V_CLIENT_PROJECT_EXEC with Table V_CLIENT_DISTRIBUT_PROJ
    Table V_CLIENT_PROJECT_EXEC with Table V_CLIENT_EXEC_PACKAGE
    execution_Id
    View_distribution _project_Id



    V_CLIENT_DISTRIBUT_PROJ


    Proyectos de distribución ejecutados.

    FIELD GUY NULLABLE DESCRIPTION

    Project_Id
    Int
    No
    Project code.

    Project_name
    Narchar
    No
    Name of the distribution project.

    device_platform    		 Varchar
    Yes
    Device platform.

    package_type
    Varchar
    Yes
    Package type (Applications, Updates, Agent).

    executions_failure
    Int
    Yes
    Number of failed executions.

    executions_successfull
    Int
    Yes
    Number of executions completed successfully.

    executions_count
    Int
    Yes
    Total executions.

    Last_execution_date
    datetime
    Yes
    Date of last execution.



    Existing Relationships Primary Key Foreign Key

    Table V_CLIENT_DISTRIBUT_PROJ with Table _CLIENT_PROJECT_EXEC
    Project_Id    		  



    V_CLIENT_EXEC_PACKAGE

    Packages present per run.

    FIELD GUY NULLABLE DESCRIPTION

    View_execution_execution_Id
    Int
    Yes
    Code of execution.

    View_distribution_package_Id
    Int
    No
    Execution package code.

    creation_date
    datetime
    Yes
    Date of creation of the package.

    execution_date
    datetime
    Yes
    Package execution date.

    creator_user    		 Narchar
    No
    User who created the package.



    Existing Relationships Primary Key Foreign Key

    Table V_CLIENT_EXEC_PACKAGE with Table _CLIENT_PROJECT_EXEC
    Table V_CLIENT_EXEC_PACKAGE with Table V_CLIENT_DISTRIBUT_PACK
    view\execution _package_Id
    View_distribution _package_Id    		  



    V_CLIENT_DISTRIBUT_PACK

    Created Packages Information.

    FIELD GUY NULLABLE DESCRIPTION

    package_Id
    Int
    No
    Package code.

    package_name
    Narchar
    No
    Package name.

    Version
    Narchar
    Yes
    Package version.

    package_type    		 Varchar
    Yes
    Package type (Applications, Updates, Agent).

    device_platform
    Varchar
    Yes
    Device platform.

    architecture_package
    Varchar
    Yes
    Package architecture.

    Description_package    		 Narchar
    Yes
    Package Description



    Existing Relationships Primary Key Foreign Key

    Table V_CLIENT_DISTRIBUT_PACK with Table V_CLIENT_EXEC_PACKAGE
    package_Id