How to solve unable to approve solutions cases ?
Requesting you to check whether you have a role assigned with the below option is enabled or not: Admin -> roles
"Allow technician to approve solution".
If not, you will not have the option to approve any solutions (when logged in as a technician), where you can only see a "Submit for Approval" option.
If the option "Allow technician to approve solution" is not checked:
As a technician, you can see:
When the same is checked,
You can see the below:
How Public and Private Solutions work
ServiceDesk Plus MSP allows you to publish knowledge base solutions as either public (available for all requesters and technicians) or private (accessible only by technicians). To make a solution public, while adding/editing the solution select the ...
Query to show Solutions and its associated fields
MSSQL: SELECT solution.solutionid "Solution ID" , max(Solution.TITLE) "Solution Title", max(KB_Topics.TOPICNAME) "Solution Topic", max(Solution_Keywords.keyword) "Keywords", max(owner.FIRST_NAME) "Solution Owner", ...
Query to get solutions account based
PGSQL & MSSQL: SELECT solution.solutionid "Solutionid", KB_Topics.TOPICNAME " Topic",Solution.TITLE "Subject ",Solution.DESCRIPTION "Contents",solutioninfo.noofhits "Views",Creator.FIRST_NAME "Created By",longtodate(SolutionInfo.CREATEDTIME) "Created ...
Run this query under Reports->New Query Report and export it to the desired format SELECT solution.solutionid "Solutionid", KB_Topics.TOPICNAME " Topic",Solution.TITLE "Subject ",Solution.DESCRIPTION "Contents",solutioninfo.noofhits ...
Roles required for SQL user
The recommended login account for creating the database requires SQL authentication and it should have the following roles enabled: * dbcreator * Public * Sysadmin If you do not want to provide Sysadmin role to the ...