Database Reference
In-Depth Information
LEFT OUTER JOIN vManagedEntityType ET ON
E.ManagedEntityTypeRowId =
ET.ManagedEntityTypeRowId
LEFT OUTER JOIN vManagedEntityTypeImage ETI ON
ET.ManagedEntityTypeRowId =
ETI.ManagedEntityTypeRowId
AND ETI.ImageCategory = 'u16x16Icon'
WHERE
A.RaisedDateTime BETWEEN @StartOfPreviousMonth AND
@EndOfPreviousMonth
ORDER BY
1 ASC, 3 DESC
Tip
You can test the query by clicking on the exclamation mark icon. Perform this
step to ensure that your query has no typing errors and is valid.
7. Click on
Next
.
8. Drag
WorkflowName
from
Available fields
to the
Row groups
area.
9. Drag
AlertName
,
RaisedDateTime
, and
EntityType and Entity
from the
Avail-
able fields
area to the
Values
area.
10. Click on
Next
and choose
Show subtotals and grand totals
,
Blocked, subtotal
above
, and
Expand/collapse groups
.
11. Click on
Next
, choose your preferred table style, and then click on
Finish
.
The wizard will now close, and Report Builder displays the table in your newly created
report. You can now modify the report and the table as desired. Perform the following
steps to modify the report:
1. Click on the
Click to add title
area and type
Top Alerts by Rule/Monitor Last
Month
.
2. Change the font size and column width to accommodate the text length (click on
the
Run
button to test the layout and click on
Design
to go back).
3. Select the
Alert Name
column. Right-click on the top gray part of the cell and se-
lect
Insert Column
.
4. Click on the
Insert
tab. Click on
Image
. Click on the cell to the right of
[Aler-
tName]
.