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.
lf you could not really produce any specific report usingNew Custom made Documentthen you can generate those reviews making use ofNew Concern Reviews. Making use of query manager you can sign up for different desks from different quests and create any type of record.
To generate query reports,
Log into AssetExplorer program using your consumer name and security password. This starts the Settings Wizard page.
Click on onReportstabs in the héader pane. This opens the All Reviews web page.
ClickNew Issue Recordbutton. This starts the Problem Editor page.
Select theDesk Schemafrom the combination container. ClickGetkey to obtain theDesk Schemaof the chosen table.
Specify theReport Titlein thé in the given text field.
Specify the question to become performed for obtaining the reports in theIssueindustry.
Select thé line to become assembled from theGroup bycombination box.
The logs will screen all error communications on supplying any wrong predicament.
ClickRun Reviewto operate query document.
Suggestions
- Time Formulae: DATEFORMAT (FR0MUNIXTIME (COLUMNNAME/1000),'%d-%m-%Y %k: %we') 'Line Alias'.
A few minutes Formulae: Circular ((((COLUMNNAME/1000)/60)) % 60) 'Mins'.
Hours Formulae: Circular (((COLUMNNAME/1000)/3600)) 'Hours'.
Compare and contrast Day: COLUMNNAME gt;= (UNIXTIMESTAMP (Time ('2006-07-24 00:00:00')). 1000).
Change Storage in GB: ((((MEMORYCOLUMN)/1024)/1024)/1024)
Default Value For Null Data: COALESCE (COLUMNNAME, 'Unassignéd')
Group by: Query declaration will end up being ends with order by lt;coIumnindexgt;
Date Formulae: DATEORMAT (FROMUNIXTIME (COLUMNNAME/1000), '%d-%michael-%y %k: %i actually) 'Line Alias'.
Moments Formulae: Circular ((((COLUMNNAME/1000)/60) 'Moments'.
Hours Formulae: Circular (((COLUMNNAME/1000)/3600)) 'Hrs'.
Do a comparison of Time: COLUMNNAMEgt;= (UNIXTIMESTAMP (DATE ('2006-07-24 00:00:00'))
Additional Field furniture
- Specialist Additional Areas - TechnicianFields
- Resource Additional Areas - AssetFields
- Wórkstation Additional Areas - WorkstationFi