Where do I Find the 'Last Update' for the Database Version Download in API?
Issue Description:
Customers are asking how to obtain the "Last update" timestamp—the date when the most recent database version was downloaded, as shown in the Inventory menu. Currently, the API endpoints /stat/engines and /stat/packages return two relevant time-related fields:
def_time: The database definition time (displayed in the "Definition" column of the Inventory menu).
download_time:
For engine packages, this is when a new engine version was downloaded (seen in the update history).
For database packages, this timestamp corresponds to the "Last update" field shown in the Inventory UI.
Detection:
A review of the /stat/packages API response shows it returns two objects:
- Engine Package – Contains download_time for engine updates
- Database Package – Contains download_time, which represents the "Last update"
The UI extracts the download_time from the database package (i.e., the object with "type": "database"), converts it from UTC to the local time zone, and displays it as the "Last update".
Example API Response from /stat/packages:
[ { "def_time": "2023-06-26T00:00:00.000Z", "download_time": "2025-03-10T03:37:01.110Z", "eng_id": "ahnlab_1_windows", "eng_name": "AhnLab", "eng_type": "Bundled engine", "eng_ver": "3.23.3.2-1853", "engine_type": "av", "notified_messages": [], "pinned": false, "state": "production", "type": "engine" }, { "db_ver": "2023.06.26.00", "download_time": "2025-03-12T10:15:38.992Z", "eng_id": "ahnlab_1_windows", "eng_name": "AhnLab", "engine_type": "av", "pinned": false, "state": "production", "type": "database" } ]
Answer:
There is no separate endpoint specifically for retrieving the "Last update" timestamp. This value is derived from the download_time field of the database package object in the /stat/packages endpoint. The UI converts this UTC timestamp to local time and displays it accordingly. Additionally:
- The "Database" column in the UI reflects the db_ver field from the database package.
Recommended Action:
To get the "Last update" timestamp:
Use the /stat/packages endpoint.
Locate the object with "type": "database".
Extract the download_time field.
Convert the value from UTC to your local time zone if needed.
If Further Assistance is required, please proceed to log a support case or chatting with our support engineer.