CA Client Automation

How to decode the numbers to date in SD files ? 

01-25-2016 11:44 AM

Dates are coded as numbers with 10 digits (3*********) in some SD files like under SWJORDER (*.xml and *.apc) or under DSM\Agent\units\00000001\usd\sdjexec (*.crf).

 

Examples :

 

- File C:\Program Files\CA\DSM\ServerDB\SWJORDER\35F0D39C-A47E-4F22-A69A-4BE3275025AF\appl.apc

 

2.jpg

 

- File C:\Program Files\CA\DSM\Agent\units\00000001\usd\sdjexec\7F686775-FADF-4DE8-82A5-0A1AB65D5FF5.crf

 

3.jpg

 

 

 

How to convert these numbers to date ?

 

 

 

Instructions: 

 

Using Microsoft SQL Server Management Studio it is possible to convert these numbers in date :

Execute this query by replacing the number in bold by the number to convert

 

 

SELECT dateadd ( ss, number - 2000000000 + datediff(ss,getutcdate(),getdate()), convert(datetime,dateadd ( ss, 2000000000, convert(datetime,'19010101'))))

 

Example :

 

4.jpg

Statistics
0 Favorited
1 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.