Query – Convert to SQL with Ivanti EPM
Query Convert SQL – Step-by-step guide to Query – Convert to SQL with Ivanti EPM, including configuration, deployment, troubleshooting and practical administration tasks for EPM.
Useful external reference: Ivanti resources.
Query Convert SQL – You may need to create a connector for an external help desk tool such as GLPI.
Useful external reference: Ivanti resources.
Query Convert SQL – In reality, it’s quite simple to achieve!
Useful external reference: Ivanti resources.
- Start by creating a query in LANDESK, displaying all the elements you need in the columns.
- Then, simply inspect your query to obtain the SQL query (which you can then use directly in SQL).
- Go further by creating a view in SQL; start by copying the SQL query. Then launch the SQL console.
- Create a new view in the EPM database (click ‘Close’ on the table selection window).
- Simply paste the SQL query; within a few seconds, SQL will perform the associations, and you can save it.
- This is how to create an SQL view in a few minutes without extensive SQL knowledge.