Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

www.webdp.net, Event 9 IIS log failed to write entry, wwwxxx jeffs, Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download, /proc/kallsyms format

Links

XODOX
Impressum

#1: Query for details

Posted on 2008-04-25 06:31:15 by sivasakthi

--=-OwV9yavCetlfEPftdR3z
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Hi all,


I have one table as following

AccessDetails

Date Time UserName
SiteName Status Virus_Category

|2008-04-23 | 14:27:38 | 172.16.1.40 |
en.wikipedia.org | A | unclassified |
| 2008-04-23 | 14:27:39 | 172.16.1.40 |
en.wikipedia.org | A | unclassified |
| 2008-04-23 | 14:27:40 | 172.16.1.92 | www.google.com
| D | Internet |
| 2008-04-23 | 14:27:40 | 172.16.1.40 | en.wikipedia.org
| A | unclassified |
| 2008-04-23 | 14:27:41 | 172.16.1.40 |
en.wikipedia.org | O | Internet |
| 2008-04-23 | 14:27:42 | 172.16.1.40 |
en.wikipedia.org | A | unclassified |
| 2008-04-23 | 14:27:42 | 172.16.1.40 |
en.wikipedia.org | O | unclassified |
| 2008-04-23 | 14:27:43 | 172.16.1.40 |
en.wikipedia.org | A | unclassified |
| 2008-04-23 | 14:27:43 | 172.16.1.40 |
meta.wikimedia.org | A | unclassified |
| 2008-04-23 | 14:27:47 | 172.16.1.34 |
googletb.skype.com | D | unclassified |


from the above table , i need the details of , how many total users,
how total accessed sited,how many total denied sites ,how many total
overridden sites and how many total sites(accessed+denied+overridden)
for particular Virus_Category with Date and Time.

In above table the Status shows A for accessed sites, D for Denied
sites,O for Overridden sites..


how can i form the query??


Thanks,


--=-OwV9yavCetlfEPftdR3z--

Report this message