You can create a LANDESK query, which has the information you want, and export to CSV. If you want to use SQL, then you need a query like the one below. You can add additional columns as needed
select DisplayName, ClientConfigurationName from computer
join landesk on computer.Computer_Idn = landesk.Computer_Idn
As mentioned you can use a query and choose what columns to display. Or you can use Custom Column sets to change what is shown in your display.
Assuming you are using the full windows console then you can just right-click and choose export to csv as below:
If using the web console then the query will shoe the columns you need and you will have an export to CSV option.
Simpler than SQL for most things.
MarXtar Ltd/MarXtar Corporation
LANDESK One Development Partner
The One-Stop Shop for LANDESK Enhancements