Reciente
`snipeit`.`custom_fieldsets`
`performance_schema`.`socket_summary_by_instance`
`performance_schema`.`file_summary_by_instance`
`snipeit`.`models`
`performance_schema`.`performance_timers`
`information_schema`.`USER_STATISTICS`
`snipeit`.`depreciations`
`phpmyadmin`.`pma__history`
`information_schema`.`SCHEMA_PRIVILEGES`
`mysql`.`time_zone_transition`
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
Ventana de consulta
*
id
name
category_id
created_by
qty
requestable
created_at
updated_at
deleted_at
location_id
purchase_date
purchase_cost
order_number
company_id
min_amt
manufacturer_id
model_number
image
supplier_id
notes
*
id
created_by
accessory_id
assigned_to
created_at
updated_at
note
assigned_type
*
id
created_by
action_type
target_id
target_type
location_id
note
filename
item_type
item_id
expected_checkin
accepted_id
created_at
updated_at
deleted_at
thread_id
company_id
accept_signature
log_meta
action_date
stored_eula
action_source
remote_ip
user_agent
*
id
name
asset_tag
model_id
serial
purchase_date
asset_eol_date
eol_explicit
purchase_cost
order_number
assigned_to
notes
image
created_by
created_at
updated_at
physical
deleted_at
status_id
archived
warranty_months
depreciate
supplier_id
requestable
rtd_location_id
accepted
last_checkout
last_checkin
expected_checkin
company_id
assigned_type
last_audit_date
next_audit_date
location_id
checkin_counter
checkout_counter
requests_counter
byod
_snipeit_memoria_ram_2
_snipeit_procesador_3
_snipeit_disco_duro_4
_snipeit_sistema_operativo_5
_snipeit_anydesk_6
_snipeit_concesionarias_7
*
id
user_id
action_type
asset_id
checkedout_to
location_id
created_at
updated_at
deleted_at
asset_type
note
filename
requested_at
accepted_at
accessory_id
accepted_id
consumable_id
expected_checkin
component_id
*
id
user_id
filename
asset_id
filenotes
created_at
updated_at
deleted_at
*
id
name
tag_color
created_at
updated_at
created_by
deleted_at
eula_text
use_default_eula
require_acceptance
alert_on_response
category_type
checkin_email
image
notes
*
id
checkoutable_type
checkoutable_id
assigned_to_id
qty
signature_filename
note
alert_on_response_id
accepted_at
declined_at
created_at
updated_at
deleted_at
stored_eula
stored_eula_file
*
id
user_id
requestable_id
requestable_type
quantity
created_at
updated_at
canceled_at
fulfilled_at
deleted_at
*
id
name
tag_color
fax
email
phone
created_at
updated_at
image
created_by
notes
*
id
name
category_id
location_id
company_id
created_by
supplier_id
qty
order_number
purchase_date
purchase_cost
model_number
manufacturer_id
created_at
updated_at
deleted_at
min_amt
serial
image
notes
*
id
created_by
assigned_qty
component_id
asset_id
created_at
updated_at
note
*
id
name
category_id
location_id
created_by
supplier_id
qty
requestable
created_at
updated_at
deleted_at
purchase_date
purchase_cost
order_number
company_id
min_amt
model_number
manufacturer_id
item_no
image
notes
*
id
created_by
consumable_id
assigned_to
created_at
updated_at
note
*
id
name
format
element
created_at
updated_at
created_by
field_values
field_encrypted
db_column
help_text
show_in_email
show_in_requestable_list
is_unique
display_in_user_view
auto_add_to_fieldsets
show_in_listview
display_checkin
display_checkout
display_audit
*
id
name
created_at
updated_at
created_by
*
id
custom_field_id
custom_fieldset_id
order
required
*
id
name
tag_color
fax
phone
created_by
company_id
location_id
manager_id
notes
created_at
updated_at
deleted_at
image
*
id
name
months
depreciation_min
depreciation_type
created_at
updated_at
created_by
*
id
name
file_path
filesize
import_type
created_at
updated_at
header_row
first_row
field_map
created_by
*
id
name
created_at
updated_at
created_by
*
id
kit_id
accessory_id
quantity
created_at
updated_at
created_by
*
id
kit_id
consumable_id
quantity
created_at
updated_at
created_by
*
id
kit_id
license_id
quantity
created_at
updated_at
created_by
*
id
kit_id
model_id
quantity
created_at
updated_at
created_by
*
id
name
serial
purchase_date
purchase_cost
order_number
seats
notes
created_by
depreciation_id
created_at
updated_at
deleted_at
license_name
license_email
depreciate
supplier_id
expiration_date
purchase_order
termination_date
maintained
reassignable
company_id
manufacturer_id
category_id
min_amt
*
id
license_id
assigned_to
unreassignable_seat
notes
created_by
created_at
updated_at
deleted_at
asset_id
*
id
name
tag_color
city
state
country
created_at
updated_at
created_by
address
address2
zip
fax
phone
deleted_at
parent_id
currency
ldap_ou
manager_id
image
company_id
notes
*
id
username
remote_ip
user_agent
successful
created_at
updated_at
*
id
asset_id
supplier_id
asset_maintenance_type
name
url
is_warranty
start_date
completion_date
asset_maintenance_time
notes
image
cost
deleted_at
created_at
updated_at
created_by
*
id
name
tag_color
created_at
updated_at
created_by
deleted_at
url
support_url
warranty_lookup_url
support_phone
support_email
image
notes
*
id
migration
batch
*
id
name
model_number
min_amt
manufacturer_id
category_id
require_serial
created_at
updated_at
depreciation_id
created_by
eol
image
deprecated_mac_address
deleted_at
fieldset_id
notes
requestable
*
id
asset_model_id
custom_field_id
default_value
*
id
user_id
client_id
name
scopes
revoked
created_at
updated_at
expires_at
*
id
user_id
client_id
scopes
revoked
expires_at
*
id
user_id
name
secret
provider
redirect
personal_access_client
password_client
revoked
created_at
updated_at
*
id
client_id
created_at
updated_at
*
id
access_token_id
revoked
expires_at
*
email
token
created_at
id
*
id
name
permissions
created_at
updated_at
created_by
notes
*
id
created_by
name
options
deleted_at
created_at
updated_at
*
id
asset_id
user_id
accepted_at
denied_at
notes
created_at
updated_at
*
id
asset_id
user_id
request_code
created_at
updated_at
deleted_at
*
id
nonce
not_valid_after
*
id
created_at
updated_at
created_by
per_page
site_name
qr_code
qr_text
display_asset_name
display_checkout_date
display_eol
auto_increment_assets
auto_increment_prefix
load_remote
logo
header_color
nav_link_color
link_light_color
link_dark_color
alert_email
alerts_enabled
default_eula_text
webhook_endpoint
webhook_channel
webhook_botname
webhook_selected
default_currency
custom_css
brand
ldap_enabled
ldap_server
ldap_uname
ldap_pword
ldap_basedn
ldap_default_group
ldap_filter
ldap_username_field
ldap_lname_field
ldap_fname_field
ldap_display_name
ldap_auth_filter_query
ldap_version
ldap_active_flag
ldap_dept
ldap_emp_num
ldap_email
ldap_phone_field
ldap_mobile
ldap_jobtitle
ldap_manager
ldap_address
ldap_city
ldap_state
ldap_zip
ldap_country
ldap_location
full_multiple_companies_support
scope_locations_fmcs
ldap_server_cert_ignore
locale
week_start
labels_per_page
labels_width
labels_height
labels_pmargin_left
labels_pmargin_right
labels_pmargin_top
labels_pmargin_bottom
labels_display_bgutter
labels_display_sgutter
labels_fontsize
labels_pagewidth
labels_pageheight
labels_display_name
labels_display_serial
labels_display_tag
alt_barcode_enabled
alert_interval
alert_threshold
name_display_format
email_domain
email_format
username_format
is_ad
ad_domain
ldap_port
ldap_tls
zerofill_count
ldap_pw_sync
two_factor_enabled
require_accept_signature
date_display_format
time_display_format
next_auto_tag_base
login_note
thumbnail_max_h
pwd_secure_uncommon
pwd_secure_complexity
pwd_secure_min
audit_interval
audit_warning_days
show_url_in_emails
custom_forgot_pass_url
show_alerts_in_menu
labels_display_company_name
show_archived_in_list
dashboard_message
support_footer
footer_text
modellist_displays
login_remote_user_enabled
login_common_disabled
login_remote_user_custom_logout_url
skin
show_images_in_email
admin_cc_email
admin_cc_always
labels_display_model
privacy_policy_link
version_footer
unique_serial
logo_print_assets
depreciation_method
favicon
default_avatar
email_logo
label_logo
acceptance_pdf_logo
allow_user_skin
show_assigned_assets
login_remote_user_header_name
ad_append_domain
saml_enabled
saml_idp_metadata
saml_attr_mapping_username
saml_forcelogin
saml_slo
saml_sp_x509cert
saml_sp_privatekey
saml_custom_settings
saml_sp_x509certNew
digit_separator
ldap_client_tls_cert
ldap_client_tls_key
dash_chart_type
label2_enable
label2_template
label2_title
label2_asset_logo
label2_1d_type
label2_2d_type
label2_2d_prefix
label2_2d_target
label2_fields
label2_empty_row_count
google_login
google_client_id
google_client_secret
profile_edit
require_checkinout_notes
shortcuts_enabled
due_checkin_days
ldap_invert_active_flag
manager_view_enabled
*
id
name
created_by
created_at
updated_at
deleted_at
deployable
pending
archived
notes
color
show_in_nav
default_label
*
id
name
tag_color
address
address2
city
state
country
phone
fax
email
contact
notes
created_at
updated_at
created_by
deleted_at
zip
url
image
*
sequence
uuid
batch_id
family_hash
should_display_on_index
type
content
created_at
*
entry_uuid
tag
*
tag
*
id
user_id
ip_address
attempts
suspended
banned
last_attempt_at
suspended_at
banned_at
*
id
email
password
permissions
activated
created_by
activation_code
activated_at
last_login
persist_code
reset_password_code
first_name
last_name
display_name
created_at
updated_at
deleted_at
website
country
gravatar
location_id
phone
mobile
jobtitle
manager_id
employee_num
avatar
username
notes
company_id
remember_token
ldap_import
locale
show_in_list
two_factor_secret
two_factor_enrolled
two_factor_optin
department_id
address
city
state
zip
skin
nav_link_color
link_light_color
link_dark_color
remote
start_date
end_date
scim_externalid
autoassign_licenses
vip
enable_sounds
enable_confetti
*
user_id
group_id
created_by
seleccionar tabla
accessories
accessories_checkout
action_logs
assets
asset_logs
asset_uploads
categories
checkout_acceptances
checkout_requests
companies
components
components_assets
consumables
consumables_users
custom_fields
custom_fieldsets
custom_field_custom_fieldset
departments
depreciations
imports
kits
kits_accessories
kits_consumables
kits_licenses
kits_models
licenses
license_seats
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
.
seleccionar columna
Mostrar
criterio
Ordenar
Ascendente
Descendente
Agregar "as"
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Texto
Otra columna
seleccionar tabla
accessories
accessories_checkout
action_logs
assets
asset_logs
asset_uploads
categories
checkout_acceptances
checkout_requests
companies
components
components_assets
consumables
consumables_users
custom_fields
custom_fieldsets
custom_field_custom_fieldset
departments
depreciations
imports
kits
kits_accessories
kits_consumables
kits_licenses
kits_models
licenses
license_seats
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
.
seleccionar columna
seleccionar tabla
accessories
accessories_checkout
action_logs
assets
asset_logs
asset_uploads
categories
checkout_acceptances
checkout_requests
companies
components
components_assets
consumables
consumables_users
custom_fields
custom_fieldsets
custom_field_custom_fieldset
departments
depreciations
imports
kits
kits_accessories
kits_consumables
kits_licenses
kits_models
licenses
license_seats
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
.
seleccionar columna
Mostrar
criterio
Ordenar
Ascendente
Descendente
Agregar "as"
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Texto
Otra columna
seleccionar tabla
accessories
accessories_checkout
action_logs
assets
asset_logs
asset_uploads
categories
checkout_acceptances
checkout_requests
companies
components
components_assets
consumables
consumables_users
custom_fields
custom_fieldsets
custom_field_custom_fieldset
departments
depreciations
imports
kits
kits_accessories
kits_consumables
kits_licenses
kits_models
licenses
license_seats
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
.
seleccionar columna
seleccionar tabla
accessories
accessories_checkout
action_logs
assets
asset_logs
asset_uploads
categories
checkout_acceptances
checkout_requests
companies
components
components_assets
consumables
consumables_users
custom_fields
custom_fieldsets
custom_field_custom_fieldset
departments
depreciations
imports
kits
kits_accessories
kits_consumables
kits_licenses
kits_models
licenses
license_seats
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
.
seleccionar columna
Mostrar
criterio
Ordenar
Ascendente
Descendente
Agregar "as"
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Texto
Otra columna
seleccionar tabla
accessories
accessories_checkout
action_logs
assets
asset_logs
asset_uploads
categories
checkout_acceptances
checkout_requests
companies
components
components_assets
consumables
consumables_users
custom_fields
custom_fieldsets
custom_field_custom_fieldset
departments
depreciations
imports
kits
kits_accessories
kits_consumables
kits_licenses
kits_models
licenses
license_seats
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
.
seleccionar columna
seleccionar tabla
accessories
accessories_checkout
action_logs
assets
asset_logs
asset_uploads
categories
checkout_acceptances
checkout_requests
companies
components
components_assets
consumables
consumables_users
custom_fields
custom_fieldsets
custom_field_custom_fieldset
departments
depreciations
imports
kits
kits_accessories
kits_consumables
kits_licenses
kits_models
licenses
license_seats
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
.
seleccionar columna
Mostrar
criterio
Ordenar
Ascendente
Descendente
Agregar "as"
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Texto
Otra columna
seleccionar tabla
accessories
accessories_checkout
action_logs
assets
asset_logs
asset_uploads
categories
checkout_acceptances
checkout_requests
companies
components
components_assets
consumables
consumables_users
custom_fields
custom_fieldsets
custom_field_custom_fieldset
departments
depreciations
imports
kits
kits_accessories
kits_consumables
kits_licenses
kits_models
licenses
license_seats
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
.
seleccionar columna