E9: Question on tracking users logged in

Thanks, got it.  I wasn't minding my parentheses.

Hello,

 

How does Epicor manage or track logged in users against max licensed users?

Is the information that I see in the Epicor Administration Console stored in a table? If yes, which table?

 

I ask because I would like to do some analytics, over time, to determine license usage.

We are looking to make changes in the near future that will increase the utilization of Epicor, which will mean increase number of users logging in, and it looks like our current license utilization is low so we might be ok…but I’d like to have some more concrete evidence.

 

JOE ROJAS

Epicor Applications Manager

VENTION MEDICAL

Advancing Your Innovations For Health


261 Cedar Hill Street  |  Marlborough, MA 01752
DIRECT: 508.597.1392 x1625  |  MOBILE: 774.826.9245

EMAIL: JoRojas@...  |  WEB: ventionmedical.com

 

THINK QUALITY. BE QUALITY. GO BEYOND.

 

This communication may contain information that is confidential, proprietary or exempt from disclosure, and is intended only for the use of the individual and/or entity it is addressed to. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone or by return e-mail, and delete this information from your computer.

LicUser is the table. Still can’t figure out how they are calculating available in Admin console. But it will get you an idea of what’s going on.

 

At a minimum you want suspended = 0 and licnum > 0

 

Joshua Giese
Technology Solutions : CXO

Direct Phone:    920.593.8299
Office Phone:    920.437.6400 x342

http://wcibags.com/email/emailFooter4.jpg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 9:33
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Question on tracking users logged in

 

 

Hello,

 

How does Epicor manage or track logged in users against max licensed users?

Is the information that I see in the Epicor Administration Console stored in a table? If yes, which table?

 

I ask because I would like to do some analytics, over time, to determine license usage.

We are looking to make changes in the near future that will increase the utilization of Epicor, which will mean increase number of users logging in, and it looks like our current license utilization is low so we might be ok…but I’d like to have some more concrete evidence.

 

JOE ROJAS

Epicor Applications Manager

VENTION MEDICAL

Advancing Your Innovations For Health


261 Cedar Hill Street  |  Marlborough, MA 01752
DIRECT: 508.597.1392 x1625  |  MOBILE: 774.826.9245

EMAIL: JoRojas@...  |  WEB: ventionmedical.com

 

THINK QUALITY. BE QUALITY. GO BEYOND.

 

This communication may contain information that is confidential, proprietary or exempt from disclosure, and is intended only for the use of the individual and/or entity it is addressed to. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone or by return e-mail, and delete this information from your computer.

Thanks Joshua.

My guess is that it is taking the last time field, adding in the time out value, and the comparing it to current time to determine if it is in use or available.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 10:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in


LicUser is the table. Still can't figure out how they are calculating available in Admin console. But it will get you an idea of what's going on.

At a minimum you want suspended = 0 and licnum > 0

Joshua Giese
Technology Solutions : CXO
Direct Phone: 920.593.8299
Office Phone: 920.437.6400 x342
[Image removed by sender. http://wcibags.com/email/emailFooter4.jpg%5d<http://www.wcibags.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 9:33
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Question on tracking users logged in


Hello,

How does Epicor manage or track logged in users against max licensed users?
Is the information that I see in the Epicor Administration Console stored in a table? If yes, which table?

I ask because I would like to do some analytics, over time, to determine license usage.
We are looking to make changes in the near future that will increase the utilization of Epicor, which will mean increase number of users logging in, and it looks like our current license utilization is low so we might be ok...but I'd like to have some more concrete evidence.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
Advancing Your Innovations For Health

261 Cedar Hill Street | Marlborough, MA 01752
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
EMAIL: JoRojas@...<mailto:JoRojas@...> | WEB: ventionmedical.com <http://www.ventionmedical.com/>

THINK QUALITY. BE QUALITY. GO BEYOND.

This communication may contain information that is confidential, proprietary or exempt from disclosure, and is intended only for the use of the individual and/or entity it is addressed to. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone or by return e-mail, and delete this information from your computer.



[Non-text portions of this message have been removed]
Hi Joshua,

Just to follow up, I believe I have this correct.

In Crystal Reports, if I compare LastTime + Timeout to Timer, I get the same results as the Admin Console.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 11:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in



Thanks Joshua.

My guess is that it is taking the last time field, adding in the time out value, and the comparing it to current time to determine if it is in use or available.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 10:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in

LicUser is the table. Still can't figure out how they are calculating available in Admin console. But it will get you an idea of what's going on.

At a minimum you want suspended = 0 and licnum > 0

Joshua Giese
Technology Solutions : CXO
Direct Phone: 920.593.8299
Office Phone: 920.437.6400 x342
[Image removed by sender. http://wcibags.com/email/emailFooter4.jpg%5d<http://www.wcibags.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 9:33
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Question on tracking users logged in

Hello,

How does Epicor manage or track logged in users against max licensed users?
Is the information that I see in the Epicor Administration Console stored in a table? If yes, which table?

I ask because I would like to do some analytics, over time, to determine license usage.
We are looking to make changes in the near future that will increase the utilization of Epicor, which will mean increase number of users logging in, and it looks like our current license utilization is low so we might be ok...but I'd like to have some more concrete evidence.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
Advancing Your Innovations For Health

261 Cedar Hill Street | Marlborough, MA 01752
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
EMAIL: JoRojas@...<mailto:JoRojas@...> | WEB: ventionmedical.com <http://www.ventionmedical.com/>

THINK QUALITY. BE QUALITY. GO BEYOND.

This communication may contain information that is confidential, proprietary or exempt from disclosure, and is intended only for the use of the individual and/or entity it is addressed to. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone or by return e-mail, and delete this information from your computer.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

I tried doing that manually and I didn’t find that to be the case.

 

I took last used plus timeout time  and it was less than current time however licnum was > 0 and suspend was = 0.

 

Example was something like

 

Last time x timeout < curr time = false

 

(53678 + 900) < 63394 but licnum > 0 and suspend ==0.  I couldn’t figure out that last bit.

 

Joshua Giese
Technology Solutions : CXO

Direct Phone:    920.593.8299
Office Phone:    920.437.6400 x342

http://wcibags.com/email/emailFooter4.jpg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 10:14
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in

 

 

Thanks Joshua.

My guess is that it is taking the last time field, adding in the time out value, and the comparing it to current time to determine if it is in use or available.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 10:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in

LicUser is the table. Still can't figure out how they are calculating available in Admin console. But it will get you an idea of what's going on.

At a minimum you want suspended = 0 and licnum > 0

Joshua Giese
Technology Solutions : CXO
Direct Phone: 920.593.8299
Office Phone: 920.437.6400 x342
[Image removed by sender. http://wcibags.com/email/emailFooter4.jpg]<http://www.wcibags.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 9:33
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Question on tracking users logged in

Hello,

How does Epicor manage or track logged in users against max licensed users?
Is the information that I see in the Epicor Administration Console stored in a table? If yes, which table?

I ask because I would like to do some analytics, over time, to determine license usage.
We are looking to make changes in the near future that will increase the utilization of Epicor, which will mean increase number of users logging in, and it looks like our current license utilization is low so we might be ok...but I'd like to have some more concrete evidence.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
Advancing Your Innovations For Health

261 Cedar Hill Street | Marlborough, MA 01752
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
EMAIL: JoRojas@...<mailto:JoRojas@...> | WEB: ventionmedical.com <http://www.ventionmedical.com/>

THINK QUALITY. BE QUALITY. GO BEYOND.

This communication may contain information that is confidential, proprietary or exempt from disclosure, and is intended only for the use of the individual and/or entity it is addressed to. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone or by return e-mail, and delete this information from your computer.

[Non-text portions of this message have been removed]

I am doing this with a direct SQL query I still can’t get it to come out.

 

Here is a screenshot of my query, results, and admin console. I’m not seeing it.

 

Using just my basic filters I am getting 16 supposedly active records

 

http://jcg.pictures/gd8wjeEjaIhjjj.png

 

If I run a comparison of the last time + timeout against current seconds since midnight it shows I should have 5 more dropping off of 16 brining me to 11 active licenses

 

However, admin console still reports 14 in use.

 

Something I’m missing there.

Joshua Giese
Technology Solutions : CXO

Direct Phone:    920.593.8299
Office Phone:    920.437.6400 x342

http://wcibags.com/email/emailFooter4.jpg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 10:36
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in

 

 

Hi Joshua,

Just to follow up, I believe I have this correct.

In Crystal Reports, if I compare LastTime + Timeout to Timer, I get the same results as the Admin Console.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 11:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in

Thanks Joshua.

My guess is that it is taking the last time field, adding in the time out value, and the comparing it to current time to determine if it is in use or available.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 10:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in

LicUser is the table. Still can't figure out how they are calculating available in Admin console. But it will get you an idea of what's going on.

At a minimum you want suspended = 0 and licnum > 0

Joshua Giese
Technology Solutions : CXO
Direct Phone: 920.593.8299
Office Phone: 920.437.6400 x342
[Image removed by sender. http://wcibags.com/email/emailFooter4.jpg]<http://www.wcibags.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 9:33
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Question on tracking users logged in

Hello,

How does Epicor manage or track logged in users against max licensed users?
Is the information that I see in the Epicor Administration Console stored in a table? If yes, which table?

I ask because I would like to do some analytics, over time, to determine license usage.
We are looking to make changes in the near future that will increase the utilization of Epicor, which will mean increase number of users logging in, and it looks like our current license utilization is low so we might be ok...but I'd like to have some more concrete evidence.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
Advancing Your Innovations For Health

261 Cedar Hill Street | Marlborough, MA 01752
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
EMAIL: JoRojas@...<mailto:JoRojas@...> | WEB: ventionmedical.com <http://www.ventionmedical.com/>

THINK QUALITY. BE QUALITY. GO BEYOND.

This communication may contain information that is confidential, proprietary or exempt from disclosure, and is intended only for the use of the individual and/or entity it is addressed to. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone or by return e-mail, and delete this information from your computer.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

Correction to the screenshot Column name should be “ShouldBeActive” not expired

 

Joshua Giese
Technology Solutions : CXO

Direct Phone:    920.593.8299
Office Phone:    920.437.6400 x342

http://wcibags.com/email/emailFooter4.jpg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 11:00
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in

 

 

I am doing this with a direct SQL query I still can’t get it to come out.

 

Here is a screenshot of my query, results, and admin console. I’m not seeing it.

 

Using just my basic filters I am getting 16 supposedly active records

 

http://jcg.pictures/gd8wjeEjaIhjjj.png

 

If I run a comparison of the last time + timeout against current seconds since midnight it shows I should have 5 more dropping off of 16 brining me to 11 active licenses

 

However, admin console still reports 14 in use.

 

Something I’m missing there.

Joshua Giese
Technology Solutions : CXO

Direct Phone:    920.593.8299
Office Phone:    920.437.6400 x342

http://wcibags.com/email/emailFooter4.jpg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 10:36
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in

 

 

Hi Joshua,

Just to follow up, I believe I have this correct.

In Crystal Reports, if I compare LastTime + Timeout to Timer, I get the same results as the Admin Console.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 11:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in

Thanks Joshua.

My guess is that it is taking the last time field, adding in the time out value, and the comparing it to current time to determine if it is in use or available.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 10:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in

LicUser is the table. Still can't figure out how they are calculating available in Admin console. But it will get you an idea of what's going on.

At a minimum you want suspended = 0 and licnum > 0

Joshua Giese
Technology Solutions : CXO
Direct Phone: 920.593.8299
Office Phone: 920.437.6400 x342
[Image removed by sender. http://wcibags.com/email/emailFooter4.jpg]<http://www.wcibags.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 9:33
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Question on tracking users logged in

Hello,

How does Epicor manage or track logged in users against max licensed users?
Is the information that I see in the Epicor Administration Console stored in a table? If yes, which table?

I ask because I would like to do some analytics, over time, to determine license usage.
We are looking to make changes in the near future that will increase the utilization of Epicor, which will mean increase number of users logging in, and it looks like our current license utilization is low so we might be ok...but I'd like to have some more concrete evidence.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
Advancing Your Innovations For Health

261 Cedar Hill Street | Marlborough, MA 01752
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
EMAIL: JoRojas@...<mailto:JoRojas@...> | WEB: ventionmedical.com <http://www.ventionmedical.com/>

THINK QUALITY. BE QUALITY. GO BEYOND.

This communication may contain information that is confidential, proprietary or exempt from disclosure, and is intended only for the use of the individual and/or entity it is addressed to. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone or by return e-mail, and delete this information from your computer.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

That's strange.
I don't see anything wrong with your query that jumps out to me.
The difference on my end is that I'm not including the suspend = 0 filter.
I found suspended session that were still showing as In Use in the admin console. I was assuming that the suspended license stayed as In Use until the timeout was hit.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 12:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in


I am doing this with a direct SQL query I still can't get it to come out.

Here is a screenshot of my query, results, and admin console. I'm not seeing it.

Using just my basic filters I am getting 16 supposedly active records

http://jcg.pictures/gd8wjeEjaIhjjj.png

If I run a comparison of the last time + timeout against current seconds since midnight it shows I should have 5 more dropping off of 16 brining me to 11 active licenses

However, admin console still reports 14 in use.

Something I'm missing there.
Joshua Giese
Technology Solutions : CXO
Direct Phone: 920.593.8299
Office Phone: 920.437.6400 x342
[Image removed by sender. http://wcibags.com/email/emailFooter4.jpg%5d<http://www.wcibags.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 10:36
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in



Hi Joshua,

Just to follow up, I believe I have this correct.

In Crystal Reports, if I compare LastTime + Timeout to Timer, I get the same results as the Admin Console.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 11:14 AM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Question on tracking users logged in

Thanks Joshua.

My guess is that it is taking the last time field, adding in the time out value, and the comparing it to current time to determine if it is in use or available.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 10:38 AM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Question on tracking users logged in

LicUser is the table. Still can't figure out how they are calculating available in Admin console. But it will get you an idea of what's going on.

At a minimum you want suspended = 0 and licnum > 0

Joshua Giese
Technology Solutions : CXO
Direct Phone: 920.593.8299
Office Phone: 920.437.6400 x342
[Image removed by sender. http://wcibags.com/email/emailFooter4.jpg%5d<http://www.wcibags.com/<http://wcibags.com/email/emailFooter4.jpg%5d%3chttp:/www.wcibags.com/>>
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 9:33
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] E9: Question on tracking users logged in

Hello,

How does Epicor manage or track logged in users against max licensed users?
Is the information that I see in the Epicor Administration Console stored in a table? If yes, which table?

I ask because I would like to do some analytics, over time, to determine license usage.
We are looking to make changes in the near future that will increase the utilization of Epicor, which will mean increase number of users logging in, and it looks like our current license utilization is low so we might be ok...but I'd like to have some more concrete evidence.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
Advancing Your Innovations For Health

261 Cedar Hill Street | Marlborough, MA 01752
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
EMAIL: JoRojas@...<mailto:JoRojas@...<mailto:JoRojas@...%3cmailto:JoRojas@...>> | WEB: ventionmedical.com <http://www.ventionmedical.com/>

THINK QUALITY. BE QUALITY. GO BEYOND.

This communication may contain information that is confidential, proprietary or exempt from disclosure, and is intended only for the use of the individual and/or entity it is addressed to. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone or by return e-mail, and delete this information from your computer.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

Ah that’s the ticket. Good eye, thanks for the bump.

 

Joshua Giese
Technology Solutions : CXO

Direct Phone:    920.593.8299
Office Phone:    920.437.6400 x342

http://wcibags.com/email/emailFooter4.jpg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 13:52
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in

 

 

That's strange.
I don't see anything wrong with your query that jumps out to me.
The difference on my end is that I'm not including the suspend = 0 filter.
I found suspended session that were still showing as In Use in the admin console. I was assuming that the suspended license stayed as In Use until the timeout was hit.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 12:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in

I am doing this with a direct SQL query I still can't get it to come out.

Here is a screenshot of my query, results, and admin console. I'm not seeing it.

Using just my basic filters I am getting 16 supposedly active records

http://jcg.pictures/gd8wjeEjaIhjjj.png

If I run a comparison of the last time + timeout against current seconds since midnight it shows I should have 5 more dropping off of 16 brining me to 11 active licenses

However, admin console still reports 14 in use.

Something I'm missing there.
Joshua Giese
Technology Solutions : CXO
Direct Phone: 920.593.8299
Office Phone: 920.437.6400 x342
[Image removed by sender. http://wcibags.com/email/emailFooter4.jpg]<http://www.wcibags.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 10:36
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Question on tracking users logged in

Hi Joshua,

Just to follow up, I believe I have this correct.

In Crystal Reports, if I compare LastTime + Timeout to Timer, I get the same results as the Admin Console.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 11:14 AM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Question on tracking users logged in

Thanks Joshua.

My guess is that it is taking the last time field, adding in the time out value, and the comparing it to current time to determine if it is in use or available.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 10:38 AM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] RE: E9: Question on tracking users logged in

LicUser is the table. Still can't figure out how they are calculating available in Admin console. But it will get you an idea of what's going on.

At a minimum you want suspended = 0 and licnum > 0

Joshua Giese
Technology Solutions : CXO
Direct Phone: 920.593.8299
Office Phone: 920.437.6400 x342
[Image removed by sender. http://wcibags.com/email/emailFooter4.jpg]<http://www.wcibags.com/<http://wcibags.com/email/emailFooter4.jpg%5d%3chttp:/www.wcibags.com/>>
From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 9:33
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] E9: Question on tracking users logged in

Hello,

How does Epicor manage or track logged in users against max licensed users?
Is the information that I see in the Epicor Administration Console stored in a table? If yes, which table?

I ask because I would like to do some analytics, over time, to determine license usage.
We are looking to make changes in the near future that will increase the utilization of Epicor, which will mean increase number of users logging in, and it looks like our current license utilization is low so we might be ok...but I'd like to have some more concrete evidence.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
Advancing Your Innovations For Health

261 Cedar Hill Street | Marlborough, MA 01752
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
EMAIL: JoRojas@...<mailto:JoRojas@...<mailto:JoRojas@...%3cmailto:JoRojas@...>> | WEB: ventionmedical.com <http://www.ventionmedical.com/>

THINK QUALITY. BE QUALITY. GO BEYOND.

This communication may contain information that is confidential, proprietary or exempt from disclosure, and is intended only for the use of the individual and/or entity it is addressed to. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone or by return e-mail, and delete this information from your computer.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

Thanks for posting this guys, I was asked the same question this morning and this will save me a lot of time figuring it out. Happy Friday!

-Bobby
One last follow up. I only wanted to have 1 row that listed the number of active users at that date and time. So here's my final sql query (thanks to Joshua for core of this). I then turned this into a Job using the management studio so it will export every hour. 

; with ActiveSessions as (SELECT "licuser"."curuserid", 
       "licuser"."lasttime", 
       "licuser"."timeout", 
       "licuser"."licnum", 
       "licuser"."sessiontype", 
       "licuser"."lastdate", 
       Case when (lasttime + timeout) > (((DatePart(hour,Getdate())) * 60 + datepart(minute, Getdate())) * 60 + datepart(second, getdate()))
then 
1
else 
0
end as "Active"
FROM   "Epicor905"."dbo"."licuser" "LicUser" 

WHERE  "licuser"."licnum" > 0 
       AND ( "licuser"."lastdate" = cast(GETDATE() as DATE) ) 
       AND "licuser"."sessiontype" = '' 
       
)

select COUNT(*) as 'activeusers', GETDATE() as date from ActiveSessions 
where Active = 1

Are LastTime and TimeOut in minutes or seconds?  I'm not sure I understand what's going on with multiplying both hours and minutes by 60.

Thanks,
Bob Beaghan

They are in seconds, so… 900 seconds / 60 = 15 minutes

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, July 05, 2016 4:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E9: Question on tracking users logged in



Are LastTime and TimeOut in minutes or seconds? I'm not sure I understand what's going on with multiplying both hours and minutes by 60.

Thanks,
Bob Beaghan




[Non-text portions of this message have been removed]