Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: glpi »Table: glpi_users
Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Options
Set default





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

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (415 total, Query took 0.0009 seconds.)
SELECT * FROM `glpi_users`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
|
Number of rows:
Filter rows:
Sort by key:
Full texts idnamepasswordphonephone2mobilerealnamefirstnamelocations_idlanguage
see define.php CFG_GLPI[language] array 		use_modelist_limitis_activecommentauths_idauthtypelast_logindate_moddate_syncis_deletedprofiles_identities_idusertitles_idusercategories_iddate_formatnumber_formatnames_formatcsv_delimiteris_ids_visibleuse_flat_dropdowntreeshow_jobs_at_loginpriority_1priority_2priority_3priority_4priority_5priority_6followup_privatetask_privatedefault_requesttypes_idpassword_forget_tokenpassword_forget_token_dateuser_dnregistration_numbershow_count_on_tabsrefresh_ticket_listset_default_techpersonal_tokenpersonal_token_dateapi_tokenapi_token_datecookie_tokencookie_token_datedisplay_count_on_homenotification_to_myselfduedateok_colorduedatewarning_colorduedatecritical_colorduedatewarning_lessduedatecritical_lessduedatewarning_unitduedatecritical_unitdisplay_optionsis_deleted_ldappdffontpicturebegin_dateend_datekeep_devices_when_purging_itemprivatebookmarkorderbackcreatedtask_statelayoutpaletteset_default_requesterlock_autolock_modelock_directunlock_notificationdate_creationhighcontrast_cssplanningssync_fieldgroups_idusers_id_supervisor
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 2
2 granvita $2y$10$hWwx1ey/KFz4FDzozwD5k.wX09z.waUlQjJoF6ksB9k... NULL NULL NULL NULL NULL 1 NULL 0 20 1 NULL 0 1 2024-12-03 10:40:52 2021-01-15 13:30:11 NULL 0 0 0 0 0 1 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL $2y$10$20y1AFn.jcOaVMzg.bm/5OSW/.d52UKgxwHar6.ViP9... 2020-11-16 10:35:46 10 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 3
3 post $2y$10$YDhC0u6kJ5zRjlpa5ima5.FQ.p4zzAcODfkQnZEFfx/... NULL NULL NULL NULL NULL 1 NULL 0 20 1 NULL 0 1 NULL 2021-01-15 13:30:11 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 4
4 oprc $2y$10$2wlIoPKusRROcIMScvkmyOi0Tgr6sdkYJe4eNP4yLt5... NULL NULL NULL NULL NULL 1 NULL 0 20 1 NULL 0 1 2020-07-23 17:09:25 2021-01-15 13:30:11 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL $2y$10$baHle4qW3CLaIFw276CVleEjo9H.aWk5b4tTFuRRtyo... 2020-07-23 17:09:25 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 5
5 userti $2y$10$Qp1K2tlznvfx7njgZovZeeTz8b3.Rj7fkIujFHDf.LX... NULL NULL NULL NULL NULL 1 NULL 0 20 1 NULL 0 1 2020-08-25 08:02:26 2021-01-15 13:30:11 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL $2y$10$T5geeIKQAWQbNBNrAQMbSu8Ic8RIxhtoN4RNJ00rj0g... 2020-08-25 08:02:26 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 6
6 Plugin_FusionInventory 34 NULL NULL NULL NULL Plugin FusionInventory 1 NULL 0 NULL 1 NULL 0 1 NULL 2021-01-15 13:30:11 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2020-05-27 13:26:50 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 7
7 vitor.souza $2y$10$jrWsNEoF6u.LuYD1Ibi.WurDt8fw0uJ2mt7JORE1cax... Souza Vitor 1 NULL 0 NULL 1 0 1 2025-01-09 17:00:12 2024-12-19 16:45:07 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 15175276603 NULL NULL NULL EtQhEqk4AM6JACHiOQJXCn5FSudSzjxR3bCYDXnk 2021-01-14 08:10:12 NULL NULL $2y$10$65xeXN2KmnTsY.UpetZsYuk2Z5DTHSfugeM2Ra3hXCD... 2022-10-31 17:12:48 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL 39/7_602fb82a1cf39.png NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2020-05-27 19:02:42 NULL {"filters":{"ChangeTask":{"color":"#E94A31","displ... NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 8
8 tiago.soares $2y$10$lDnVwHugfO2ojnvCuOblpO45mvJApbn35ddXIUGNzLM... Soares Tiago 1 NULL 0 NULL 1 0 1 2024-02-19 11:51:10 2022-10-18 14:08:34 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 08831802607 NULL NULL NULL 8acmVjqIddB2FnapeS6RLTHJ3f6pldfvnQybltzo 2021-04-28 15:58:27 NULL NULL $2y$10$IDwHVLGC0LJLRy67qUV5N.1mIfDds1A3WxGuFrQKbUM... 2022-10-18 14:08:34 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2020-05-27 19:03:24 NULL NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 9
9 bruno.silva $2y$10$nbTj6cchg/eC59Bn28psgucqrzav1gYicBL5i/qxcYH... Silva Bruno 1 NULL 0 NULL 1 0 1 2024-12-27 10:11:59 2022-08-26 11:54:17 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 14331898601 NULL NULL NULL THeMCv0bzPmncfe05icV0rvrXK0PilbUpRR93fvc 2021-01-14 08:16:19 NULL NULL $2y$10$ehWTL1hTE0w6xgVEuuuKReVgl1HTx127uKCECXjup0D... 2022-08-26 11:54:17 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL lightblue NULL NULL NULL 2020-05-27 19:04:07 NULL {"filters":{"ChangeTask":{"color":"#E94A31","displ... NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 10
10 daniele.vilaca $2y$10$EzdJgc7H0WIfSDNX3Rbl5eUG3i6.3tFQbMQOahdKRYF... Vilaça Daniele 1 NULL 0 NULL 1 0 1 2021-04-22 10:06:10 2021-04-22 08:50:35 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 11495069621 NULL NULL NULL nUW0aQ5bvBotpihoAjcLlu7YgN8CNYqgzxUlipYT 2021-01-18 08:13:21 NULL NULL $2y$10$onj5oxdRnTaHebBGj/JNZOg/hcrhCq5Jkxp4TtRw4YU... 2021-04-22 08:50:35 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL lightblue NULL NULL NULL 2020-05-27 19:04:43 NULL NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 11
11 admin $2y$10$T2CE46dPO9TMiQKLdxsCK.7i/x/radTBZOmHawSPelZ... admin 1 NULL 0 NULL 1 0 1 2020-11-11 14:01:13 2021-01-15 13:30:11 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL $2y$10$UuUDn8P2ooiMiE.hVIUoYeFu2jm518tXv8N9nnBBjKY... 2020-11-11 14:01:13 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2020-05-27 21:56:34 NULL NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 12
12 adriana.gomes NULL NULL NULL NULL Gomes Adriana 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 11:35:09 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 03293817688 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 13
13 alcione.duarte NULL NULL NULL NULL Duarte Alcione 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 10:19:26 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 05136981679 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 14
14 amanda.amaral NULL NULL NULL NULL Amaral Amanda 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 10:19:52 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 10394088697 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 15
15 amanda.anjos NULL NULL NULL NULL dos Anjos Amanda 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 10:20:28 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 13211615652 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 16
16 ana.flavia NULL NULL NULL NULL Flavia Ana 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 10:20:39 NULL 1 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 17
17 ana.chizzotti NULL NULL NULL NULL Chizzotti Ana 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 11:35:29 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 29611281889 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 18
18 aryele.paiva NULL NULL NULL NULL Paiva Aryele 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 10:21:16 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 12442449617 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 19
19 bruno.caetano NULL NULL NULL NULL Caetano Bruno 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 10:21:38 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 12461656606 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 20
20 bruno.teixeira NULL NULL NULL NULL Teixeira Bruno 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 10:22:01 NULL 1 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 21
21 bruno.guimaraes NULL NULL NULL NULL Guimaraes Bruno 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 11:35:58 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 09542219660 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 22
22 barbara.teixeira NULL NULL NULL NULL Teixeira Barbara 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 10:22:29 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 09531876673 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 23
23 campanhas NULL NULL NULL NULL Granvita Campanhas 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 10:22:37 NULL 1 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 24
24 carla.nogueira NULL NULL NULL NULL Nogueira Carla 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 10:22:57 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 05464923632 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 25
25 claret.pereira NULL NULL NULL NULL Pereira Claret 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 10:23:15 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 71068295600 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_users` WHERE `glpi_users`.`id` = 26
26 claudio.campos NULL NULL NULL NULL Torres Campos Claudio 1 NULL 0 NULL 1 NULL 0 0 NULL 2021-02-22 11:36:19 NULL 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 82352810663 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL 0 0
With selected: With selected:
|
|
|
|
Number of rows:
Filter rows:
Sort by key:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport ExportDisplay chart Display chartCreate view Create view