Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / running out SL license
Microsoft Dynamics SL (Archived)

running out SL license

(0) ShareShare
ReportReport
Posted on by bobnewbie 155

My company has 25 SL license at the moment

the total user is approximately and it just recently grew to about 70 users

most of them only use SL occasionally.

my question is when it runs out of license. the USER will get an error message saying no more license available. Is there a way to capture this event and record WHO and WHEN

my end goal is by having a dataset of WHO and WHEN get "no more license" error for a certain period, is hopefully to determine how many more license to buy

PLS advise?

thank you

*This post is locked for comments

  • Ram Peru Profile Picture
    Ram Peru 2,830 on at
    RE: running out SL license

    You can do the simple SQL Query to find out the user licenses count.

    You can use the below query in SQL Job and send an email to your tech support team once the count reaches 25 as what Dwight & Randall Wade said earlier.

    Select COUNT ( DISTINCT InternetAddress ) From Access where ScrnNbr LIKE '%%' AND ScrnNbr <> 'MENU'

    You can use the below KB article for better understanding

    support.microsoft.com/.../848814

    Thanks,

    Perumalsamy R

  • Community Member Profile Picture
    Community Member on at
    RE: running out SL license

    We do a similar method to what Dwight has mentioned. I set up a sql job that collects the user data and open screen counts on each of our company databases and dumps it into another db/table. Then I use SSRS to display usage graphs on our tech support Sharepoint site.

    Looking at the graphs, we can identify peak times and user load as it spreads across the different company DBs (which we also use for diverting license cost to the correct place).

    Also, you could likely use a similar method that could email mail a warning when your user count gets to a certain threshold if you wanted a more automated notification approach.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: running out SL license

    What version of DSL are you using?

    I capture my number of users every 3 minutes to keep track of how close and how many times we hit the limit.  But the code is dependent on the version as some users do not count in the user count (like Application servers)

  • Suggested answer
    Ram Peru Profile Picture
    Ram Peru 2,830 on at
    RE: running out SL license

    Please go through the below link and you will get an idea about licensing and pricing details of Dynamics SL User Licenses.

    www.microsoft.com/.../erp-buy-sl-software.aspx

    This may help you

    Thanks,

    Perumalsamy R

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans