User log Blank Title 91612

Yahoo Archive
1
Good Morning Brian,

Thanks so much for the info.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian W. Spolarich
Sent: Tuesday, July 06, 2010 4:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] User log



SELECT * FROM dbo.licuser

You can ignore sessiontype = 'PS' as that's for printing and doesn't
count against your licenses.

Sessiontype = 'DC' indicates an MES session. If its blank it's a
regular session.

You could create some queries and archive the results however you like
to compare over time. You could setup a scheduled task in the SQL Task
Agent that would insert the results of a query against this table into a
separate database for trending, etc.

You could also add a trigger on the table in your custom db so that if
the value you insert into the column representing the number of active
sessions is too high you could get an e-mail. There are examples for
sending e-mail via triggers in MSSQL 2005.

e.g. http://www.4guysfromrolla.com/webtech/tips/t051706-1.shtml

-brian


-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Hernandez, Dolores
Sent: Tuesday, July 06, 2010 5:21 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] User log

Hello everyone,

We are on 8.03.409 - SQL server and we are trying to find a way to see
the history of the number of users signed on at any given day/time and,
but have not been able to do so. We also want to see if we could have
some kind of alert that would let us know when we are getting close to
maximum limit with our license.

Just talked to Epicor and they told me that it would require a custom
program.

Does anyone know of a way to do this?

Thank you much,
_______________________________________________
Dolores Hernandez
Le Sueur, Inc.
ERP Systems Administrator
507-665-6204 x248

[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/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]
2
Hello everyone,

We are on 8.03.409 - SQL server and we are trying to find a way to see the history of the number of users signed on at any given day/time and, but have not been able to do so. We also want to see if we could have some kind of alert that would let us know when we are getting close to maximum limit with our license.

Just talked to Epicor and they told me that it would require a custom program.

Does anyone know of a way to do this?

Thank you much,
_______________________________________________
Dolores Hernandez
Le Sueur, Inc.
ERP Systems Administrator
507-665-6204 x248



[Non-text portions of this message have been removed]
3
SELECT * FROM dbo.licuser

You can ignore sessiontype = 'PS' as that's for printing and doesn't
count against your licenses.

Sessiontype = 'DC' indicates an MES session. If its blank it's a
regular session.

You could create some queries and archive the results however you like
to compare over time. You could setup a scheduled task in the SQL Task
Agent that would insert the results of a query against this table into a
separate database for trending, etc.

You could also add a trigger on the table in your custom db so that if
the value you insert into the column representing the number of active
sessions is too high you could get an e-mail. There are examples for
sending e-mail via triggers in MSSQL 2005.

e.g. http://www.4guysfromrolla.com/webtech/tips/t051706-1.shtml

-brian


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Hernandez, Dolores
Sent: Tuesday, July 06, 2010 5:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] User log

Hello everyone,

We are on 8.03.409 - SQL server and we are trying to find a way to see
the history of the number of users signed on at any given day/time and,
but have not been able to do so. We also want to see if we could have
some kind of alert that would let us know when we are getting close to
maximum limit with our license.

Just talked to Epicor and they told me that it would require a custom
program.

Does anyone know of a way to do this?

Thank you much,
_______________________________________________
Dolores Hernandez
Le Sueur, Inc.
ERP Systems Administrator
507-665-6204 x248



[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/.
(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