help querying / visualizing log tables

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

help querying / visualizing log tables

Author

Topic

mike123
Master Smack Fu Yak Hacker

1462 Posts

Posted - 2008-12-23 : 08:39:08

Hi,

I have some tables in my database that I would like to visualize better. I'm not sure the best way to do this. I want to visualize as much as possible.

I run stats against this query that shows the amount of users that login per day etc. But it would be really cool to see stats that incorporate more advanced stuff like showing, average logins per user etc, basically anything imaginable.

Are there any programs that can plug into a table and do something like this ? Any templated queries available ?

hopefully this post makes sense. To sum it up I am not specific about exactly what I need, but since its a loggin table based one 1 ID and a datetime, perhaps theres some advanced queries out there that will fit this case.

I can imagine sites like facebook etc, have their login tables turned into some sort of graph so they can watch growth etc very accurately.

Any suggestions greatly appreciated !

CREATE TABLE [dbo].[tblLogins_Log](
[loginID] [int] IDENTITY(1,1) NOT NULL,
[userID] [int] NULL,
[IP] [varchar](15) NOT NULL,
[loginDate] [datetime] NOT NULL,
[countryCode] [varchar](3) NULL
) ON [PRIMARY]

GO

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-23 : 09:14:57

I guess you can use Reporting Services in SQL Server to visualize more about your requirements.