Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

number login events(45) inferior than logout events(46

3 posts in General Discussion Last posting was on 2009-09-28 13:11:11.0Z
Xavier Posted on 2009-09-22 15:29:14.0Z
From: "xavier" <renco_tac@yahoo.fr>
Newsgroups: sybase.public.ase.general
Organization: 130.214.40.129
X-Newsreader: AspNNTP 1.50 (JodoHost)
Subject: number login events(45) inferior than logout events(46
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ab8ed4a$1@forums-1-dub>
Date: 22 Sep 2009 08:29:14 -0700
X-Trace: forums-1-dub 1253633354 10.22.241.152 (22 Sep 2009 08:29:14 -0700)
X-Original-Trace: 22 Sep 2009 08:29:14 -0700, vip152.sybase.com
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28345
Article PK: 77591

Hi,
I'm auditing server and observe that for a given loginname I allways have the
number of login events(45) inferior to the number of logout events(46).

Events:
45 = Any login to Adaptive Server
46 = Any logouts from Adaptive Server

1> select count(*)
2> from sybsecurity.dbo.sysaudits_02
where event in (45)
and loginname = 'user_pim'
and eventtime between '20090913' and '20090913 11:59:59 PM'

select count(*)
from sybsecurity.dbo.sysaudits_02
where event in (46)
and loginname = 'user_pim'
and eventtime between '20090913' and '20090913 11:59:59 PM'
3> 4> 5> 6> 7> 8> 9> 10> 11> 12>
13> go

-----------
40

(1 row affected)

-----------
388507

(1 row affected)

Any advice ?

Thanks in advance,
Xavier
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


Cory Sane [TeamSybase] Posted on 2009-09-23 11:54:07.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4ab8ed4a$1@forums-1-dub>
In-Reply-To: <4ab8ed4a$1@forums-1-dub>
Subject: Re: number login events(45) inferior than logout events(46
Lines: 47
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4aba0c5f$1@forums-1-dub>
Date: 23 Sep 2009 04:54:07 -0700
X-Trace: forums-1-dub 1253706847 10.22.241.152 (23 Sep 2009 04:54:07 -0700)
X-Original-Trace: 23 Sep 2009 04:54:07 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28349
Article PK: 77593

Are they in sysaudits_01?
What is the first & last eventdate in sysaudits_02?


--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

"xavier" <renco_tac@yahoo.fr> wrote in message news:4ab8ed4a$1@forums-1-dub...
> Hi,
> I'm auditing server and observe that for a given loginname I allways have the
> number of login events(45) inferior to the number of logout events(46).
>
> Events:
> 45 = Any login to Adaptive Server
> 46 = Any logouts from Adaptive Server
>
> 1> select count(*)
> 2> from sybsecurity.dbo.sysaudits_02
> where event in (45)
> and loginname = 'user_pim'
> and eventtime between '20090913' and '20090913 11:59:59 PM'
>
> select count(*)
> from sybsecurity.dbo.sysaudits_02
> where event in (46)
> and loginname = 'user_pim'
> and eventtime between '20090913' and '20090913 11:59:59 PM'
> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12>
> 13> go
>
> -----------
> 40
>
> (1 row affected)
>
> -----------
> 388507
>
> (1 row affected)
>
> Any advice ?
>
> Thanks in advance,
> Xavier
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp


Kon T. Amusse Posted on 2009-09-28 13:11:11.0Z
From: "Kon T. Amusse" <kon.t@amusse.invalid>
Newsgroups: sybase.public.ase.general
Subject: Re: number login events(45) inferior than logout events(46
Date: Mon, 28 Sep 2009 15:11:11 +0200
Organization: A noiseless patient Spider
Lines: 9
Message-ID: <h9qclh$vvo$1@news.eternal-september.org>
References: <4ab8ed4a$1@forums-1-dub>
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Trace: news.eternal-september.org U2FsdGVkX18mV71ovq2hVQcgJYGDy+7jm1CDWahCgc0bLKvsjRW+9EtCJ5ZIS0zM3dAxh1DrIvvtvvR3jMR1kEh0N8ENVEVy3Do1xrMU86mrqItKw+oPYPAFiShZdSWA5L+rASBCbgcH6oPpYvjAugNNd6ZWrYbw
X-Complaints-To: abuse@eternal-september.org
NNTP-Posting-Date: Mon, 28 Sep 2009 13:11:13 +0000 (UTC)
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
In-Reply-To: <4ab8ed4a$1@forums-1-dub>
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-Auth-Sender: U2FsdGVkX19rHO7UQ3C7swCRQ7mAqX82GidxQ4NGbRiXdS+MJKb72w==
Cancel-Lock: sha1:dkOs+fsi8TPZOvPGbob9Oddd1gI=
X-Priority: 3
X-MSMail-Priority: Normal
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!newsfeed.news2me.com!news.glorb.com!news2.glorb.com!news.glorb.com!feeder.erje.net!feeder.eternal-september.org!eternal-september.org!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28377
Article PK: 77622

----- Original Message -----

> Hi,
> I'm auditing server and observe that for a given loginname I allways have
> the
> number of login events(45) inferior to the number of logout events(46).

Is it possible that at the beginning of the period someone was already
logged in, and logged out during the period?