anybody having an agent procedure / script to "daily" check / alert on the Kserver license expiration status.
What is your end-goal for this? From what I understand, most licenses are annual and your account manager should be aware and follow-up with you and/or your company when getting close to license expiration.
Unfortunately it didn't and we got in maintenance expired !!!
easiest thing for you to do is set up a SQL job that runs - here is the text for the job to do what you are wanting... Obviously - change the 30 and 7 to whatever values you want and you can schedule the job to run as frequently as you need.
@Chris Clancy Thanks for sharing your SQL skills, learned a few new things by playing around with it and now I have a SQL Agent Job that will warn me for this.
Cool info - thank you. I've added the license expiry and max agents into to my NOC system.
where did you get this ......dbo.fn_GetUsageAgentsFiltered(1, '') ?
that SQL function already does that math for you regarding KNM - here is what it calls to get the "KNM Licenses"
yes, I have that one, but is there a count for the nbr of agents installed ?