EN
Español
English
Português
    Client Views2

    V_CLIENT_SOFTWARE_VERSION

    Set of all the software of the devices with their version.

    FIELD GUY NULLABLE DESCRIPTION

    software_Id
    Int
    No
    Software code.

    product_name
    Narchar
    No
    Software name.

    software_type
    Varchar
    Yes
    Type of software (Operating System, Application, Update).

    manufacturer
    Narchar
    Yes
    Software developer.

    Platform
    Varchar
    Yes
    Software platform.

    Is_inventory
    Varchar
    No
    Software inventory status.

    Version
    Narchar
    Yes
    Software version.

    Is_permitted
    Varchar
    No
    Sets whether software is allowed - no.



    Existing Relationships Foreign Key  

    Table V_CLIENT_SOFTWARE_VERSION with Table V_CLIENT_DEVICE_SOFTWARE    		 software_Id



    V_CLIENT_DEVICE FILES

    Breakage table indicating the files present on the device according to the last inventory.

    FIELD GUY NULLABLE DESCRIPTION

    View_device_Id
    Int
    No
    Device code.

    View_file_version_Id
    Int
    No
    File code.



    Existing Relationships Foreign Key

    Table V_CLIENT_DEVICE_FILES with Table V_CLIENT_DEVICES
    View_file_version_Id



    V_CLIENT_FILES

    A set of all files on the devices.

    FIELD GUY NULLABLE DESCRIPTION

    file_version_Id
    Narchar
    No
    File version code.

    file_Id
    Narchar
    No
    File code.

    file_extension
    bigint
    No
    File extension.

    file_name
    Narchar
    Yes
    File name.

    default_file_size
    Narchar
    Yes
    File size in bits.

    file_size_Convert
    Narchar
    Yes
    Size of the converted file.

    file_version
    datetime
    Yes
    File version.

    file_description    		 Narchar
    Yes
    File description.

    file_modification_date    		 Narchar
    No
    Date of file modification.

    file_Path    		 Narchar
    No
    Path where the file is located.



    Existing Relationships Foreign Key

    Table V_CLIENT_FILES with Table V_CLIENT_DEVICE_FILES
    Table V_CLIENT_FILES with Table V_CLIENT_SOFTWARWE_USAGE

    file_version_Id



    V_CLIENT_PATCH

    Patches available to install.

    FIELD GUY NULLABLE DESCRIPTION
    patch_id Int No Patch code.
    class_type Int No Patch class.
    guid Varchar Yes Patch guid.
    bulletin_id Varchar Yes Bulletin code.
    Summary Varchar Yes Patch summary.
    sqnumber Varchar Yes Patch revision number.
    Name Varchar Yes Name of the executable.
    bulletin_url Varchar Yes Patch URL.
    cve_ids Varchar Yes Patch vulnerabilities.
    severity_patch Int Yes Patch severity.
    bulletin_title Varchar Yes Name of the patch.
    posted_date datetime2 Yes Date of release of the patch.
    Deployable Int No The patch is installable.
    is_installed Int No The patch is installed.
    patch_type Int Yes Identifier of the patch type.
    download_id Int No Download code.
    download_status Int No Download status identifier.
    download_date datetime Yes Download date.
    scheduled_date datetime Yes Programming date.
    URL Varchar No Patch download URL.
    size bigint No Patch size.
    language_id Int No Id of language.
    Existing Relationships Primary Key Foreign Key
    Table V_CLIENT_PATCH with Table V_CLIENT_PATCH_DEVICE   patch_id, language_id


    V_CLIENT_PATCH_DEVICE

    Patch ratio to the number of installed and uninstalled devices.

    FIELD GUY NULLABLE DESCRIPTION
    patch_id Int No Patch code.
    language_id Int No Patch language code.
    installed_dev_count Int No The number of devices that have the patch installed.
    not_installed_dev_count Int No The number of devices that do not have the patch installed.
    Existing Relationships Primary Key Foreign Key
    Table V_CLIENT_PATCH with Table V_CLIENT_PATCH_DEVICE   patch_id, language_id