.. Reminder for header structure: Parts (H1) : #################### with overline Chapters (H2) : ******************** with overline Sections (H3) : ==================== Subsections (H4) : -------------------- Subsubsections (H5) : ^^^^^^^^^^^^^^^^^^^^ Paragraphs (H6) : """""""""""""""""""" .. meta:: :description: WAPT Console Cheat sheet :keywords: waptconsole, detailed, WAPT, preferences, documentation, the WAPT Console .. |enterprise_feature| image:: wapt-resources/icon_wapt_enterprise.png :scale: 1% :alt: WAPT Enterprise feature only .. _wapt_console_detailed: ######################## WAPT Console Cheat sheet ######################## This page details various windows and menus of the WAPT console for quick access. .. list-table:: Cheat sheet for quickly accessing the least used functions in the WAPT Console :header-rows: 1 :align: center :widths: auto * - Path to action - Description - Keyboard shortcut * - :menuselection:`File --> Quit` - To close the WAPT Console. - :kbd:`Ctrl + Q` * - :menuselection:`View --> Refresh` - To refresh the content of the WAPT Console. - :kbd:`F5` * - :menuselection:`View --> Display preferences` - :ref:`To customize the WAPT Console for your daily comfort `. - * - :menuselection:`View --> Restore default grid layout` - To restore the WAPT Console to its default settings. - * - :menuselection:`Tools --> Change admin password` - To change the WAPT Server SuperAdmin password in the WAPT Console. - * - :menuselection:`Tools --> Change admin password` - :ref:`To generate a new certificate for a new WAPT Administrator `. - * - :menuselection:`Tools --> Build WAPT Agent` - :ref:`To build the WAPT Agent installer `. - * - :menuselection:`Tools --> Change password of private key ...` - To change the private key password. - * - :menuselection:`Tools --> Clean local cache` - To clean the local cache. - * - :menuselection:`Tools --> Reset Websocket connections` - To restart the WAPT Server service without restarting the :program:`Nginx` web service. - * - :menuselection:`Tools --> Make package template from setup file` - :ref:`To create a package template from the WAPT Console `. - * - :menuselection:`Tools --> Build and upload package` - :ref:`To build a WAPT package and to send it to the WAPT Server `. - * - :menuselection:`Tools --> External repository settings` - :ref:`To add external repositories ` - * - :menuselection:`Tools --> Normalize software titles` - :ref:`To Normalize software title names `. - * - :menuselection:`Tools --> Preferences` - :ref:`To make changes to the WAPT Console settings `. - * - :menuselection:`Tools --> Manage WAPT users and rights` - :ref:`To open the ACL management window ` - * - :menuselection:`Tools --> Shown authentication logs` - To show WAPT authentication logs. - * - :menuselection:`Tools --> Manage WAPT to GLPI` - :ref:`To open the GLPI connector configuration window ` - * - :menuselection:`? --> Online help`. - To open a web browser with this documentation. - :kbd:`F1` * - :menuselection:`? --> Check Waptagent updates` - To check whether a WAPT Agent update is available on the WAPT Server. - * - :menuselection:`? --> Licences` - :ref:`To add licences to WAPT `. - * - :menuselection:`? --> About` - To show a summary of the context in which the WAPT Console is running. - * - :menuselection:`? --> See working actions` - To show the WAPT tasks that are currently running - .. _configuring_wapt_console_for_comfort: *********************************************** Configuring the WAPT Console for your daily use *********************************************** To customize the WAPT Console, do :menuselection:`View --> Display preferences`. .. figure:: wapt-resources/wapt_console_preferences_container-window.png :align: center :alt: Window for personalizing the WAPT Console Window for personalizing the WAPT Console .. list-table:: Personalization options of the WAPT Console :header-rows: 1 :align: center :widths: auto * - Options (Default Value) - Description - Example * - The :guilabel:`Maximum number of hosts to display` field (default ``2000``). - Defines the maximum number of hosts to display in the inventory. Keep low to improve the refreshment performance of the inventory in the WAPT Console. - 2000 * - The :guilabel:`Language` dropdown box (default ``system locale``) - Defines the locale of the WAPT Console. - French/English/German * - The :guilabel:`Reset the WAPT Console layout` button - Resets default settings - * - The :guilabel:`Show debug informations` checkbox (default ``False``) - Adds debug informations panel on the bottom of the WAPT Console. - False * - The :guilabel:`Enable external tools in host popup menus` checkbox (default ``True``) - Shows Windows tools on right-click in the host menu of the WAPT Console. - True * - The :guilabel:`Hide unavaible actions` checkbox (default ``False``) - Hides the option if the action is not allowed for the current user, according to :ref:`ACLs `. - False * - The :guilabel:`Enable WAPTWUA features` checkbox (default ``True``) - Shows the Windows Update tab. - True * - The :guilabel:`Show host audit data tab` checkbox (default ``False``) - Shows the :guilabel:`Audit` tab in the :guilabel:`Host inventory` window in the WAPT Console. - False .. _configuring_the_WAPT_console: **************************************** Configuring the WAPT Console preferences **************************************** To make changes to the WAPT Console settings, go to :menuselection:`Tools --> Preferences`. Basic configuration =================== .. figure:: wapt-resources/wapt_console_basic-configuration-tab_container-window.png :align: center :alt: Window for the basic configuration of the WAPT Console Window for the basic configuration of the WAPT Console .. list-table:: :header-rows: 1 :align: center :widths: auto * - Option - Description - Example * - The :guilabel:`WAPT Server address or name` field - Defines the URL (IP or :abbr:`FQDN (Fully Qualified Domain Name)`) of the WAPT Server - *srvwapt.mydomain.lan*. * - The :guilabel:`Check and set` button - Checks whether the WAPT Server exists and write the WAPT Server URL to :file:`waptconsole.ini` - * - The :guilabel:`Manual override` checkbox - Defines whether the main WAPT repository is not hosted on the WAPT Server. - Checked * - The :guilabel:`URL to the main WAPT repository` field - Defines the address of the WAPT repository (only if :guilabel:`Manual override` is checked). - http://srvwapt.mydomain.lan/wapt/ * - The :guilabel:`WAPT Server URL` field - Defines the WAPT Server address (only if :guilabel:`Specify manually` is checked). - *https://srvwapt.mydomain.lan/* * - The :guilabel:`Verify the WAPT Server HTTPS certificate` checkbox - Indicates whether the HTTPS certificate **MUST** be verified. - Checked * - The :guilabel:`Path to CA certificates bundle` field - Defines the path to the CA bundle of certificates that will allow certificates to be verified. Visit :ref:`the documentation on activating HTTPS verification `. - :file:`C:\\Program Files (x86)\\wapt\\lib\\site-packages\\certifi\\cacert.pem` * - The :guilabel:`Get Server https Certificate` button - Defines whether to retrieve the https certificate chain from the WAPT Server. - * - The :guilabel:`WAPT packages prefix` field - Defines the prefix that will be given to WAPT packages that are imported from an external repository. - tis * - The :guilabel:`Path to personal certificate` field - Defines the path to the certificate associated with the private key used to sign packages. - :file:`C:\\private\\mykey.crt` * - The :guilabel:`Licence directory` field - Defines the path to the licence for Enterprise version. Set (empty) by default in WAPT install folder. It is possible to set another path. - :file:`X:\\licence` * - The :guilabel:`Check matching private key` button - Checks whether the :mimetype:`.crt` certificate matches the :mimetype:`.pem` private key. - * - The :guilabel:`New private key and certificate` button - CreateDefines a new :ref:`private key / certificate ` pair. - * - The :guilabel:`Show config file` button - Opens :file:`%appdata%\\Local\\waptconsole\\waptconsole.ini` file with a text editor. - .. hint:: The button :guilabel:`Get the WAPT Server certificate` downloads the WAPT Server HTTPS certificate to :file:`WAPT\\ssl\\server` and tells the WAPT Console to verify HTTPS connections using that bundle of certificates. The method is called :ref:`Certificate pinning `. Before downloding the HTTPS certificate, you **MUST** be sure that you are connecting with the right WAPT Server. .. _console_detailed_advanced_config: Advanced configuration ====================== Advanced tab for advanced configuration options; .. figure:: wapt-resources/wapt_console_advanced-config_container-window.png :align: center :alt: Window for the advanced configuration of the WAPT Console .. list-table:: Options in the advanced configuration window of the WAPT Console :header-rows: 1 :align: center :widths: auto * - Option - Description - Example * - The :guilabel:`Base directory for package development` field - Defines the path to the directory for storing WAPT packages while in development. - :file:`C:\\waptdev` * - The :guilabel:`http proxy to use (if needed)` field - Defines a proxy server to be used by the WAPT Console when accessing the WAPT repository or the WAPT Server. - http://srvproxy.mydomain.lan:8080 * - The :guilabel:`Activate proxy when accessing the main repository` checkbox - Activates the proxy settings for connecting to the WAPT repository. - Checked * - The :guilabel:`Activate proxy when accessing the WAPT Server` checkbox - Activates the proxy when accessing the WAPT Server. - Checked * - The :guilabel:`Default package maturity` dropdown box - Defines the default maturity for imported packages. - PROD * - The :guilabel:`Client certificate path for authentication` field - Defines the path to the certificate for using :ref:`Client side SSL authentication `. - * - The :guilabel:`Client auth key path` field - Defines the path to the key for using :ref:`Client side SSL authentication `. - * - The :guilabel:`Editor for packages` field - Defines the default development environment when developing WAPT packages. - :program:`PyScripter` * - The :guilabel:`Show config file` button - Opens the :file:`waptconsole.ini` file in :file:`%appdata%\\Local\\waptconsole`. - .. _plugins_host: ********************************* Using plugins in the WAPT Console ********************************* Pluggins allow you to add custom actions not natively available with WAPT. .. figure:: wapt-resources/wapt_console_plugins-empty_container-window.png :align: center :alt: Creating a custom plugin in the WAPT Console Creating a custom plugin in the WAPT Console Click :guilabel:`Add` to add plugins, then edit the corresponding columns. .. list-table:: :header-rows: 1 :align: center :widths: auto * - Column - Description * - The :guilabel:`Name` column - Defines the name that will appear in the menu. * - The :guilabel:`Executable` column - Defines the path to the executable that will be executed. * - The :guilabel:`Arguments` column - Defines the arguments that will be passed to the executable. Some variables can be used like {ip}, {uuid} or {computer_fqdn}. * - The :guilabel:`Show config file` column - Opens the :file:`waptconsole.ini` file in :file:`%appdata%/Local/waptconsole`. Plugins will then appear in the menu: .. figure:: wapt-resources/wapt_console_plugins-full_container-window.png :align: center :alt: Creating a custom plugin in the WAPT Console Creating a custom plugin in the WAPT Console .. _adding_licences: ******************** Adding WAPT Licences ******************** The :guilabel:`Licences` menu item is used to :ref:`activate WAPT licences ` on WAPT Server. .. figure:: wapt-resources/wapt_console_licences_container-window.png :align: center :alt: Window for managing WAPT licences in the WAPT Console Window for managing WAPT licences in the WAPT Console .. list-table:: Informations about WAPT licences :header-rows: 1 :align: center :widths: auto * - Column - Description * - The :guilabel:`Status` column - Defines whether the license is valid. * - The :guilabel:`Count` column - Provides the number of hosts covered by the license, as specified in the licence file. * - The :guilabel:`Licence nr` column - Provides the :abbr:`UUID (Universally Unique IDentifier)` of the WAPT licence, as specified in the licence file. * - The :guilabel:`Licenced to` column - Provides the license owner, as specified in the licence file. * - The :guilabel:`Date` column - Provides the date when the licence was first uploaded to the WAPT Server. * - The :guilabel:`Valid from` column - Provides the start date of the licence, as specified in the licence file. * - The :guilabel:`Valid until` column - Provide the end date of the licence, as specified in the licence file. * - The :guilabel:`Contact email` column - Provides the email of the licence's owner, as specified in the licence file. * - The :guilabel:`Message` column - Provides the content of the *ERROR* message when the license has an *ERROR* status. * - The :guilabel:`Filename` column - Defines the path to the licence file. **************************************** Running quick queries on host properties **************************************** .. image:: wapt-resources/wapt_console_host-inventory_menu-list.png :align: center :alt: Host inventory menu list .. note:: Some columns are not displayed by default, you can select more columns with a right-click on the inventory header. .. list-table:: Host inventory menu list :header-rows: 1 :widths: auto :align: center * - Status - Description * - The :guilabel:`Status (host_status)` menu item - Provides the :ref:`status ` of the WAPT package on the host. * - The :guilabel:`Reachable (reachable)` menu item - Defines whether the host is seen by the WAPT Server. * - The :guilabel:`Audit status (audit_status)` menu item - Provides the audit status of all packages on the host. * - The :guilabel:`WUA (waptwua_status.status)` menu item - Provides the :ref:`WUA service ` status via WAPT. * - The :guilabel:`Host (computer_fqdn)` menu item - Provides the :abbr:`FQDN (Fully Qualified Domain Name)` of the host. * - The :guilabel:`Description (description)` menu item - Provides the current description of the host. * - The :guilabel:`Manufacturer (manufacturer)` menu item - Provides the manufacturer of the host. * - The :guilabel:`IP addresses (connected_ips)` menu item - Provides the list of IP addresses of the host. * - The :guilabel:`Plateform (plateform)` menu item - Provides the processor architecture of the host. * - The :guilabel:`Operating system (os_name)` menu item - Provides the Operating System name of the host. * - The :guilabel:`Model (productname)` menu item - Provides the manufacturer model name for the host. * - The :guilabel:`Serial number (serialnr)` menu item - Provides the manufacturer serial number of the host. * - The :guilabel:`Last seen on (last_seen_on)` menu item - Provides the date at which the inventory of the host was last updated. * - The :guilabel:`Logged in users (last_seen_on)` menu item - Provides the current user that is logged into the host. * - The :guilabel:`MAC address (mac_addresses)` menu item - Provides the MAC addresses associated of the host. * - The :guilabel:`WAPT version (wapt_version)` menu item - Provides the WAPT version deployed on the host. * - The :guilabel:`uuid (uuid)` menu item - Provides the :abbr:`UUID (Universally Unique IDentifier)` of the host * - The :guilabel:`purchase_order (purchase_order)` menu item - Provides the purchase Order of the host (if defined). * - The :guilabel:`purchase_date (purchase_date)` menu item - Provides the purchase date of the host (if defined). * - The :guilabel:`Domain controller (host_info/domain_controller)` menu item - Provides the Domain Controller of which the host is a member. * - The :guilabel:`Groups (depends)` menu item - Provides the groups of which the host is a member. * - The :guilabel:`Domaine (host_info/domain_controller_address)` menu item - Provides the domain name of which the host is a member. * - The :guilabel:`Listening address (listening_address)` menu item - Provides the listening IP addresses of the Domain Controlers of which the host is a member * - The :guilabel:`Domain contoller address (host_info/domain_controller_address)` menu item - Provides the Domain controller's address to which the host is attached. * - The :guilabel:`AD DN` menu item - Provides the :abbr:`DN (Distinguished Name)` of the host as the host knows it. * - The :guilabel:`Last logged on user (last_logged_on_user)` menu item - Provides the last user that has logged into the host. * - The :guilabel:`Registration Method (registration_auth_user)` menu item - Provides the name of the user that has registered the host with the WAPT Server. * - The :guilabel:`Repositories (repositories)` menu item - Lists the repositories that the host sees. One can add columns from the Software Inventory by using a drag and drop. You have to refresh the WAPT Console (:kbd:`F5`) to see the additional data. .. figure:: wapt-resources/wapt_console_drag-and-drop-on-host_container-window.gif :align: center :alt: Animation showing the dragging and dropping of inventory items in the WAPT Console grid Animation showing the dragging and dropping of inventory items in the WAPT Console grid .. _detailed_host_actions: *************************************** Acting on the hosts in the WAPT Console *************************************** .. image:: wapt-resources/wapt_console_host-configuration_menu-list.png :align: center :alt: Host configuration menu list in the WAPT Console .. list-table:: Host configuration menu list in the WAPT Console :header-rows: 1 :widths: auto :align: center * - Status - Description - Keyboard shortcut * - The :guilabel:`Edit host` menu item - Allows to :ref:`edit ` the configuration on the selected host(s). - `:kbd:`Ctrl + O` * - The :guilabel:`Check updates` menu item - Allows to :ref:`check for available updates ` for the selected host(s). - :kbd:`Ctrl + U` * - The :guilabel:`Apply upgrades for not running applications` menu item - Allows to :ref:`apply upgrades ` on the selected host(s) **if the software is not being currently used by a user**. - :kbd:`Ctrl + P` * - The :guilabel:`Propose Upgrades to logged on users` menu item - Allows to propose upgrades to currently logged-in users of the selected host(s). **A popup will then appear on the user's terminal allowing the user to trigger or postpone the offered upgrade**. - * - The :guilabel:`Send a message to users` menu item - Allows to send a message to logged-in users of the selected host(s). - :kbd:`Shift + Ctrl + O` * - The :guilabel:`Run packages audit` menu item - Allows to trigger manually a :ref:`compliance audit ` on the selected host(s). - * - The :guilabel:`Add packages to host` menu item - Allows :ref:`to remove a list of WAPT packages ` from the selected host(s). - * - The :guilabel:`Remove package(s) from host(s)` menu item - Allows :ref:`to remove a list of WAPT packages ` from the selected host(s). - * - The :guilabel:`Re-sign host packages` menu item - Allows to :ref:`re-sign the WAPT configuration ` of the selected host(s). - * - The :guilabel:`Add package to host conflicts` menu item - Allows you to prevent a WAPT package from being installed on the selected host(s). - * - The :guilabel:`Remove package from host conflicts` menu item - Allows you to re-authorize a forbidden WAPT package on the selected host(s). - * - The :guilabel:`Remove host` menu item - Allows to remove the selected host(s) from the WAPT Server database. A prompt allows to select between **2** options: #1 To delete the host from the inventory database to remove the host from the inventory data. #2 To delete the host configuration (Package) to delete *host* package data. - :kbd:`Ctrl + Del` * - The :guilabel:`Plugins` menu item - :ref:`Allows to define and run plugins `. - * - The :guilabel:`Connect via RDP` menu item - Allows to open a :abbr:`RDP (Remote Desktop Protocol)` on the selected host. **Note**: by default, there is no incoming port open on WAPT equiped hosts, so it will be necessary to make a special WAPT package to open and secure the inbound port on the host. - * - The :guilabel:`Remote Assistance` menu item - Allows to launch the Windows Remote Assistance utility. - * - The :guilabel:`Mesh remote desktop` menu item - Allows to use `Mesh Commander `_ from the WAPT Console. - :kbd:`Shift + Ctrl + R` * - The :guilabel:`Windows Computer management` menu item - Allows to launch the Windows Remote Management tools from the WAPT Console. **Note**: by default, there is no incoming port open on WAPT equiped hosts, so it will be necessary to make a special WAPT package to open and secure the inbound port on the host. - * - The :guilabel:`Update AD Group Policies on host` menu item - Allows to launch a :command:`gpupdate /force` command on the selected host(s) from the WAPT Console. - * - The :guilabel:`Run CleanMgr on host` menu item - Allows you to remotely trigger the :program:`cleanmgr` tool on the selected host(s). - * - The :guilabel:`Computer management` menu item - Allows to remotely launch :program:`compmgmt.msc` on the selected host. - * - The :guilabel:`Local users and groups management` menu item - Allows to remotely launch :program:`lusrmgr.exe` on the selected host. - * - The :guilabel:`Services management` menu item - Allows to remotely launch :program:`services.msc` on the selected host. - * - The :guilabel:`Power ON with WakeOnLan` menu item - Allows to remotely wake selected host(s) if magic packages are authorized. - * - The :guilabel:`Reboot computers` menu item - Allows to remotely reboot the selected host(s). This feature is disabled by default, see :ref:`Configuring the WAPT Agent ` for enabling the feature. - * - The :guilabel:`Shutdown computers` menu item - Allows to remotely shut down the selected host(s). This feature is disabled by default, see :ref:`Configuring the WAPT Agent ` for enabling the feature. - * - The :guilabel:`Trigger the scan of missing Windows Updates` menu item - Allows you to remotely trigger the scan of for :ref:`missing Windows Updates ` on the selected host(s). - * - The :guilabel:`Trigger the download of pending Windows Updates` menu item - Allows to remotely trigger the download of :ref:`pending Windows Updates ` on the selected host(s). - * - The :guilabel:`Trigger the install of pending Windows Updates` menu item - Allows you to remotely trigger the installation of :ref:`pending Windows Updates ` on the selected host(s). - * - The :guilabel:`Refresh host inventory` menu item - Allows to force the selected host(s) to send their current inventory. - * - The :guilabel:`Trigger a restart of waptservice` menu item - Allows to remotely force the selected host(s) to restart their **WAPT service**. - .. _host_inventory_refresh: ***************************** Refreshing the host inventory ***************************** The :guilabel:`Refresh host inventory` menu option allows you to force selected host(s) to send their current inventory. .. figure:: wapt-resources/wapt_console_host-inventory-refresh_container-window.png :align: center :alt: Window listing hosts currently updating their inventory Window listing hosts currently updating their inventory .. list-table:: Listing of items in the window :header-rows: 1 :widths: auto :align: center * - Column - Description * - The :guilabel:`Host` column - Provides the name of the hosts having pending WAPT updates. * - The :guilabel:`IP` column - Provides the IP of the hosts having pending WAPT updates. * - The :guilabel:`Status` column - Provides the type of pending updates. * - The :guilabel:`status` column - Provides a visual status of the type of pending update. * - The :guilabel:`Message` column - Provides the result message from the update. * - The :guilabel:`Launch update` button - Launches the WAPT updates * - The :guilabel:`Close` button - Closes the window ****************************************************************** Running quick queries on WAPT package properties deployed on hosts ****************************************************************** .. image:: wapt-resources/wapt_console_packages-grid-header_menu-list.png :align: center :alt: WAPT package menu list .. note:: Some columns are not displayed by default, you can select more columns with a right-click on the inventory header. .. list-table:: WAPT package menu list :header-rows: 1 :align: center :widths: auto * - Status - Description * - The :guilabel:`Status (install_status)` menu item - Provides the :ref:`status ` of the WAPT package on the host. * - The :guilabel:`Audit status (last_audit_status)` menu item - Provides the :ref:`last date of the compliance audit `. * - The :guilabel:`Version (version)` menu item - Provides the version of the WAPT package. * - The :guilabel:`Description (description)` menu item - Provides the description of the WAPT package. * - The :guilabel:`Dependencies (depends)` menu item - Lists the dependancies of the WAPT package. * - The :guilabel:`Install date (install_date)` menu item - Provides the install date of the WAPT package. * - The :guilabel:`priority` menu item - **Not used**. * - The :guilabel:`sources (sources)` menu item - Provides the URL for downloading the original software title. * - The :guilabel:`Installed by (explicit_by)` menu item - Provides the user who has installed the package on the host. * - The :guilabel:`Section (section)` menu item - Provides the :ref:`type ` of WAPT package. * - The :guilabel:`Architecture (architecture)` menu item - Provides the CPU architecture for the WAPT package. * - The :guilabel:`Locale (locale)` menu item - Provides the language of the WAPT package. * - The :guilabel:`md5sum (md5sum)` menu item - Provides the md5 sum of the WAPT package. * - The :guilabel:`File name (filename)` menu item - Provides the name of the WAPT package on the WAPT repository. * - The :guilabel:`Parameters (install_params)` menu item - Lists the installation parameters for the WAPT package. * - The :guilabel:`Log install (install_output)` menu item - Provides the installation history of the WAPT package. * - The :guilabel:`maintainer (maintainer)` menu item - Provides the name of the maintainer of the WAPT package. * - The :guilabel:`conflict (conflict)` menu item - Lists the forbidden WAPT packages (packages that need to be uninstalled before the package can install). * - The :guilabel:`Size after install (installed_size)` menu item - Provides the estimated storage occupied by the WAPT package once successfully installed. * - The :guilabel:`URL of repository (repo_url)` menu item - Provides the URL of the repository from which the package has been downloaded. * - The :guilabel:`Size (size)` menu item - Provides the size of the WAPT package in the repository. * - The :guilabel:`Name of repository (repo_url)` menu item - Provides the :abbr:`FQDN (Fully Qualified Domain Name)` of the WAPT repository from which the WAPT package has been downloaded. * - The :guilabel:`Maturity (maturity)` menu item - Provides the level of maturity of the WWAPT package (**DEV**, **PREPROD**, **PROD**). * - The :guilabel:`Audited on` menu item - Provides the date at which the compliance audit of the WAPT package was last run. * - The :guilabel:`Next audit (next_audit_on)` menu item - Provides the date of the next compliance audit for the WAPT package. * - The :guilabel:`uninstall_key (uninstall_key)` menu item - Provides the uninstall key of the software title embedded in the WAPT package. * - The :guilabel:`update_on (update_on)` menu item - Provides the date when the WAPT package update was last updated. * - The :guilabel:`update_by (update_by)` menu item - Provides the user having last updated the WAPT package. * - The :guilabel:`created_on (created_on)` menu item - Provides the date when the WAPT package was first installed on the host. * - The :guilabel:`created_by (created_by)` menu item - Provides the user having first installed the WAPT package. * - The :guilabel:`last_audit_output (last_audit_output)` menu item - Provides the log when the compliance audit of the WAPT package was last run on the host. * - The :guilabel:`id (id)` menu item - Provides the database ID of the WAPT package in the WAPT Agent local :file:`sqlite` file. ********************************* SQL reporting in the WAPT Console ********************************* .. image:: wapt-resources/wapt_console_reporting_menu-list.png :align: center :alt: Menu list for the reporting in the WAPT Console .. list-table:: Menu list for the reporting in the WAPT Console :header-rows: 1 :align: center :widths: auto * - Status - Description - Keyboard shortcut * - The :guilabel:`Execute` menu item - Allows to execute a SQL query in the WAPT Console. - :kbd:`F5` * - The :guilabel:`Edit name` menu item - Allows to rename a SQL query in the WAPT Console. - * - The :guilabel:`Export to spreadsheet` menu item - Allows to export the query result to a spreadheet. - :kbd:`Shift + Ctrl + E` * - The :guilabel:`Export queries to file ...` menu item - Allows to export the selected SQL queries into a file for sharing with others. - * - The :guilabel:`Import queries ...` menu item - Allows to import SQL queries received from other WAPT users. - * - The :guilabel:`Search` menu item - Allows to search text in a SQL query. - :kbd:`Ctrl + F` * - The :guilabel:`Find next` menu item - Allows to find the next occurence of the searched text in a SQL query. - :kbd:`F3` * - The :guilabel:`Copy` menu item - Allows to copy the result of a SQL query as a text file. - :kbd:`Shift + Ctrl + C` * - The :guilabel:`Copy cell` menu item - Allows to copy the content of a cell resulting from having run a SQL query. - :kbd:`Ctrl + V` * - The :guilabel:`Paste` menu item - Allows to paste a copied value into a cell. - :kbd:`Ctrl + Del` * - The :guilabel:`Delete selected rows` menu item - Allows to delete rows in the result of a SQL query. - :kbd:`Ctrl + A` * - The :guilabel:`Select all rows` menu item - Allows to select all rows in the result of a SQL query - * - The :guilabel:`Customize columns` menu item - Allows to customize the column names of the resulting query. - ******************************************************** Using Active Directory OU with WAPT |enterprise_feature| ******************************************************** WAPT Console is not directly connected to Active Directory. The arborescence is built from WAPT Agent inventory information. If the tree structure is not up-to-date, you have to launch a :guilabel:`Check Updates` on a :ref:`client ` or on :ref:`OU `. .. list-table:: Menu list for the Organizational Units in the WAPT Console :header-rows: 1 :align: center :widths: auto * - Status - Description - Keyboard shortcut * - The :guilabel:`Include computers from subfolders` checkbox - This option allows to display all available hosts in :abbr:`OU (Organizational Unit)` folders and subfolders. If not checked, only available hosts in selected :abbr:`OU (Organizational Unit)` will be displayed in the WAPT Console. - * - The :guilabel:`Search OU ...` field - This option allows to search in :abbr:`OU (Organizational Unit)` folders. Filters work with `regular expression `_. - * - The :guilabel:`Create or Edit Organizational Unit package` menu item - This option allows to :ref:`edit or create Unit package `. - * - The :guilabel:`Check updates on all hosts of this OU` menu item - This option allows to :ref:`check updates ` of all the hosts in the :abbr:`OU (Organizational Unit)`. - * - The :guilabel:`Apply upgrades on all hots of this OU` menu item - This option allows to :ref:`apply upgrades ` on all hosts in the :abbr:`OU (Organizational Unit)`. - :kbd:`Ctrl + P` * - The :guilabel:`Propose Upgrades to logged on users` menu item - This option allows to :ref:`propose upgrades ` to users currently loggedinto the hosts of the selected OU. - * - The :guilabel:`Send a message to users` menu item - This option allows to send a HTML formatted message to users currently logged into the hosts of the selected OU. - :kbd:`Shift + Ctrl + M` * - The :guilabel:`Run package audit` menu item - This option force the hosts in the selected OU and sub-OUs to run a compliance audit. - Applying upgrades on all hosts in an Organizational Unit ======================================================== .. image:: wapt-resources/wapt_console_apply-upgrades-ou_menu-item.png :align: center :alt: Menu option to upgrade hosts in the OU This option allows you to :ref:`apply upgrades ` on all hosts in the :abbr:`OU (Organizational Unit)`.