Export Solutions

To export solutions to pdf, XLS use the below queries,

 

For PGSQL,

SELECT Solution.solutionid “SolutionId”, KB_Topics.TOPICNAME “Topic”,Solution.TITLE “Subject”, Solution.DESCRIPTION “Contents”, Creator.FIRST_NAME

“Created By”, longtodate(SolutionInfo.CREATEDTIME) “Created Time”, Updater.FIRST_NAME “Last Modified By”,longtodate(SolutionInfo.LASTUPDATEDTIME)

“Last Modified Time”, Sol_StatusDefinition.STATUSNAME “Status” FROM Solution INNER JOIN SolutionInfo ON Solution.SOLUTIONID=SolutionInfo.SOLUTIONID

LEFT JOIN KB_Topics ON Solution.TOPICID=KB_Topics.TOPICID LEFT JOIN SolutionCreationInfo ON

SolutionInfo.SOLUTIONID=SolutionCreationInfo.SOLUTIONID LEFT

JOIN SolutionUpdationInfo ON SolutionInfo.SOLUTIONID=SolutionUpdationInfo.SOLUTIONID LEFT JOIN AaaUser Updater ON

SolutionUpdationInfo.LASTUPDATEDBY=Updater.USER_ID LEFT JOIN AaaUser Creator ON SolutionCreationInfo.CREATEDBY=Creator.USER_ID LEFT JOIN

Solution_Keywords ON Solution.SOLUTIONID=Solution_Keywords.SOLUTIONID LEFT JOIN Sol_StatusDefinition ON

Solution.STATUSID=Sol_StatusDefinition.STATUSID

 

For MSSQL,

 

SELECT solution.solutionid’Solution Id’,KB_Topics.TOPICNAME ‘Category / Topic’,Solution.TITLE ‘Subject / Title’,Solution.DESCRIPTION ‘Contents’,Creator.FIRST_NAME ‘Created By’,dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (SolutionInfo.CREATEDTIME/1000),’1970-01-01 00:00:00′) ‘Created Time’,Updater.FIRST_NAME ‘Last Modified By’,dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (SolutionInfo.LASTUPDATEDTIME/1000),’1970-01-01 00:00:00′) ‘Last Modified Time’,Sol_StatusDefinition.STATUSNAME ‘Status’ FROM Solution INNER JOIN SolutionInfo ON Solution.SOLUTIONID=SolutionInfo.SOLUTIONID LEFT JOIN KB_Topics ON Solution.TOPICID=KB_Topics.TOPICID LEFT JOIN SolutionCreationInfo ON SolutionInfo.SOLUTIONID=SolutionCreationInfo.SOLUTIONID LEFT JOIN SolutionUpdationInfo ON SolutionInfo.SOLUTIONID=SolutionUpdationInfo.SOLUTIONID LEFT JOIN AaaUser Updater ON SolutionUpdationInfo.LASTUPDATEDBY=Updater.USER_ID LEFT JOIN AaaUser Creator ON SolutionCreationInfo.CREATEDBY=Creator.USER_ID LEFT JOIN Solution_Keywords ON Solution.SOLUTIONID=Solution_Keywords.SOLUTIONID LEFT JOIN Sol_StatusDefinition ON Solution.STATUSID=Sol_StatusDefinition.STATUSID order by 1,2

 

For Mysql,

 

SELECT solution.solutionid’Solution Id’,KB_Topics.TOPICNAME ‘Category / Topic’,Solution.TITLE ‘Subject / Title’,Solution.DESCRIPTION ‘Contents’,Creator.FIRST_NAME ‘Created By’,DATE_FORMAT(FROM_UNIXTIME(SolutionInfo.CREATEDTIME/1000),’%d-%m-%Y %k:%i’) ‘Created Time’,Updater.FIRST_NAME ‘Last Modified By’,DATE_FORMAT(FROM_UNIXTIME(SolutionInfo.LASTUPDATEDTIME/1000),’%d-%m-%Y %k:%i’) ‘Last Modified Time’,Sol_StatusDefinition.STATUSNAME ‘Status’ FROM Solution INNER JOIN SolutionInfo ON Solution.SOLUTIONID=SolutionInfo.SOLUTIONID LEFT JOIN KB_Topics ON Solution.TOPICID=KB_Topics.TOPICID LEFT JOIN SolutionCreationInfo ON SolutionInfo.SOLUTIONID=SolutionCreationInfo.SOLUTIONID LEFT JOIN SolutionUpdationInfo ON SolutionInfo.SOLUTIONID=SolutionUpdationInfo.SOLUTIONID LEFT JOIN AaaUser Updater ON SolutionUpdationInfo.LASTUPDATEDBY=Updater.USER_ID LEFT JOIN AaaUser Creator ON SolutionCreationInfo.CREATEDBY=Creator.USER_ID LEFT JOIN Solution_Keywords ON Solution.SOLUTIONID=Solution_Keywords.SOLUTIONID LEFT JOIN Sol_StatusDefinition ON Solution.STATUSID=Sol_StatusDefinition.STATUSID order by 1,2

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500