web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

How to find the expiry date of the ISV license provided to the client.

(0) ShareShare
ReportReport
Posted on by 50

Hi,

Is there a method or a way to check the expiry date of the license provided to a customer by ISV. There is a requirement as per which I am supposed to show the expiry date of the licenses that we provide to our clients. But I am not able to find the location or the table in which this information is stored.

Please help me out.

I have the same question (0)
  • Suggested answer
    nmaenpaa Profile Picture
    101,160 Moderator on at
    RE: How to find the expiry date of the ISV license provided to the client.

    I think it should be up to Microsoft to show this info, instead of individual ISV. We simply track the expiration of our customers' licenses ourself and remind them when the expiration date is coming close.

    You can look into SysConfig table to get some info. And also look at SysLicenseCode form in AX2012 to see how they show the expiration date.

  • nmaenpaa Profile Picture
    101,160 Moderator on at
    RE: How to find the expiry date of the ISV license provided to the client.

    Moved to D365 Finance forum.

  • Anshul Thakur Profile Picture
    50 on at
    RE: How to find the expiry date of the ISV license provided to the client.

    Hey Nikolaos, thanks for answering. I checked in the SysConfig table but couldnt find it. We also use a similar approach as of now, but what we i fwant to show  the expiry date to the customer. Can that be done? If yes, can you please tell how? Also, I dont have AX2012 and hence can't see the form.

  • Suggested answer
    nmaenpaa Profile Picture
    101,160 Moderator on at
    RE: How to find the expiry date of the ISV license provided to the client.

    SysConfig is not visible in AOT, but you can find it via table browser in D365, or SQL Server Management Studio.

    And of course you can refer to it in x++ code.

    About your second question, I already asked you to check SysLicenseCode form in AX2012. It should be a very good example on how to show expiration of licenses on a form. I suggest you try to get your hands on AX2012 system to look at the form.

  • Anshul Thakur Profile Picture
    50 on at
    RE: How to find the expiry date of the ISV license provided to the client.

    I saw in the table browser and the expiry date was blank. It maybe because I have a developers license and hence there is no expiry date on that. But if I install a license with expiry date, will it be visible in SysConfig table?

  • Suggested answer
    nmaenpaa Profile Picture
    101,160 Moderator on at
    RE: How to find the expiry date of the ISV license provided to the client.

    I looked at the AX2012 form for you, and here's some info:

    - License description can be fetched by calling SysLicenseCodeReadFile::codeDescription(_sysConfig.Id);

    - License expiration can be fetched by calling str2Date(_sysConfig.Expiration, 123);

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    299,407 Super User 2025 Season 2 on at
    RE: How to find the expiry date of the ISV license provided to the client.

    HI Anshul,

    When an ISV provides an expiry date, it will be visible in the SysConfig table. No expiry date means no expiry.

    You can also open the license file provided by the ISV to see the expiry date.

  • Anshul Thakur Profile Picture
    50 on at
    RE: How to find the expiry date of the ISV license provided to the client.

    Hey Nicholas, can you tell me how to call the expiration date for a particular id. Like the I found the expiry date in the SysConfig table, but to show it on a form, I need to fetch the expiry date of that particular id. Lets say the date is 1/1/2020 and the id for the license is 123456789. So how can I fetch this date using this Id. I am not good at coding and hence trying to understand how to do this.

  • Suggested answer
    nmaenpaa Profile Picture
    101,160 Moderator on at
    RE: How to find the expiry date of the ISV license provided to the client.

    If you have particular id, just find the SysConfig that has that ID.

    If you can't find it, just display all records from SysConfig table on a grid and the users can see everything at one glance.

  • Anshul Thakur Profile Picture
    50 on at
    RE: How to find the expiry date of the ISV license provided to the client.

    I have a particular ID and I have used it also. But I am not able to use that Id to fetch the date from SysConfig in a class. I can't show all the records as I have to show the expiry date of a particular license that we provide.So is there a method that i can use? Like how can I use Find method in SyConfig table. I have stred that ID in a variable, now I want to pass that to SysConfig so that it can give the date at hat ID. how can I do this?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,882

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 794 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 525 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans