EN
Español
English
Português
    Customer Views5

    V_CLIENT_DEVICE_HARDWARE

    Hardware related to each device.

    FIELD GUY NULLABLE DESCRIPTION

    View_device_Id
    Int
    No
    Device code.

    View_hardware_Id
    bigint
    Yes
    Hardware code.



    Existing Relationships Primary Key Foreign Key

    Table V_CLIENT_DEVICE_HARDWARE with Table V_CLIENT_DEVICES
    Table V_CLIENT_DEVICE_HARDWARE with Table V_CLIENT_HARDWARE_SUMMARY

    View_device_id view_hardware_Id



    V_CLIENT_HARDWARE_SUMARY

    Basic information on all hardware found in inventories.

    FIELD GUY NULLABLE DESCRIPTION

    hardware_Id
    bigint
    Yes
    HARDWARE code.

    type_hardware_Id
    Int
    No
    Hardware code.

    hardware_type
    Int
    Yes
    Hardware type code.

    type
    Varchar
    No
    Type of hardware.

    Name
    Narchar
    Yes
    Hardware name.

    device_count
    Int
    Yes
    Number of devices that have that hardware.

    manufacturer
    Narchar
    Yes
    Hardware manufacturer.



    Existing Relationships Primary Key Foreign Key

    Table V_CLIENT_HARDWARE_SUMMARY with Table V_CLIENT_DEVICE_HARDWARE
    Table V_CLIENT_HARDWARE_SUMMARY with Table V_CLIENT_HARD_PHYS_DISKS
    Table V_CLIENT_HARDWARE_SUMMARY with Table V_CLIENT_HARDWARE_PRINTER
    Table V_CLIENT_HARDWARE_SUMMARY with Table V_CLIENT_MEMORY_SLOT
    Table V_CLIENT_HARDWARE_SUMMARY with Table V_CLIENT_HARD_PROCESSOR
    Table V_CLIENT_HARDWARE_SUMMARY with Table V_CLIENT_HARD_KEYBOARD
    Table V_CLIENT_HARDWARE_SUMMARY with Table V_CLIENT_HARD_VIDEO_CARD
    hardware_Id
    type_hardware_Id



    V_CLIENT_HARD_PHYS_DISKS

    Partition-specific information on physical disks.

    FIELD GUY NULLABLE DESCRIPTION

    Disk_Id
    Int
    No
    Disk code.

    Disk_name
    Narchar
    No
    Name of the album.

    bus_type
    Narchar
    Yes
    Type of bus.

    Disk_size
    bigint
    No
    Disk size.

    logical_unit
    Narchar
    No
    Disc manufacturer.

    unit_type
    Narchar
    Yes
    Type of logical unit.

    unit_size
    bigint
    Yes
    Size of the logical drive.

    unit_size_free
    bigint
    Yes
    Free space in the logical drive.

    unit_file_system
    Narchar
    Yes
    Logical drive file system.

    manufacturer
    Narchar
    Yes
    Disc manufacturer.



    Existing Relationships Primary Key Foreign Key

    Table V_CLIENT_HARD_PHYS_DISKS with Table V_CLIENT_HARDWARE_SUMMARY
    Disk_Id



    V_CLIENT_HARDWARE_PRINTER

    Printer-specific information.

    FIELD GUY NULLABLE DESCRIPTION

    printer_Id
    Int
    No
    Printer code.

    printer_name
    Narchar
    Yes
    Printer name.

    printer_port
    Narchar
    Yes
    Printer port.

    manufacturer
    Narchar
    Yes
    Printer manufacturer.
    Existing Relationships Primary Key Foreign Key

    Table V_CLIENT_HARDWARE_PRINTER with Table V_CLIENT_HARDWARE_SUMMARY
    printer_Id