Posts

Showing posts from May, 2023

How to reset Admin password (SDOrg) for SupportCenter Plus

Image
  How to reset Admin password (SDOrg) for SupportCenter Plus 11.0 version and above This is applicable only above SupportCenter Plus 11.0 version. If you are using any other build , please contact support with the details. You can get the build number from About us present in the top right of the user interface. 1. Access your SupportCenter Plus server and browse to [your drive]:\ManageEngine\SupportCenterPlus\bin. 2. Click changeDBServer.bat.  Information on the configured database will be displayed.    If the database is MSSQL, go to the SQL Management Studio, go to the 6th step.       3. If the database is PGSQL , connect to it.  4. Click the Windows icon and select  Command Prompt (Run as administrator). 5. Go to [your drive]:ManageEngine\SupportCenterPlus\pgsql\bin and run For Windows: psql.exe -U scpadmin -p 65432 -d supportcenter -h 127.0.0.1 For Linux: psql -U scpadmin -p 65432 -d supportcenter -h 127.0.0.1 If...

ServiceDesk Plus Show Date And Time for Custom Report Query

 DATE_FORMAT (FROM_UNIXTIME (wo.CREATEDTIME/1000),'%d-%m-%Y %k: %i') ((ct.TIMESPENT))/60000 AS "Time Spent(min)",  wo.CREATEDTIME >= DATETOLONG('2023-05-06 00:00:00'))