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