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')) 

Comments

Post a Comment

Popular posts from this blog

ServiceDesk Plus Upgrade Fixes

  GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA pg_catalog TO sdpadmin; changeDBPassword.bat -U postgres -p <old_password> -P Stonebraker   Try starting the application after the execution of the above query.   Perform the step below as well and send us the query output:   Open  CMD as an admin on your application server, navigate to <SDP-home>/pgsql/bin and execute:  psql.exe -U sdpadmin -p 65432 -d servicedesk -h  127.0.0.1     password:  sdp@123   Execute the query below and share us the output   SELECT * FROM TableDetails where TABLE_NAME like '%DBCredentialsAudit%'; --GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA pg_catalog TO sdpadmin; --delete from uvhvalues where pattern = 'Report_Modules:MODULE_ID:89403225' and genvalues > 100000000; --delete from RequestNotification_Recipients where NOTIFICATIONID in (select RequestNotification_Recipients.NOTIFICATIONID from RequestNotification_Recipients left join RequestNotific...
Read more

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...
Read more