thinkpad.tailce24ed.ts.net / 127.0.0.1 / ot2 / tb_hardware

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (75 total, Query took 0.0008 seconds.)

SELECT * FROM `tb_hardware`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

			id_hardware	id_clientes	id_clientes_team	num_serie	tipo_de_equipo	marca	modelo	procesador	ram	almacenamiento	sistema_operativo	usuario_asignado	estado	anydesk	rustdesk	teamviewer	usuarios_sis_op	password	notas
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 1	1	250	3	2026554	Desktop	PC	PC	i5	16GB DRR4	SSD HIKSEMI 500GB HDD 500GB	WINDOWS 11 PRO	maricel	Activo	1860861885	434295050	1153660401	NULL	NULL	http://parmavex.co.uk/WinAudit.zip
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 2	2	250	5	NULL	Desktop	NULL	NULL	NULL	NULL	NULL	Windows 11	NULL	Activo	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 3	3	71	8	2026513	Laptop	LENOVO	IDEA PAD 3 15 IML05	I3 10110U	8 GB	240 M.2	WINDOWS 11 HOME	FABIAN	Activo	NULL	NULL	NULL	NULL	NULL	CONTRASEÑA EQUIPO CASA 0469 - TEAMVIEWER 22739769...
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 6	6	2	17	2026427	Desktop	NULL	Rysen 3 2200G	Rysen 3 2200G	8 GB	240 GB	WIN 10 LTSC	NULL	Activo	NULL	NULL	NULL	NULL	NULL	SECRETARIA1 imef2022
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 7	7	2	17	2026434	Desktop	NULL	ATHLON 200GE	ATHLON 200GE	8 Gb	240 SSD	Win 10 LTSC	LUCIANA	Activo	NULL	NULL	NULL	NULL	NULL	SECRETARIA2 imef2022
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 8	8	2	17	2026514	Laptop	LENOVO	G505	NULL	4 GB DDR3 AMPLIALE	120 SSD	WINDOWS 10 PRO	NULL	Activo	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 9	9	2	1	20260765	Desktop	PC	PC	RYZEN 3 2200G	8 FFR4	SSD 240GB	WINDOWS	lu	Activo	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 10	10	254	20	2026516	Laptop	Lenovo	Ideapad S340-15iWL	i5-8265	12 gb	120 gb	w11	NULL	Activo	NULL	NULL	NULL	NULL	NULL	NO SOPORTA MAS MEMORIA
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 11	11	8	21	20260719	Desktop	PC	PC	RYZEN 5 3400G	8GB DDR4	SSD 240GB Y HDD 500GB	WINDOWS 11 PRO	lu	Activo	NULL	259603633	595056037	NULL	hsi123456	PC IZQUIERDA
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 12	12	8	23	2026520	Desktop	pc	pc	AMD A6 7470K	8GB ( 2 MEMORIAS DE 4GB) DDR3	SSD 240GB	WINDOWS 10 LTSC	lu	Activo	1052868839	207380189	595056037	NULL	hsi123456	NULL
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 13	13	265	24	2026720	Desktop	PC	PC	AMD A6-7400K R	8GB DDR3	SSD 240GB	WINDOWS 10 LTSC	lu	Activo	NULL	NULL	NULL	NULL	hsi123456	NUM REP:RE042
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 14	14	188	27	2026524	Desktop	Clon	NULL	I3-6100 3.7 Ghz	16 GB	447 Gb	Windows 11 Pro	Ariela	Activo	NULL	215679984	550147064	NULL	febrero16	HogarSanRoqueDHL contraseña:febrero16
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 15	15	188	32	NULL	Desktop	Server	NULL	I5-11400 2.6 Ghz	16 Ddr4	Ssd 480 Gb + Hd 1 Tb	W 10 Pro 22H2	Server	Activo	hogarsroqueserver@ad	136 690 214	1 671 234 154	Server	hsi123456	NULL
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 16	16	188	29	2026523	Desktop	Pc	NULL	AMD Athlon 3000G with Radeon	8,00 GB (5,95 GB usable)	112 GB SSD GIGABYTE GP-GSTFS31120GNTD, 932 GB	Windows 10 Pro	Jorge	Activo	815215619	NULL	864 757 460	Hogar-PC02	febrero16	Nombre del dispositivo Ariela Tipo de sistema Sist...
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 17	17	70	35	2026535	Impresora	Hp	Multifunción HP Laser 137fnw	NULL	NULL	NULL	NULL	Monica	Activo	NULL	NULL	NULL	NULL	NULL	Vendida 10/02/26
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 18	18	70	35	2026534	Impresora	Hp	P1005	NULL	NULL	NULL	NULL	Monica	Activo	NULL	NULL	NULL	NULL	NULL	usa toner A285 o 35
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 19	19	254	20	2026522	Laptop	LENOVO	THINKPAD GEN2 E15	I5-1135G7	16GB	240GB m.2	WINDOWS 11 PRO	lu	Activo	NULL	NULL	240876513	NULL	hsi123456	NULL
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 20	20	188	28	2026525	Desktop	PC	PC	AMD AThlon 3000G	8GB	82GB OCUPADO DE 112GB	WINDOWS 10 PRO	lu	Activo	315844710	2509205	NULL	NULL	hsi123456	NOMBRE DEL EQUIPO: JANINA Y NOMBRE DE USUARIO:1
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 21	21	188	36	2026526	Impresora	EPSON	L3150	NULL	NULL	NULL	NULL	lu	Activo	NULL	NULL	NULL	NULL	hsi123456	NULL
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 25	25	188	30	2026530	Desktop	PC	PC	AMD AThlon 3000G	8GB	SSD 112GB HDD 932GB ( 441GB USADOS)	WINDOWS 10 PRO	NULL	Activo	1836415785	NULL	NULL	NULL	NULL	NOMBRE DEL EQUIPO: Vicente NOMBRE DE USUARIO: PC-...
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 26	26	188	30	2026531	Impresora	BROTHER	HL-22	NULL	NULL	NULL	NULL	lu	Activo	NULL	NULL	NULL	NULL	hsi123456	IMPRESORA DE VICENTE
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 27	27	188	30	2026532	Monitor	LG	19M38A	NULL	NULL	NULL	NULL	Lu	Activo	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 28	28	70	35	2026352	Desktop	Pc	Pc	AMD A8-9600	8gb	SSD 240gb	Windows 10 pro	Lu	Activo	782274646	NULL	876906164	NULL	NULL	Nombre del dispositivo: PcCasa Usuario: Mónica
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 29	29	70	35	2026533	Desktop	Pc	Pc	I3-9100F	8gb DDR4	SSD Kingston 224gb	Windows 10 pro	Lu	Activo	430696427	NULL	132590698	NULL	NULL	Nombre del equipo: Pcimef Usuario: User
Edit	Copy	Delete DELETE FROM tb_hardware WHERE `tb_hardware`.`id_hardware` = 30	30	188	29	2026527	Monitor	LG	19A38M	NULL	NULL	NULL	NULL	lu	Activo	NULL	NULL	NULL	NULL	hsi123456	COD DE PRODUCTO: 19M38A-BB.ASJDJSN

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view