Query report for Solutions with creator site information
I got below query for my 'Solutions' report. I would like to add 'site' and 'support group' of 'creator' of that solution.
- SELECT solution.solutionid "Solution ID" ,Solution.TITLE "Subject ",Solution.DESCRIPTION "Contents",Creator.FIRST_NAME "Created By",Sol_StatusDefinition.STATUSNAME "Status",longtodate(SolutionInfo.CREATEDTIME) "Created Time",KB_Topics.TOPICNAME " Topic",Updater.FIRST_NAME "Last Modified By",longtodate(SolutionInfo.LASTUPDATEDTIME) "Last Modified Time",solutioninfo.noofhits "Views" FROM Solution
- INNER JOIN SolutionInfo ON Solution.SOLUTIONID=SolutionInfo.SOLUTIONID
- LEFT JOIN KB_Topics ON Solution.TOPICID=KB_Topics.TOPICID
- LEFT JOIN AaaUser Updater ON SolutionInfo.LASTUPDATEDBY=Updater.USER_ID
- LEFT JOIN AaaUser Creator ON SolutionInfo.CREATEDBY=Creator.USER_ID
- LEFT JOIN Solution_Keywords ON Solution.SOLUTIONID=Solution_Keywords.SOLUTIONID
- LEFT JOIN Sol_StatusDefinition ON Solution.STATUSID=Sol_StatusDefinition.STATUSID
Database of the application --> SQL Server 14.00.1000
Build number of the application --> 14.0 Build 14006