EN
Español
English
Português
    Customer Views6

    V_CLIENT_MEMORY_SLOT

    RAM-specific information.

    FIELD GUY NULLABLE DESCRIPTION

    memory_Id
    Int
    No
    Memory code.

    memory_name
    Narchar
    No
    Memory name.

    memory_type
    Narchar
    Yes
    Type of memory (DIMM, DDR, among others).

    Socket_name
    Narchar
    No
    Name of the socket.

    Socket_size
    bigint
    No
    Socket size.

    Socket_speed
    Int
    No
    Socket speed.

    memory_bank_name
    Narchar
    Yes
    Name of the memory bank.

    Form_factor    		 Narchar
    Yes
    Get or set Form factor

    menufacturer
    Narchar
    Yes
    Memory manufacturer.



    Existing Relationships Primary Key Foreign Key

    Table V_CLIENT_MEMORY_SLOT with Table V_CLIENT_HARDWARE_SUMMARY
    memory_Id



    V_CLIENT_HARD_PROCESSOR

    Processor-specific information.

    FIELD GUY NULLABLE DESCRIPTION

    processor_Id
    Int
    No
    Processor code.

    processor_name
    Narchar
    Yes
    Name of the processor.

    Features
    Narchar
    Yes
    Processor features.

    speed_processor
    bigint
    Yes
    Processor speed.

    Socket_type
    Narchar
    Yes
    Socket type.

    Core_count
    Int
    Yes
    Number of processor cores.

    status_processor
    Varchar
    Yes
    Processor Status (Unknow, Enalbe, DisabledByUser,
    DisabledByBios, Idle, Reserved1, Reserverd2, Other).

    Socket_use
    Varchar
    Yes
    Obtains or sets whether the socket is in use - no.



    Existing Relationships Primary Key Foreign Key

    Table V_CLIENT_HARD_PROCESSOR
    with Table V_CLIENT_HARDWARE_SUMMARY    		 processor_Id



    V_CLIENT_HARD_KEYBOARD

    Keyboard-specific information

    FIELD GUY NULLABLE DESCRIPTION

    keyboard_Id
    Int
    No
    Keypad code.

    keyboard_name    		 Narchar
    No
    Keyboard name.

    manufacturer
    Narchar
    Yes
    Keyboard manufacturer.

    device_identificator
    Narchar
    No
    Unique identifier of the keyboard on the machine.

    keyboard_type
    Narchar
    Yes
    Set the keyboard type.

    keyboard_language
    Narchar
    Yes
    Sets the language in which the keyboard is configured.

    keyboard_Country
    Narchar
    Yes
    Set the country for which the keyboard is configured.

    keyboard_layout
    Narchar
    Yes
    Sets the keyboard layout for which it is configured.



    Existing Relationships Primary Key Foreign Key

    Table V_CLIENT_HARD_KEYBOARD with Table V_CLIENT_HARDWARE_SUMMARY
    keyboard_Id



    V_CLIENT_HARD_VIDEO_CARD

    Video card-specific information.

    FIELD GUY NULLABLE DESCRIPTION

    video_Id
    Int
    No
    Video card code.

    video_name
    Narchar
    No
    Name of the video card.

    manufacturer
    Narchar
    Yes
    Video card manufacturer.

    video_driver_name
    Narchar
    No
    Driver name for the video card.

    video_chipset
    Narchar
    Yes
    Set your own chipset for the video card

    video_Dac
    Narchar
    Yes
    Set the built-in Digital Analog Converter on the video card.

    video_memory_size
    bigint
    Yes
    Sets the amount of memory built into the video card.

    video_version
    Narchar
    Yes
    Set the video card version.



    Existing Relationships Primary Key Foreign Key

    Table V_CLIENT_HARD_VIDEO_CARD with Table V_CLIENT_HARDWARE_SUMMARY
    video_Id



    V_CLIENT_LICENSE_SOFTWARE

    Displays the software associated with the license.

    FIELD GUY NULLABLE DESCRIPTION
    Id Int No Identifier of the relationship between the software and the license.
    software_id Int No Software code.
    license_id Int No Licensing code.
    Existing Relationships Primary Key Foreign Key
    Table V_CLIENT_LICENSE_SOFTWARE with Table V_CLIENT_LICENSE
    Table V_CLIENT_LICENSE_SOFTWARE with Table V_CLIENT_SOFTWARE_VERSION    		 Id software_id license_id

    V_CLIENT_LICENSE_PACKAGE

    Displays license packages.

    FIELD GUY NULLABLE DESCRIPTION
    Id Int No License package identifier.
    package_type Narchar No Package type.
    Quantity Int No Number of licenses purchased.
    unit_cost float Yes Unit cost of licenses.
    creation_date datetime No Date of creation of the license.
    expiration_date datetime No License expiration date.
    activation_date datetime No License activation date.
    package_name Varchar No Name of the license package.
    Currency Varchar Yes Currency with which the license was purchased.
    license_id Int No License pool code.
    Description Varchar Yes Description of the license.
    Existing Relationships Primary Key Foreign Key
    Table V_CLIENT_LICENSE_PACKAGE with Table V_CLIENT_LICENSE Id license_package_id license_id

    V_CLIENT_LICENSE_EVENT

    It allows you to identify which alerts have been generated from the licenses.

    FIELD GUY NULLABLE DESCRIPTION
    licensing_id Int No Identifier of the license that is related to the event
    Description Varchar Yes Description of the alert at the time of setting it up.
    Destination Varchar Yes Alert Mail Message
    Message Varchar Yes Content generated by the alert
    severity Varchar Yes Alert severity text (low, medium, high, critical)
    subject Varchar Yes Subject of the alert
    title Varchar Yes Title of the alert (when it has a subject this field has no content)
    type Varchar Yes Alert Type (Alert, Notification, Assign, Remove)
    unit Varchar Yes Unit of time to report the time the license expires (days, months, years)
    value Int Yes Value of the unit of time to notify when a license is going to expire (Ex: 5, if the unit is Days, then it will notify 5 days before the license becomes expired)
    Existing Relationships Primary Key Foreign Key
    Table V_CLIENT_LICENSE_EVENT with Table V_CLIENT_LICENSE   licensing_id