search cancel

How to find previous object´s data in UC4 database

book

Article ID: 89763

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

How to find previous object´s data in UC4 database

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Detailed Description and Symptoms

This article describes how to find objects saved with versions management in the database?


Investigation

Ticket S# 191403?


Solution

This data is saved within the OX table. Copy this to a editor like notepad++ and change the character setting from Hex to ASCII.

Using the following statement you will use the SQL builtin converter.

MSSQL:

select *, CONVERT(varchar,ox_content) from ox

 

Oracle:

need to test this. will be inserted.

?