Good Day:
Suddenly, I am remembering that Country-Western song about the
SQuirreL that got loose in the meeting house during services.
Len
________________________________
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf
Of Tom J. Christie
Sent: Wednesday, November 21, 2012 11:02 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Monitor Epicor Sessions/Licenses
The name is more fun to throw around at the office?
From:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Ted Koch
Sent: Wednesday, November 21, 2012 8:27 AM
To:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Monitor Epicor Sessions/Licenses
Is there any benefit to using SquirreL instead of the Administration
Console?
________________________________
From: Vic Drecchio <
vic.drecchio@...
<mailto:vic.drecchio%40swepcotube.com>
<mailto:vic.drecchio%40swepcotube.com>>
To:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Wednesday, November 21, 2012 10:24 AM
Subject: RE: [Vantage] Monitor Epicor Sessions/Licenses
It's part of the Epicor db. Not listed in the data dictionary.
Querying/viewing with Access shouldn't be a problem. In SQuirreL I just
did
a "SELECT * FROM PUB.LICUSER" and it works fine.
From:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:
vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf Of
Len Hartka
Sent: Wednesday, November 21, 2012 10:11 AM
To:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Monitor Epicor Sessions/Licenses
Good Day Vic:
I do not see LicUser in list of files in the Data-Dictionary-Viewer-
I am not surprised.
Where is it located? Server? Directory?
Do you think I could Import it into ACCESS?
Len
________________________________
From:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf
Of Vic Drecchio
Sent: Wednesday, November 21, 2012 9:40 AM
To:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Monitor Epicor Sessions/Licenses
You can still query the table with SQuirreL or something similar.
From:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Ted Koch
Sent: Wednesday, November 21, 2012 8:40 AM
To:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Monitor Epicor Sessions/Licenses
Thanks Brian, unfortunately only Progress.
________________________________
From: Brian Roberts <
broberts@... <mailto:broberts%40gfxltd.com>
<mailto:broberts%40gfxltd.com> <mailto:broberts%40gfxltd.com>
<mailto:broberts%40gfxltd.com>
<mailto:broberts%40gfxltd.com> >
To: "
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> "
<
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> >
Sent: Wednesday, November 21, 2012 8:37 AM
Subject: RE: [Vantage] Monitor Epicor Sessions/Licenses
If you are on SQL, look at the LicUser table.
It includes both active & inactive sessions, this where clause will find
only the active ones: WHERE DATEDIFF(SS, DATEADD(SS, LastTime,
LastDate),
GETDATE()) < [TimeOut]
Brian.
From:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of tkoch77
Sent: Tuesday, November 20, 2012 6:22 PM
To:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Monitor Epicor Sessions/Licenses
Other than the Epicor Administration Console, is there any other way to
see
how licenses are being consumed? We are trying to determine how many
licenses we need to purchase.
Thanks,
-Ted
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/gr
oup/vantage/files/>
<
http://groups.yahoo.com/group/vantage/files/>
<
http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2629/5407 - Release Date:
11/20/12
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2629/5409 - Release Date:
11/21/12
[Non-text portions of this message have been removed]
This e-mail and any attachments may contain proprietary and/or
confidential
information. If you are not the intended recipient, please notify the
sender
immediately by reply e-mail or at 410-472-2900 and then delete the
message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.
[Non-text portions of this message have been removed]
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2629/5409 - Release Date:
11/21/12
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2629/5409 - Release Date:
11/21/12
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/gr
oup/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
[Non-text portions of this message have been removed]