EN
Español
English
Português
    Customer Views4

    V_CLIENT_LICENSE

    Information on licenses created.

    FIELD GUY NULLABLE DESCRIPTION
    license_id Int No License code.
    license_name Varchar Yes Name of the license.
    creator_user Narchar Yes User who created the license.
    user_modifier Narchar Yes User who modified the license.
    creation_package_date datetime Yes Date of creation of the license package.
    updating_license_date datetime Yes Date the license was updated.
    Note Additional licensing information in the following views
    Existing Relationships Foreign Key
    Table V_CLIENT_LICENSE with Table V_CLIENT_LICENSE_SOFTWARE license_id
    Table V_CLIENT_LICENSE with Table V_CLIENT_LICENSE_PACKAGE license_id
    Table V_CLIENT_LICENSE with Table V_CLIENT_LICENSE_EVENT license_id



    V_CLIENT_POLICY_DEVICE

    Devices included in policies.

    FIELD GUY NULLABLE DESCRIPTION

    View_device_Id
    Int
    No
    Device code.

    View_policy_Id
    Int
    No
    Code of the policy.



    Existing Relationships Primary Key Foreign Key

    Table V_CLIENT_POLICY_DEVICE with Table V_CLIENT_DEVICES
    Table V_CLIENT_POLICY_DEVICE with Table V_CLIENT_POLICIES    		  
    View_device_id view_policy_Id



    V_CLIENT_POLICIES

    Information on policies created.

    FIELD GUY NULLABLE DESCRIPTION

    Policy_Id
    Int
    No
    Code of the policy.

    Policy_name
    Narchar
    No
    Name of the policy.

    user_name
    Narchar
    No
    User who created the policy.

    creation_date
    datetime
    No
    Date the policy was created.

    edit_date
    datetime
    Yes
    Date of publication of the policy.

    device_platform
    Varchar
    Yes
    Device platform.

    Policy_type
    Varchar
    Yes
    Policy Type (Energy, ForbiddenPrograms, Restriction).



    Existing Relationships Primary Key Foreign Key

    Table V_CLIENT_POLICIES with Table V_CLIENT_POLICY_DEVICE
    Policy_Id



    V_CLIENT_COMUNICAT_NODE

    Node-specific information: Conservers and Repserver.

    FIELD GUY NULLABLE DESCRIPTION

    Node_Id
    Int
    No
    Node code.

    Node_name
    Narchar
    No
    Node name.

    URL_node
    Narchar
    Yes
    Node URL.

    address
    Narchar
    Yes
    IP address of the node.

    parent_node_Id
    Int
    Yes
    Establishes the inheritance of the node.

    Node_enbled_statud
    Varchar
    Yes
    Sets whether the node is enabled or not.

    Last_communication
    datetime
    No
    Date of last communication.



    Existing Relationships Primary Key Foreign Key


    Node_Id