Getting Statistics from Now Wap

Getting Statistics from Now Wap SearchSearch
Author Message
Togo WAP
New member
Username: Togo31

Post Number: 1
Registered: 01-2011
Posted on Monday, January 10, 2011 - 08:42 pm:   

Hello All,

Is there a way to get statistics form the "Service" tab of the Now.Wap main window. Like which has been the maximun number of users for one week or the number of session during a regular day or the availability of the service, and others


I would also like to know if I can save a history of it.

Please let me know where to get this info or how the configure the application to do it.

Best Regards,

togo
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 2824
Registered: 08-2008
Posted on Wednesday, January 12, 2011 - 08:30 pm:   

Hi Togo,

Have you tried the "Reports" page?

--
Des
NowSMS Support
Togo WAP
New member
Username: Togo31

Post Number: 2
Registered: 01-2011
Posted on Friday, January 14, 2011 - 11:06 pm:   

Hi Des,

The Reports tab provide the information of a day before, what I need is to see the information all day long, lets say a graphic of these statistics.

At the same time I would like to get a graphic of sessions usage during the day.

Is there a way to do this? Can you provide me a query to look for the info in the database.

Best Regards

Togo
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 2834
Registered: 08-2008
Posted on Monday, January 17, 2011 - 02:05 pm:   

Hi Togo,

I'm not an expert in SQL, and unfortunately my colleague who is, is on vacation this week. So I will give a more detailed reply next week.

What I can tell you is that previous day log files get converted to an SQLite database format. (The current day log remains in text format until the day is over.)

You might want to download SQLite from www.sqlite.org, and run sqlite3.exe against the database to become familiar with the format. I believe the date time stamp is stored as a YYYYMMDDHHMMSS format which may make it more challenging to develop queries to count requests by hour. Maybe this will help you get started. When my colleague gets back I will ask him to provide more detail and examples.

--
Des
NowSMS Support
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 3146
Registered: 08-2008
Posted on Thursday, May 05, 2011 - 06:46 pm:   

Belated follow-up ...

My colleague posted some details on the database format here:

http://support.nowsms.com/discus/messages/131/70109.html

Add Your Message Here, or click here to start a new topic.
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image
Options: Automatically activate URLs in message
Action: