Hi,

we are facing problem with the sql queries given below
query number one gives the output as workstation and total logon failure
attempts from that workstation
which is fine
1) select logonsvr,workstnid, count (username) from winadlogon where
evtid="681" group by workstnid order by workstnid;

query number 2 is generating list
username-workstnid-hits from the user
e.g.
userA-workstation A- 3
userB-Workstation A -2
userc-workstation B -1

2)select time,workstnid,username count (username) from winadlogon where
evtid="681" group by username order by workstnid;

as shown in above example we are getting the list.
If user A also has attempted login from workstation B the it is not
displayed as we have done grouping by username.

we need output such as
userA-workstation A -3
userA-workstation B -2

if user is attempling log on from various workstations the this query
should show all entries for the user for all workstations from where it
has tried log on and hits from each workstation logon and while group by
username is in place.
please suggest if there is any solution to this problem.


Thanks,
Narasimha
-----Original Message-----
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 3:00 PM
To: mysql@lists.mysql.com
Subject: Re: Wrong bytesec nightmare!

Hello.

You may use --extend-check option with myisamchk, but
usually it finds a lot of garbage, and should be used as
a last resort.



Francisco Lopez <[EMAIL PROTECTED]> wrote:
> Hello all,
> I am getting quite desperate on this, since I've been trying to
recover 
> my diary of a whole year of travelling which was stored in a MyISAM 
> table for a couples of weeks now! The MySQL server was running in a XP

> machine and suddenly the hard disk crashed starting my particular 
> nightmare. I had to use recovery tools to scan the disk and I thought
I 
> was saved when I found the *.frm, *.MYI and *.MYD files and was able
to 
> recover them, but when I tried get the tables back into MySQL and 
> backup their contents, I found a series of errors that have kept me 
> down ever since!
> The first complain I got when I selected the table was:
>
> Didn't find any fields in table 'news'
>
> I then checked the table for errors, and got:
>
> mysql> check table news;
> +----------+-------+--------

--
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]




Confidentiality Notice

The information contained in this electronic message and any attachments to 
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or 
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL 
PROTECTED] immediately
and destroy all copies of this message and any attachments.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to