License Use - logging

Yahoo Archive
1
You probably have a continuous process with that frequency - task agent,
global alerts, etc. I've always assumed these processes didn't use a
license.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of c.krusen1
Sent: Monday, September 19, 2011 1:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: License Use - logging





Correction:

My "manager" updates every 2 minutes, and *NO* scheduled tasks have that
frequency.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"c.krusen1" <ckrusen1@...> wrote:
>
> One more thing. On my system, the "manager" user is always updating.
Even when no one is logged in. I verified this with an ODBC query of
UserFile. My "manager" updates every 2 minutes, and now scheduled tasks
have that frequency.
>





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

I am looking for a way to build a log of the number of licenses in use.

I suspect there are more licenses than needed.
The number was determined many years ago.
40 users and 8 MES.
The site doesn't have nearly as many users as it did then.

Also, wondering if anybody knows where I might I find info about when licenses are used up? Logon, ODBC connections, etc...

Thanks...
3
You can see this if you log into the Admin Tools and then select licensing. It will show what is in use. Remember licenses are released and renewed so watch that count.
Are you planning to get rid of some licenses to save money? Epicor seems to resist that and offers other ways to save, so check with them if that is your plan. You can "Freeze" modules etc. and not pay the support but if you ever want to use them again, you need to pay the back support to activat them again. Usually makes sense to just keep them IMHO.

Good Luck,
George Hicks
Pacific Consolidated Industries


--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> Hi,
>
> I am looking for a way to build a log of the number of licenses in use.
>
> I suspect there are more licenses than needed.
> The number was determined many years ago.
> 40 users and 8 MES.
> The site doesn't have nearly as many users as it did then.
>
> Also, wondering if anybody knows where I might I find info about when licenses are used up? Logon, ODBC connections, etc...
>
> Thanks...
>
4
Thanks George,
I hadn't thought about freezing modules.
We have several that we have never used and probably never will.

As per licenses. Yes, I think we have more than needed.
I was hoping there was a way to log use, or maybe a command with output I could redirect to a text file.
I guess I'll do a manual count a couple times a day for a few days.

Hmmm, now I wonder how the software keeps track of the licenses...

--- In vantage@yahoogroups.com, "pcivantage" <vantagegroup@...> wrote:
>
>
> You can see this if you log into the Admin Tools and then select licensing. It will show what is in use. Remember licenses are released and renewed so watch that count.
> Are you planning to get rid of some licenses to save money? Epicor seems to resist that and offers other ways to save, so check with them if that is your plan. You can "Freeze" modules etc. and not pay the support but if you ever want to use them again, you need to pay the back support to activat them again. Usually makes sense to just keep them IMHO.
>
> Good Luck,
> George Hicks
> Pacific Consolidated Industries
>
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > Hi,
> >
> > I am looking for a way to build a log of the number of licenses in use.
> >
> > I suspect there are more licenses than needed.
> > The number was determined many years ago.
> > 40 users and 8 MES.
> > The site doesn't have nearly as many users as it did then.
> >
> > Also, wondering if anybody knows where I might I find info about when licenses are used up? Logon, ODBC connections, etc...
> >
> > Thanks...
> >
>
5
The UserFile table has two fields that might work for you. They are 'LastDate' and 'LastTime' the user logged in.

A BAQ with a Query Phrase of:
"for each UserFile where ( UserFile.LastDate = TODAY + 0) no-lock by UserFile.DcdUserID."

Will return a list of all the user ID's that logged in that day. Create a BAQ Report and set it to run once a day at 11:50PM.

We don't us MES, so I'm not sure how/if they'd show up.

Calvin

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> Thanks George,
> I hadn't thought about freezing modules.
> We have several that we have never used and probably never will.
>
> As per licenses. Yes, I think we have more than needed.
> I was hoping there was a way to log use, or maybe a command with output I could redirect to a text file.
> I guess I'll do a manual count a couple times a day for a few days.
>
> Hmmm, now I wonder how the software keeps track of the licenses...
>
> --- In vantage@yahoogroups.com, "pcivantage" <vantagegroup@> wrote:
> >
> >
> > You can see this if you log into the Admin Tools and then select licensing. It will show what is in use. Remember licenses are released and renewed so watch that count.
> > Are you planning to get rid of some licenses to save money? Epicor seems to resist that and offers other ways to save, so check with them if that is your plan. You can "Freeze" modules etc. and not pay the support but if you ever want to use them again, you need to pay the back support to activat them again. Usually makes sense to just keep them IMHO.
> >
> > Good Luck,
> > George Hicks
> > Pacific Consolidated Industries
> >
> >
> > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> > >
> > > Hi,
> > >
> > > I am looking for a way to build a log of the number of licenses in use.
> > >
> > > I suspect there are more licenses than needed.
> > > The number was determined many years ago.
> > > 40 users and 8 MES.
> > > The site doesn't have nearly as many users as it did then.
> > >
> > > Also, wondering if anybody knows where I might I find info about when licenses are used up? Logon, ODBC connections, etc...
> > >
> > > Thanks...
> > >
> >
>
6
Hi Calvin,

Your idea worked great.
I was able to add this too - Count( UserFile.DcdUserID )


BTW...
I'm getting a count of 2 for today.
My userID and administrator.
I wonder if one license is really taken up by administrator all the time?

Thanks


--- In vantage@yahoogroups.com, "c.krusen1" <ckrusen1@...> wrote:
>
> The UserFile table has two fields that might work for you. They are 'LastDate' and 'LastTime' the user logged in.
>
> A BAQ with a Query Phrase of:
> "for each UserFile where ( UserFile.LastDate = TODAY + 0) no-lock by UserFile.DcdUserID."
>
> Will return a list of all the user ID's that logged in that day. Create a BAQ Report and set it to run once a day at 11:50PM.
>
> We don't us MES, so I'm not sure how/if they'd show up.
>
> Calvin
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > Thanks George,
> > I hadn't thought about freezing modules.
> > We have several that we have never used and probably never will.
> >
> > As per licenses. Yes, I think we have more than needed.
> > I was hoping there was a way to log use, or maybe a command with output I could redirect to a text file.
> > I guess I'll do a manual count a couple times a day for a few days.
> >
> > Hmmm, now I wonder how the software keeps track of the licenses...
> >
> > --- In vantage@yahoogroups.com, "pcivantage" <vantagegroup@> wrote:
> > >
> > >
> > > You can see this if you log into the Admin Tools and then select licensing. It will show what is in use. Remember licenses are released and renewed so watch that count.
> > > Are you planning to get rid of some licenses to save money? Epicor seems to resist that and offers other ways to save, so check with them if that is your plan. You can "Freeze" modules etc. and not pay the support but if you ever want to use them again, you need to pay the back support to activat them again. Usually makes sense to just keep them IMHO.
> > >
> > > Good Luck,
> > > George Hicks
> > > Pacific Consolidated Industries
> > >
> > >
> > > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> > > >
> > > > Hi,
> > > >
> > > > I am looking for a way to build a log of the number of licenses in use.
> > > >
> > > > I suspect there are more licenses than needed.
> > > > The number was determined many years ago.
> > > > 40 users and 8 MES.
> > > > The site doesn't have nearly as many users as it did then.
> > > >
> > > > Also, wondering if anybody knows where I might I find info about when licenses are used up? Logon, ODBC connections, etc...
> > > >
> > > > Thanks...
> > > >
> > >
> >
>
7
I saw the same thing with the "manager" user id.

I also think the LastTime field is only updated when you log in, yet the "manager" user (which no one was logged in as) kept updating exactly every 2 minutes.

Also, a BAQ report is over kill. A BAQ Export Process is easier to setup.

Calvin

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> Hi Calvin,
>
> Your idea worked great.
> I was able to add this too - Count( UserFile.DcdUserID )
>
>
> BTW...
> I'm getting a count of 2 for today.
> My userID and administrator.
> I wonder if one license is really taken up by administrator all the time?
>
> Thanks
>
>
> --- In vantage@yahoogroups.com, "c.krusen1" <ckrusen1@> wrote:
> >
> > The UserFile table has two fields that might work for you. They are 'LastDate' and 'LastTime' the user logged in.
> >
> > A BAQ with a Query Phrase of:
> > "for each UserFile where ( UserFile.LastDate = TODAY + 0) no-lock by UserFile.DcdUserID."
> >
> > Will return a list of all the user ID's that logged in that day. Create a BAQ Report and set it to run once a day at 11:50PM.
> >
> > We don't us MES, so I'm not sure how/if they'd show up.
> >
> > Calvin
> >
> > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> > >
> > > Thanks George,
> > > I hadn't thought about freezing modules.
> > > We have several that we have never used and probably never will.
> > >
> > > As per licenses. Yes, I think we have more than needed.
> > > I was hoping there was a way to log use, or maybe a command with output I could redirect to a text file.
> > > I guess I'll do a manual count a couple times a day for a few days.
> > >
> > > Hmmm, now I wonder how the software keeps track of the licenses...
> > >
> > > --- In vantage@yahoogroups.com, "pcivantage" <vantagegroup@> wrote:
> > > >
> > > >
> > > > You can see this if you log into the Admin Tools and then select licensing. It will show what is in use. Remember licenses are released and renewed so watch that count.
> > > > Are you planning to get rid of some licenses to save money? Epicor seems to resist that and offers other ways to save, so check with them if that is your plan. You can "Freeze" modules etc. and not pay the support but if you ever want to use them again, you need to pay the back support to activat them again. Usually makes sense to just keep them IMHO.
> > > >
> > > > Good Luck,
> > > > George Hicks
> > > > Pacific Consolidated Industries
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> > > > >
> > > > > Hi,
> > > > >
> > > > > I am looking for a way to build a log of the number of licenses in use.
> > > > >
> > > > > I suspect there are more licenses than needed.
> > > > > The number was determined many years ago.
> > > > > 40 users and 8 MES.
> > > > > The site doesn't have nearly as many users as it did then.
> > > > >
> > > > > Also, wondering if anybody knows where I might I find info about when licenses are used up? Logon, ODBC connections, etc...
> > > > >
> > > > > Thanks...
> > > > >
> > > >
> > >
> >
>
8
If you want to log license usage, and they are concurrent, you will need to run a query on an interval getting all current users.
If you use SQL, the following query will display that information – you can schedule to run every minute or 2 into a dB table
select SYSDATETIME() as systemdate,

DATEADD(SS,lasttime,LastDate) as LastUsed,

DATEDIFF(ss , DATEADD(SS,lasttime,LastDate),SYSDATETIME() ) as time2live,

* from LicUser where
DATEDIFF(ss , DATEADD(SS,lasttime,LastDate),SYSDATETIME() ) < Timeout
order by SessionType


Motty


--- In vantage@yahoogroups.com, "c.krusen1" <ckrusen1@...> wrote:
>
> I saw the same thing with the "manager" user id.
>
> I also think the LastTime field is only updated when you log in, yet the "manager" user (which no one was logged in as) kept updating exactly every 2 minutes.
>
> Also, a BAQ report is over kill. A BAQ Export Process is easier to setup.
>
> Calvin
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > Hi Calvin,
> >
> > Your idea worked great.
> > I was able to add this too - Count( UserFile.DcdUserID )
> >
> >
> > BTW...
> > I'm getting a count of 2 for today.
> > My userID and administrator.
> > I wonder if one license is really taken up by administrator all the time?
> >
> > Thanks
> >
> >
> > --- In vantage@yahoogroups.com, "c.krusen1" <ckrusen1@> wrote:
> > >
> > > The UserFile table has two fields that might work for you. They are 'LastDate' and 'LastTime' the user logged in.
> > >
> > > A BAQ with a Query Phrase of:
> > > "for each UserFile where ( UserFile.LastDate = TODAY + 0) no-lock by UserFile.DcdUserID."
> > >
> > > Will return a list of all the user ID's that logged in that day. Create a BAQ Report and set it to run once a day at 11:50PM.
> > >
> > > We don't us MES, so I'm not sure how/if they'd show up.
> > >
> > > Calvin
> > >
> > > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> > > >
> > > > Thanks George,
> > > > I hadn't thought about freezing modules.
> > > > We have several that we have never used and probably never will.
> > > >
> > > > As per licenses. Yes, I think we have more than needed.
> > > > I was hoping there was a way to log use, or maybe a command with output I could redirect to a text file.
> > > > I guess I'll do a manual count a couple times a day for a few days.
> > > >
> > > > Hmmm, now I wonder how the software keeps track of the licenses...
> > > >
> > > > --- In vantage@yahoogroups.com, "pcivantage" <vantagegroup@> wrote:
> > > > >
> > > > >
> > > > > You can see this if you log into the Admin Tools and then select licensing. It will show what is in use. Remember licenses are released and renewed so watch that count.
> > > > > Are you planning to get rid of some licenses to save money? Epicor seems to resist that and offers other ways to save, so check with them if that is your plan. You can "Freeze" modules etc. and not pay the support but if you ever want to use them again, you need to pay the back support to activat them again. Usually makes sense to just keep them IMHO.
> > > > >
> > > > > Good Luck,
> > > > > George Hicks
> > > > > Pacific Consolidated Industries
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > I am looking for a way to build a log of the number of licenses in use.
> > > > > >
> > > > > > I suspect there are more licenses than needed.
> > > > > > The number was determined many years ago.
> > > > > > 40 users and 8 MES.
> > > > > > The site doesn't have nearly as many users as it did then.
> > > > > >
> > > > > > Also, wondering if anybody knows where I might I find info about when licenses are used up? Logon, ODBC connections, etc...
> > > > > >
> > > > > > Thanks...
> > > > > >
> > > > >
> > > >
> > >
> >
>
9
One more thing. On my system, the "manager" user is always updating. Even when no one is logged in. I verified this with an ODBC query of UserFile. My "manager" updates every 2 minutes, and now scheduled tasks have that frequency.

Calvin

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> Hi Calvin,
>
> Your idea worked great.
> I was able to add this too - Count( UserFile.DcdUserID )
>
>
> BTW...
> I'm getting a count of 2 for today.
> My userID and administrator.
> I wonder if one license is really taken up by administrator all the time?
>
> Thanks
>
>
> --- In vantage@yahoogroups.com, "c.krusen1" <ckrusen1@> wrote:
> >
> > The UserFile table has two fields that might work for you. They are 'LastDate' and 'LastTime' the user logged in.
> >
> > A BAQ with a Query Phrase of:
> > "for each UserFile where ( UserFile.LastDate = TODAY + 0) no-lock by UserFile.DcdUserID."
> >
> > Will return a list of all the user ID's that logged in that day. Create a BAQ Report and set it to run once a day at 11:50PM.
> >
> > We don't us MES, so I'm not sure how/if they'd show up.
> >
> > Calvin
> >
> > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> > >
> > > Thanks George,
> > > I hadn't thought about freezing modules.
> > > We have several that we have never used and probably never will.
> > >
> > > As per licenses. Yes, I think we have more than needed.
> > > I was hoping there was a way to log use, or maybe a command with output I could redirect to a text file.
> > > I guess I'll do a manual count a couple times a day for a few days.
> > >
> > > Hmmm, now I wonder how the software keeps track of the licenses...
> > >
> > > --- In vantage@yahoogroups.com, "pcivantage" <vantagegroup@> wrote:
> > > >
> > > >
> > > > You can see this if you log into the Admin Tools and then select licensing. It will show what is in use. Remember licenses are released and renewed so watch that count.
> > > > Are you planning to get rid of some licenses to save money? Epicor seems to resist that and offers other ways to save, so check with them if that is your plan. You can "Freeze" modules etc. and not pay the support but if you ever want to use them again, you need to pay the back support to activat them again. Usually makes sense to just keep them IMHO.
> > > >
> > > > Good Luck,
> > > > George Hicks
> > > > Pacific Consolidated Industries
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> > > > >
> > > > > Hi,
> > > > >
> > > > > I am looking for a way to build a log of the number of licenses in use.
> > > > >
> > > > > I suspect there are more licenses than needed.
> > > > > The number was determined many years ago.
> > > > > 40 users and 8 MES.
> > > > > The site doesn't have nearly as many users as it did then.
> > > > >
> > > > > Also, wondering if anybody knows where I might I find info about when licenses are used up? Logon, ODBC connections, etc...
> > > > >
> > > > > Thanks...
> > > > >
> > > >
> > >
> >
>
10
Correction:

My "manager" updates every 2 minutes, and *NO* scheduled tasks have that frequency.



--- In vantage@yahoogroups.com, "c.krusen1" <ckrusen1@...> wrote:
>
> One more thing. On my system, the "manager" user is always updating. Even when no one is logged in. I verified this with an ODBC query of UserFile. My "manager" updates every 2 minutes, and now scheduled tasks have that frequency.
>
> Calvin
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > Hi Calvin,
> >
> > Your idea worked great.
> > I was able to add this too - Count( UserFile.DcdUserID )
> >
> >
> > BTW...
> > I'm getting a count of 2 for today.
> > My userID and administrator.
> > I wonder if one license is really taken up by administrator all the time?
> >
> > Thanks
> >
> >
> > --- In vantage@yahoogroups.com, "c.krusen1" <ckrusen1@> wrote:
> > >
> > > The UserFile table has two fields that might work for you. They are 'LastDate' and 'LastTime' the user logged in.
> > >
> > > A BAQ with a Query Phrase of:
> > > "for each UserFile where ( UserFile.LastDate = TODAY + 0) no-lock by UserFile.DcdUserID."
> > >
> > > Will return a list of all the user ID's that logged in that day. Create a BAQ Report and set it to run once a day at 11:50PM.
> > >
> > > We don't us MES, so I'm not sure how/if they'd show up.
> > >
> > > Calvin
> > >
> > > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> > > >
> > > > Thanks George,
> > > > I hadn't thought about freezing modules.
> > > > We have several that we have never used and probably never will.
> > > >
> > > > As per licenses. Yes, I think we have more than needed.
> > > > I was hoping there was a way to log use, or maybe a command with output I could redirect to a text file.
> > > > I guess I'll do a manual count a couple times a day for a few days.
> > > >
> > > > Hmmm, now I wonder how the software keeps track of the licenses...
> > > >
> > > > --- In vantage@yahoogroups.com, "pcivantage" <vantagegroup@> wrote:
> > > > >
> > > > >
> > > > > You can see this if you log into the Admin Tools and then select licensing. It will show what is in use. Remember licenses are released and renewed so watch that count.
> > > > > Are you planning to get rid of some licenses to save money? Epicor seems to resist that and offers other ways to save, so check with them if that is your plan. You can "Freeze" modules etc. and not pay the support but if you ever want to use them again, you need to pay the back support to activat them again. Usually makes sense to just keep them IMHO.
> > > > >
> > > > > Good Luck,
> > > > > George Hicks
> > > > > Pacific Consolidated Industries
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > I am looking for a way to build a log of the number of licenses in use.
> > > > > >
> > > > > > I suspect there are more licenses than needed.
> > > > > > The number was determined many years ago.
> > > > > > 40 users and 8 MES.
> > > > > > The site doesn't have nearly as many users as it did then.
> > > > > >
> > > > > > Also, wondering if anybody knows where I might I find info about when licenses are used up? Logon, ODBC connections, etc...
> > > > > >
> > > > > > Thanks...
> > > > > >
> > > > >
> > > >
> > >
> >
>