Invalid SQL: select typeid from swcustomfieldvalues where fieldvalue='Messaging, Reports and Who's On' (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's On'' at line 1)Invalid SQL: select kbarticleid from swkbarticles where subject='Messaging, Reports and Who's On' (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's On'' at line 1)Invalid SQL: select kbcategoryid from `swkbcategories` where title='Messaging, Reports and Who's On' (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's On'' at line 1) <Windows Hosting Help, Webhosting Technical Support and Knowledgebase - Applied Innovations
asp.net hosting
 
 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search

Support Center » Knowledgebase » Resellers-Websellers » How do I Generate Reports and Find Out Who’s On?

 How do I Generate Reports and Find Out Who’s On?
Solution

Helm gives you the ability to generate reports for customer and domain bandwidth, and customer and domain diskspace usage. It also lets you export these reports to Microsoft Excel. There is also the ability to see Whos On currently i.e. see who is logged in to your control panel.

 

Click on the Reports icon on the Reseller Main Menu and you will be taken to the following screen:

If you click on the Whos On button, you will be able to see a list of users who are currently logged into the control panel. You can see their username, when they logged on, the part of the control panel they are currently in, and their IP:

 

Clicking on one of them will take you to that users main menu.

 

You can also click on one of the reports to see the various bandwidth usages. For instance, if you clicked on Customer Bandwidth Usage Report, you would be taken to the following screen:

In the above example, three packages are listed with the customer account number, type of package that they use, and how much bandwidth (in Megabytes) they use along with a colour-coded percentage (green if it is under their limit and red if they have exceeded their limit). Clicking on one of these will take you to the graphical statistics for that user.

 

An example of a statistical display of a customer is below:

This is also accessible directly from the user level.

 

With the bandwidth usage reports, it is possible to select the bandwidth period that you wish to view the report for. Simply type the date you wish to view or use the helpful calendar tool next to the date field, then click Search. 

 

You can also export your reports to Microsoft Excel for your convenience, either as a saved Excel file, or you can open and view it in a web browser (if supported).

 

The diskspace usage reports work in a similar way to bandwidth, except that diskspace is not tracked over a period of time the amount you see in the report, is the amount of diskspace that the user currently uses:

As with bandwidth, clicking on a customer in the list will take you to the resource usage page for that customers package.

 

The domain diskspace usage report is similar too:

Clicking on a domain listed in the report will take you to the statistics page for that domain.



Article Details
Article ID: 368
Created On: Feb 26 2007 08:10 PM

 This answer was helpful  This answer was not helpful

 Back
 
 Article Options
 
Home | Register | Submit a Ticket | Knowledgebase | News | Downloads
FrontPageSQL2005Windows 2003SmarterMailSmarterStatsASP.netPlesk hostingHELM hosting
Products & Services  |  Company Information  |  Testimonials  |  Support  |  Resellers  |  Affiliates  |  Contact Us  |  Terms of Use  |  Site Map  |  Home
© 1999-2009 Applied Innovations Corp., All Rights Reserved
ASP.net Hosting | Windows VPS Hosting | IIS7 Beta Hosting | Windows Hosting | BVCommerce Hosting | AspDotNetStorefront Hosting | Windows Reseller Hosting | Kentico CMS Hosting | SQL Server Hosting | ASP.NET AJAX Hosting | Windows Dedicated Server Hosting | Sharepoint Hosting | Expression Web Hosting | FrontPage Hosting | E-Commerce Hosting | DotNetNuke Hosting | Community Server Hosting | Search Engine Marketing | Online Merchant Accounts | Application Hosting | Free PCI Scanning | Cardinal Commerce | Discount Windows Hosting | Small Business Hosting | Enterprise Windows Hosting | Advanced Windows Hosting | Storefront Hosting | Free Website Building Software | Hosting Affiliate Program | News & Press Releases
More Info on Shared Hosting More Info on Application Hosting More Info on E-Commerce More Info on Dedicated Hosting More Info on Reseller Hosting More Info on Virtual Private Servers Windows 2003 Shared Hosting More Info on ASP.net Hosting More Info on Dedicated Servers Microsoft Gold Certified Partner Get it NOW! Sign-up  NOW!