Creating Reports in iMonnit Enterprise
iMonnit Enterprise currently offers the Report types listed below which can be generated in the Enterprise Portal. In iMonnit Enterprise, all Reports are delivered via email. This means in order for Reports to be generated and delivered, the following conditions must be met:
- An SMTP server must be configured and working in Enterprise in order to deliver the Reports from Enterprise.
- The size of the Report generated must meet the SMTP server attachment type/size limitations. The Report will be delivered as a common CSV file.
Available preconfigured Reports
There are seven Reports available in iMonnit Enterprise that can be run as soon as you have an SMTP server configured:
Account Report
Description: Reports on basic sensor information for each sensor in your account.
Sent Notifications
Description: Reports sent notification details of Account owner.
Sensor: Data Export (daily/weekly/monthly)
Description: Reports all readings from a sensor that were recorded the previous day, week or month.
Network: Data Export (daily/weekly/monthly/ 30 sensor limit)
Description: Reports all readings from all the sensors from a particular network that were recorded the previous day, week or month/ this report will only work with a network with 30 sensors or less.
Logged Notes Report
Description: Notes Logged by Users
Sensor: No Notification Profile.
Description: Provides a list for account and all sub accounts of each sensor that does not have a notification attached.
Reseller: User List
Description: Returns a list of all users on Reseller Account and all subaccounts.
Creating Reports
Creating Reports in iMonnit Enterprise is no different than creating them in iMonnit Online:
- Log into the desired User.
- Select Reports in the main navigation menu.
- Select the +Add Report button toward the of the page.
- Select the Enterprise card.
- Select the Report type.
- Enter the desired Name.
Select the Report Schedule (Daily/Weekly/Monthly/Annually/Immediately).
Note: Selecting Once will run the Report on-the-fly. The Report will generate within 60 minutes, and the recipient will receive it via email.
Report Builder in iMonnit Enterprise
In addition to the preconfigured Reports, the Report Builder will allow Users with SQL scripting capabilities to generate Reports that contain specific parameters and data. This does require the User to have the ability to generate the SQL script to retrieve the data.
❕Note: Inquiries regarding scripts or database schemas are strictly outside of the scope of Monnit Support. If you are not familiar with how to generate the scripts, you can reach out to the Monnit Sales channel to discuss the purchase of a development agreement.
Steps to create a custom Report in iMonnit Enterprise:
- Login to the Admin Enterprise account.
- In the man Navigation menu, select Admin.
- Select Server.
- In the menu that is revealed, select Report Builder.
- Select the +Create Report button toward the top of the pane.
- Enter the following details:
- Name (the name to be displayed on the Report's card).
- Description (the detailed description of the data the Report provides).
- SQL (the SQL script to generate the Report).
Schedule Type Availability (the frequency available when a User creates Report).
Notes: Other fields can be left blank/default and are not supported within the scope of support for iMonnit Enterprise. Be sure to Leave AccountID/AccountThemeID both blank.
- Select Save.
- ⚠ Important: In Enterprise 4.0.3.4, the ReportQuery is saved without ReportTypeID being saved. A DBA must perform a query against the database to set the ReportTypeID with the following statement:
UPDATE ReportQuery set ReportTypeID = 1
Once these steps are completed, a User can create the newly generated Report:
- Log into the standard User account.
- Select Reports in the main navigation menu.
- Select the +Add Report button toward the top of the pane.
- Select the newly created Report type.
- Select the desired parameters.
- Save.
The Report will be generated and delivered by the configured SMTP server.