Kill user sessions

I have been having a look at the progress.open4gl.dynamicapi.sessionpool to try and get a list of sessions. If I can I should be able to disconnect them using vb code.
That was using the progress.04glrt.dll


Cheers,

Ross

Sent from my iPad

On 11 Dec 2012, at 15:11, Greg Payne <gpayne@...> wrote:

> I see the In Use License users in the LicUser table in sql. I don’t see the sessions that are marked as available, although those would probably not be an issue.
>
> Greg Payne
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ross Robertson
> Sent: Tuesday, December 11, 2012 9:37 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Re: Kill user sessions
>
>
>
> Hi,
>
> The issue that we have is that we only let all staff have a single user session due to the license count we have. I need to try and find a way of getting rid of the sessions as when they try and log in they can get a message only allowed one session.
> I know it's the users fault for not logging out.
> I have been looking at this today but still no joy.
>
> Cheers,
>
> Ross
>
> Sent from my iPad
>
> On 11 Dec 2012, at 13:59, "jgiese1988" <epicor-team@...<mailto:epicor-team%40wisconsinconverting.com>> wrote:
>
> > Is there any harm in killing active sessions other than that those people will be booted out with errors. (I think the same happens if you delete their sessions too)
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, John Driggers <waffqle@...<mailto:waffqle@...>> wrote:
> > >
> > > The idle user session shouldn't really present any danger. I'd just go
> > > ahead and kill the app servers and not worry about them.
> > >
> > > *John Driggers*
> > > **
> > > *Chief Data Wrangler*
> > > *
> > > *
> > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> > > *
> > > *:: 904.404.9233
> > > :: waffqle@...
> > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > >
> > > *
> > >
> > > *
> > >
> > >
> > >
> > > On Tue, Dec 11, 2012 at 3:45 AM, Ross Robertson <
> > > ross_robertson@...> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Dear all,
> > > >
> > > > I hope that someone is able to help. I am currently working on writing a
> > > > script that restarts the database and app servers. This seems to work well
> > > > but I would like to tidy up one thing.
> > > > We have a number of users that go home and don't log out of vantage. I
> > > > have tried a number of settings such as trying to time out the session etc
> > > > but the connection will always show as being connected and using a licence
> > > > up when you check under the vantage admin tools. I then end up having to
> > > > delete this session manually.
> > > > Is it possible to write something in vb to clear these user sessions out
> > > > just before I shut down the app servers and database and then start them up
> > > > again.
> > > >
> > > > We are on vantage 8 using a progress DB. I have been having a look at the
> > > > blconnectionpool and session .dll files to see if I can find a method to
> > > > get a list of current client sessions? I noticed a progress .dll file? I
> > > > don't know if anyone has tries this before.
> > > >
> > > > Cheers,
> > > >
> > > > Ross
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
>
> [Non-text portions of this message have been removed]
>
>


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

I hope that someone is able to help. I am currently working on writing a script that restarts the database and app servers. This seems to work well but I would like to tidy up one thing.
We have a number of users that go home and don't log out of vantage. I have tried a number of settings such as trying to time out the session etc but the connection will always show as being connected and using a licence up when you check under the vantage admin tools. I then end up having to delete this session manually.
Is it possible to write something in vb to clear these user sessions out just before I shut down the app servers and database and then start them up again.

We are on vantage 8 using a progress DB. I have been having a look at the blconnectionpool and session .dll files to see if I can find a method to get a list of current client sessions? I noticed a progress .dll file? I don't know if anyone has tries this before.


Cheers,

Ross
The idle user session shouldn't really present any danger. I'd just go
ahead and kill the app servers and not worry about them.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Tue, Dec 11, 2012 at 3:45 AM, Ross Robertson <
ross_robertson@...> wrote:

> **
>
>
> Dear all,
>
> I hope that someone is able to help. I am currently working on writing a
> script that restarts the database and app servers. This seems to work well
> but I would like to tidy up one thing.
> We have a number of users that go home and don't log out of vantage. I
> have tried a number of settings such as trying to time out the session etc
> but the connection will always show as being connected and using a licence
> up when you check under the vantage admin tools. I then end up having to
> delete this session manually.
> Is it possible to write something in vb to clear these user sessions out
> just before I shut down the app servers and database and then start them up
> again.
>
> We are on vantage 8 using a progress DB. I have been having a look at the
> blconnectionpool and session .dll files to see if I can find a method to
> get a list of current client sessions? I noticed a progress .dll file? I
> don't know if anyone has tries this before.
>
> Cheers,
>
> Ross
>
>


[Non-text portions of this message have been removed]
Is there any harm in killing active sessions other than that those people will be booted out with errors. (I think the same happens if you delete their sessions too)

--- In vantage@yahoogroups.com, John Driggers <waffqle@...> wrote:
>
> The idle user session shouldn't really present any danger. I'd just go
> ahead and kill the app servers and not worry about them.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
>
>
> On Tue, Dec 11, 2012 at 3:45 AM, Ross Robertson <
> ross_robertson@...> wrote:
>
> > **
> >
> >
> > Dear all,
> >
> > I hope that someone is able to help. I am currently working on writing a
> > script that restarts the database and app servers. This seems to work well
> > but I would like to tidy up one thing.
> > We have a number of users that go home and don't log out of vantage. I
> > have tried a number of settings such as trying to time out the session etc
> > but the connection will always show as being connected and using a licence
> > up when you check under the vantage admin tools. I then end up having to
> > delete this session manually.
> > Is it possible to write something in vb to clear these user sessions out
> > just before I shut down the app servers and database and then start them up
> > again.
> >
> > We are on vantage 8 using a progress DB. I have been having a look at the
> > blconnectionpool and session .dll files to see if I can find a method to
> > get a list of current client sessions? I noticed a progress .dll file? I
> > don't know if anyone has tries this before.
> >
> > Cheers,
> >
> > Ross
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Hi,

The issue that we have is that we only let all staff have a single user session due to the license count we have. I need to try and find a way of getting rid of the sessions as when they try and log in they can get a message only allowed one session.
I know it's the users fault for not logging out.
I have been looking at this today but still no joy.

Cheers,

Ross

Sent from my iPad

On 11 Dec 2012, at 13:59, "jgiese1988" <epicor-team@...> wrote:

> Is there any harm in killing active sessions other than that those people will be booted out with errors. (I think the same happens if you delete their sessions too)
>
> --- In vantage@yahoogroups.com, John Driggers <waffqle@...> wrote:
> >
> > The idle user session shouldn't really present any danger. I'd just go
> > ahead and kill the app servers and not worry about them.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> >
> >
> > On Tue, Dec 11, 2012 at 3:45 AM, Ross Robertson <
> > ross_robertson@...> wrote:
> >
> > > **
> > >
> > >
> > > Dear all,
> > >
> > > I hope that someone is able to help. I am currently working on writing a
> > > script that restarts the database and app servers. This seems to work well
> > > but I would like to tidy up one thing.
> > > We have a number of users that go home and don't log out of vantage. I
> > > have tried a number of settings such as trying to time out the session etc
> > > but the connection will always show as being connected and using a licence
> > > up when you check under the vantage admin tools. I then end up having to
> > > delete this session manually.
> > > Is it possible to write something in vb to clear these user sessions out
> > > just before I shut down the app servers and database and then start them up
> > > again.
> > >
> > > We are on vantage 8 using a progress DB. I have been having a look at the
> > > blconnectionpool and session .dll files to see if I can find a method to
> > > get a list of current client sessions? I noticed a progress .dll file? I
> > > don't know if anyone has tries this before.
> > >
> > > Cheers,
> > >
> > > Ross
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>


[Non-text portions of this message have been removed]
I see the In Use License users in the LicUser table in sql. I don’t see the sessions that are marked as available, although those would probably not be an issue.

Greg Payne

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ross Robertson
Sent: Tuesday, December 11, 2012 9:37 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Kill user sessions



Hi,

The issue that we have is that we only let all staff have a single user session due to the license count we have. I need to try and find a way of getting rid of the sessions as when they try and log in they can get a message only allowed one session.
I know it's the users fault for not logging out.
I have been looking at this today but still no joy.

Cheers,

Ross

Sent from my iPad

On 11 Dec 2012, at 13:59, "jgiese1988" <epicor-team@...<mailto:epicor-team%40wisconsinconverting.com>> wrote:

> Is there any harm in killing active sessions other than that those people will be booted out with errors. (I think the same happens if you delete their sessions too)
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, John Driggers <waffqle@...<mailto:waffqle@...>> wrote:
> >
> > The idle user session shouldn't really present any danger. I'd just go
> > ahead and kill the app servers and not worry about them.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> >
> >
> > On Tue, Dec 11, 2012 at 3:45 AM, Ross Robertson <
> > ross_robertson@...> wrote:
> >
> > > **
> > >
> > >
> > > Dear all,
> > >
> > > I hope that someone is able to help. I am currently working on writing a
> > > script that restarts the database and app servers. This seems to work well
> > > but I would like to tidy up one thing.
> > > We have a number of users that go home and don't log out of vantage. I
> > > have tried a number of settings such as trying to time out the session etc
> > > but the connection will always show as being connected and using a licence
> > > up when you check under the vantage admin tools. I then end up having to
> > > delete this session manually.
> > > Is it possible to write something in vb to clear these user sessions out
> > > just before I shut down the app servers and database and then start them up
> > > again.
> > >
> > > We are on vantage 8 using a progress DB. I have been having a look at the
> > > blconnectionpool and session .dll files to see if I can find a method to
> > > get a list of current client sessions? I noticed a progress .dll file? I
> > > don't know if anyone has tries this before.
> > >
> > > Cheers,
> > >
> > > Ross
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>

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


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


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