mysql database
We need to run a query to extract some lookup data from our ServiceDesk MySQL database but I'm not able to find the table that stores the data.
The data we need is the information displayed in ServiceDesk Plus in the Configuration Wizard -> Asset Management - Product -> Product List.
We'd like to be able to run a query against the MySQL database to get these same results so we can export this as a csv file and use it to build another csv file with assets to import back into the Assets area.
Can you provide the database schema information or the query to pull this information?
The data we need is the information displayed in ServiceDesk Plus in the Configuration Wizard -> Asset Management - Product -> Product List.
We'd like to be able to run a query against the MySQL database to get these same results so we can export this as a csv file and use it to build another csv file with assets to import back into the Assets area.
Can you provide the database schema information or the query to pull this information?