You may need to create a connector for an external help desk tool such as GLPI.
In reality, it’s quite simple to achieve!
- Start by creating a query in LANDESK, displaying all the elements you need in the columns.
![LANDESK Query Interface](https://blog.wuibaille.fr/wp-content/uploads/2024/04/queryexterne01.png)
- Then, simply inspect your query to obtain the SQL query (which you can then use directly in SQL).
![Inspecting LANDESK Query](https://blog.wuibaille.fr/wp-content/uploads/2024/04/queryexterne02.png)
- Go further by creating a view in SQL; start by copying the SQL query. Then launch the SQL console.
![SQL Console](https://blog.wuibaille.fr/wp-content/uploads/2024/04/queryexterne03.png)
- Create a new view in the EPM database (click ‘Close’ on the table selection window).
![Creating SQL View](https://blog.wuibaille.fr/wp-content/uploads/2024/04/queryexterne04.png)
- Simply paste the SQL query; within a few seconds, SQL will perform the associations, and you can save it.
![SQL View Ready](https://blog.wuibaille.fr/wp-content/uploads/2024/04/queryexterne05.png)
- This is how to create an SQL view in a few minutes without extensive SQL knowledge.