The date for any columns is set to 01 Jan 1970 01:00:00.000000
Issue:
The date columns are filled with 01 Jan 1970 01:00:00.000000 instead of being empty.
Root Cause:
ServiceDesk Upgrade did not handle it
Solution:
Add the entry " ZOHO_UPDATE_NULL_FOR_NEGATIVEVALUE=true" in <SDP_HOME>\zreports\uploadtool\conf\common_params.conf
Hit re-sync button.
Note: ServiceDesk Plus restart not necessary.
New to ADSelfService Plus?
Related Articles
Steps to import approval date
We can fetch the approval date data from ServiceDesk Plus using the following workaround. Below are the steps to be followed to successfully import the data. Step 1: Click Import data within the ServiceDesk Plus database in Analytics Plus. Step 2: ...
Date format wrongly set in A+ DB
To correct date format in A+ Database Find the ID for the table https://localhost:8443/ZROPQueryTool.cc select * from zdbdbobject where displayname like 'table name or column name' Connect to psql \AnalyticsPlus\pgsql\bin>psql.exe -h ...
How to add/view current date in a dashboard
1. Click on "Edit Design" in a dashboard 2. Choose Add Text and select edit HTML( refer attached screenshot) 3. Watch this video to see how you can do it. Video link: https://youtu.be/hcaTPUuM9PE Clock ...
Query to Fetch Inactive Columns from a Workspace
Requirement: Customer wanted to determine the number of used or unused columns in a workspace. Solution: To achieve this, we need to connect to the Analytics Plus database by using local database import method (PostgrSQL) and then use the custom ...
Query to Fetch Warranty Details from Endpoint Central
Requirement: The requirement is to fetch warranty expiry details of managed machines from Endpoint Central into Analytics Plus using a custom query through local database import. This enables users to track warranty coverage, identify machines ...