Reciente
`performance_schema`.`socket_summary_by_instance`
`snipeit`.`custom_fields`
`performance_schema`.`setup_objects`
`information_schema`.`KEY_COLUMN_USAGE`
`phpmyadmin`.`pma__table_coords`
`information_schema`.`FILES`
`mysql`.`transaction_registry`
`information_schema`.`INNODB_FT_INDEX_TABLE`
`snipeit`.`suppliers`
`mysql`.`global_priv`
Favoritas
No existen tablas favoritas.
Nueva
information_schema
mysql
performance_schema
phpmyadmin
snipeit
test
Panel de navegación
Árbol de navegación
Servidores
Bases de datos
Tablas
Panel de navegación
Cambiar la apariencia del panel de navegación.
Panel de navegación
Mostrar las bases de datos navegación como árbol
En el panel de navegación, reemplaza el árbol de base de datos con un selector
Enlace al panel principal
Enlace con el panel principal resaltando la base de datos o tabla actual.
Mostrar el logo
Mostrar el logo en el panel de navegación.
URL para enlace del logo
URL a la que apuntará el logo en el panel de navegación.
Logo destino del enlace
Abrir la página enlazada en la ventana principal (
principal
) o en una nueva (
nueva
).
main
new
Permitir destacar
Resaltar servidor bajo el cursor.
Cantidad máxima de elementos en el primer nivel
El número de elementos que pueden ser mostrados en cada página en el primer nivel del árbol de navegación.
Número mínimo de elementos para mostrar la caja de filtro
Define el número mínimo de elementos (tablas, vistas, rutinas y eventos) para mostrar un cuadro de filtro.
Tablas recientemente utilizadas
Número máximo de tablas recientemente utilizadas; 0 para desactivar.
Tablas favoritas
Cantidad máxima de tablas favoritas; 0 para desactivar.
Anchura del panel de navegación
Asignar 0 para ocular el panel de navegación.
Árbol de navegación
Personalizar el árbol de navegación.
Árbol de navegación
Cantidad máxima de elementos en una rama
El número de elementos que pueden ser mostrados en cada página del árbol de navegación.
Agrupar elementos en el árbol
Agrupar elementos en el árbol de navegación (determinado por el separador definido abajo en las pestañas superiores de Bases de datos y Tablas).
Activar la expansión del árbol de navegación
Si tendrá la posibilidad de expandir el árbol en el panel de navegación.
Mostrar tablas en árbol
Si se muestran las tablas bajo base de datos en el árbol de navegación
Mostrar vistas en árbol
Si se muestran vistas bajo base de datos en el árbol de navegación
Mostrar funciones en árbol
Si se muestran las funciones bajo la base de datos en el árbol de navegación
Mostrar procedimientos en árbol
Si se muestran los procedimientos bajo la base de datos en el árbol de navegación
Mostrar eventos en árbol
Si se muestran eventos bajo la base de datos en el árbol de navegación
Expandir la base de datos única
Si se debe desglosar automáticamente una base de datos individual en el árbol de navegación.
Servidores
Opciones para visualizar los servidores.
Servidores
Mostrar la selección de servidores
Mostrar la elección de servidor en la parte superior del panel de navegación.
Mostrar los servidores en una lista
Mostrar los servidores en una lista en lugar de una caja desplegable.
Bases de datos
Opciones para visualizar las bases de datos.
Bases de datos
Número mínimo de bases de datos a mostrar en la ventana de filtro de bases de datos
Separador de árbol de base de datos
Cadena que separa bases de datos en diferentes niveles de árbol.
Tablas
Opciones para visualizar las tablas.
Tablas
Destino para el icono de acceso rápido
Estructura
SQL
Buscar
Insertar
Examinar
Objetivo para el segundo icono de acceso rápido
Estructura
SQL
Buscar
Insertar
Examinar
Separador de árbol de tablas
Cadena que separa tablas en diferentes niveles de árbol.
Profundidad máxima del árbol de tablas
Suelte aquí los archivos
Carga SQL (
0
)
x
-
Mostrar los elementos escondidos del árbol de navegación.
Crear vista
¡Pasado este punto, debe tener Javascript activado!
Servidor: 127.0.0.1
Base de datos: snipeit
Estructura
SQL
Buscar
Generar una consulta
(actual)
Exportar
Importar
Operaciones
Privilegios
Rutinas
Eventos
Disparadores
Seguimiento
Diseñador
Columnas centrales
Consola
Limpiar
Historial
Opciones
Favoritos
Depuración SQL
Presione Ctrl+Enter para ejecutar la consulta
Presione Enter para ejecutar la consulta
ascendente
descendente
Orden:
Depuración SQL
Cantidad
Orden de ejecución
Tiempo necesario
Ordenar por:
Consultas grupales
Desagrupar las consultas
Colapsar
Expandir
Mostrar rastro
Ocultar rastro
Cantidad :
Tiempo necesario :
Favoritos
Actualizar
Agregar
Ningún favorito
Agregar favorito
Etiqueta:
Base de datos de destino:
Compartir favorito
OK
Opciones
Definir predeterminado
Siempre expandir mensajes de consultas
Mostrar histórico de consultas al iniciar
Mostrar consulta de navegación actual
Ejecute consultas en Enter e inserte una nueva línea con Shift+Enter. Para que esto sea permanente, consulte la configuración.
Cambiar al tema oscuro
Colapsar
Expandir
Reconsultar
Editar
Explicar
Perfilando
Agregar a favoritos
Falló la consulta
Base de datos :
Fecha y hora la consulta :
Cargando
Editor de ENUM/SET
Crear vista
Consulta multitabla
Consulta por ejemplo
Cambiar al
constructor visual
Búsquedas favoritas guardadas:
Nuevo favorito
Columna:
`accessories`.*
`accessories`.`id`
`accessories`.`name`
`accessories`.`category_id`
`accessories`.`created_by`
`accessories`.`qty`
`accessories`.`requestable`
`accessories`.`created_at`
`accessories`.`updated_at`
`accessories`.`deleted_at`
`accessories`.`location_id`
`accessories`.`purchase_date`
`accessories`.`purchase_cost`
`accessories`.`order_number`
`accessories`.`company_id`
`accessories`.`min_amt`
`accessories`.`manufacturer_id`
`accessories`.`model_number`
`accessories`.`image`
`accessories`.`supplier_id`
`accessories`.`notes`
`accessories_checkout`.*
`accessories_checkout`.`id`
`accessories_checkout`.`created_by`
`accessories_checkout`.`accessory_id`
`accessories_checkout`.`assigned_to`
`accessories_checkout`.`created_at`
`accessories_checkout`.`updated_at`
`accessories_checkout`.`note`
`accessories_checkout`.`assigned_type`
`action_logs`.*
`action_logs`.`id`
`action_logs`.`created_by`
`action_logs`.`action_type`
`action_logs`.`target_id`
`action_logs`.`target_type`
`action_logs`.`location_id`
`action_logs`.`note`
`action_logs`.`filename`
`action_logs`.`item_type`
`action_logs`.`item_id`
`action_logs`.`expected_checkin`
`action_logs`.`accepted_id`
`action_logs`.`created_at`
`action_logs`.`updated_at`
`action_logs`.`deleted_at`
`action_logs`.`thread_id`
`action_logs`.`company_id`
`action_logs`.`accept_signature`
`action_logs`.`log_meta`
`action_logs`.`action_date`
`action_logs`.`stored_eula`
`action_logs`.`action_source`
`action_logs`.`remote_ip`
`action_logs`.`user_agent`
`asset_logs`.*
`asset_logs`.`id`
`asset_logs`.`user_id`
`asset_logs`.`action_type`
`asset_logs`.`asset_id`
`asset_logs`.`checkedout_to`
`asset_logs`.`location_id`
`asset_logs`.`created_at`
`asset_logs`.`updated_at`
`asset_logs`.`deleted_at`
`asset_logs`.`asset_type`
`asset_logs`.`note`
`asset_logs`.`filename`
`asset_logs`.`requested_at`
`asset_logs`.`accepted_at`
`asset_logs`.`accessory_id`
`asset_logs`.`accepted_id`
`asset_logs`.`consumable_id`
`asset_logs`.`expected_checkin`
`asset_logs`.`component_id`
`asset_uploads`.*
`asset_uploads`.`id`
`asset_uploads`.`user_id`
`asset_uploads`.`filename`
`asset_uploads`.`asset_id`
`asset_uploads`.`filenotes`
`asset_uploads`.`created_at`
`asset_uploads`.`updated_at`
`asset_uploads`.`deleted_at`
`assets`.*
`assets`.`id`
`assets`.`name`
`assets`.`asset_tag`
`assets`.`model_id`
`assets`.`serial`
`assets`.`purchase_date`
`assets`.`asset_eol_date`
`assets`.`eol_explicit`
`assets`.`purchase_cost`
`assets`.`order_number`
`assets`.`assigned_to`
`assets`.`notes`
`assets`.`image`
`assets`.`created_by`
`assets`.`created_at`
`assets`.`updated_at`
`assets`.`physical`
`assets`.`deleted_at`
`assets`.`status_id`
`assets`.`archived`
`assets`.`warranty_months`
`assets`.`depreciate`
`assets`.`supplier_id`
`assets`.`requestable`
`assets`.`rtd_location_id`
`assets`.`accepted`
`assets`.`last_checkout`
`assets`.`last_checkin`
`assets`.`expected_checkin`
`assets`.`company_id`
`assets`.`assigned_type`
`assets`.`last_audit_date`
`assets`.`next_audit_date`
`assets`.`location_id`
`assets`.`checkin_counter`
`assets`.`checkout_counter`
`assets`.`requests_counter`
`assets`.`byod`
`assets`.`_snipeit_memoria_ram_2`
`assets`.`_snipeit_procesador_3`
`assets`.`_snipeit_disco_duro_4`
`assets`.`_snipeit_sistema_operativo_5`
`assets`.`_snipeit_anydesk_6`
`assets`.`_snipeit_concesionarias_7`
`categories`.*
`categories`.`id`
`categories`.`name`
`categories`.`tag_color`
`categories`.`created_at`
`categories`.`updated_at`
`categories`.`created_by`
`categories`.`deleted_at`
`categories`.`eula_text`
`categories`.`use_default_eula`
`categories`.`require_acceptance`
`categories`.`alert_on_response`
`categories`.`category_type`
`categories`.`checkin_email`
`categories`.`image`
`categories`.`notes`
`checkout_acceptances`.*
`checkout_acceptances`.`id`
`checkout_acceptances`.`checkoutable_type`
`checkout_acceptances`.`checkoutable_id`
`checkout_acceptances`.`assigned_to_id`
`checkout_acceptances`.`qty`
`checkout_acceptances`.`signature_filename`
`checkout_acceptances`.`note`
`checkout_acceptances`.`alert_on_response_id`
`checkout_acceptances`.`accepted_at`
`checkout_acceptances`.`declined_at`
`checkout_acceptances`.`created_at`
`checkout_acceptances`.`updated_at`
`checkout_acceptances`.`deleted_at`
`checkout_acceptances`.`stored_eula`
`checkout_acceptances`.`stored_eula_file`
`checkout_requests`.*
`checkout_requests`.`id`
`checkout_requests`.`user_id`
`checkout_requests`.`requestable_id`
`checkout_requests`.`requestable_type`
`checkout_requests`.`quantity`
`checkout_requests`.`created_at`
`checkout_requests`.`updated_at`
`checkout_requests`.`canceled_at`
`checkout_requests`.`fulfilled_at`
`checkout_requests`.`deleted_at`
`companies`.*
`companies`.`id`
`companies`.`name`
`companies`.`tag_color`
`companies`.`fax`
`companies`.`email`
`companies`.`phone`
`companies`.`created_at`
`companies`.`updated_at`
`companies`.`image`
`companies`.`created_by`
`companies`.`notes`
`components`.*
`components`.`id`
`components`.`name`
`components`.`category_id`
`components`.`location_id`
`components`.`company_id`
`components`.`created_by`
`components`.`supplier_id`
`components`.`qty`
`components`.`order_number`
`components`.`purchase_date`
`components`.`purchase_cost`
`components`.`model_number`
`components`.`manufacturer_id`
`components`.`created_at`
`components`.`updated_at`
`components`.`deleted_at`
`components`.`min_amt`
`components`.`serial`
`components`.`image`
`components`.`notes`
`components_assets`.*
`components_assets`.`id`
`components_assets`.`created_by`
`components_assets`.`assigned_qty`
`components_assets`.`component_id`
`components_assets`.`asset_id`
`components_assets`.`created_at`
`components_assets`.`updated_at`
`components_assets`.`note`
`consumables`.*
`consumables`.`id`
`consumables`.`name`
`consumables`.`category_id`
`consumables`.`location_id`
`consumables`.`created_by`
`consumables`.`supplier_id`
`consumables`.`qty`
`consumables`.`requestable`
`consumables`.`created_at`
`consumables`.`updated_at`
`consumables`.`deleted_at`
`consumables`.`purchase_date`
`consumables`.`purchase_cost`
`consumables`.`order_number`
`consumables`.`company_id`
`consumables`.`min_amt`
`consumables`.`model_number`
`consumables`.`manufacturer_id`
`consumables`.`item_no`
`consumables`.`image`
`consumables`.`notes`
`consumables_users`.*
`consumables_users`.`id`
`consumables_users`.`created_by`
`consumables_users`.`consumable_id`
`consumables_users`.`assigned_to`
`consumables_users`.`created_at`
`consumables_users`.`updated_at`
`consumables_users`.`note`
`custom_field_custom_fieldset`.*
`custom_field_custom_fieldset`.`id`
`custom_field_custom_fieldset`.`custom_field_id`
`custom_field_custom_fieldset`.`custom_fieldset_id`
`custom_field_custom_fieldset`.`order`
`custom_field_custom_fieldset`.`required`
`custom_fields`.*
`custom_fields`.`id`
`custom_fields`.`name`
`custom_fields`.`format`
`custom_fields`.`element`
`custom_fields`.`created_at`
`custom_fields`.`updated_at`
`custom_fields`.`created_by`
`custom_fields`.`field_values`
`custom_fields`.`field_encrypted`
`custom_fields`.`db_column`
`custom_fields`.`help_text`
`custom_fields`.`show_in_email`
`custom_fields`.`show_in_requestable_list`
`custom_fields`.`is_unique`
`custom_fields`.`display_in_user_view`
`custom_fields`.`auto_add_to_fieldsets`
`custom_fields`.`show_in_listview`
`custom_fields`.`display_checkin`
`custom_fields`.`display_checkout`
`custom_fields`.`display_audit`
`custom_fieldsets`.*
`custom_fieldsets`.`id`
`custom_fieldsets`.`name`
`custom_fieldsets`.`created_at`
`custom_fieldsets`.`updated_at`
`custom_fieldsets`.`created_by`
`departments`.*
`departments`.`id`
`departments`.`name`
`departments`.`tag_color`
`departments`.`fax`
`departments`.`phone`
`departments`.`created_by`
`departments`.`company_id`
`departments`.`location_id`
`departments`.`manager_id`
`departments`.`notes`
`departments`.`created_at`
`departments`.`updated_at`
`departments`.`deleted_at`
`departments`.`image`
`depreciations`.*
`depreciations`.`id`
`depreciations`.`name`
`depreciations`.`months`
`depreciations`.`depreciation_min`
`depreciations`.`depreciation_type`
`depreciations`.`created_at`
`depreciations`.`updated_at`
`depreciations`.`created_by`
`imports`.*
`imports`.`id`
`imports`.`name`
`imports`.`file_path`
`imports`.`filesize`
`imports`.`import_type`
`imports`.`created_at`
`imports`.`updated_at`
`imports`.`header_row`
`imports`.`first_row`
`imports`.`field_map`
`imports`.`created_by`
`kits`.*
`kits`.`id`
`kits`.`name`
`kits`.`created_at`
`kits`.`updated_at`
`kits`.`created_by`
`kits_accessories`.*
`kits_accessories`.`id`
`kits_accessories`.`kit_id`
`kits_accessories`.`accessory_id`
`kits_accessories`.`quantity`
`kits_accessories`.`created_at`
`kits_accessories`.`updated_at`
`kits_accessories`.`created_by`
`kits_consumables`.*
`kits_consumables`.`id`
`kits_consumables`.`kit_id`
`kits_consumables`.`consumable_id`
`kits_consumables`.`quantity`
`kits_consumables`.`created_at`
`kits_consumables`.`updated_at`
`kits_consumables`.`created_by`
`kits_licenses`.*
`kits_licenses`.`id`
`kits_licenses`.`kit_id`
`kits_licenses`.`license_id`
`kits_licenses`.`quantity`
`kits_licenses`.`created_at`
`kits_licenses`.`updated_at`
`kits_licenses`.`created_by`
`kits_models`.*
`kits_models`.`id`
`kits_models`.`kit_id`
`kits_models`.`model_id`
`kits_models`.`quantity`
`kits_models`.`created_at`
`kits_models`.`updated_at`
`kits_models`.`created_by`
`license_seats`.*
`license_seats`.`id`
`license_seats`.`license_id`
`license_seats`.`assigned_to`
`license_seats`.`unreassignable_seat`
`license_seats`.`notes`
`license_seats`.`created_by`
`license_seats`.`created_at`
`license_seats`.`updated_at`
`license_seats`.`deleted_at`
`license_seats`.`asset_id`
`licenses`.*
`licenses`.`id`
`licenses`.`name`
`licenses`.`serial`
`licenses`.`purchase_date`
`licenses`.`purchase_cost`
`licenses`.`order_number`
`licenses`.`seats`
`licenses`.`notes`
`licenses`.`created_by`
`licenses`.`depreciation_id`
`licenses`.`created_at`
`licenses`.`updated_at`
`licenses`.`deleted_at`
`licenses`.`license_name`
`licenses`.`license_email`
`licenses`.`depreciate`
`licenses`.`supplier_id`
`licenses`.`expiration_date`
`licenses`.`purchase_order`
`licenses`.`termination_date`
`licenses`.`maintained`
`licenses`.`reassignable`
`licenses`.`company_id`
`licenses`.`manufacturer_id`
`licenses`.`category_id`
`licenses`.`min_amt`
`locations`.*
`locations`.`id`
`locations`.`name`
`locations`.`tag_color`
`locations`.`city`
`locations`.`state`
`locations`.`country`
`locations`.`created_at`
`locations`.`updated_at`
`locations`.`created_by`
`locations`.`address`
`locations`.`address2`
`locations`.`zip`
`locations`.`fax`
`locations`.`phone`
`locations`.`deleted_at`
`locations`.`parent_id`
`locations`.`currency`
`locations`.`ldap_ou`
`locations`.`manager_id`
`locations`.`image`
`locations`.`company_id`
`locations`.`notes`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`username`
`login_attempts`.`remote_ip`
`login_attempts`.`user_agent`
`login_attempts`.`successful`
`login_attempts`.`created_at`
`login_attempts`.`updated_at`
`maintenances`.*
`maintenances`.`id`
`maintenances`.`asset_id`
`maintenances`.`supplier_id`
`maintenances`.`asset_maintenance_type`
`maintenances`.`name`
`maintenances`.`url`
`maintenances`.`is_warranty`
`maintenances`.`start_date`
`maintenances`.`completion_date`
`maintenances`.`asset_maintenance_time`
`maintenances`.`notes`
`maintenances`.`image`
`maintenances`.`cost`
`maintenances`.`deleted_at`
`maintenances`.`created_at`
`maintenances`.`updated_at`
`maintenances`.`created_by`
`manufacturers`.*
`manufacturers`.`id`
`manufacturers`.`name`
`manufacturers`.`tag_color`
`manufacturers`.`created_at`
`manufacturers`.`updated_at`
`manufacturers`.`created_by`
`manufacturers`.`deleted_at`
`manufacturers`.`url`
`manufacturers`.`support_url`
`manufacturers`.`warranty_lookup_url`
`manufacturers`.`support_phone`
`manufacturers`.`support_email`
`manufacturers`.`image`
`manufacturers`.`notes`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`models`.*
`models`.`id`
`models`.`name`
`models`.`model_number`
`models`.`min_amt`
`models`.`manufacturer_id`
`models`.`category_id`
`models`.`require_serial`
`models`.`created_at`
`models`.`updated_at`
`models`.`depreciation_id`
`models`.`created_by`
`models`.`eol`
`models`.`image`
`models`.`deprecated_mac_address`
`models`.`deleted_at`
`models`.`fieldset_id`
`models`.`notes`
`models`.`requestable`
`models_custom_fields`.*
`models_custom_fields`.`id`
`models_custom_fields`.`asset_model_id`
`models_custom_fields`.`custom_field_id`
`models_custom_fields`.`default_value`
`oauth_access_tokens`.*
`oauth_access_tokens`.`id`
`oauth_access_tokens`.`user_id`
`oauth_access_tokens`.`client_id`
`oauth_access_tokens`.`name`
`oauth_access_tokens`.`scopes`
`oauth_access_tokens`.`revoked`
`oauth_access_tokens`.`created_at`
`oauth_access_tokens`.`updated_at`
`oauth_access_tokens`.`expires_at`
`oauth_auth_codes`.*
`oauth_auth_codes`.`id`
`oauth_auth_codes`.`user_id`
`oauth_auth_codes`.`client_id`
`oauth_auth_codes`.`scopes`
`oauth_auth_codes`.`revoked`
`oauth_auth_codes`.`expires_at`
`oauth_clients`.*
`oauth_clients`.`id`
`oauth_clients`.`user_id`
`oauth_clients`.`name`
`oauth_clients`.`secret`
`oauth_clients`.`provider`
`oauth_clients`.`redirect`
`oauth_clients`.`personal_access_client`
`oauth_clients`.`password_client`
`oauth_clients`.`revoked`
`oauth_clients`.`created_at`
`oauth_clients`.`updated_at`
`oauth_personal_access_clients`.*
`oauth_personal_access_clients`.`id`
`oauth_personal_access_clients`.`client_id`
`oauth_personal_access_clients`.`created_at`
`oauth_personal_access_clients`.`updated_at`
`oauth_refresh_tokens`.*
`oauth_refresh_tokens`.`id`
`oauth_refresh_tokens`.`access_token_id`
`oauth_refresh_tokens`.`revoked`
`oauth_refresh_tokens`.`expires_at`
`password_resets`.*
`password_resets`.`email`
`password_resets`.`token`
`password_resets`.`created_at`
`password_resets`.`id`
`permission_groups`.*
`permission_groups`.`id`
`permission_groups`.`name`
`permission_groups`.`permissions`
`permission_groups`.`created_at`
`permission_groups`.`updated_at`
`permission_groups`.`created_by`
`permission_groups`.`notes`
`report_templates`.*
`report_templates`.`id`
`report_templates`.`created_by`
`report_templates`.`name`
`report_templates`.`options`
`report_templates`.`deleted_at`
`report_templates`.`created_at`
`report_templates`.`updated_at`
`requested_assets`.*
`requested_assets`.`id`
`requested_assets`.`asset_id`
`requested_assets`.`user_id`
`requested_assets`.`accepted_at`
`requested_assets`.`denied_at`
`requested_assets`.`notes`
`requested_assets`.`created_at`
`requested_assets`.`updated_at`
`requests`.*
`requests`.`id`
`requests`.`asset_id`
`requests`.`user_id`
`requests`.`request_code`
`requests`.`created_at`
`requests`.`updated_at`
`requests`.`deleted_at`
`saml_nonces`.*
`saml_nonces`.`id`
`saml_nonces`.`nonce`
`saml_nonces`.`not_valid_after`
`settings`.*
`settings`.`id`
`settings`.`created_at`
`settings`.`updated_at`
`settings`.`created_by`
`settings`.`per_page`
`settings`.`site_name`
`settings`.`qr_code`
`settings`.`qr_text`
`settings`.`display_asset_name`
`settings`.`display_checkout_date`
`settings`.`display_eol`
`settings`.`auto_increment_assets`
`settings`.`auto_increment_prefix`
`settings`.`load_remote`
`settings`.`logo`
`settings`.`header_color`
`settings`.`nav_link_color`
`settings`.`link_light_color`
`settings`.`link_dark_color`
`settings`.`alert_email`
`settings`.`alerts_enabled`
`settings`.`default_eula_text`
`settings`.`webhook_endpoint`
`settings`.`webhook_channel`
`settings`.`webhook_botname`
`settings`.`webhook_selected`
`settings`.`default_currency`
`settings`.`custom_css`
`settings`.`brand`
`settings`.`ldap_enabled`
`settings`.`ldap_server`
`settings`.`ldap_uname`
`settings`.`ldap_pword`
`settings`.`ldap_basedn`
`settings`.`ldap_default_group`
`settings`.`ldap_filter`
`settings`.`ldap_username_field`
`settings`.`ldap_lname_field`
`settings`.`ldap_fname_field`
`settings`.`ldap_display_name`
`settings`.`ldap_auth_filter_query`
`settings`.`ldap_version`
`settings`.`ldap_active_flag`
`settings`.`ldap_dept`
`settings`.`ldap_emp_num`
`settings`.`ldap_email`
`settings`.`ldap_phone_field`
`settings`.`ldap_mobile`
`settings`.`ldap_jobtitle`
`settings`.`ldap_manager`
`settings`.`ldap_address`
`settings`.`ldap_city`
`settings`.`ldap_state`
`settings`.`ldap_zip`
`settings`.`ldap_country`
`settings`.`ldap_location`
`settings`.`full_multiple_companies_support`
`settings`.`scope_locations_fmcs`
`settings`.`ldap_server_cert_ignore`
`settings`.`locale`
`settings`.`week_start`
`settings`.`labels_per_page`
`settings`.`labels_width`
`settings`.`labels_height`
`settings`.`labels_pmargin_left`
`settings`.`labels_pmargin_right`
`settings`.`labels_pmargin_top`
`settings`.`labels_pmargin_bottom`
`settings`.`labels_display_bgutter`
`settings`.`labels_display_sgutter`
`settings`.`labels_fontsize`
`settings`.`labels_pagewidth`
`settings`.`labels_pageheight`
`settings`.`labels_display_name`
`settings`.`labels_display_serial`
`settings`.`labels_display_tag`
`settings`.`alt_barcode_enabled`
`settings`.`alert_interval`
`settings`.`alert_threshold`
`settings`.`name_display_format`
`settings`.`email_domain`
`settings`.`email_format`
`settings`.`username_format`
`settings`.`is_ad`
`settings`.`ad_domain`
`settings`.`ldap_port`
`settings`.`ldap_tls`
`settings`.`zerofill_count`
`settings`.`ldap_pw_sync`
`settings`.`two_factor_enabled`
`settings`.`require_accept_signature`
`settings`.`date_display_format`
`settings`.`time_display_format`
`settings`.`next_auto_tag_base`
`settings`.`login_note`
`settings`.`thumbnail_max_h`
`settings`.`pwd_secure_uncommon`
`settings`.`pwd_secure_complexity`
`settings`.`pwd_secure_min`
`settings`.`audit_interval`
`settings`.`audit_warning_days`
`settings`.`show_url_in_emails`
`settings`.`custom_forgot_pass_url`
`settings`.`show_alerts_in_menu`
`settings`.`labels_display_company_name`
`settings`.`show_archived_in_list`
`settings`.`dashboard_message`
`settings`.`support_footer`
`settings`.`footer_text`
`settings`.`modellist_displays`
`settings`.`login_remote_user_enabled`
`settings`.`login_common_disabled`
`settings`.`login_remote_user_custom_logout_url`
`settings`.`skin`
`settings`.`show_images_in_email`
`settings`.`admin_cc_email`
`settings`.`admin_cc_always`
`settings`.`labels_display_model`
`settings`.`privacy_policy_link`
`settings`.`version_footer`
`settings`.`unique_serial`
`settings`.`logo_print_assets`
`settings`.`depreciation_method`
`settings`.`favicon`
`settings`.`default_avatar`
`settings`.`email_logo`
`settings`.`label_logo`
`settings`.`acceptance_pdf_logo`
`settings`.`allow_user_skin`
`settings`.`show_assigned_assets`
`settings`.`login_remote_user_header_name`
`settings`.`ad_append_domain`
`settings`.`saml_enabled`
`settings`.`saml_idp_metadata`
`settings`.`saml_attr_mapping_username`
`settings`.`saml_forcelogin`
`settings`.`saml_slo`
`settings`.`saml_sp_x509cert`
`settings`.`saml_sp_privatekey`
`settings`.`saml_custom_settings`
`settings`.`saml_sp_x509certNew`
`settings`.`digit_separator`
`settings`.`ldap_client_tls_cert`
`settings`.`ldap_client_tls_key`
`settings`.`dash_chart_type`
`settings`.`label2_enable`
`settings`.`label2_template`
`settings`.`label2_title`
`settings`.`label2_asset_logo`
`settings`.`label2_1d_type`
`settings`.`label2_2d_type`
`settings`.`label2_2d_prefix`
`settings`.`label2_2d_target`
`settings`.`label2_fields`
`settings`.`label2_empty_row_count`
`settings`.`google_login`
`settings`.`google_client_id`
`settings`.`google_client_secret`
`settings`.`profile_edit`
`settings`.`require_checkinout_notes`
`settings`.`shortcuts_enabled`
`settings`.`due_checkin_days`
`settings`.`ldap_invert_active_flag`
`settings`.`manager_view_enabled`
`status_labels`.*
`status_labels`.`id`
`status_labels`.`name`
`status_labels`.`created_by`
`status_labels`.`created_at`
`status_labels`.`updated_at`
`status_labels`.`deleted_at`
`status_labels`.`deployable`
`status_labels`.`pending`
`status_labels`.`archived`
`status_labels`.`notes`
`status_labels`.`color`
`status_labels`.`show_in_nav`
`status_labels`.`default_label`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`tag_color`
`suppliers`.`address`
`suppliers`.`address2`
`suppliers`.`city`
`suppliers`.`state`
`suppliers`.`country`
`suppliers`.`phone`
`suppliers`.`fax`
`suppliers`.`email`
`suppliers`.`contact`
`suppliers`.`notes`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`suppliers`.`created_by`
`suppliers`.`deleted_at`
`suppliers`.`zip`
`suppliers`.`url`
`suppliers`.`image`
`telescope_entries`.*
`telescope_entries`.`sequence`
`telescope_entries`.`uuid`
`telescope_entries`.`batch_id`
`telescope_entries`.`family_hash`
`telescope_entries`.`should_display_on_index`
`telescope_entries`.`type`
`telescope_entries`.`content`
`telescope_entries`.`created_at`
`telescope_entries_tags`.*
`telescope_entries_tags`.`entry_uuid`
`telescope_entries_tags`.`tag`
`telescope_monitoring`.*
`telescope_monitoring`.`tag`
`throttle`.*
`throttle`.`id`
`throttle`.`user_id`
`throttle`.`ip_address`
`throttle`.`attempts`
`throttle`.`suspended`
`throttle`.`banned`
`throttle`.`last_attempt_at`
`throttle`.`suspended_at`
`throttle`.`banned_at`
`users`.*
`users`.`id`
`users`.`email`
`users`.`password`
`users`.`permissions`
`users`.`activated`
`users`.`created_by`
`users`.`activation_code`
`users`.`activated_at`
`users`.`last_login`
`users`.`persist_code`
`users`.`reset_password_code`
`users`.`first_name`
`users`.`last_name`
`users`.`display_name`
`users`.`created_at`
`users`.`updated_at`
`users`.`deleted_at`
`users`.`website`
`users`.`country`
`users`.`gravatar`
`users`.`location_id`
`users`.`phone`
`users`.`mobile`
`users`.`jobtitle`
`users`.`manager_id`
`users`.`employee_num`
`users`.`avatar`
`users`.`username`
`users`.`notes`
`users`.`company_id`
`users`.`remember_token`
`users`.`ldap_import`
`users`.`locale`
`users`.`show_in_list`
`users`.`two_factor_secret`
`users`.`two_factor_enrolled`
`users`.`two_factor_optin`
`users`.`department_id`
`users`.`address`
`users`.`city`
`users`.`state`
`users`.`zip`
`users`.`skin`
`users`.`nav_link_color`
`users`.`link_light_color`
`users`.`link_dark_color`
`users`.`remote`
`users`.`start_date`
`users`.`end_date`
`users`.`scim_externalid`
`users`.`autoassign_licenses`
`users`.`vip`
`users`.`enable_sounds`
`users`.`enable_confetti`
`users_groups`.*
`users_groups`.`user_id`
`users_groups`.`group_id`
`users_groups`.`created_by`
`accessories`.*
`accessories`.`id`
`accessories`.`name`
`accessories`.`category_id`
`accessories`.`created_by`
`accessories`.`qty`
`accessories`.`requestable`
`accessories`.`created_at`
`accessories`.`updated_at`
`accessories`.`deleted_at`
`accessories`.`location_id`
`accessories`.`purchase_date`
`accessories`.`purchase_cost`
`accessories`.`order_number`
`accessories`.`company_id`
`accessories`.`min_amt`
`accessories`.`manufacturer_id`
`accessories`.`model_number`
`accessories`.`image`
`accessories`.`supplier_id`
`accessories`.`notes`
`accessories_checkout`.*
`accessories_checkout`.`id`
`accessories_checkout`.`created_by`
`accessories_checkout`.`accessory_id`
`accessories_checkout`.`assigned_to`
`accessories_checkout`.`created_at`
`accessories_checkout`.`updated_at`
`accessories_checkout`.`note`
`accessories_checkout`.`assigned_type`
`action_logs`.*
`action_logs`.`id`
`action_logs`.`created_by`
`action_logs`.`action_type`
`action_logs`.`target_id`
`action_logs`.`target_type`
`action_logs`.`location_id`
`action_logs`.`note`
`action_logs`.`filename`
`action_logs`.`item_type`
`action_logs`.`item_id`
`action_logs`.`expected_checkin`
`action_logs`.`accepted_id`
`action_logs`.`created_at`
`action_logs`.`updated_at`
`action_logs`.`deleted_at`
`action_logs`.`thread_id`
`action_logs`.`company_id`
`action_logs`.`accept_signature`
`action_logs`.`log_meta`
`action_logs`.`action_date`
`action_logs`.`stored_eula`
`action_logs`.`action_source`
`action_logs`.`remote_ip`
`action_logs`.`user_agent`
`asset_logs`.*
`asset_logs`.`id`
`asset_logs`.`user_id`
`asset_logs`.`action_type`
`asset_logs`.`asset_id`
`asset_logs`.`checkedout_to`
`asset_logs`.`location_id`
`asset_logs`.`created_at`
`asset_logs`.`updated_at`
`asset_logs`.`deleted_at`
`asset_logs`.`asset_type`
`asset_logs`.`note`
`asset_logs`.`filename`
`asset_logs`.`requested_at`
`asset_logs`.`accepted_at`
`asset_logs`.`accessory_id`
`asset_logs`.`accepted_id`
`asset_logs`.`consumable_id`
`asset_logs`.`expected_checkin`
`asset_logs`.`component_id`
`asset_uploads`.*
`asset_uploads`.`id`
`asset_uploads`.`user_id`
`asset_uploads`.`filename`
`asset_uploads`.`asset_id`
`asset_uploads`.`filenotes`
`asset_uploads`.`created_at`
`asset_uploads`.`updated_at`
`asset_uploads`.`deleted_at`
`assets`.*
`assets`.`id`
`assets`.`name`
`assets`.`asset_tag`
`assets`.`model_id`
`assets`.`serial`
`assets`.`purchase_date`
`assets`.`asset_eol_date`
`assets`.`eol_explicit`
`assets`.`purchase_cost`
`assets`.`order_number`
`assets`.`assigned_to`
`assets`.`notes`
`assets`.`image`
`assets`.`created_by`
`assets`.`created_at`
`assets`.`updated_at`
`assets`.`physical`
`assets`.`deleted_at`
`assets`.`status_id`
`assets`.`archived`
`assets`.`warranty_months`
`assets`.`depreciate`
`assets`.`supplier_id`
`assets`.`requestable`
`assets`.`rtd_location_id`
`assets`.`accepted`
`assets`.`last_checkout`
`assets`.`last_checkin`
`assets`.`expected_checkin`
`assets`.`company_id`
`assets`.`assigned_type`
`assets`.`last_audit_date`
`assets`.`next_audit_date`
`assets`.`location_id`
`assets`.`checkin_counter`
`assets`.`checkout_counter`
`assets`.`requests_counter`
`assets`.`byod`
`assets`.`_snipeit_memoria_ram_2`
`assets`.`_snipeit_procesador_3`
`assets`.`_snipeit_disco_duro_4`
`assets`.`_snipeit_sistema_operativo_5`
`assets`.`_snipeit_anydesk_6`
`assets`.`_snipeit_concesionarias_7`
`categories`.*
`categories`.`id`
`categories`.`name`
`categories`.`tag_color`
`categories`.`created_at`
`categories`.`updated_at`
`categories`.`created_by`
`categories`.`deleted_at`
`categories`.`eula_text`
`categories`.`use_default_eula`
`categories`.`require_acceptance`
`categories`.`alert_on_response`
`categories`.`category_type`
`categories`.`checkin_email`
`categories`.`image`
`categories`.`notes`
`checkout_acceptances`.*
`checkout_acceptances`.`id`
`checkout_acceptances`.`checkoutable_type`
`checkout_acceptances`.`checkoutable_id`
`checkout_acceptances`.`assigned_to_id`
`checkout_acceptances`.`qty`
`checkout_acceptances`.`signature_filename`
`checkout_acceptances`.`note`
`checkout_acceptances`.`alert_on_response_id`
`checkout_acceptances`.`accepted_at`
`checkout_acceptances`.`declined_at`
`checkout_acceptances`.`created_at`
`checkout_acceptances`.`updated_at`
`checkout_acceptances`.`deleted_at`
`checkout_acceptances`.`stored_eula`
`checkout_acceptances`.`stored_eula_file`
`checkout_requests`.*
`checkout_requests`.`id`
`checkout_requests`.`user_id`
`checkout_requests`.`requestable_id`
`checkout_requests`.`requestable_type`
`checkout_requests`.`quantity`
`checkout_requests`.`created_at`
`checkout_requests`.`updated_at`
`checkout_requests`.`canceled_at`
`checkout_requests`.`fulfilled_at`
`checkout_requests`.`deleted_at`
`companies`.*
`companies`.`id`
`companies`.`name`
`companies`.`tag_color`
`companies`.`fax`
`companies`.`email`
`companies`.`phone`
`companies`.`created_at`
`companies`.`updated_at`
`companies`.`image`
`companies`.`created_by`
`companies`.`notes`
`components`.*
`components`.`id`
`components`.`name`
`components`.`category_id`
`components`.`location_id`
`components`.`company_id`
`components`.`created_by`
`components`.`supplier_id`
`components`.`qty`
`components`.`order_number`
`components`.`purchase_date`
`components`.`purchase_cost`
`components`.`model_number`
`components`.`manufacturer_id`
`components`.`created_at`
`components`.`updated_at`
`components`.`deleted_at`
`components`.`min_amt`
`components`.`serial`
`components`.`image`
`components`.`notes`
`components_assets`.*
`components_assets`.`id`
`components_assets`.`created_by`
`components_assets`.`assigned_qty`
`components_assets`.`component_id`
`components_assets`.`asset_id`
`components_assets`.`created_at`
`components_assets`.`updated_at`
`components_assets`.`note`
`consumables`.*
`consumables`.`id`
`consumables`.`name`
`consumables`.`category_id`
`consumables`.`location_id`
`consumables`.`created_by`
`consumables`.`supplier_id`
`consumables`.`qty`
`consumables`.`requestable`
`consumables`.`created_at`
`consumables`.`updated_at`
`consumables`.`deleted_at`
`consumables`.`purchase_date`
`consumables`.`purchase_cost`
`consumables`.`order_number`
`consumables`.`company_id`
`consumables`.`min_amt`
`consumables`.`model_number`
`consumables`.`manufacturer_id`
`consumables`.`item_no`
`consumables`.`image`
`consumables`.`notes`
`consumables_users`.*
`consumables_users`.`id`
`consumables_users`.`created_by`
`consumables_users`.`consumable_id`
`consumables_users`.`assigned_to`
`consumables_users`.`created_at`
`consumables_users`.`updated_at`
`consumables_users`.`note`
`custom_field_custom_fieldset`.*
`custom_field_custom_fieldset`.`id`
`custom_field_custom_fieldset`.`custom_field_id`
`custom_field_custom_fieldset`.`custom_fieldset_id`
`custom_field_custom_fieldset`.`order`
`custom_field_custom_fieldset`.`required`
`custom_fields`.*
`custom_fields`.`id`
`custom_fields`.`name`
`custom_fields`.`format`
`custom_fields`.`element`
`custom_fields`.`created_at`
`custom_fields`.`updated_at`
`custom_fields`.`created_by`
`custom_fields`.`field_values`
`custom_fields`.`field_encrypted`
`custom_fields`.`db_column`
`custom_fields`.`help_text`
`custom_fields`.`show_in_email`
`custom_fields`.`show_in_requestable_list`
`custom_fields`.`is_unique`
`custom_fields`.`display_in_user_view`
`custom_fields`.`auto_add_to_fieldsets`
`custom_fields`.`show_in_listview`
`custom_fields`.`display_checkin`
`custom_fields`.`display_checkout`
`custom_fields`.`display_audit`
`custom_fieldsets`.*
`custom_fieldsets`.`id`
`custom_fieldsets`.`name`
`custom_fieldsets`.`created_at`
`custom_fieldsets`.`updated_at`
`custom_fieldsets`.`created_by`
`departments`.*
`departments`.`id`
`departments`.`name`
`departments`.`tag_color`
`departments`.`fax`
`departments`.`phone`
`departments`.`created_by`
`departments`.`company_id`
`departments`.`location_id`
`departments`.`manager_id`
`departments`.`notes`
`departments`.`created_at`
`departments`.`updated_at`
`departments`.`deleted_at`
`departments`.`image`
`depreciations`.*
`depreciations`.`id`
`depreciations`.`name`
`depreciations`.`months`
`depreciations`.`depreciation_min`
`depreciations`.`depreciation_type`
`depreciations`.`created_at`
`depreciations`.`updated_at`
`depreciations`.`created_by`
`imports`.*
`imports`.`id`
`imports`.`name`
`imports`.`file_path`
`imports`.`filesize`
`imports`.`import_type`
`imports`.`created_at`
`imports`.`updated_at`
`imports`.`header_row`
`imports`.`first_row`
`imports`.`field_map`
`imports`.`created_by`
`kits`.*
`kits`.`id`
`kits`.`name`
`kits`.`created_at`
`kits`.`updated_at`
`kits`.`created_by`
`kits_accessories`.*
`kits_accessories`.`id`
`kits_accessories`.`kit_id`
`kits_accessories`.`accessory_id`
`kits_accessories`.`quantity`
`kits_accessories`.`created_at`
`kits_accessories`.`updated_at`
`kits_accessories`.`created_by`
`kits_consumables`.*
`kits_consumables`.`id`
`kits_consumables`.`kit_id`
`kits_consumables`.`consumable_id`
`kits_consumables`.`quantity`
`kits_consumables`.`created_at`
`kits_consumables`.`updated_at`
`kits_consumables`.`created_by`
`kits_licenses`.*
`kits_licenses`.`id`
`kits_licenses`.`kit_id`
`kits_licenses`.`license_id`
`kits_licenses`.`quantity`
`kits_licenses`.`created_at`
`kits_licenses`.`updated_at`
`kits_licenses`.`created_by`
`kits_models`.*
`kits_models`.`id`
`kits_models`.`kit_id`
`kits_models`.`model_id`
`kits_models`.`quantity`
`kits_models`.`created_at`
`kits_models`.`updated_at`
`kits_models`.`created_by`
`license_seats`.*
`license_seats`.`id`
`license_seats`.`license_id`
`license_seats`.`assigned_to`
`license_seats`.`unreassignable_seat`
`license_seats`.`notes`
`license_seats`.`created_by`
`license_seats`.`created_at`
`license_seats`.`updated_at`
`license_seats`.`deleted_at`
`license_seats`.`asset_id`
`licenses`.*
`licenses`.`id`
`licenses`.`name`
`licenses`.`serial`
`licenses`.`purchase_date`
`licenses`.`purchase_cost`
`licenses`.`order_number`
`licenses`.`seats`
`licenses`.`notes`
`licenses`.`created_by`
`licenses`.`depreciation_id`
`licenses`.`created_at`
`licenses`.`updated_at`
`licenses`.`deleted_at`
`licenses`.`license_name`
`licenses`.`license_email`
`licenses`.`depreciate`
`licenses`.`supplier_id`
`licenses`.`expiration_date`
`licenses`.`purchase_order`
`licenses`.`termination_date`
`licenses`.`maintained`
`licenses`.`reassignable`
`licenses`.`company_id`
`licenses`.`manufacturer_id`
`licenses`.`category_id`
`licenses`.`min_amt`
`locations`.*
`locations`.`id`
`locations`.`name`
`locations`.`tag_color`
`locations`.`city`
`locations`.`state`
`locations`.`country`
`locations`.`created_at`
`locations`.`updated_at`
`locations`.`created_by`
`locations`.`address`
`locations`.`address2`
`locations`.`zip`
`locations`.`fax`
`locations`.`phone`
`locations`.`deleted_at`
`locations`.`parent_id`
`locations`.`currency`
`locations`.`ldap_ou`
`locations`.`manager_id`
`locations`.`image`
`locations`.`company_id`
`locations`.`notes`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`username`
`login_attempts`.`remote_ip`
`login_attempts`.`user_agent`
`login_attempts`.`successful`
`login_attempts`.`created_at`
`login_attempts`.`updated_at`
`maintenances`.*
`maintenances`.`id`
`maintenances`.`asset_id`
`maintenances`.`supplier_id`
`maintenances`.`asset_maintenance_type`
`maintenances`.`name`
`maintenances`.`url`
`maintenances`.`is_warranty`
`maintenances`.`start_date`
`maintenances`.`completion_date`
`maintenances`.`asset_maintenance_time`
`maintenances`.`notes`
`maintenances`.`image`
`maintenances`.`cost`
`maintenances`.`deleted_at`
`maintenances`.`created_at`
`maintenances`.`updated_at`
`maintenances`.`created_by`
`manufacturers`.*
`manufacturers`.`id`
`manufacturers`.`name`
`manufacturers`.`tag_color`
`manufacturers`.`created_at`
`manufacturers`.`updated_at`
`manufacturers`.`created_by`
`manufacturers`.`deleted_at`
`manufacturers`.`url`
`manufacturers`.`support_url`
`manufacturers`.`warranty_lookup_url`
`manufacturers`.`support_phone`
`manufacturers`.`support_email`
`manufacturers`.`image`
`manufacturers`.`notes`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`models`.*
`models`.`id`
`models`.`name`
`models`.`model_number`
`models`.`min_amt`
`models`.`manufacturer_id`
`models`.`category_id`
`models`.`require_serial`
`models`.`created_at`
`models`.`updated_at`
`models`.`depreciation_id`
`models`.`created_by`
`models`.`eol`
`models`.`image`
`models`.`deprecated_mac_address`
`models`.`deleted_at`
`models`.`fieldset_id`
`models`.`notes`
`models`.`requestable`
`models_custom_fields`.*
`models_custom_fields`.`id`
`models_custom_fields`.`asset_model_id`
`models_custom_fields`.`custom_field_id`
`models_custom_fields`.`default_value`
`oauth_access_tokens`.*
`oauth_access_tokens`.`id`
`oauth_access_tokens`.`user_id`
`oauth_access_tokens`.`client_id`
`oauth_access_tokens`.`name`
`oauth_access_tokens`.`scopes`
`oauth_access_tokens`.`revoked`
`oauth_access_tokens`.`created_at`
`oauth_access_tokens`.`updated_at`
`oauth_access_tokens`.`expires_at`
`oauth_auth_codes`.*
`oauth_auth_codes`.`id`
`oauth_auth_codes`.`user_id`
`oauth_auth_codes`.`client_id`
`oauth_auth_codes`.`scopes`
`oauth_auth_codes`.`revoked`
`oauth_auth_codes`.`expires_at`
`oauth_clients`.*
`oauth_clients`.`id`
`oauth_clients`.`user_id`
`oauth_clients`.`name`
`oauth_clients`.`secret`
`oauth_clients`.`provider`
`oauth_clients`.`redirect`
`oauth_clients`.`personal_access_client`
`oauth_clients`.`password_client`
`oauth_clients`.`revoked`
`oauth_clients`.`created_at`
`oauth_clients`.`updated_at`
`oauth_personal_access_clients`.*
`oauth_personal_access_clients`.`id`
`oauth_personal_access_clients`.`client_id`
`oauth_personal_access_clients`.`created_at`
`oauth_personal_access_clients`.`updated_at`
`oauth_refresh_tokens`.*
`oauth_refresh_tokens`.`id`
`oauth_refresh_tokens`.`access_token_id`
`oauth_refresh_tokens`.`revoked`
`oauth_refresh_tokens`.`expires_at`
`password_resets`.*
`password_resets`.`email`
`password_resets`.`token`
`password_resets`.`created_at`
`password_resets`.`id`
`permission_groups`.*
`permission_groups`.`id`
`permission_groups`.`name`
`permission_groups`.`permissions`
`permission_groups`.`created_at`
`permission_groups`.`updated_at`
`permission_groups`.`created_by`
`permission_groups`.`notes`
`report_templates`.*
`report_templates`.`id`
`report_templates`.`created_by`
`report_templates`.`name`
`report_templates`.`options`
`report_templates`.`deleted_at`
`report_templates`.`created_at`
`report_templates`.`updated_at`
`requested_assets`.*
`requested_assets`.`id`
`requested_assets`.`asset_id`
`requested_assets`.`user_id`
`requested_assets`.`accepted_at`
`requested_assets`.`denied_at`
`requested_assets`.`notes`
`requested_assets`.`created_at`
`requested_assets`.`updated_at`
`requests`.*
`requests`.`id`
`requests`.`asset_id`
`requests`.`user_id`
`requests`.`request_code`
`requests`.`created_at`
`requests`.`updated_at`
`requests`.`deleted_at`
`saml_nonces`.*
`saml_nonces`.`id`
`saml_nonces`.`nonce`
`saml_nonces`.`not_valid_after`
`settings`.*
`settings`.`id`
`settings`.`created_at`
`settings`.`updated_at`
`settings`.`created_by`
`settings`.`per_page`
`settings`.`site_name`
`settings`.`qr_code`
`settings`.`qr_text`
`settings`.`display_asset_name`
`settings`.`display_checkout_date`
`settings`.`display_eol`
`settings`.`auto_increment_assets`
`settings`.`auto_increment_prefix`
`settings`.`load_remote`
`settings`.`logo`
`settings`.`header_color`
`settings`.`nav_link_color`
`settings`.`link_light_color`
`settings`.`link_dark_color`
`settings`.`alert_email`
`settings`.`alerts_enabled`
`settings`.`default_eula_text`
`settings`.`webhook_endpoint`
`settings`.`webhook_channel`
`settings`.`webhook_botname`
`settings`.`webhook_selected`
`settings`.`default_currency`
`settings`.`custom_css`
`settings`.`brand`
`settings`.`ldap_enabled`
`settings`.`ldap_server`
`settings`.`ldap_uname`
`settings`.`ldap_pword`
`settings`.`ldap_basedn`
`settings`.`ldap_default_group`
`settings`.`ldap_filter`
`settings`.`ldap_username_field`
`settings`.`ldap_lname_field`
`settings`.`ldap_fname_field`
`settings`.`ldap_display_name`
`settings`.`ldap_auth_filter_query`
`settings`.`ldap_version`
`settings`.`ldap_active_flag`
`settings`.`ldap_dept`
`settings`.`ldap_emp_num`
`settings`.`ldap_email`
`settings`.`ldap_phone_field`
`settings`.`ldap_mobile`
`settings`.`ldap_jobtitle`
`settings`.`ldap_manager`
`settings`.`ldap_address`
`settings`.`ldap_city`
`settings`.`ldap_state`
`settings`.`ldap_zip`
`settings`.`ldap_country`
`settings`.`ldap_location`
`settings`.`full_multiple_companies_support`
`settings`.`scope_locations_fmcs`
`settings`.`ldap_server_cert_ignore`
`settings`.`locale`
`settings`.`week_start`
`settings`.`labels_per_page`
`settings`.`labels_width`
`settings`.`labels_height`
`settings`.`labels_pmargin_left`
`settings`.`labels_pmargin_right`
`settings`.`labels_pmargin_top`
`settings`.`labels_pmargin_bottom`
`settings`.`labels_display_bgutter`
`settings`.`labels_display_sgutter`
`settings`.`labels_fontsize`
`settings`.`labels_pagewidth`
`settings`.`labels_pageheight`
`settings`.`labels_display_name`
`settings`.`labels_display_serial`
`settings`.`labels_display_tag`
`settings`.`alt_barcode_enabled`
`settings`.`alert_interval`
`settings`.`alert_threshold`
`settings`.`name_display_format`
`settings`.`email_domain`
`settings`.`email_format`
`settings`.`username_format`
`settings`.`is_ad`
`settings`.`ad_domain`
`settings`.`ldap_port`
`settings`.`ldap_tls`
`settings`.`zerofill_count`
`settings`.`ldap_pw_sync`
`settings`.`two_factor_enabled`
`settings`.`require_accept_signature`
`settings`.`date_display_format`
`settings`.`time_display_format`
`settings`.`next_auto_tag_base`
`settings`.`login_note`
`settings`.`thumbnail_max_h`
`settings`.`pwd_secure_uncommon`
`settings`.`pwd_secure_complexity`
`settings`.`pwd_secure_min`
`settings`.`audit_interval`
`settings`.`audit_warning_days`
`settings`.`show_url_in_emails`
`settings`.`custom_forgot_pass_url`
`settings`.`show_alerts_in_menu`
`settings`.`labels_display_company_name`
`settings`.`show_archived_in_list`
`settings`.`dashboard_message`
`settings`.`support_footer`
`settings`.`footer_text`
`settings`.`modellist_displays`
`settings`.`login_remote_user_enabled`
`settings`.`login_common_disabled`
`settings`.`login_remote_user_custom_logout_url`
`settings`.`skin`
`settings`.`show_images_in_email`
`settings`.`admin_cc_email`
`settings`.`admin_cc_always`
`settings`.`labels_display_model`
`settings`.`privacy_policy_link`
`settings`.`version_footer`
`settings`.`unique_serial`
`settings`.`logo_print_assets`
`settings`.`depreciation_method`
`settings`.`favicon`
`settings`.`default_avatar`
`settings`.`email_logo`
`settings`.`label_logo`
`settings`.`acceptance_pdf_logo`
`settings`.`allow_user_skin`
`settings`.`show_assigned_assets`
`settings`.`login_remote_user_header_name`
`settings`.`ad_append_domain`
`settings`.`saml_enabled`
`settings`.`saml_idp_metadata`
`settings`.`saml_attr_mapping_username`
`settings`.`saml_forcelogin`
`settings`.`saml_slo`
`settings`.`saml_sp_x509cert`
`settings`.`saml_sp_privatekey`
`settings`.`saml_custom_settings`
`settings`.`saml_sp_x509certNew`
`settings`.`digit_separator`
`settings`.`ldap_client_tls_cert`
`settings`.`ldap_client_tls_key`
`settings`.`dash_chart_type`
`settings`.`label2_enable`
`settings`.`label2_template`
`settings`.`label2_title`
`settings`.`label2_asset_logo`
`settings`.`label2_1d_type`
`settings`.`label2_2d_type`
`settings`.`label2_2d_prefix`
`settings`.`label2_2d_target`
`settings`.`label2_fields`
`settings`.`label2_empty_row_count`
`settings`.`google_login`
`settings`.`google_client_id`
`settings`.`google_client_secret`
`settings`.`profile_edit`
`settings`.`require_checkinout_notes`
`settings`.`shortcuts_enabled`
`settings`.`due_checkin_days`
`settings`.`ldap_invert_active_flag`
`settings`.`manager_view_enabled`
`status_labels`.*
`status_labels`.`id`
`status_labels`.`name`
`status_labels`.`created_by`
`status_labels`.`created_at`
`status_labels`.`updated_at`
`status_labels`.`deleted_at`
`status_labels`.`deployable`
`status_labels`.`pending`
`status_labels`.`archived`
`status_labels`.`notes`
`status_labels`.`color`
`status_labels`.`show_in_nav`
`status_labels`.`default_label`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`tag_color`
`suppliers`.`address`
`suppliers`.`address2`
`suppliers`.`city`
`suppliers`.`state`
`suppliers`.`country`
`suppliers`.`phone`
`suppliers`.`fax`
`suppliers`.`email`
`suppliers`.`contact`
`suppliers`.`notes`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`suppliers`.`created_by`
`suppliers`.`deleted_at`
`suppliers`.`zip`
`suppliers`.`url`
`suppliers`.`image`
`telescope_entries`.*
`telescope_entries`.`sequence`
`telescope_entries`.`uuid`
`telescope_entries`.`batch_id`
`telescope_entries`.`family_hash`
`telescope_entries`.`should_display_on_index`
`telescope_entries`.`type`
`telescope_entries`.`content`
`telescope_entries`.`created_at`
`telescope_entries_tags`.*
`telescope_entries_tags`.`entry_uuid`
`telescope_entries_tags`.`tag`
`telescope_monitoring`.*
`telescope_monitoring`.`tag`
`throttle`.*
`throttle`.`id`
`throttle`.`user_id`
`throttle`.`ip_address`
`throttle`.`attempts`
`throttle`.`suspended`
`throttle`.`banned`
`throttle`.`last_attempt_at`
`throttle`.`suspended_at`
`throttle`.`banned_at`
`users`.*
`users`.`id`
`users`.`email`
`users`.`password`
`users`.`permissions`
`users`.`activated`
`users`.`created_by`
`users`.`activation_code`
`users`.`activated_at`
`users`.`last_login`
`users`.`persist_code`
`users`.`reset_password_code`
`users`.`first_name`
`users`.`last_name`
`users`.`display_name`
`users`.`created_at`
`users`.`updated_at`
`users`.`deleted_at`
`users`.`website`
`users`.`country`
`users`.`gravatar`
`users`.`location_id`
`users`.`phone`
`users`.`mobile`
`users`.`jobtitle`
`users`.`manager_id`
`users`.`employee_num`
`users`.`avatar`
`users`.`username`
`users`.`notes`
`users`.`company_id`
`users`.`remember_token`
`users`.`ldap_import`
`users`.`locale`
`users`.`show_in_list`
`users`.`two_factor_secret`
`users`.`two_factor_enrolled`
`users`.`two_factor_optin`
`users`.`department_id`
`users`.`address`
`users`.`city`
`users`.`state`
`users`.`zip`
`users`.`skin`
`users`.`nav_link_color`
`users`.`link_light_color`
`users`.`link_dark_color`
`users`.`remote`
`users`.`start_date`
`users`.`end_date`
`users`.`scim_externalid`
`users`.`autoassign_licenses`
`users`.`vip`
`users`.`enable_sounds`
`users`.`enable_confetti`
`users_groups`.*
`users_groups`.`user_id`
`users_groups`.`group_id`
`users_groups`.`created_by`
`accessories`.*
`accessories`.`id`
`accessories`.`name`
`accessories`.`category_id`
`accessories`.`created_by`
`accessories`.`qty`
`accessories`.`requestable`
`accessories`.`created_at`
`accessories`.`updated_at`
`accessories`.`deleted_at`
`accessories`.`location_id`
`accessories`.`purchase_date`
`accessories`.`purchase_cost`
`accessories`.`order_number`
`accessories`.`company_id`
`accessories`.`min_amt`
`accessories`.`manufacturer_id`
`accessories`.`model_number`
`accessories`.`image`
`accessories`.`supplier_id`
`accessories`.`notes`
`accessories_checkout`.*
`accessories_checkout`.`id`
`accessories_checkout`.`created_by`
`accessories_checkout`.`accessory_id`
`accessories_checkout`.`assigned_to`
`accessories_checkout`.`created_at`
`accessories_checkout`.`updated_at`
`accessories_checkout`.`note`
`accessories_checkout`.`assigned_type`
`action_logs`.*
`action_logs`.`id`
`action_logs`.`created_by`
`action_logs`.`action_type`
`action_logs`.`target_id`
`action_logs`.`target_type`
`action_logs`.`location_id`
`action_logs`.`note`
`action_logs`.`filename`
`action_logs`.`item_type`
`action_logs`.`item_id`
`action_logs`.`expected_checkin`
`action_logs`.`accepted_id`
`action_logs`.`created_at`
`action_logs`.`updated_at`
`action_logs`.`deleted_at`
`action_logs`.`thread_id`
`action_logs`.`company_id`
`action_logs`.`accept_signature`
`action_logs`.`log_meta`
`action_logs`.`action_date`
`action_logs`.`stored_eula`
`action_logs`.`action_source`
`action_logs`.`remote_ip`
`action_logs`.`user_agent`
`asset_logs`.*
`asset_logs`.`id`
`asset_logs`.`user_id`
`asset_logs`.`action_type`
`asset_logs`.`asset_id`
`asset_logs`.`checkedout_to`
`asset_logs`.`location_id`
`asset_logs`.`created_at`
`asset_logs`.`updated_at`
`asset_logs`.`deleted_at`
`asset_logs`.`asset_type`
`asset_logs`.`note`
`asset_logs`.`filename`
`asset_logs`.`requested_at`
`asset_logs`.`accepted_at`
`asset_logs`.`accessory_id`
`asset_logs`.`accepted_id`
`asset_logs`.`consumable_id`
`asset_logs`.`expected_checkin`
`asset_logs`.`component_id`
`asset_uploads`.*
`asset_uploads`.`id`
`asset_uploads`.`user_id`
`asset_uploads`.`filename`
`asset_uploads`.`asset_id`
`asset_uploads`.`filenotes`
`asset_uploads`.`created_at`
`asset_uploads`.`updated_at`
`asset_uploads`.`deleted_at`
`assets`.*
`assets`.`id`
`assets`.`name`
`assets`.`asset_tag`
`assets`.`model_id`
`assets`.`serial`
`assets`.`purchase_date`
`assets`.`asset_eol_date`
`assets`.`eol_explicit`
`assets`.`purchase_cost`
`assets`.`order_number`
`assets`.`assigned_to`
`assets`.`notes`
`assets`.`image`
`assets`.`created_by`
`assets`.`created_at`
`assets`.`updated_at`
`assets`.`physical`
`assets`.`deleted_at`
`assets`.`status_id`
`assets`.`archived`
`assets`.`warranty_months`
`assets`.`depreciate`
`assets`.`supplier_id`
`assets`.`requestable`
`assets`.`rtd_location_id`
`assets`.`accepted`
`assets`.`last_checkout`
`assets`.`last_checkin`
`assets`.`expected_checkin`
`assets`.`company_id`
`assets`.`assigned_type`
`assets`.`last_audit_date`
`assets`.`next_audit_date`
`assets`.`location_id`
`assets`.`checkin_counter`
`assets`.`checkout_counter`
`assets`.`requests_counter`
`assets`.`byod`
`assets`.`_snipeit_memoria_ram_2`
`assets`.`_snipeit_procesador_3`
`assets`.`_snipeit_disco_duro_4`
`assets`.`_snipeit_sistema_operativo_5`
`assets`.`_snipeit_anydesk_6`
`assets`.`_snipeit_concesionarias_7`
`categories`.*
`categories`.`id`
`categories`.`name`
`categories`.`tag_color`
`categories`.`created_at`
`categories`.`updated_at`
`categories`.`created_by`
`categories`.`deleted_at`
`categories`.`eula_text`
`categories`.`use_default_eula`
`categories`.`require_acceptance`
`categories`.`alert_on_response`
`categories`.`category_type`
`categories`.`checkin_email`
`categories`.`image`
`categories`.`notes`
`checkout_acceptances`.*
`checkout_acceptances`.`id`
`checkout_acceptances`.`checkoutable_type`
`checkout_acceptances`.`checkoutable_id`
`checkout_acceptances`.`assigned_to_id`
`checkout_acceptances`.`qty`
`checkout_acceptances`.`signature_filename`
`checkout_acceptances`.`note`
`checkout_acceptances`.`alert_on_response_id`
`checkout_acceptances`.`accepted_at`
`checkout_acceptances`.`declined_at`
`checkout_acceptances`.`created_at`
`checkout_acceptances`.`updated_at`
`checkout_acceptances`.`deleted_at`
`checkout_acceptances`.`stored_eula`
`checkout_acceptances`.`stored_eula_file`
`checkout_requests`.*
`checkout_requests`.`id`
`checkout_requests`.`user_id`
`checkout_requests`.`requestable_id`
`checkout_requests`.`requestable_type`
`checkout_requests`.`quantity`
`checkout_requests`.`created_at`
`checkout_requests`.`updated_at`
`checkout_requests`.`canceled_at`
`checkout_requests`.`fulfilled_at`
`checkout_requests`.`deleted_at`
`companies`.*
`companies`.`id`
`companies`.`name`
`companies`.`tag_color`
`companies`.`fax`
`companies`.`email`
`companies`.`phone`
`companies`.`created_at`
`companies`.`updated_at`
`companies`.`image`
`companies`.`created_by`
`companies`.`notes`
`components`.*
`components`.`id`
`components`.`name`
`components`.`category_id`
`components`.`location_id`
`components`.`company_id`
`components`.`created_by`
`components`.`supplier_id`
`components`.`qty`
`components`.`order_number`
`components`.`purchase_date`
`components`.`purchase_cost`
`components`.`model_number`
`components`.`manufacturer_id`
`components`.`created_at`
`components`.`updated_at`
`components`.`deleted_at`
`components`.`min_amt`
`components`.`serial`
`components`.`image`
`components`.`notes`
`components_assets`.*
`components_assets`.`id`
`components_assets`.`created_by`
`components_assets`.`assigned_qty`
`components_assets`.`component_id`
`components_assets`.`asset_id`
`components_assets`.`created_at`
`components_assets`.`updated_at`
`components_assets`.`note`
`consumables`.*
`consumables`.`id`
`consumables`.`name`
`consumables`.`category_id`
`consumables`.`location_id`
`consumables`.`created_by`
`consumables`.`supplier_id`
`consumables`.`qty`
`consumables`.`requestable`
`consumables`.`created_at`
`consumables`.`updated_at`
`consumables`.`deleted_at`
`consumables`.`purchase_date`
`consumables`.`purchase_cost`
`consumables`.`order_number`
`consumables`.`company_id`
`consumables`.`min_amt`
`consumables`.`model_number`
`consumables`.`manufacturer_id`
`consumables`.`item_no`
`consumables`.`image`
`consumables`.`notes`
`consumables_users`.*
`consumables_users`.`id`
`consumables_users`.`created_by`
`consumables_users`.`consumable_id`
`consumables_users`.`assigned_to`
`consumables_users`.`created_at`
`consumables_users`.`updated_at`
`consumables_users`.`note`
`custom_field_custom_fieldset`.*
`custom_field_custom_fieldset`.`id`
`custom_field_custom_fieldset`.`custom_field_id`
`custom_field_custom_fieldset`.`custom_fieldset_id`
`custom_field_custom_fieldset`.`order`
`custom_field_custom_fieldset`.`required`
`custom_fields`.*
`custom_fields`.`id`
`custom_fields`.`name`
`custom_fields`.`format`
`custom_fields`.`element`
`custom_fields`.`created_at`
`custom_fields`.`updated_at`
`custom_fields`.`created_by`
`custom_fields`.`field_values`
`custom_fields`.`field_encrypted`
`custom_fields`.`db_column`
`custom_fields`.`help_text`
`custom_fields`.`show_in_email`
`custom_fields`.`show_in_requestable_list`
`custom_fields`.`is_unique`
`custom_fields`.`display_in_user_view`
`custom_fields`.`auto_add_to_fieldsets`
`custom_fields`.`show_in_listview`
`custom_fields`.`display_checkin`
`custom_fields`.`display_checkout`
`custom_fields`.`display_audit`
`custom_fieldsets`.*
`custom_fieldsets`.`id`
`custom_fieldsets`.`name`
`custom_fieldsets`.`created_at`
`custom_fieldsets`.`updated_at`
`custom_fieldsets`.`created_by`
`departments`.*
`departments`.`id`
`departments`.`name`
`departments`.`tag_color`
`departments`.`fax`
`departments`.`phone`
`departments`.`created_by`
`departments`.`company_id`
`departments`.`location_id`
`departments`.`manager_id`
`departments`.`notes`
`departments`.`created_at`
`departments`.`updated_at`
`departments`.`deleted_at`
`departments`.`image`
`depreciations`.*
`depreciations`.`id`
`depreciations`.`name`
`depreciations`.`months`
`depreciations`.`depreciation_min`
`depreciations`.`depreciation_type`
`depreciations`.`created_at`
`depreciations`.`updated_at`
`depreciations`.`created_by`
`imports`.*
`imports`.`id`
`imports`.`name`
`imports`.`file_path`
`imports`.`filesize`
`imports`.`import_type`
`imports`.`created_at`
`imports`.`updated_at`
`imports`.`header_row`
`imports`.`first_row`
`imports`.`field_map`
`imports`.`created_by`
`kits`.*
`kits`.`id`
`kits`.`name`
`kits`.`created_at`
`kits`.`updated_at`
`kits`.`created_by`
`kits_accessories`.*
`kits_accessories`.`id`
`kits_accessories`.`kit_id`
`kits_accessories`.`accessory_id`
`kits_accessories`.`quantity`
`kits_accessories`.`created_at`
`kits_accessories`.`updated_at`
`kits_accessories`.`created_by`
`kits_consumables`.*
`kits_consumables`.`id`
`kits_consumables`.`kit_id`
`kits_consumables`.`consumable_id`
`kits_consumables`.`quantity`
`kits_consumables`.`created_at`
`kits_consumables`.`updated_at`
`kits_consumables`.`created_by`
`kits_licenses`.*
`kits_licenses`.`id`
`kits_licenses`.`kit_id`
`kits_licenses`.`license_id`
`kits_licenses`.`quantity`
`kits_licenses`.`created_at`
`kits_licenses`.`updated_at`
`kits_licenses`.`created_by`
`kits_models`.*
`kits_models`.`id`
`kits_models`.`kit_id`
`kits_models`.`model_id`
`kits_models`.`quantity`
`kits_models`.`created_at`
`kits_models`.`updated_at`
`kits_models`.`created_by`
`license_seats`.*
`license_seats`.`id`
`license_seats`.`license_id`
`license_seats`.`assigned_to`
`license_seats`.`unreassignable_seat`
`license_seats`.`notes`
`license_seats`.`created_by`
`license_seats`.`created_at`
`license_seats`.`updated_at`
`license_seats`.`deleted_at`
`license_seats`.`asset_id`
`licenses`.*
`licenses`.`id`
`licenses`.`name`
`licenses`.`serial`
`licenses`.`purchase_date`
`licenses`.`purchase_cost`
`licenses`.`order_number`
`licenses`.`seats`
`licenses`.`notes`
`licenses`.`created_by`
`licenses`.`depreciation_id`
`licenses`.`created_at`
`licenses`.`updated_at`
`licenses`.`deleted_at`
`licenses`.`license_name`
`licenses`.`license_email`
`licenses`.`depreciate`
`licenses`.`supplier_id`
`licenses`.`expiration_date`
`licenses`.`purchase_order`
`licenses`.`termination_date`
`licenses`.`maintained`
`licenses`.`reassignable`
`licenses`.`company_id`
`licenses`.`manufacturer_id`
`licenses`.`category_id`
`licenses`.`min_amt`
`locations`.*
`locations`.`id`
`locations`.`name`
`locations`.`tag_color`
`locations`.`city`
`locations`.`state`
`locations`.`country`
`locations`.`created_at`
`locations`.`updated_at`
`locations`.`created_by`
`locations`.`address`
`locations`.`address2`
`locations`.`zip`
`locations`.`fax`
`locations`.`phone`
`locations`.`deleted_at`
`locations`.`parent_id`
`locations`.`currency`
`locations`.`ldap_ou`
`locations`.`manager_id`
`locations`.`image`
`locations`.`company_id`
`locations`.`notes`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`username`
`login_attempts`.`remote_ip`
`login_attempts`.`user_agent`
`login_attempts`.`successful`
`login_attempts`.`created_at`
`login_attempts`.`updated_at`
`maintenances`.*
`maintenances`.`id`
`maintenances`.`asset_id`
`maintenances`.`supplier_id`
`maintenances`.`asset_maintenance_type`
`maintenances`.`name`
`maintenances`.`url`
`maintenances`.`is_warranty`
`maintenances`.`start_date`
`maintenances`.`completion_date`
`maintenances`.`asset_maintenance_time`
`maintenances`.`notes`
`maintenances`.`image`
`maintenances`.`cost`
`maintenances`.`deleted_at`
`maintenances`.`created_at`
`maintenances`.`updated_at`
`maintenances`.`created_by`
`manufacturers`.*
`manufacturers`.`id`
`manufacturers`.`name`
`manufacturers`.`tag_color`
`manufacturers`.`created_at`
`manufacturers`.`updated_at`
`manufacturers`.`created_by`
`manufacturers`.`deleted_at`
`manufacturers`.`url`
`manufacturers`.`support_url`
`manufacturers`.`warranty_lookup_url`
`manufacturers`.`support_phone`
`manufacturers`.`support_email`
`manufacturers`.`image`
`manufacturers`.`notes`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`models`.*
`models`.`id`
`models`.`name`
`models`.`model_number`
`models`.`min_amt`
`models`.`manufacturer_id`
`models`.`category_id`
`models`.`require_serial`
`models`.`created_at`
`models`.`updated_at`
`models`.`depreciation_id`
`models`.`created_by`
`models`.`eol`
`models`.`image`
`models`.`deprecated_mac_address`
`models`.`deleted_at`
`models`.`fieldset_id`
`models`.`notes`
`models`.`requestable`
`models_custom_fields`.*
`models_custom_fields`.`id`
`models_custom_fields`.`asset_model_id`
`models_custom_fields`.`custom_field_id`
`models_custom_fields`.`default_value`
`oauth_access_tokens`.*
`oauth_access_tokens`.`id`
`oauth_access_tokens`.`user_id`
`oauth_access_tokens`.`client_id`
`oauth_access_tokens`.`name`
`oauth_access_tokens`.`scopes`
`oauth_access_tokens`.`revoked`
`oauth_access_tokens`.`created_at`
`oauth_access_tokens`.`updated_at`
`oauth_access_tokens`.`expires_at`
`oauth_auth_codes`.*
`oauth_auth_codes`.`id`
`oauth_auth_codes`.`user_id`
`oauth_auth_codes`.`client_id`
`oauth_auth_codes`.`scopes`
`oauth_auth_codes`.`revoked`
`oauth_auth_codes`.`expires_at`
`oauth_clients`.*
`oauth_clients`.`id`
`oauth_clients`.`user_id`
`oauth_clients`.`name`
`oauth_clients`.`secret`
`oauth_clients`.`provider`
`oauth_clients`.`redirect`
`oauth_clients`.`personal_access_client`
`oauth_clients`.`password_client`
`oauth_clients`.`revoked`
`oauth_clients`.`created_at`
`oauth_clients`.`updated_at`
`oauth_personal_access_clients`.*
`oauth_personal_access_clients`.`id`
`oauth_personal_access_clients`.`client_id`
`oauth_personal_access_clients`.`created_at`
`oauth_personal_access_clients`.`updated_at`
`oauth_refresh_tokens`.*
`oauth_refresh_tokens`.`id`
`oauth_refresh_tokens`.`access_token_id`
`oauth_refresh_tokens`.`revoked`
`oauth_refresh_tokens`.`expires_at`
`password_resets`.*
`password_resets`.`email`
`password_resets`.`token`
`password_resets`.`created_at`
`password_resets`.`id`
`permission_groups`.*
`permission_groups`.`id`
`permission_groups`.`name`
`permission_groups`.`permissions`
`permission_groups`.`created_at`
`permission_groups`.`updated_at`
`permission_groups`.`created_by`
`permission_groups`.`notes`
`report_templates`.*
`report_templates`.`id`
`report_templates`.`created_by`
`report_templates`.`name`
`report_templates`.`options`
`report_templates`.`deleted_at`
`report_templates`.`created_at`
`report_templates`.`updated_at`
`requested_assets`.*
`requested_assets`.`id`
`requested_assets`.`asset_id`
`requested_assets`.`user_id`
`requested_assets`.`accepted_at`
`requested_assets`.`denied_at`
`requested_assets`.`notes`
`requested_assets`.`created_at`
`requested_assets`.`updated_at`
`requests`.*
`requests`.`id`
`requests`.`asset_id`
`requests`.`user_id`
`requests`.`request_code`
`requests`.`created_at`
`requests`.`updated_at`
`requests`.`deleted_at`
`saml_nonces`.*
`saml_nonces`.`id`
`saml_nonces`.`nonce`
`saml_nonces`.`not_valid_after`
`settings`.*
`settings`.`id`
`settings`.`created_at`
`settings`.`updated_at`
`settings`.`created_by`
`settings`.`per_page`
`settings`.`site_name`
`settings`.`qr_code`
`settings`.`qr_text`
`settings`.`display_asset_name`
`settings`.`display_checkout_date`
`settings`.`display_eol`
`settings`.`auto_increment_assets`
`settings`.`auto_increment_prefix`
`settings`.`load_remote`
`settings`.`logo`
`settings`.`header_color`
`settings`.`nav_link_color`
`settings`.`link_light_color`
`settings`.`link_dark_color`
`settings`.`alert_email`
`settings`.`alerts_enabled`
`settings`.`default_eula_text`
`settings`.`webhook_endpoint`
`settings`.`webhook_channel`
`settings`.`webhook_botname`
`settings`.`webhook_selected`
`settings`.`default_currency`
`settings`.`custom_css`
`settings`.`brand`
`settings`.`ldap_enabled`
`settings`.`ldap_server`
`settings`.`ldap_uname`
`settings`.`ldap_pword`
`settings`.`ldap_basedn`
`settings`.`ldap_default_group`
`settings`.`ldap_filter`
`settings`.`ldap_username_field`
`settings`.`ldap_lname_field`
`settings`.`ldap_fname_field`
`settings`.`ldap_display_name`
`settings`.`ldap_auth_filter_query`
`settings`.`ldap_version`
`settings`.`ldap_active_flag`
`settings`.`ldap_dept`
`settings`.`ldap_emp_num`
`settings`.`ldap_email`
`settings`.`ldap_phone_field`
`settings`.`ldap_mobile`
`settings`.`ldap_jobtitle`
`settings`.`ldap_manager`
`settings`.`ldap_address`
`settings`.`ldap_city`
`settings`.`ldap_state`
`settings`.`ldap_zip`
`settings`.`ldap_country`
`settings`.`ldap_location`
`settings`.`full_multiple_companies_support`
`settings`.`scope_locations_fmcs`
`settings`.`ldap_server_cert_ignore`
`settings`.`locale`
`settings`.`week_start`
`settings`.`labels_per_page`
`settings`.`labels_width`
`settings`.`labels_height`
`settings`.`labels_pmargin_left`
`settings`.`labels_pmargin_right`
`settings`.`labels_pmargin_top`
`settings`.`labels_pmargin_bottom`
`settings`.`labels_display_bgutter`
`settings`.`labels_display_sgutter`
`settings`.`labels_fontsize`
`settings`.`labels_pagewidth`
`settings`.`labels_pageheight`
`settings`.`labels_display_name`
`settings`.`labels_display_serial`
`settings`.`labels_display_tag`
`settings`.`alt_barcode_enabled`
`settings`.`alert_interval`
`settings`.`alert_threshold`
`settings`.`name_display_format`
`settings`.`email_domain`
`settings`.`email_format`
`settings`.`username_format`
`settings`.`is_ad`
`settings`.`ad_domain`
`settings`.`ldap_port`
`settings`.`ldap_tls`
`settings`.`zerofill_count`
`settings`.`ldap_pw_sync`
`settings`.`two_factor_enabled`
`settings`.`require_accept_signature`
`settings`.`date_display_format`
`settings`.`time_display_format`
`settings`.`next_auto_tag_base`
`settings`.`login_note`
`settings`.`thumbnail_max_h`
`settings`.`pwd_secure_uncommon`
`settings`.`pwd_secure_complexity`
`settings`.`pwd_secure_min`
`settings`.`audit_interval`
`settings`.`audit_warning_days`
`settings`.`show_url_in_emails`
`settings`.`custom_forgot_pass_url`
`settings`.`show_alerts_in_menu`
`settings`.`labels_display_company_name`
`settings`.`show_archived_in_list`
`settings`.`dashboard_message`
`settings`.`support_footer`
`settings`.`footer_text`
`settings`.`modellist_displays`
`settings`.`login_remote_user_enabled`
`settings`.`login_common_disabled`
`settings`.`login_remote_user_custom_logout_url`
`settings`.`skin`
`settings`.`show_images_in_email`
`settings`.`admin_cc_email`
`settings`.`admin_cc_always`
`settings`.`labels_display_model`
`settings`.`privacy_policy_link`
`settings`.`version_footer`
`settings`.`unique_serial`
`settings`.`logo_print_assets`
`settings`.`depreciation_method`
`settings`.`favicon`
`settings`.`default_avatar`
`settings`.`email_logo`
`settings`.`label_logo`
`settings`.`acceptance_pdf_logo`
`settings`.`allow_user_skin`
`settings`.`show_assigned_assets`
`settings`.`login_remote_user_header_name`
`settings`.`ad_append_domain`
`settings`.`saml_enabled`
`settings`.`saml_idp_metadata`
`settings`.`saml_attr_mapping_username`
`settings`.`saml_forcelogin`
`settings`.`saml_slo`
`settings`.`saml_sp_x509cert`
`settings`.`saml_sp_privatekey`
`settings`.`saml_custom_settings`
`settings`.`saml_sp_x509certNew`
`settings`.`digit_separator`
`settings`.`ldap_client_tls_cert`
`settings`.`ldap_client_tls_key`
`settings`.`dash_chart_type`
`settings`.`label2_enable`
`settings`.`label2_template`
`settings`.`label2_title`
`settings`.`label2_asset_logo`
`settings`.`label2_1d_type`
`settings`.`label2_2d_type`
`settings`.`label2_2d_prefix`
`settings`.`label2_2d_target`
`settings`.`label2_fields`
`settings`.`label2_empty_row_count`
`settings`.`google_login`
`settings`.`google_client_id`
`settings`.`google_client_secret`
`settings`.`profile_edit`
`settings`.`require_checkinout_notes`
`settings`.`shortcuts_enabled`
`settings`.`due_checkin_days`
`settings`.`ldap_invert_active_flag`
`settings`.`manager_view_enabled`
`status_labels`.*
`status_labels`.`id`
`status_labels`.`name`
`status_labels`.`created_by`
`status_labels`.`created_at`
`status_labels`.`updated_at`
`status_labels`.`deleted_at`
`status_labels`.`deployable`
`status_labels`.`pending`
`status_labels`.`archived`
`status_labels`.`notes`
`status_labels`.`color`
`status_labels`.`show_in_nav`
`status_labels`.`default_label`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`name`
`suppliers`.`tag_color`
`suppliers`.`address`
`suppliers`.`address2`
`suppliers`.`city`
`suppliers`.`state`
`suppliers`.`country`
`suppliers`.`phone`
`suppliers`.`fax`
`suppliers`.`email`
`suppliers`.`contact`
`suppliers`.`notes`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`suppliers`.`created_by`
`suppliers`.`deleted_at`
`suppliers`.`zip`
`suppliers`.`url`
`suppliers`.`image`
`telescope_entries`.*
`telescope_entries`.`sequence`
`telescope_entries`.`uuid`
`telescope_entries`.`batch_id`
`telescope_entries`.`family_hash`
`telescope_entries`.`should_display_on_index`
`telescope_entries`.`type`
`telescope_entries`.`content`
`telescope_entries`.`created_at`
`telescope_entries_tags`.*
`telescope_entries_tags`.`entry_uuid`
`telescope_entries_tags`.`tag`
`telescope_monitoring`.*
`telescope_monitoring`.`tag`
`throttle`.*
`throttle`.`id`
`throttle`.`user_id`
`throttle`.`ip_address`
`throttle`.`attempts`
`throttle`.`suspended`
`throttle`.`banned`
`throttle`.`last_attempt_at`
`throttle`.`suspended_at`
`throttle`.`banned_at`
`users`.*
`users`.`id`
`users`.`email`
`users`.`password`
`users`.`permissions`
`users`.`activated`
`users`.`created_by`
`users`.`activation_code`
`users`.`activated_at`
`users`.`last_login`
`users`.`persist_code`
`users`.`reset_password_code`
`users`.`first_name`
`users`.`last_name`
`users`.`display_name`
`users`.`created_at`
`users`.`updated_at`
`users`.`deleted_at`
`users`.`website`
`users`.`country`
`users`.`gravatar`
`users`.`location_id`
`users`.`phone`
`users`.`mobile`
`users`.`jobtitle`
`users`.`manager_id`
`users`.`employee_num`
`users`.`avatar`
`users`.`username`
`users`.`notes`
`users`.`company_id`
`users`.`remember_token`
`users`.`ldap_import`
`users`.`locale`
`users`.`show_in_list`
`users`.`two_factor_secret`
`users`.`two_factor_enrolled`
`users`.`two_factor_optin`
`users`.`department_id`
`users`.`address`
`users`.`city`
`users`.`state`
`users`.`zip`
`users`.`skin`
`users`.`nav_link_color`
`users`.`link_light_color`
`users`.`link_dark_color`
`users`.`remote`
`users`.`start_date`
`users`.`end_date`
`users`.`scim_externalid`
`users`.`autoassign_licenses`
`users`.`vip`
`users`.`enable_sounds`
`users`.`enable_confetti`
`users_groups`.*
`users_groups`.`user_id`
`users_groups`.`group_id`
`users_groups`.`created_by`
Alias:
Mostrar:
Ordenar:
Ascendente
Descendente
Ascendente
Descendente
Ascendente
Descendente
Orden de clasificación:
1
2
3
1
2
3
1
2
3
Criterio:
Agregar:
Y:
Borrar:
O:
Modificar:
O:
Y:
Insertar
Borrar
O:
Y:
Insertar
Borrar
Insertar
Borrar
Añadir/Eliminar filas de criterio:
-3
-2
-1
0
1
2
3
Añadir/Eliminar columnas:
-3
-2
-1
0
1
2
3
Usar tablas
accessories
accessories_checkout
action_logs
asset_logs
asset_uploads
assets
categories
checkout_acceptances
checkout_requests
companies
components
components_assets
consumables
consumables_users
custom_field_custom_fieldset
custom_fields
custom_fieldsets
departments
depreciations
imports
kits
kits_accessories
kits_consumables
kits_licenses
kits_models
license_seats
licenses
locations
login_attempts
maintenances
manufacturers
migrations
models
models_custom_fields
oauth_access_tokens
oauth_auth_codes
oauth_clients
oauth_personal_access_clients
oauth_refresh_tokens
password_resets
permission_groups
report_templates
requested_assets
requests
saml_nonces
settings
status_labels
suppliers
telescope_entries
telescope_entries_tags
telescope_monitoring
throttle
users
users_groups
Consulta a la base de datos
snipeit
: