Logging in mssql and reporting with ms Reporting Service

All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
Post Reply
frbo
Posts: 6
Joined: Thu May 28, 2009 2:09 am

Logging in mssql and reporting with ms Reporting Service

Post by frbo »

Dear,

is there anyone who have already tried to log in to a mssql database and make reports with the ms reporting server.

Frederik
violant
Posts: 51
Joined: Sat Apr 25, 2009 1:23 pm
Location: Ukraine

Post by violant »

I login to MYSQL (by ODBC). Use PHP+IIS to generate report. Daily report sorting by test name and time (colored), and form with checkbox-testname and report period (start-end date). Very simple select to DB. For backup use mysqldump.
There is some problem:
1)When I change testname I need see log by old and new name separetly. I must rename old entries in table for old log.
2)List of all test that running now without old testname. I use log midnight and when status change. So I need everyday to generate list of all actual testname by select all midnight testname to another table. That all for create checkbox-list.
frbo
Posts: 6
Joined: Thu May 28, 2009 2:09 am

Post by frbo »

do you use odbc as a primary log our do you have a alert profile with a sql satement.

How many data do you generate in your database
violant
Posts: 51
Joined: Sat Apr 25, 2009 1:23 pm
Location: Ukraine

Post by violant »

I use it as primary log.
If I dont want see some row in log html I dont select it, but insert in log table in DB.
about 200 test
450 row in a day (only change status and midnight login)
mysql dump = 2,5 Mb/month
Post Reply