PDA

View Full Version : ISPConfig Mail ID and Reports


mphayesuk
31st October 2005, 13:35
1. Ok you can have web[webid] as the tag for usernames when setting up mail accounts, are there anyother settings you can have in instead of [webid].

2. Are there any reports that can be run off the system.

till
31st October 2005, 15:12
1) [domain] It is documented in the manual. But you might get problems with long domain names.

2) Which type of reports, statistics?

mphayesuk
31st October 2005, 15:21
1) Fair enough I will have a look ect.....

2) Yeah reports to for example list all sites under clients under resellers and to list traffic stats quota stats mail traffic stats mail storage stats ect...

So you might have:
Reseller1
Customer1
Site1 - traffic MB - storage MB -
Site2 - traffic MB - storage MB -

Something like that, if not perhaps add it into the next version

Is the raw data stored somewhere in log files or in the mysql database.

Thanks

falko
31st October 2005, 16:02
2) Yeah reports to for example list all sites under clients under resellers and to list traffic stats quota stats mail traffic stats mail storage stats ect...

So you might have:
Reseller1
Customer1
Site1 - traffic MB - storage MB -
Site2 - traffic MB - storage MB -

Something like that, if not perhaps add it into the next version

Is the raw data stored somewhere in log files or in the mysql database.

Thanks
That's already implemented, have a look on the Statistics tab of a web site, a client and a reseller.

The data is extracted from the log files and stored in the MySQL database.

mphayesuk
31st October 2005, 16:13
Yeah I have seen it on screen I was wondering if there was a full report that you could pull off.

i.e. I want to look at the usage every month of every reseller, and then perhaps every client and if needed every site. And in total I have 500 sites, I dont want to have to go and look at every site so that I can print off the stats.

So I print-out would be much easier so I can skim down the sheet and have a quick look at what is what.

Do you get what I mean and what I am after?

Thanks

falko
31st October 2005, 17:01
You could write a script that generates the output in a printer-friendly way. The traffic is stored in the isp_traffic table in the ISPConfig database.

mphayesuk
7th November 2005, 13:29
Hi there are no details of web[webid] and other values I can have in the manual... is domain the only other one you can have.

Thanks

till
7th November 2005, 14:07
Hi there are no details of web[webid] and other values I can have in the manual... is domain the only other one you can have.

Thanks

The options currently available are:

[WEBID] => e.g. 1
[DOMAIN] => e.g. mydomain.com
[HOST] => e.g. www
[HOSTDOMAIN] => e.g. www.mydomain.com

if the host is empty, hostdomain contains the same as domain.

mphayesuk
11th November 2005, 16:51
Perhaps for the next version or next update I think it would be helpfull to have as an option "client user name" as well as all the others..... Perhaps???

till
11th November 2005, 18:46
Not a good idea i think, because when the client has more than one web, the usernames will collide.