web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Containers in database

Microsoft Dynamics AX (Archived)

Containers in database

(0) Share

Report

Report

Posted on by Simone F

43

Hello all,

I'm trying to parse batch job logs directly in SQL Server. So far, I've found that the Info field of BatchHistory table contains the data that I'm looking for, but I can't figure out how they are stored.

i.e.: this is one example of Info field's content:

0x07FD0707FD0101000000FF0707FD010000000...

Is it possible to decode it, somehow?

Thank you in advance

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Khurshid Wali 928 on at

Like (0)

Report
Copy link

Link copied!

Hi Simone F,

The 0x is just a prefix used in many languages (programming) which means the following number is in base 16.

You can use tools Like.

www.convertstring.com/.../HexEncode

Was this reply helpful? Yes No
Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Simone,

Info field in BatchHistory table is not container,is varbinary(MAX)

You can use case() as bigint .

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#2

Andrew Jones a1x 2

#3

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans