43
7. Tochangethesizeofyournewreport,eitherclickFittowindowwidthto
fitthenewreporttothecurrentbrowserwindow,orenteranewvalue,in
pixels(px),intheReportwidthfield.
8. IntheHeaderarea,configureyournewreportasfollows:
a. EnteraTitleandSubtitle.
b. Toreplacethedefaultlogo,confirmthatLogoischecked,andclick
Browseforlogotoselectyournewlogo.
9. IntheContentarea,configureyournewreportasfollows:
a. EitherselecttherequiredPageLayoutfromtheselectorontheright
orprovidethenumberofLayoutcolumns.
b. Foreachcolumn,clickAddContenttoaddresourcestoyourreport.
Formoreinformation,seeAdding
Content
to
a
Web-
Based
Report
Column
.
c. ClickAddsectiontoaddfurtherrowsofcontenttothisreport.
10. Toincludeafooterinyourreport,confirmthatFooterischecked,and
completethefollowingsteps:
l
Toincludethereportcreationdateinthefooter,confirmthat
Creationdateischecked.
l
Toprovidecustomtextinthefooter,confirmthatCustomtextis
checked,andthenprovidethecustomtextyouwanttoinclude.
11. ClickNexttodisplaythePreviewview.
12. Ifthepreviewisnothowyouwantyourreporttobe,clickBack,and
maketherequirededits.
13. Ifthereportpreviewisacceptable,clickNexttodisplaytheProperties
view.
14. TostorethisreportasoneofyourFavoriteReports,checkMyFavorite
Reports.Markingareportasafavoritepromotesittothetopofanyreports
listinwhichitappears.
15. ProvideanappropriateReportDescription.
16. SelecttheappropriateReportCategory.
Note:ThisreportwillbeincludedintheselectedGroupbycategoryonthe
ManageReportsview.
573
CreatingaNewWeb-BasedReport
41
Chapter19:CreatingandViewingReports
17. Ifthereareanydefinedcustompropertiesthatmayapplytothisreport,
theyarelistedintheCustomPropertiesarea.Provideappropriatevaluesfor
alllistedcustomproperties.
Note:Youmayleaveanycustompropertyfieldblank,butyourSQL
databasewillrecordthefieldas'empty'becauseSQLdoesnotrecognize
NULLasavalidentry.
18. EnteranycommentsappropriateforthisreportintheCommentsbox.In
additiontoprovidinginformationaboutyourreport,youcanusethistogroup
reportsontheinitialReportpage.
19. Toapplyorchangelimitationsforthisreport,expandReportLimitation,
andthenselectanappropriateReportlimitationcategory.
Note:Web-basedreportscanberestrictedtospecificusers.Usersmaybe
assignedspecificreportlimitationcategories,andtheymayonlyview
reportsthatareinthesamereportlimitationcategory.
20. ClickNexttodisplaytheScheduleReportview.
21. Toschedulethisreporttobegenerated,emailed,savedand/orprinted
atsettimes:
a. SelectSchedulethisreporttorunregularly.
b. Ifyouhavealreadysetupreportschedules,clickAssign
Schedule,andselectfromthelist.
c. Tosetupanewschedule,clickCreatenewschedule.Formore
information,seeCreating
a
Report
Schedule
While
Creating
or
Editing
a
Report
.
22. ClickNexttodisplaytheSummaryview.
23. Ifyoudonotwanttoschedulethisreport,checkNoscheduleneeded.
24. Reviewthereportconfiguration.ClickEdittoreturntoanysectionsyou
wanttoamendorclickSubmittosavethereport.
AddingContenttoaWeb-BasedReportColumn
Youcanincludeanywebconsoleresourceinyournewreport,asdescribed
below.
574
50
Note:Thefollowingprocedureassumesyouarealreadycreatingoreditinga
reportinthewebconsolereportLayoutBuilder.Formoreinformation,see
Creating
Reports
in
the
Web
Console
.
Toaddcontenttoaweb-basedreportcolumn:
1. OntheLayoutBuilderview,clickAddContentinthecolumntowhichyou
wanttoaddanewreportresource.
2. SelectacriterionintheGroupby:field.
Note:TheClassiccategorygroupingprovidesthemostcomprehensive
listofavailableresources.
3. Selecttheresourcegroupfromthelistintheleftpane.
4. Selecttheresourcefromthelistinthemainpane.
5. ClickSelectandContinue.
6. Iftheresourceisdesignatedtoworkonlywithaspecificobjector
objects:
a. Selecttherequiredobject(s)fromtheleftpane.
b. Togiveaspecificnametothisdatasource,ratherthanacceptingthe
default,enteritintheSelectionNamefield.
c. ClickAddtoLayout.
7. IfyouareanadvanceduserandwanttoaddaCustomChartorTable,
seeAdding
a
Custom
Chart
or
Table
to
a
Web-
Based
Report
Column
.
8. Onceyouhaveaddedcontenttoacolumn,itisdisplayedwithanEdit
Resourcebutton.Dependingontheselectedresource,clickingthisbutton
willenableyoutochangethetitle,subtitleandvariousotherfieldsand
settings.
Note:Forresourcesandchartsthatreportonaspecificobjectorobjects,
youcanselecttheobject(s)fromadrop-downlist.
9. Ifyouwanttoaddafurtherrowtoyourreport,clickAddsection.Youcan
nowaddcontenttothisrowasdescribedabove.
Note:Resourcescanbedraggedbetweencolumnsandsections.
10. ClickNexttopreviewthereport.
575
AddingContenttoaWeb-BasedReportColumn
37
Chapter19:CreatingandViewingReports
AddingaCustomChartorTabletoaWeb-BasedReportColumn
Advanceduserscancreatecustomchartsortablesforinclusionintheirweb-
basedreports,asdescribedinthefollowingprocedure.BecausetheOrion
platformgeneratessuchawealthofdata,youneedtoensurethatyouknow
exactlywhatdatayouareusing,fromwhichinstancesitoriginatesfrom,andwhat
youdowiththemtoensurethatyourcustomchartsandtablesshowmeaningful
results.
Toaddacustomchartortabletoaweb-basedreportcolumn:
1. ClickAddContentinthecolumntowhichyouwanttoaddacustomchart.
2. SelectTypeintheGroupby:field.
3. SelectReportsfromthelistintheleftpane.
4. SelectCustomChartorCustomTableasrequiredfromthelistinthemain
pane,andclickSelectandContinue.
5. Select:
l
SpecificObjects(staticselection)ifyouknowpreciselywhich
objectsyouwanttoincludeinyourchartortable.
Note:Thisisthemoststraightforwardselectionmethod,and
recommendedfornewusers.Itisalsothepreferredmethodfor
relativelypermanentnetworkobjects.
l
SelectDynamicQueryBuildertoselectobjectsbasedonobject
properties.
Note:Thisisthepreferredselectionmethodforgroupsofobjectsofa
specifiedtypethatmaychangeovertime."AllCisconodesinAustin"
isanexampleofagroupbestdefinedusingtheDynamicQuery
Builder.
l
SelectAdvancedDataBaseQuery(SQL,SWQL)onlyifyouare
comfortablequeryingyourSolarWindsdatabasedirectly,usingSQL
orSWQL.
6. IfyouselectedtheSpecificObjects(staticselection)method,select
objectsasshowninthefollowingsteps:
a. SelecttheobjecttypetochartfromtheShowdrop-down.
b. SelectthegroupingcriterionfromtheGroupbydrop-down.
576
32
c. Expandthegroupsdisplayed,ifnecessary,thenchecktheobject(s)to
use.
7. IfyouselectedtheDynamicQueryBuildermethod,defineobjectsas
showninthefollowingsteps:
a. Selectthetypeofselectorqueryyouwanttouse(Basicor
Advanced).
Note:ThoughtheAdvancedSelectorprovidesaccesstoallnetwork
objectcharacteristics,theBasicSelectorprovidesaccesstoa
smallersubsetofthemostfrequentlyusednetworkobject
characteristics.
b. TousetheBasicselector:
i. SelectthetypeofobjectstoreportonfromtheI wanttoreport
ondrop-down.
ii. SelectwhetherAllchildconditionsmustbesatisfied(AND)
orifonlyAtleastonechildconditionmustbesatisfied(OR).
iii. Selectapropertyofthemonitoredobject,aconditionalrelation,
andprovideavalue.
iv. ClickAddSimpleConditionifyouwanttoaddanother
condition.
c. TousetheAdvancedSelector:
i. SelectthetypeofobjectstoreportonfromtheI wanttoreport
ondrop-down.
ii. SelectwhetherAllchildconditionsmustbesatisfied(AND)
orifonlyAtleastonechildconditionmustbesatisfied(OR).
iii. Foreachconditionyouwanttoadd,selecttheconditiontypeby
clickingonthegreenplussymbol(+).YoucanaddaSimple
Conditionwhereyouspecifyamonitoredobjectproperty,a
conditionalrelationshipandavalue,anAdvancedCondition
whereyouselecttwomonitoredobjectpropertiesanda
conditionalrelationship,oranestedAnd/Orblock.
577
AddingaCustomChartorTabletoaWeb-BasedReportColumn
40
Chapter19:CreatingandViewingReports
8. IfyouselectedtheAdvancedDatabaseQuery(SQL.SWQL),providea
selectionquery,asfollows:
a. SelecttheQueryType(SWQLorSQL).
Note:FormoreinformationaboutSWQLandSQLqueries,clickHow
touseSWQL/SQL.
b. Enteraquery,andthenclickPreviewResultstoconfirmthatyour
queryprovidesexpectedresults.
9. IneachcaseenteranameforthisselectionintheSelectionNamefieldif
youdon'twanttousethedefaultnameandclickAddtoLayout.
10. Younowneedtoeditthechartortabletospecifythedataseriesorcolumns
youwanttouseandothersettings.ThisiscoveredinEditing
a
custom
chart
andEditing
a
custom
table
.
Toaddadditionalcustomchartsortables:
1. Ifyouaddfurthercustomchartsortables,youwillbeaskedifyouwantto
useobjectsyouselectedpreviouslyormakeanewobjectselection.
l
ClickUsepreviouslyspecifiedobjectsandselecttheobjectsfrom
thedrop-downtousethepreviouslyselectedobjects.
l
ClickCreatenewobjectselectionandcontinuefromStep5aboveto
specifynewobjects.
Toeditacustomchart:
Onceyouhavespecifiedtheobjectstobereportedonforachart,youneedto
selectthedataseriestobeused.
1. Forthecustomchartyouwanttoedit,selectthetimeperiodtobereported
onfromtheFromdrop-down.
2. ClickEditChart.
3. EnteraTitleandSubtitleasrequired.
4. ClickAddDataSeries.
5. SelecttheObjecttoreporton,thenhowyoutogroupdatapertainingtothis
object.
578
38
Note:Thegroupsavailableandthedataserieswithinthesegroupswill
dependontheobjectselected.
6. SelecttheDataSeriesNamefromthelistintherightpane,andclickAdd
DataSeries.
7. Foradditionalsettingsforeachdataseries,clickMore.Hereyoucan:
l
EdittheDisplaynameforthisdataseries
l
SelectacustomColorforthisdataseries
l
Showthe95thpercentilelineforthisdataseries
l
ShowTrendforthisdataseries
8. Repeatsteps4to7toaddfurtherdataseries.
9. EnteraCustomlabelfortheLeftaxis.
10. SelecttheUnitsdisplayed,andCharttype,andchecktheShowthesum
ofalldataseries,ifrequired.
11. SelecttheSampleInterval.Thiscanbefromonceaminutetooncea
week.Datawithineachsampleintervalissummarizedsothatasinglepoint
orbarisplottedforeachoftheseperiods.Note: Itispossibletoselecta
sampleintervalthatislongerthanthereportingperiod.
12. Tofilterthedatausedinthechart:
a. Either:
l
SelectShowonlylimitednumberoftoprecordsandenter
howmanyofthetoprecordstobeused.
l
SelectShowonlylimited%oftoprecordsandenterthetop
percentageofthetoprecordstobeused.
b. SelecthowyouwanttosortthisselectionofrecordsfromtheSort
recordsbydrop-down.Thechoicesshownherewilldependonthe
dataseriesselected.
c. SelecteitherAscendingorDescendingfromtheSortorderdrop-
down.
d. SelecttheDataaggregationmethodrequired.
e. ClickAdvancedifyouwanttosortrecordsusingasecondaryfield.
579
AddingaCustomChartorTabletoaWeb-BasedReportColumn
32
Chapter19:CreatingandViewingReports
13. Youcansetupadditionaldataseriesusingtherightaxis.Thisallowsyouto
superimposetwochartsusingdifferentlabels,units,andcharttype.
Note: Youcannotuseaseparatetimeperiodorfilterresultssettingsforthe
rightaxisseries.
14. ClickSubmittoreturntotheAddReportpage.
Toeditacustomtable:
Onceyouhavespecifiedtheobjectstobereportedonforatable,youneedto
selectthedataseriestobeused.
1. Forthecustomtableyouwanttoedit,selectthetimeperiodtobereported
onfromtheFromdrop-down.
2. ClickEditTable.
3. EnteraTitleandSubtitleasrequired.
4. ClickAddColumn.
5. SelecttheObjecttoreporton,thenhowyouwanttogroupdatapertaining
tothisobject.
Note:Thegroupsavailableandthedataserieswithinthesegroupswill
dependontheobjectselected.
6. SelecttheDatabasecolumnnamesfromthelistintherightpane,and
clickAddColumn.
7. Foradditionalsettingsforacolumn,clickAdvanced.Hereyoucan:
l
EdittheDisplaynameforthiscolumn.
l
CheckHidethiscolumnintheresultingtable,ifyouwanttousethis
columnwhenqueryingthedatabasebutdonotwanttoshowit.For
example,youmaywanttousethiscolumn'sdatainthetime-based
settingsbutnotshowthedatainthetable.
l
CheckAllowHTMLtags,ifyouwanttouseanyHTMLtagsretrieved
fromthedatabaseforthiscolumn.
580
Documents you may be interested
Documents you may be interested