New Query Reports

 

If you could not generate any specific report using New Custom Report then you can generate those reports using New Query Reports. Using query editor you can join different tables from different modules and generate any type of report.

 

To generate query reports,

1. Log into AssetExplorer application using your user name and password. This opens the Configuration Wizard page.

2. Click on Reports tab in the header pane. This opens the All Reports page.

3. Click New Query Report button. This opens the Query Editor page.

4. Select the Table Schema from the combo box. Click Get button to get the Table Schema of the selected table.

5. Specify the Report Title in the in the given text field.

6. Specify the query to be executed for getting the reports in the Query field.

7. Select the column to be grouped from the Group by combo box.

8. The logs will display all error messages on providing any wrong query.

9. Click Run Report to run query report.

Tips

1. Date Formulae: DATE_FORMAT (FROM_UNIXTIME (COLUMN_NAME/1000),'%d-%m-%Y %k: %i') 'Column Alias'.

2. Minutes Formulae: ROUND ((((COLUMN_NAME/1000)/60)) % 60) 'Minutes'.

3. Hours Formulae: ROUND (((COLUMN_NAME/1000)/3600)) 'Hours'.

4. Compare Date: COLUMN_NAME >= (UNIX_TIMESTAMP (DATE ('2006-07-24 00:00:00')) * 1000).

5. Convert Memory in GB: ((((MEMORY_COLUMN)/1024)/1024)/1024)

6. Default Value For Null Data: COALESCE (COLUMN_NAME, 'Unassigned')

7. Group by: Query statement will be ends with order by <column_index>

Date Formulae: DATE_ORMAT (FROM_UNIXTIME (COLUMN_NAME/1000), '%d-%m-%y %k: %i) 'Column Alias'.

Minutes Formulae: ROUND ((((COLUMN_NAME/1000)/60) 'Minutes'.

Hours Formulae: ROUND (((COLUMN_NAME/1000)/3600)) 'Hours'.

Compare Date: COLUMN_NAME>= (UNIX_TIMESTAMP (DATE ('2006-07-24 00:00:00'))

 

 

Additional Field tables

1. Technician Additional Fields - Technician_Fields

2. Asset Additional Fields - Asset_Fields

3. Workstation Additional Fields - Workstation_Fi