EN
Español
English
Português
    Customer Views1

    V_CLIENT_DEVICES

    Device overview

    FIELD GUY NULLABLE DESCRIPTION
    device_id Int No Device code.
    device_name Narchar No Device name.
    device_type Varchar Yes Defines the type of device (Unknown, Desktop, Laptop, Server, Printer, Switch, Router).
    Description Narchar Yes Description of the device.
    Domain Narchar Yes The domain to which the device belongs.
    creation_date datetime No Date of the agent’s first communication with the Conserver.
    device_user_name Narchar Yes Device username.
    responsible_user_name Narchar Yes User responsible for the device.
    responsible_user_email Narchar Yes Email from the user responsible for the device.
    Platform Varchar Yes Device platform.
    operating_system Narchar Yes Device operating system.
    operating_system_version Narchar Yes Operating system version.
    is_active Varchar Yes Set whether the device is active or not.
    model Narchar Yes Device model.
    serial Narchar Yes Serial of the device.
    manufacturer Narchar Yes Device manufacturer.
    agent_version Narchar No Agent version installed on the device.
    last_inventory datetime Yes Date and time of the last inventory generated.
    agent_profile Narchar Yes Agent profile.
    Keep Narchar Yes Url of the Restaurant with which it communicates.
    last_communication_update datetime Yes Time and date of the agent’s last communication with the Conserver.
    communication_address Narchar Yes IP of the device with which it communicates with the conserver.
    days_since_last_inventory Int Yes Days elapsed without inventory.
    min_since_last_communication Int Yes Minutes elapsed since the last communication.
    is_discovery     Determines whether the device was discovered or if the agent was installed manually.
    Existing Relationships Primary Key
    Table V_CLIENT_DEVICES with TablaV_CLIENT_DEVICE_HARDWARE device Id
    Table V_CLIENT_DEVICES with Table V_CLIENT_SOFTWARWE_USAGE  
    Table V_CLIENT_DEVICES with Table V_CLIENT_HARDWARE_MEMORY  
    Table V_CLIENT_DEVICES with Table V_CLIENT_DEVICE_SOFTWARE  
    Table V_CLIENT_DEVICES with Table V_CLIENT_DEVICE_FILES  
    Table V_CLIENT_DEVICES with Table V_CLIENT_EXECUTION_DEVICE  
    Table V_CLIENT_DEVICES with Table V_CLIENT_POLICY_DEVICE  

    V_CLIENT_SOFTWARWE_USAGE

    List of software usage slots

    FIELD GUY NULL ABLE DESCRIPTION

    View_device_Id
    Int
    No

    Device code.

    View_file_Id
    Int
    No

    File code.

    Use yourself    		 Date
    No

    Date the software was used.

    Duration_seconds
    bigint
    No

    Duration in seconds that the software was used.

    usage_user
    Narchar
    Yes

    User who used the software.



    Existing Relationships Foreign Keys
    Table V_CLIENT_SOFTWARWE_USAGE with Table V_CLIENT_DEVICES View_device_Id
    Table V_CLIENT_SOFTWARWE_USAGE with Table V_CLIENT_FILES View_file_Id



    V_CLIENT_HARDWARE_MEMORY

    Total and available memory of the device

    FIELD GUY NULL ABLE DESCRIPTION

    View_device_Id
    Int
    No

    Device code.

    total_physical_RAM
    bigint
    No

    Total physical memory.

    available_physical_RAM
    bigint
    No

    Available physical memory.

    total_vistual_memory    		 bigint
    No

    Total virtual memory.

    available_virtual_RAM
    bigint
    No

    Virtual memory available.

    Max_RAM    		 bigint
    No

    Maximum memory capacity.

    page_memory
    bigint No Paging memory.    		    
    available_page_memory bigint No

    Available paging memory.
    Slot_count Int No
    Number of occupied slots.



    Existing Relationships Foreign Key
    Table V_CLIENT_HARDWARE_MEMORY with Table V_CLIENT_DEVICES  



    V_CLIENT_DEVICE_SOFTWARE

    Breakout table indicating the software installed on the devices

    FIELD GUY NULL ABLE DESCRIPTION

    View_software_Id
    Int
    No

    Software code.

    View_device_Id
    bigint
    No
    Device code.



    Existing Relationships Foreign Key
    Table V_CLIENT_HARDWARE_MEMORY with Table V_CLIENT_DEVICES View_software_id view_device_Id