|
Amphis - BizMonitor v1.1 - Support Pages
monitor key business information
latest version v1.1 Build 1 released 6th October 2008
|
Email Customer Support
If you cannot find the answer to your problem on the Support Pages,
please click
here
to email customer support.
To check if you have the latest version installed, please select the Help->Help About menu option. You should see the version number like this.
If you are evaluating Amphis - BizMonitor and you have an older version than 1.1.1 we recommend that you uninstall your current version and install the latest version for your evaluation. You can download the latest version from
here.
If you have already paid for a license for an earlier version, you can upgrade for free to this version, but please email customer support for help with upgrading to this latest version.
Frequently Asked Questions (FAQ)
I'm having problems installing or running Amphis BizMonitor on Windows Vista
What URL do I need to browse to in order to see the data ?
I'm trying to use the default folder c:\inetpub\wwwroot but it doesn't exist
How do I specify which fields I want to monitor ?
Why aren't the html web pages being created ?
How do I start or restart the Amphis BizMonitor windows service ?
Why are values displayed as a question mark ?
Problems with installation
How do I specify which fields I want to monitor ?
First of all, you need to run the Amphis BizMonitor Config application and specify on page 1 which database you wish to monitor.
Then, on page 2 you can specify which fields to monitor. This is done by entering a SQL statement for each field you wish to monitor.
You can monitor things like :-
The count of new entries in the last hour eg for "Number of new User registrations in the last hour".
The total value of entries created in the last hour eg for "Total sales in the last hour".
The total number of entries in a table eg for "Total number of users".
The BizMonitor application requires that you return the result in a "result" field. Here are some example SQL queries that you could use. Please note that the exact SQL you need depends on the schema of your database.
Total number of users
select count(*) as result from users
(the above example shows the total number of users in the database)
New registrations
select count(*) as result from users where datecreated > dateadd('h',-1,now())
(the above example shows the total number of users created in the last hour)
Total sales
select sum(total) as result from sales
(the above example shows the total value of all sales in the database)
Sales this hour
select sum(total) as result from sales where datecreated > dateadd('h',-1,now())
(the above example shows the total value of sales created in the last hour)
Current Status
select status as result from summary
(the above example shows the current value of the status field)
What URL do I need to browse to in order to see the data ?
By default the URL on Windows XP is
C:\Documents and Settings\All Users\Application Data\Amphis BizMonitor\report.htm
and on Windows Vista it is
C:\ProgramData\Amphis BizMonitor\report.htm
The easiest way to browse to the URL is to go to page 1 of the Amphis BizMonitorConfig app and click on the View button next to the Summary File details.
From the summary page you can also click on the 24 hour history link to see the historic values.
If you have Internet Information Services (IIS) installed you can change the folder to something like c:\inetpub\wwwroot and access the summary file through IIS eg at http://localhost/report.htm
With IIS you could also configure the pages to be available across the internet so you could access the data remotely.
Why aren't the html web pages being created ?
First of all, please check you are using v1.1 which is the latest version. If you run the Amphis BizMonitorConfig application and go to the Help->Help About menu it will show you the version you are using. If you are using v1.0, please go to Control Panel and uninstall it and then download the latest version from
here and install it.
v1.1 is easier to setup and also starts the windows service automatically.
You need to run the Amphis BizMonitor Config application to specify which database you wish to monitor and what values you are going to monitor and to specify any alerts etc.
After you have completed page 2, the Amphis BizMonitor windows service will be started automatically. It is the BizMonitor windows service which creates the web pages and (optionally) sends summary and alert emails.
Then you can browse to the BizMonitor summary page. The easiest way to do this is to run the BizMonitor Config application and click on the View button on page 1.
Once you are happy that the BizMonitor windows service is configured correctly (ie you can see the summary page with the values being monitored) it is a good idea to set the windows service to start automatically when your PC starts up. You can do this by right-clicking on the windows service, selecting Properties and selecting the startup type as Automatic.
How do I start or restart the Amphis BizMonitor windows service ?
In v1.1, the windows service is started for you automatically from the Amphis BizMonitorConfig application but it is also a good idea to set the windows service to start automatically when you reboot your PC.
From the Start menu, click Control Panel and then double-click Administrative Tools. Then double-click Services and you will see a list of windows services like this. The status will show as Started if the service has already been started.
To start the Amphis BizMonitor service, select the Amphis BizMonitor row and then either click the Play button or you can right-click on it and select the Start menu option. If the service is already Started you can restart it by right-clicking on it and selecting Restart.
Why are values displayed as a question mark ?
If a value is displayed as a question mark, it means there was a problem retrieving the required value. This could be because there is a problem with the SQL command specified in the Amphis BizMonitor Configuration application.
To fix this, run the Configuration application again and check the alerts you have specified on Page 2.
In the example above there is a typo in the SELECT statement which would cause the database query to fail and this is why the value is displayed as ? on the html summary page. To fix it just requires changing selct to select, clicking OK and then restarting the windows service.
Also, the problem could be a permissions problem. By default the Amphis BizMonitor windows service runs as the Local System account. If you are trying to monitor a SQL Server database you may need to change the service to run as a different user that has access to your SQL Server database.
I'm having problems installing or running Amphis BizMonitor on Windows Vista
There were problems with Amphis BizMonitor v1.0 on Vista which have been fixed in v1.1. Please download the latest .msi from
here
v1.1 is easier to setup and also starts the windows service automatically.
If you have already installed v1.0, please go to Control Panel and remove v1.0 before installing v1.1.
Please click
here
here
to email customer support if you have any problems installing or configuring Amphis BizMonitor.
I'm trying to use the default folder c:\inetpub\wwwroot but it doesn't exist
This was an issue with v1.0. Please go to Control Panel and uninstall v1.0. Then download v1.1 from
here
v1.1 is easier to setup and also starts the windows service automatically.
Problems With Installation
Microsoft .Net Framework
Amphis - BizMonitor requires the Microsoft .Net Framework v2.0 to be installed. This comes with Microsoft Windows Vista but if you use Microsoft Windows XP or an older version of Windows, you might not already have it installed. You can install it from here.
On that web page, just click on the Download button (see screenshot below), then click Save and save the download to your hard disk. Then click Open Folder and double-click on the file dotnetfx.exe to install the software.
Microsoft Windows Installer
If you see a message that says you need to install a newer version of the Microsoft Windows Installer, you can install it from here.
On that web page, just click Continue (see screenshot below)
and then when the button changes to this
scroll down until you see these 3 Download buttons
and click on the third Download button to download the Windows Installer .exe file.
Then click Save and save the download to your hard disk. Then click Open Folder and double-click on the WindowssInstaller .exe file to install the software.
Amphis - BizMonitor requires the Microsoft MDAC components to be installed. If you have successfully installed Amphis - BizMonitor, but the application fails to run, click here to install Microsoft MDAC components.
Email Customer Support
If you cannot find the answer to your problem on the Support Pages,
please click
here
to email customer support.