Migrate Asset History from OP to OD as an Attachment.
Currently, there is no option to transfer asset history from the OP instance to the OD instance. As a workaround, a Python script retrieves history data, generates a readable PDF file, and uploads it as an attachment to the corresponding asset in the OP instance. This attachment is then migrated along with the asset during the OP to OD migration.
The script requires specific configurations in config.json. In PostgreSQL, the database port,user and password must be set. Asset history data is fetched from the CIHistory table, while resource state and ownership history are retrieved from ResourceStateHistory and ResourceOwnerHistory. The CIHistory data is generated as a separate PDF, and ownership history is also stored in a separate PDF. Additionally, an authentication token and URL of to access applicatoin must be configured in config.json to invoke the asset API and upload the attachments.
New to ADSelfService Plus?
Related Articles
Asset Ownership History Report
Please use the below query to get the report on Asset Ownership History. SELECT r.resourcename AS "Workstation Name", ct.componenttypename AS "Product type", rs.displaystate AS "Asset State", aa.first_name AS "Assigned User", LONGTODATE(sh.starttime) ...Query to show Asset state history ( MSSQL)
Tested in MSSQL build (14306) SELECT res.resourcename 'Asset Name', res.assettag 'Asset Tag',res.serialno 'Asset Serial No.', rs2.statedesc 'Previous State',rs1.statedesc 'Current State',DATEADD(s,DATEDIFF(s,GETUTCDATE() ,getdate()) + ...Query to retrieve users login and logout history and find their current status
REQUIREMENT: To generate a report that contains the login and logout history of users and to determine the current user status. TESTED IN: Builds 14503 (Postgres) QUERY 1: The following query provides the login and logout history of users. SELECT ...Hide Asset
Use case If Technicians want to hide Asset field during template loading, then the same can be achieved using Execute Script option in Field and Form Rules. Solution Edit the incident/service template from which the asset needs to be hidden, choose ...AntisamyNotificationSchedule - Move Notification Description as Attachment
Large content (>64k) in notificationtodescription table causes failure in backup/trimmed backup. The schedule's (AntisamyNotificationSchedule) job is to move large content from notificationtodesc table as attachment. Below is the file attached to ...