%3CLINGO-SUB%20id%3D%22lingo-sub-365574%22%20slang%3D%22en-US%22%3ESample%20Queries%20and%20Reports%20from%20my%20MMS%20Session%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-365574%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3E%20First%20published%20on%20TECHNET%20on%20Apr%2022%2C%202010%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EHere%20are%20the%20reports%20and%20queries%20that%20I%20used%20in%20the%20demos%20of%20my%20%E2%80%9CWriting%20Basic%20Custom%20Reports%20for%20Operations%20Manager%E2%80%9D%20session%20at%20MMS%202010.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E**I%E2%80%99ve%20updated%20the%20Alert%20Dashboard%20report%20to%20correct%20a%20problem%20with%20the%20Alert%20Priority%2FSeverity%20pie%20charts.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHere%20are%20the%20descriptions%20of%20each%20file%20included%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EMMS.Sample.Reports.MP.xml%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EThis%20is%20the%20Management%20Pack%20that%20contains%20all%20of%20the%20reports%20listed%20below.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%20Sample%20Reports%3A%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EAdvanced.Performance.Report.rdl%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EThis%20report%20allows%20the%20user%20to%20select%20a%20singe%20Performance%20Counter%20to%20report%20on.%26nbsp%3B%20The%20user%20can%20find%20the%20counter%20based%20on%20Management%20Pack%2C%20Rule%2C%20Object%2C%20Counter%2C%20and%20Instance.%26nbsp%3B%20The%20user%20can%20also%20select%20the%20computers%20to%20report%20on%2C%20based%20on%20group%20membership.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20823px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86809i0CCA5140941F160C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EAlert.Dashboard.rdl%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EThis%20report%20shows%20the%20following%20information%20about%20Alerts%20within%20a%20user-specified%20time%20range%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EPie%20charts%20showing%20alert%20count%20by%20Severity%20and%20Priority%3C%2FLI%3E%0A%3CLI%3ELine%20charts%20showing%20Top%2010%20Alerts%2C%20Top%2010%20Management%20Packs%20generating%20alerts%2C%20and%20Top%2010%20Computers%20generating%20alerts%3C%2FLI%3E%0A%3CLI%3EPie%2FLine%20charts%20showing%20Alert%20logging%20latency%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20826px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86810iDA42D4C9D9C12B3F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ESample.Alert.Report.rdl%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EThis%20report%20displays%20a%20basic%20table%20with%20Computer%20Name%2C%20Alert%20Name%2C%20Date%2FTime%2C%20and%20Repeat%20Count.%26nbsp%3B%20The%20user%20selects%20a%20date%20range%20and%20the%20computers%20to%20report%20on%2C%20based%20on%20group%20membership%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86812i623828A967CC9F6C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ESample.Event.Report.BasicTable.rdl%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EThis%20report%20displays%20a%20table%20showing%20error%20events%20for%20specified%20computers.%26nbsp%3B%20The%20user%20selects%20a%20date%20range%20and%20the%20computers%20to%20report%20on%2C%20based%20on%20group%20membership%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20937px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86814iCCCB317DFC3EB3E7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ESample.Event.Report.GroupedTable.rdl%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3ESame%20data%20as%20the%20above%20report%2C%20but%20this%20one%20groups%20by%20Computer%20Name%20and%20Event%20ID%2FSource%20to%20make%20the%20report%20cleaner.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86816iEDA7EB489F8EC5EC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ESample.Performance.Report.Chart.rdl%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EThis%20report%20shows%20a%20line%20chart%20of%20the%20%25Processor%20Time%20counter%20for%20selected%20Computers.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86818i49D1879D15361FF9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ESample.Performance.Report.Table.rdl%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3ESame%20as%20above%2C%20but%20the%20data%20is%20in%20a%20table%20instead%20of%20a%20chart.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20998px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86820iEF34FD9C811F9E51%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%20Sample%20Queries%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EGroupList.txt%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EThis%20query%20gets%20a%20list%20of%20groups%20currently%20in%20OpsMgr.%26nbsp%3B%20It%20will%20only%20return%20groups%20that%20contain%20objects%20(empty%20groups%20are%20not%20listed)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EComputerList.txt%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EThis%20query%20gets%20a%20list%20of%20objects%20in%20a%20group%2C%20then%20returns%20the%20Computer%20Name%20for%20each%20object.%26nbsp%3B%20The%20query%20requires%20the%20ManagedEntityRowId%20for%20the%20group%20as%20a%20parameter%20(passed%20by%20the%20above%20GroupList%20query).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EAlertReport1.txt%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EThis%20is%20the%20basic%20query%20used%20for%20the%20Sample%20Alert%20Report%2C%20but%20does%20not%20contain%20any%20parameters%E2%80%A6it%20just%20gets%20data%20for%20ALL%20alerts%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EAlertReport.txt%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EThis%20is%20the%20query%20used%20for%20the%20Sample%20Alert%20Report%2C%20with%20Computer%20and%20Date%20Range%20parameters%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EEventReport.txt%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EThis%20is%20the%20query%20used%20in%20the%20above%20Event%20Reports.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EPerfReport.txt%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EThis%20is%20the%20query%20used%20in%20the%20above%20Performance%20Reports%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20to%20everyone%20who%20came%20to%20my%20session.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmsdnshared.blob.core.windows.net%2Fmedia%2FTNBlogsFS%2Fprod.evol.blogs.technet.com%2Ftelligent.evolution.components.attachments%2F01%2F6699%2F00%2F00%2F03%2F32%2F77%2F43%2FMMS_Files.zip%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%20MMS_Files.zip%20%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-365574%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20published%20on%20TECHNET%20on%20Apr%2022%2C%202010%20Here%20are%20the%20reports%20and%20queries%20that%20I%20used%20in%20the%20demos%20of%20my%20%E2%80%9CWriting%20Basic%20Custom%20Reports%20for%20Operations%20Manager%E2%80%9D%20session%20at%20MMS%202010.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-365574%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EJimmyHarper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

First published on TECHNET on Apr 22, 2010

Here are the reports and queries that I used in the demos of my “Writing Basic Custom Reports for Operations Manager” session at MMS 2010.

 

**I’ve updated the Alert Dashboard report to correct a problem with the Alert Priority/Severity pie charts.

 

Here are the descriptions of each file included:

 

MMS.Sample.Reports.MP.xml
This is the Management Pack that contains all of the reports listed below.

 

Sample Reports:

Advanced.Performance.Report.rdl
This report allows the user to select a singe Performance Counter to report on.  The user can find the counter based on Management Pack, Rule, Object, Counter, and Instance.  The user can also select the computers to report on, based on group membership.

 

 

Alert.Dashboard.rdl
This report shows the following information about Alerts within a user-specified time range:

  • Pie charts showing alert count by Severity and Priority
  • Line charts showing Top 10 Alerts, Top 10 Management Packs generating alerts, and Top 10 Computers generating alerts
  • Pie/Line charts showing Alert logging latency

 

Sample.Alert.Report.rdl
This report displays a basic table with Computer Name, Alert Name, Date/Time, and Repeat Count.  The user selects a date range and the computers to report on, based on group membership

 

Sample.Event.Report.BasicTable.rdl
This report displays a table showing error events for specified computers.  The user selects a date range and the computers to report on, based on group membership

 

Sample.Event.Report.GroupedTable.rdl
Same data as the above report, but this one groups by Computer Name and Event ID/Source to make the report cleaner.

 

Sample.Performance.Report.Chart.rdl
This report shows a line chart of the %Processor Time counter for selected Computers.

 

Sample.Performance.Report.Table.rdl
Same as above, but the data is in a table instead of a chart.

 

Sample Queries

GroupList.txt
This query gets a list of groups currently in OpsMgr.  It will only return groups that contain objects (empty groups are not listed)

 

ComputerList.txt
This query gets a list of objects in a group, then returns the Computer Name for each object.  The query requires the ManagedEntityRowId for the group as a parameter (passed by the above GroupList query).

 

AlertReport1.txt
This is the basic query used for the Sample Alert Report, but does not contain any parameters…it just gets data for ALL alerts

 

AlertReport.txt
This is the query used for the Sample Alert Report, with Computer and Date Range parameters

 

EventReport.txt
This is the query used in the above Event Reports.

 

PerfReport.txt
This is the query used in the above Performance Reports

 

Thanks to everyone who came to my session.

 

MMS_Files.zip