System information

CAST(mstr.physical_name AS VARCHAR(72)) AS 'File',
stats.num_of_reads,
stats.num_of_bytes_read/1000000 as 'MB read',
stats.num_of_writes,
stats.num_of_bytes_written/1000000 as 'MB write',
stats.size_on_disk_bytes/1000000 as 'MB size'
FROM sys.dm_io_virtual_file_stats(null,null) AS stats
join sys.master_files AS mstr
ON mstr.database_id = stats.database_id
and mstr.FILE_ID = stats.FILE_ID
WHERE DB_NAME(mstr.database_id) = 'tempdb' or
DB_NAME(mstr.database_id) = 'mserver';
go
5.111. How to recalculate the prices for certain cdr
This can be done with the “rebill” command from the server console.
From the MizuManage open the Server Console form and click on connect.
Then enter rebill,days,datefrom,dateto,usertype,childfor
For example the following command will recalculate all pricing for endusers whose parent is user with id 854 between Sept 1 and 30 in 2011.
rebill,,9/1/2011 00:00:00,9/31/2011 23:59:59,0,854
The following command will recalculate the billing for all users in the last 2 days (48 hours):
rebill,2
5.112. How to create different webportal for different resellers
Under the server app directory create a new folder and inside this folder create separate folders for each of your resellers which needs a separate webportal.
Copy the following files in these folders:
-webservice.exe
-mizuserver.ini
-the “Files” directory
-loginimage.jpg or loginimage.gif
-
webphone.jar