The Performance tile enables you to view a wide range of visualizations using performance data from the SCOM Data Warehouse.
SquaredUp DS accesses the Data Warehouse directly using the published schema, so must have a Data Warehouse connection (see How to check and reconfigure the Data Warehouse connection) with the correct permissions for Performance graphs to work.
Performance tiles can be added to both dashboards and perspectives.
This short (2 min) video gives you and overview of performance reporting features, including using the page timeframe, aggregation and resolution options, drilldown to a full page graph, compare to other objects/groups and export to Excel (Export to Excel).
The following steps guide you through configuring all visualizations except the Report, since configuring a Performance Report works a little bit differently. If you want to configure a Report jump to How to configure a Performance tile Report.
Add a new tile to a dashboard or perspective and choose the Performance tile.
Select the visualization for your Performance tile and click next.
Uses the latest data to compare data, such as the top or bottom ranking metrics in descending or ascending order, as 'Top N'.
Visualizes both a number and the resulting bar width based on the number value.
Shows data over time (like line graphs), but each item gets its own graph instead of showing all lines in one graph.
Example:
A Scalar displays one value. A Scalar is useful to show a specific number like "total cost of my services" or "free disk space on this server". When multiple values are returned (meaning a table with multiple rows), you will still be able to pick the Scalar visualization, but the Scalar will only show the value of the first row.
Allows you to compare metrics, such as two different metrics or metrics over different time periods. For example, compare Processor Time with Memory Available, or compare Percentage CPU with the same period last week.
Scope:
The scope allows you to define which objects are shown, which in turn determines which metrics are available. For the full information on scoping tiles on dashboards and perspectives, as well as FAQs, see How to scope tiles.
Note for using the group or advanced option:
By default the scope of Performance tiles will look at multiple levels of membership (recursive search) for objects, so they will look at multiple-levels of membership rather than just one level. This means the tile shows data for objects that aren't directly contained in a group, but are contained within other objects. For example, this allows you to find disk metrics when scoped to a server.
If the scoped group contains only subgroups and you have not specified a class, then no metrics will be available in the metrics drop down list. By specifying a group AND a class it means that you can extend this recursive search to use top-level groups to show graph data for objects within sub-groups (as well as objects).
To enable recursive searching to work for sub-groups you should specify a group AND a class in the advanced scope option. This will allow the dropdown list to show the metrics for the objects in the sub-groups.
Note for choosing a class:
Choose your class carefully as for a Performance tile this will determine which metrics are available in the Metric panel.
Note for Scalars:
The Scalar visualization should be scoped to only one object using the list option, as only one figure is shown. Do not use a group.
Metric:
Here you define which value the graph will show. For example, if you want to see the response time of different servers, your metric value would be response time. If you want to see the number of tickets, your metric value would be number (of tickets).
Quick find:
The drop-down list will show you a list of all metrics available for the scope you have set. Press the down arrow on your keyboard in the choose metric field to see the list.
Advanced:
Allows you to specify the object, counter and/or instance. For example, you can use the quick find to find and select the metric LogicalDisk - % Free Space, and then click on advanced and specify C: in the instance box to only view C: drives.
Exclude matching instances:
Checking Exclude matching instances will show all instances other than those you've specified, i.e. NOT C: drives (v7.0 and above).
Resolution refers to the raw, hourly or daily data stored in the Data Warehouse.
SquaredUp DS, when using the auto resolution setting, uses the highest resolution data available (raw, hourly or daily), based on what data is available in the Data Warehouse for the whole graph timeframe. So SquaredUp DS will use raw data as long as it is available for the whole reporting timeframe, then it will use hourly, and when that is not available for the whole timeframe it will use daily data.
For Performance tiles the resolution is set in metric > resolution
Using the autoresolution setting on a Performance tile automatically changes to a more suitable resolution when the page timeframe is changed by a user, in order to optimize the time to return the graphs.
The auto setting applies to visualizations that use time periods, such as line graphs, sparklines and reports. Visualizations that do not show a time period, such as Bar Top N, Heatmap and Scalar, use the latest data point. These visualizations do not change when a user changes the page timeframe. For these visualizations the auto resolution setting defaults to daily.
The data available in the Data Warehouse is determined by the retention period set in SCOM.
When a resolution of hourly or daily is chosen you can select whether you'd like to see the average, minimum or maximum figures for that aggregated time period. For example, for a web transaction you might want to see the maximum or minimum figures rather than the average.
This allows you to specify the metric label, which is then displayed on the y-axis and hover value.
You should select the label that matches how the the data is being returned, or use the other option to specify a custom metric label, such as pages/sec or count.
This visualization always uses the latest data and ignores the dynamic page timeframe set by users.
The Page Timeframe is the timeframe setting a dashboard or perspective is currently using. These timeframes are all relative to the current time, for example 7 days ago until now. When a user changes the page timeframe, all tiles that have Use Page Timeframe set will adapt to the new timeframe. (Tiles that do not have Use Page Timeframe set (i.e. are set to Specific Timeframe or Custom Timeframe) are not affected and won't change.)
The Custom option can be used to set timeframes using ISO 8601 format
SquaredUp DS does not support the week notation.
Settings:
Data Range
The Data Range option allows you to choose the range of data the graph will display. For line graphs, this means the data on the y-axis.
percentage
Shows 0 to 100
fit to data
Shows the data minimum to data maximum
fit to data (from zero)
Shows from 0 to the data maximum
custom
Allows you to specify the min and max
custom fit
Allows you to specify the min and max limits, so that data outside your settings will not be shown. If all the data falls within your specified ranges then the y-axis range will fit to the data rather than your caps.
Sort
Sort allows you to change the order of the results displayed. You can sort by value (ascending or descending) or label (alphabetically ascending or descending).
Limit number of results:
This option is only available when you sort by values, not by labels.
Here you can define a limit for the number of results you want to see. Activate the limit number of results displayed checkbox to enter a limit for results. You can choose if this limit should be applied from the top ranking results down (ascending, default option) or from the bottom ranking results up (descending).
Value
Value Formatter
Allows you to format the value, using the mustache picker, and the modified values will be shown on the axis and hover values. For example, you can round the value up or down or convert it.
Label
Allows you to change the label of the results.
auto
Choose this option if you want to use the default label that has been created automatically.
custom
Here you can change the label to a custom label. You can use static text and dynamic properties. Use the mustache picker
to select dynamic properties from the response data to use them as labels.
If you turn color matching on, one item (a specific resource, object, site, anything you are displaying in your graphs) is shown in the same color in different graphs on one dashboard or one perspective. You can use either color matching or custom colors (colors based on values), they cannot both be used at the same time.
custom colors
Setting colors based on values
You can display the data in different colors based on values you define here. For example, you can display the data in green when the value is below 100 and in red when it is above 100.
Click on add to configure a condition.
Click on select color.... to open the color picker. Select the color for this condition.
Enter your condition in the field next to the color. You can use the value property and manipulate it with JavaScript String and Regex APIs. When you click on the mustache picker, you'll get some examples:
Value is greater than something, less than something, etc. For example: {{value < 10}} (The color you pick will be used if the value is less than 10)
Value is present in the result (scalar tiles only) For example: value.IndexOf('error') != -1 (The color you pick will be used if the string value "error" is present in the results)
Value matches one of the regular expressions you defined (scalar tiles only) For example: value.match(/healthy|good|up/) (The color you picked will be used if the string values are healthy, good, or up)
You are able to combine value matching with label matching.
Setting colors based on labels
You can display the data in different colors based on labels. For example, you can display data in green for a specific user.
Click on select color.... to open the color picker. Select the color for this condition.
Enter your condition in the field next to the color. You can use the label property and manipulate it with JavaScript String and Regex APIs. When you click on the mustache picker, you'll get some examples:
Condition is true if the label contains something For example: {{label.indexOf('SQL') != -1}} (The color you pick will be used if the label contains 'SQL')
Condition is true if the label contains multiple things For example: {{label.match(/C:|D:|E:/) != null}} (The color you pick will be used if the label contains 'C:', 'D:' or 'E:')
Condition is true if the label contains multiple things with multiple variations For example: {{label.match(/^[Ss]erver[0-9]+$/) != null}} (The color you pick will be used if the label is 'Server' or 'server' with a number after it)
You are able to combine label matching with value matching.
Which timeframe does this visualization use?
This visualization always uses the latest data and ignores the dynamic page timeframe set by users.
The Page Timeframe is the timeframe setting a dashboard or perspective is currently using. These timeframes are all relative to the current time, for example 7 days ago until now. When a user changes the page timeframe, all tiles that have Use Page Timeframe set will adapt to the new timeframe. (Tiles that do not have Use Page Timeframe set (i.e. are set to Specific Timeframe or Custom Timeframe) are not affected and won't change.)
The Custom option can be used to set timeframes using ISO 8601 format
SquaredUp DS does not support the week notation.
Settings:
Display
Here you can change the width and height of the individual blocks of the graph. Use the sliders for width and height to change the settings.
Fixed width: All blocks have the same width and height according to your settings.
Property based width: The blocks' size depends on the property you chose. The more of property x an object has (for example, the number of processors), the bigger the block will be displayed proportionally to the other blocks. You can still define the overall width and height with the sliders.
Color
Here you can choose the color scheme for your heatmap. Higher values are shown in a lighter shade of the color, and lower values in darker shades.
Data Range
The Data Range option allows you to choose the range of data the graph will display. For line graphs, this means the data on the y-axis.
percentage
Shows 0 to 100
fit to data
Shows the data minimum to data maximum
fit to data (from zero)
Shows from 0 to the data maximum
custom
Allows you to specify the min and max
custom fit
Allows you to specify the min and max limits, so that data outside your settings will not be shown. If all the data falls within your specified ranges then the y-axis range will fit to the data rather than your caps.
Label
auto
Choose this option if you want to use the default label that has been created automatically.
value
Your chosen metric is used as a label
none
No label
custom
Here you can change the label to a custom label. You can use static text and dynamic properties. Use the mustache picker
to select dynamic properties from the response data to use them as labels.
The Timeframe section allows you to determine the timeframe for the data. You can choose either to use:
Use Page Timeframe
The Page Timeframe is the timeframe setting a dashboard or perspective is currently using. These timeframes are all relative to the current time, for example 7 days ago until now. When a user changes the page timeframe, all tiles that have Use Page Timeframe set will adapt to the new timeframe. (Tiles that do not have Use Page Timeframe set (i.e. are set to Specific Timeframe or Custom Timeframe) are not affected and won't change.)
The Custom option can be used to set timeframes using ISO 8601 format
SquaredUp DS does not support the week notation.
Specific Timeframe
Choosing a Specific Timeframe allow you to set a fixed timeframe such as Last 1 hour or Last 7 days. You can use the available timeframes button to list the timeframes you can pick.
These timeframes are all relative to the current time, for example 7 days ago until now. Using this setting means that any change the user makes to the page timeframe is ignored.
The Custom option can be used to set timeframes using ISO 8601 format
SquaredUp DS does not support the week notation.
Custom Timeframe
This allows you to set a fixed timeframe window from the time and calendar picker. This sets a completely customizable timeframe window, not relative to now.
Top N
Here you can define a limit for the number of results you want to see. Activate the limit number of results displayed checkbox to enter a limit for results. You can choose if this limit should be applied from the top ranking results down (ascending, default option) or from the bottom ranking results up (descending).
Threshold
You can choose to apply a threshold line at a specified value, and whether you wish to fill above or below this value, or just show the line. For example, for free disk space you might want to fill below the line to highlight when space goes below a particular threshold. For processor information you might want to fill above the line to highlight when processor percentage goes above that threshold. The threshold is also shown on the drilldown view.
Max, min, avg
When drilled-down to view a graph, you can select the min, max and avgoptions for each object (displayed to the right of the graph), which displays a line cutting horizontally across the graph a each of the selected value points.
Data range
The Data Range option allows you to choose the range of data the graph will display. For line graphs, this means the data on the y-axis.
percentage
Shows 0 to 100
fit to data
Shows the data minimum to data maximum
fit to data (from zero)
Shows from 0 to the data maximum
custom
Allows you to specify the min and max
custom fit
Allows you to specify the min and max limits, so that data outside your settings will not be shown. If all the data falls within your specified ranges then the y-axis range will fit to the data rather than your caps.
Display
Height:
Allows you to set the height of the tile with a slider.
Show hover details:
Shows the value for all lines at any point you hover. There may not be a value exactly where you hover so the value is interpolated from the values either side.
Show points:
Shows where the data points are on the line. Useful to identify missing points, or detail for changing data.
Show trend
Enable the Show Trend Linestoggle to display a trend line for the line graph data. Disable the toggle to hide the trend line.
Custom colors:
You can display the data in different colors based on labels. For example, you can display data in green for a specific user.
Click on select color.... to open the color picker. Select the color for this condition.
Enter your condition in the field next to the color. You can use the label property and manipulate it with JavaScript String and Regex APIs. When you click on the mustache picker, you'll get some examples:
Condition is true if the label contains something For example: {{label.indexOf('SQL') != -1}} (The color you pick will be used if the label contains 'SQL')
Condition is true if the label contains multiple things For example: {{label.match(/C:|D:|E:/) != null}} (The color you pick will be used if the label contains 'C:', 'D:' or 'E:')
Condition is true if the label contains multiple things with multiple variations For example: {{label.match(/^[Ss]erver[0-9]+$/) != null}} (The color you pick will be used if the label is 'Server' or 'server' with a number after it)
Label
Allows you to change the label of the results.
Options
Show legend
Allows you to show or hide the legend of the graph.
Sort legend
Allows you to sort the legend entries is ascending or descending order.
Label:
auto
Choose this option if you want to use the default label that has been created automatically.
custom
Here you can change the label to a custom label. You can use static text and dynamic properties. Use the mustache picker
to select dynamic properties from the response data to use them as labels.
Allows you to format the value, using the mustache picker, and the modified values will be shown on the axis and hover values. For example, you can round the value up or down or convert it.
Timeframe
The Timeframe section allows you to determine the timeframe for the data. You can choose either to use:
Use Page Timeframe
The Page Timeframe is the timeframe setting a dashboard or perspective is currently using. These timeframes are all relative to the current time, for example 7 days ago until now. When a user changes the page timeframe, all tiles that have Use Page Timeframe set will adapt to the new timeframe. (Tiles that do not have Use Page Timeframe set (i.e. are set to Specific Timeframe or Custom Timeframe) are not affected and won't change.)
The Custom option can be used to set timeframes using ISO 8601 format
SquaredUp DS does not support the week notation.
Specific Timeframe
Choosing a Specific Timeframe allow you to set a fixed timeframe such as Last 1 hour or Last 7 days. You can use the available timeframes button to list the timeframes you can pick.
These timeframes are all relative to the current time, for example 7 days ago until now. Using this setting means that any change the user makes to the page timeframe is ignored.
The Custom option can be used to set timeframes using ISO 8601 format
SquaredUp DS does not support the week notation.
Custom Timeframe
This allows you to set a fixed timeframe window from the time and calendar picker. This sets a completely customizable timeframe window, not relative to now.
Threshold
You can choose to apply a threshold line at a specified value, and whether you wish to fill above or below this value, or just show the line. For example, for free disk space you might want to fill below the line to highlight when space goes below a particular threshold. For processor information you might want to fill above the line to highlight when processor percentage goes above that threshold. The threshold is also shown on the drilldown view.
Data range
The Data Range option allows you to choose the range of data the graph will display. For line graphs, this means the data on the y-axis.
percentage
Shows 0 to 100
fit to data
Shows the data minimum to data maximum
fit to data (from zero)
Shows from 0 to the data maximum
custom
Allows you to specify the min and max
custom fit
Allows you to specify the min and max limits, so that data outside your settings will not be shown. If all the data falls within your specified ranges then the y-axis range will fit to the data rather than your caps.
Display
Height:
Allows you to set the height of the tile with a slider.
Show hover details:
Shows the value for all lines at any point you hover. There may not be a value exactly where you hover so the value is interpolated from the values either side.
Solid bars:
Show the bars as solid color or translucent.
Custom colors:
You can display the data in different colors based on labels. For example, you can display data in green for a specific user.
Click on select color.... to open the color picker. Select the color for this condition.
Enter your condition in the field next to the color. You can use the label property and manipulate it with JavaScript String and Regex APIs. When you click on the mustache picker, you'll get some examples:
Condition is true if the label contains something For example: {{label.indexOf('SQL') != -1}} (The color you pick will be used if the label contains 'SQL')
Condition is true if the label contains multiple things For example: {{label.match(/C:|D:|E:/) != null}} (The color you pick will be used if the label contains 'C:', 'D:' or 'E:')
Condition is true if the label contains multiple things with multiple variations For example: {{label.match(/^[Ss]erver[0-9]+$/) != null}} (The color you pick will be used if the label is 'Server' or 'server' with a number after it)
Label
Allows you to change the label of the results.
Options
Show legend
Allows you to show or hide the legend of the graph.
Sort legend
Allows you to sort the legend entries is ascending or descending order.
Label:
auto
Choose this option if you want to use the default label that has been created automatically.
custom
Here you can change the label to a custom label. You can use static text and dynamic properties. Use the mustache picker
to select dynamic properties from the response data to use them as labels.
Allows you to format the value, using the mustache picker, and the modified values will be shown on the axis and hover values. For example, you can round the value up or down or convert it.
Timeframe
The Timeframe section allows you to determine the timeframe for the data. You can choose either to use:
Use Page Timeframe
The Page Timeframe is the timeframe setting a dashboard or perspective is currently using. These timeframes are all relative to the current time, for example 7 days ago until now. When a user changes the page timeframe, all tiles that have Use Page Timeframe set will adapt to the new timeframe. (Tiles that do not have Use Page Timeframe set (i.e. are set to Specific Timeframe or Custom Timeframe) are not affected and won't change.)
The Custom option can be used to set timeframes using ISO 8601 format
SquaredUp DS does not support the week notation.
Specific Timeframe
Choosing a Specific Timeframe allow you to set a fixed timeframe such as Last 1 hour or Last 7 days. You can use the available timeframes button to list the timeframes you can pick.
These timeframes are all relative to the current time, for example 7 days ago until now. Using this setting means that any change the user makes to the page timeframe is ignored.
The Custom option can be used to set timeframes using ISO 8601 format
SquaredUp DS does not support the week notation.
Custom Timeframe
This allows you to set a fixed timeframe window from the time and calendar picker. This sets a completely customizable timeframe window, not relative to now.
Data Range
The Data Range option allows you to choose the range of data the graph will display. For line graphs, this means the data on the y-axis.
percentage
Shows 0 to 100
fit to data
Shows the data minimum to data maximum
fit to data (from zero)
Shows from 0 to the data maximum
custom
Allows you to specify the min and max
custom fit
Allows you to specify the min and max limits, so that data outside your settings will not be shown. If all the data falls within your specified ranges then the y-axis range will fit to the data rather than your caps.
Sort
Sort allows you to change the order of the results displayed. You can sort by value (ascending or descending) or label (alphabetically ascending or descending).
Value
Value Formatter
Allows you to format the value, using the mustache picker, and the modified values will be shown on the axis and hover values. For example, you can round the value up or down or convert it.
Label
Allows you to change the label of the results.
auto
Choose this option if you want to use the default label that has been created automatically.
custom
Here you can change the label to a custom label. You can use static text and dynamic properties. Use the mustache picker
to select dynamic properties from the response data to use them as labels.
If you turn color matching on, one item (a specific resource, object, site, anything you are displaying in your graphs) is shown in the same color in different graphs on one dashboard or one perspective. You can use either color matching or custom colors (colors based on values), they cannot both be used at the same time.
custom colors
Setting colors based on values
You can display the data in different colors based on values you define here. For example, you can display the data in green when the value is below 100 and in red when it is above 100.
Click on add to configure a condition.
Click on select color.... to open the color picker. Select the color for this condition.
Enter your condition in the field next to the color. You can use the value property and manipulate it with JavaScript String and Regex APIs. When you click on the mustache picker, you'll get some examples:
Value is greater than something, less than something, etc. For example: {{value < 10}} (The color you pick will be used if the value is less than 10)
Value is present in the result (scalar tiles only) For example: value.IndexOf('error') != -1 (The color you pick will be used if the string value "error" is present in the results)
Value matches one of the regular expressions you defined (scalar tiles only) For example: value.match(/healthy|good|up/) (The color you picked will be used if the string values are healthy, good, or up)
You are able to combine value matching with label matching.
Setting colors based on labels
You can display the data in different colors based on labels. For example, you can display data in green for a specific user.
Click on select color.... to open the color picker. Select the color for this condition.
Enter your condition in the field next to the color. You can use the label property and manipulate it with JavaScript String and Regex APIs. When you click on the mustache picker, you'll get some examples:
Condition is true if the label contains something For example: {{label.indexOf('SQL') != -1}} (The color you pick will be used if the label contains 'SQL')
Condition is true if the label contains multiple things For example: {{label.match(/C:|D:|E:/) != null}} (The color you pick will be used if the label contains 'C:', 'D:' or 'E:')
Condition is true if the label contains multiple things with multiple variations For example: {{label.match(/^[Ss]erver[0-9]+$/) != null}} (The color you pick will be used if the label is 'Server' or 'server' with a number after it)
You are able to combine label matching with value matching.
Which timeframe does this visualization use?
This visualization always uses the latest data and ignores the dynamic page timeframe set by users.
The Page Timeframe is the timeframe setting a dashboard or perspective is currently using. These timeframes are all relative to the current time, for example 7 days ago until now. When a user changes the page timeframe, all tiles that have Use Page Timeframe set will adapt to the new timeframe. (Tiles that do not have Use Page Timeframe set (i.e. are set to Specific Timeframe or Custom Timeframe) are not affected and won't change.)
The Custom option can be used to set timeframes using ISO 8601 format
SquaredUp DS does not support the week notation.
Settings:
Scalar
Font size
Allows you to set the font size of the value in the tile.
Alignment
Select the scalar text alignment. Choose from left, center or right.
Unit
Allows you to add a unit to the value displayed in the Scalar tile. For example, if your value shows a time in milliseconds, you can enter "ms" or if your value shows pageviews, you can enter "pageviews".
Value Formatter
Allows you to format the value, using the mustache picker, and the modified values will be shown on the axis and hover values. For example, you can round the value up or down or convert it.
Color
Conditional formatting:
You can display the data in different colors based on values you define here. For example, you can display the data in green when the value is below 100 and in red when it is above 100.
Click on add to configure a condition.
Click on select color.... to open the color picker. Select the color for this condition.
Enter your condition in the field next to the color. You can use the value property and manipulate it with JavaScript String and Regex APIs. When you click on the mustache picker, you'll get some examples:
Value is greater than something, less than something, etc. For example: {{value < 10}} (The color you pick will be used if the value is less than 10)
Value is present in the result (scalar tiles only) For example: value.IndexOf('error') != -1 (The color you pick will be used if the string value "error" is present in the results)
Value matches one of the regular expressions you defined (scalar tiles only) For example: value.match(/healthy|good|up/) (The color you picked will be used if the string values are healthy, good, or up)
Display:
Here you decide how the color is used:
Tile background
Highlight the tile in the color you defined.
Text foreground
Display the text in the color you defined.
Link options
Allows you to turn the graph item(s) into links. You can either enter plain text to create a fixed link (URL always stays the same) or use dynamic properties to create a dynamic link.
Dynamic links make use of dynamic properties which are inserted as part of the URL. This creates a template URL that will be resolved to an actual URL based on the items properties.
For example, if you want to link to tickets in your ticket system and the format of the URL for tickets in your system is https://www.my-system/ticket-123, where 123 is the ticket ID, you can use the dynamic property that contains the ticket ID and enter the dynamic URL https://www.my-system/ticket-{{ticketID}}.
For scalars, you can only use the dynamic property value in dynamic links, which means the link changes when the value of the scalar changes. Since a scalar is just one item, it would also make sense to use a fixed link, for example the link to the website of which you are displaying the response time.
For status icon or bars and the rows of a grid, you usually want to use a dynamic link since you get multiple items or rows that represent different things. You can use any of the dynamic properties the mustache picker offers you.
Dynamic mustache properties and values you need to change according to your instance are highlighted in bold.
Add a new tile to a dashboard or perspective and choose the Performance tile.
Choose the Report visualization.
Allows you to compare metrics, such as two different metrics or metrics over different time periods. For example, compare Processor Time with Memory Available, or compare Percentage CPU with the same period last week.
Report editor: Click on Configure report to switch to the report editor. In the report editor, you can compare different metrics and time periods with each other: Examples:
Timeframe (at the top of the editor)
There is only one timeframe for the report and it can be controlled from two different places, in the timeframe panel in the tile and in the report editor. If you change the timeframe in the panel, the timeframe in the report editor changes. If you change the timeframe in the report editor, the timeframe changes in the panel.
The Timeframe section allows you to determine the timeframe for the data. You can choose either to use:
Use Page Timeframe
The Page Timeframe is the timeframe setting a dashboard or perspective is currently using. These timeframes are all relative to the current time, for example 7 days ago until now. When a user changes the page timeframe, all tiles that have Use Page Timeframe set will adapt to the new timeframe. (Tiles that do not have Use Page Timeframe set (i.e. are set to Specific Timeframe or Custom Timeframe) are not affected and won't change.)
The Custom option can be used to set timeframes using ISO 8601 format
SquaredUp DS does not support the week notation.
Specific Timeframe
Choosing a Specific Timeframe allow you to set a fixed timeframe such as Last 1 hour or Last 7 days. You can use the available timeframes button to list the timeframes you can pick.
These timeframes are all relative to the current time, for example 7 days ago until now. Using this setting means that any change the user makes to the page timeframe is ignored.
The Custom option can be used to set timeframes using ISO 8601 format
SquaredUp DS does not support the week notation.
Custom Timeframe
This allows you to set a fixed timeframe window from the time and calendar picker. This sets a completely customizable timeframe window, not relative to now.
SquaredUp DS automatically uses the highest resolution data available for the time period. If for example you are comparing a weeks worth of data with this time last week, then last weeks data (days 8-14) will most likely being showing hourly data, because by default the retention settings only keep raw data in the Data Warehouse for 10 days (see How to optimise the Data Warehouse - 5 Point Plan).
If your report uses the page timeframe, some page timeframe settings might make it impossible to show a time comparison. The page timeframe must be set to a shorter range than the time comparison. Example: Your report uses the page timeframe and your time comparison is set to last week (which means 7 days ago from today). When a user changes the page timeframe to last 30 days (which means 30 days ago from today), the time range of the report data is longer than the time comparison.
How to identify this issue: When the comparison line cannot be shown a yellow exclamation mark will be shown at the top right of the tile with a message similar to Timeframe from 5/25/2019 10:26:00 AM to 6/24/2019 10:26:00 AM cannot be shifted by the range 'Last7Days' because it is longer than the range.
How to fix this issue: If you set your report to a specific timeframe, this issue will not occur since the page timeframe will be ignored.
Scope
The scope allows you to define which objects are shown, which in turn determines which metrics are available. For the full information on scoping tiles on dashboards and perspectives, as well as FAQs, see How to scope tiles.
Note for using the group or advanced option:
By default the scope of Performance tiles will look at multiple levels of membership (recursive search) for objects, so they will look at multiple-levels of membership rather than just one level. This means the tile shows data for objects that aren't directly contained in a group, but are contained within other objects. For example, this allows you to find disk metrics when scoped to a server.
If the scoped group contains only subgroups and you have not specified a class, then no metrics will be available in the metrics drop down list. By specifying a group AND a class it means that you can extend this recursive search to use top-level groups to show graph data for objects within sub-groups (as well as objects).
To enable recursive searching to work for sub-groups you should specify a group AND a class in the advanced scope option. This will allow the dropdown list to show the metrics for the objects in the sub-groups.
Note for choosing a class:
Choose your class carefully as for a Performance tile this will determine which metrics are available in the Metric panel.
Note for Scalars:
The Scalar visualization should be scoped to only one object using the list option, as only one figure is shown. Do not use a group.
Metric
Here you define which value the graph will show. For example, if you want to see the response time of different servers, your metric value would be response time. If you want to see the number of tickets, your metric value would be number (of tickets).
Quick find:
The drop-down list will show you a list of all metrics available for the scope you have set. Press the down arrow on your keyboard in the choose metric field to see the list.
Advanced:
Allows you to specify the object, counter and/or instance. For example, you can use the quick find to find and select the metric LogicalDisk - % Free Space, and then click on advanced and specify C: in the instance box to only view C: drives.
Exclude matching instances:
Checking Exclude matching instances will show all instances other than those you've specified, i.e. NOT C: drives (v7.0 and above).
Resolution refers to the raw, hourly or daily data stored in the Data Warehouse.
SquaredUp DS, when using the auto resolution setting, uses the highest resolution data available (raw, hourly or daily), based on what data is available in the Data Warehouse for the whole graph timeframe. So SquaredUp DS will use raw data as long as it is available for the whole reporting timeframe, then it will use hourly, and when that is not available for the whole timeframe it will use daily data.
For Performance tiles the resolution is set in metric > resolution
Using the autoresolution setting on a Performance tile automatically changes to a more suitable resolution when the page timeframe is changed by a user, in order to optimize the time to return the graphs.
The auto setting applies to visualizations that use time periods, such as line graphs, sparklines and reports. Visualizations that do not show a time period, such as Bar Top N, Heatmap and Scalar, use the latest data point. These visualizations do not change when a user changes the page timeframe. For these visualizations the auto resolution setting defaults to daily.
The data available in the Data Warehouse is determined by the retention period set in SCOM.
When a resolution of hourly or daily is chosen you can select whether you'd like to see the average, minimum or maximum figures for that aggregated time period. For example, for a web transaction you might want to see the maximum or minimum figures rather than the average.
This allows you to specify that metric label, which is then displayed on the y-axis and hover value.
You should select the label that matches how the the data is being returned, or use the other option to specify a custom metric label, such as pages/sec or count.
Here you can define a limit for the number of results you want to see. Activate the limit number of results displayed checkbox to enter a limit for results. You can choose if this limit should be applied from the top ranking results down (ascending, default option) or from the bottom ranking results up (descending).
Time comparison Creates a new line in the graph that shows the same data, but how it looked like in the past. The line will be a dashed line to be easily identifiable as a time comparison. If the line refers to the same object, the lines will be the same color, with the time comparison line in a lighter shade. You can choose different points in the past between yesterday and 12 months ago. If you don't want a time comparison line in your graph, leave the setting to none (default).
For SquaredUp DS v4.4 and above: The time comparison always shows the same objects. The top n setting is applied to the objects for the current time period, and then the same objects are shown for the time comparison as dashed lines.
For SquaredUp DS v4.3 and below: When you limit the number of results using the top n option in a time comparison in the Report tile, the top n lines are shown for the current time period can be different from the top n lines shown for the time comparison period. For example, if your top n settings limit the number of results to the top 5 results (ascending) and compare them to the results 30 days ago, there might be different results in the top 5 which leads to different objects shown in the graph.
Note: Only the lines shown for the current time period are shown in the legend, which may not be clear when using Open Access.
SquaredUp DS automatically uses the highest resolution data available for the time period. If for example you are comparing a weeks worth of data with this time last week, then last weeks data (days 8-14) will most likely being showing hourly data, because by default the retention settings only keep raw data in the Data Warehouse for 10 days (see How to optimise the Data Warehouse - 5 Point Plan).
Y-axis Here you can decide if the values (y-axis) and labels for this layer will be shown on the left or right side of the graph. If you want to compare two different metrics, it makes sense to put one layer's metrics on the left side and the other layer's metrics on the right side.
Label
auto
Choose this option if you want to use the default label that has been created automatically.
custom
Here you can change the label to a custom label. You can use static text and dynamic properties. Use the mustache picker
to select dynamic properties from the response data to use them as labels.
A Layer contains the object and the metric. By adding new layers, you add new metrics and compare them with each other.
Time comparisons compares different time periods of the same metric in the same layer.
If you want to compare how one metric looks compared to the same metric six months ago, you only need one layer with a time comparison.
If you want to compare the CPU usage to the memory usage of one computer, you need two layers with different metrics.
Click back to dashboard in the upper left corner to get back from the report editor to your dashboard.
If you want to define further settings for your report, you need to switch the dashboard to edit mode and edit the tile.
Timeframe:
There is only one timeframe for the report and it can be controlled from two different places, in the timeframe panel in the tile and in the report editor. If you change the timeframe in the panel, the timeframe in the report editor changes. If you change the timeframe in the report editor, the timeframe changes in the panel.
The Timeframe section allows you to determine the timeframe for the data. You can choose either to use:
Use Page Timeframe
The Page Timeframe is the timeframe setting a dashboard or perspective is currently using. These timeframes are all relative to the current time, for example 7 days ago until now. When a user changes the page timeframe, all tiles that have Use Page Timeframe set will adapt to the new timeframe. (Tiles that do not have Use Page Timeframe set (i.e. are set to Specific Timeframe or Custom Timeframe) are not affected and won't change.)
The Custom option can be used to set timeframes using ISO 8601 format
SquaredUp DS does not support the week notation.
Specific Timeframe
Choosing a Specific Timeframe allow you to set a fixed timeframe such as Last 1 hour or Last 7 days. You can use the available timeframes button to list the timeframes you can pick.
These timeframes are all relative to the current time, for example 7 days ago until now. Using this setting means that any change the user makes to the page timeframe is ignored.
The Custom option can be used to set timeframes using ISO 8601 format
SquaredUp DS does not support the week notation.
Custom Timeframe
This allows you to set a fixed timeframe window from the time and calendar picker. This sets a completely customizable timeframe window, not relative to now.
If your report uses the page timeframe, some page timeframe settings might make it impossible to show a time comparison. The page timeframe must be set to a shorter range than the time comparison. Example: Your report uses the page timeframe and your time comparison is set to last week (which means 7 days ago from today). When a user changes the page timeframe to last 30 days (which means 30 days ago from today), the time range of the report data is longer than the time comparison.
How to identify this issue: When the comparison line cannot be shown a yellow exclamation mark will be shown at the top right of the tile with a message similar to Timeframe from 5/25/2019 10:26:00 AM to 6/24/2019 10:26:00 AM cannot be shifted by the range 'Last7Days' because it is longer than the range.
How to fix this issue: If you set your report to a specific timeframe, this issue will not occur since the page timeframe will be ignored.
Data range:
The Data Range option allows you to choose the range of data the graph will display. For line graphs, this means the data on the y-axis.
percentage
Shows 0 to 100
fit to data
Shows the data minimum to data maximum
fit to data (from zero)
Shows from 0 to the data maximum
custom
Allows you to specify the min and max
custom fit
Allows you to specify the min and max limits, so that data outside your settings will not be shown. If all the data falls within your specified ranges then the y-axis range will fit to the data rather than your caps.
Height:
Height:
Allows you to set the height of the tile with a slider.
Legend:
Options
Show legend
Allows you to show or hide the legend of the graph.
Click done to save the tile.
The tile now shows data according to your settings.
Graph color matching means that one item (a specific resource, object, site, anything you are displaying in your graphs) is shown in the same color in different graphs on one dashboard or one perspective.
Line Graphs, Sparklines, Bar Graphs and Reports (available in Performance tiles) support graph color matching.
Color matching only works when the item uses the exact same label in all graphs.
For SquaredUp DS v4.8 and above: Graph lines on a dashboard will show the same color when the object labels match, even if those graphs show different metrics.
For SquaredUp DS v4.7 and below: Graph lines will only show the same color for the same object when displaying the same metric.
Graph color matching must be enabled for the dashboard or the perspective. The default setting for all dashboards and perspectives is color matching enabled.
The default setting for graph color matching is on. Here's how you can check or change this setting:
On a dashboard or perspective click the edit button
Click the settings button.
The match by label button is under Graph colors. If you want to disable color matching, toggle the match by label button to OFF. If you want to enable color matching, toggle the match by label button to ON.
The label for the item must be the same in all graphs that you want to display the same color.
In the label panel of your graph, set the label to custom label.
If you are using a mustache property, make sure that you use the same property in all graphs you want to color match. If you are using a manipulated mustache label (for example, custom text between labels like Name: {{properties.name}} ), make sure to use the exact same label in all graphs you want to color match. If you are using custom text, make sure to use the exact same custom text including upper and lower cases.
For resources that show the same label the colors will now match:
For Sparklines and Bar Graphs (called Bar Top N in Performance tiles), you need to switch on multiple colors to enable color matching. Multiple colors is switched off by default, you need to switch it on for each Sparkline and Bar Graph.
Go to the color panel of the Sparkline or Bar Graph.
Toggle multiple colors to on. The Sparkline or Bar Graph will now color match, as long as the dashboard setting match by label is on and the labels do match.
Walkthrough: Adding a Line Graph to show % Processor Time
The Performance tile can be used on a dashboard or a perspective. This walkthrough shows you how to add a Line Graph to a dashboard.
In SquaredUp DS navigate to where you'd like the dashboard to be created. Hover over the + button and click dashboard.
Give the dashboard a title, by replacing the text that says New Dashboard. The dashboard is saved as you go along so there's no need to save your changes. You can find your dashboard in System > Administration > Content > Unpublished.
A new tile has already been added to the dashboard. Edit the title by overwriting the placeholder value New tile with your own title.
The tile selector will already be open. Click Performance. The Performance tile button (along with several other tiles) displays a little plus up the top right. This indicates that there are more tiles available from this one button.
Click on the Line Graph button to create a line graph.
Next we need to scope the tile. In the scope section select group then type the name of a group, such as the IIS Computer Group and then click on the group from the results. Correctly scoping the tile is very important. To find out more about advanced scoping options see How to use criteria when scoping objects. On perspectives the tile scope will only show you the groups and classes that the object you have drilled down to is a member of.
Click next.
The quick find option will find metrics available for the scope you have set. Either start typing, or press the down arrow on the keyboard to see a list of all the metrics available. For this walkthrough type processor and then select the metric Processor Information - % Processor Time. Performance graphs for the servers should appear after a moment. You could stop here, but we'll continue to configure the tile.
Under metric label click on percent. % symbols will show on the y-axis of the graph, and very small values will be shown in percent rather than milli values (see Understanding the figures on Performance graphs).
Click next.
Leave the Timeframe set to use page timeframe so the time period for this tile changes when users change the page timeframe.
Click next.
In the top n section limit the number of results displayed to 3, and tick descending to show those with the highest processor utilization.
Leave data range as it is.
In the display section drag the slider to increase the graph height.
Leave the label section as it is. For more information on changing the label see How to use Custom Labels.
Click done.
Walkthrough: Adding a Heatmap to show % Processor time and Logical Processors
Click the orange + plus button to add a new tile to the dashboard.
Click Performance, and then the Heatmap button.
In the scope section select group then type the name of a group, such as the IIS Computer Group and then click on that group in the results. On perspectives the tile scope will only show you the groups and classes that the object you have drilled down to is a member of.
In the metricquick find section type processor and then select the metric Processor Information - % Processor Time. A heatmap should appear after a moment.
Once you've chosen a metric give the tile a title which explains what the tile shows.
In the display section adjust the width and height sliders to change the heatmap sizes. In addition, you can choose to use a property to determine the size of each rectangle, for example logicalProcessors.
By default objects with no data are hidden, you can choose to show them by ticking the box show objects with no data.
The color section allows you to change the heatmap color.
Leave the data range section as it is for now. This allows you to change the range of values shown.
Leave the label section as it is. For more information on changing the label see How to use Custom Labels.
Click done.
Walkthrough: Adding a Report to compare different metrics and/or time periods
This walkthrough shows you how to add metrics as layers to the Report tile, and also how to compare them with historical data.
Click on the Report button to create a Report.
Give the tile a title.
The Report tile uses layers to allow you to add multiple metrics to one graph for comparison. This could get difficult to view in a narrow column, so this tile allows you to edit the tile full screen in a report editor). Click configure report to open the report editor and add layers.
The report editor has opened full screen, but you can return to your dashboard at any time by clicking the back to dashboard button at the top right. The layer configuration appears on the left side of the screen, and a preview of the graph will show on the right as your proceed.
The first layer is expanded ready for you to edit. Give the layer a title, such as the metric you intend to add.
For this walkthrough we are going to compare two metrics for one machine. In the scope section click list then type the name of a machine, and then click on that machine in the results.
In the metric > quick find box type the name of the first metric you want to add. For this walkthrough type processor and then select the metric Processor Information / % Processor Time. The right side of the screen will show a preview of the graph. You could stop here, but we'll continue to configure the tile.
Click done.
Click the orange plus button to add a second layer for your next metric.
Give this layer the title of the metric you are adding.
Click list then type the name of machine you used for the first layer, and then click on that machine in the results.
In the metric > quick find box type the name of the first metric you want to add. For this walkthrough type memory and then select the metric Memory / PercentMemoryUsed.
Leave the top n section as it is for this walkthrough. You might like to add a line to allow you to compare this data with historical data. Adding the time comparison is optional.
In the time comparison section click one of the time periods to compare with this data, for example click yesterday.
To add a time comparison for the existing layer, hover over the existing layer and then click the compare layer button to jump straight into the time comparison section and then click yesterday.
In the y-axis section click on right to get the PercentMemoryUsed graph to use the right-hand y-axis. This is useful because the two metrics use quite different scales, so the two graphs show more clearly using two different y axes.
Leave the label section as it is. For more information on changing the label see How to use Custom Labels.
At this point the graph is complete, so you can click done and then the back to dashboard button up the top right of the page.
Return to editing the Report tile by clicking the edit this dashboard button at the top right, and then the edit tile button to the top right of the tile itself.
Click into the legend configuration section and click on show legend to tick the box.
Clicking on a line graph, bar chart or sparkline will take you to a Performance drilldown page. On a line graph you can click on an individual line to drilldown to that one line, or click on white space to drilldown to multiple lines.
From here you can:
Change the timeframe using the options along the top, the custom timeframe picker, or by clicking on the graph itself.
Compare the data to another object or group of objects.
Export the performance data to Excel for further analysis (see Export to Excel).
If your report uses the page timeframe, some page timeframe settings might make it impossible to show a time comparison. The page timeframe must be set to a shorter range than the time comparison. Example: Your report uses the page timeframe and your time comparison is set to last week (which means 7 days ago from today). When a user changes the page timeframe to last 30 days (which means 30 days ago from today), the time range of the report data is longer than the time comparison.
How to identify this issue: When the comparison line cannot be shown a yellow exclamation mark will be shown at the top right of the tile with a message similar to Timeframe from 5/25/2019 10:26:00 AM to 6/24/2019 10:26:00 AM cannot be shifted by the range 'Last7Days' because it is longer than the range.
How to fix this issue: If you set your report to a specific timeframe, this issue will not occur since the page timeframe will be ignored.
SquaredUp DS automatically uses the highest resolution data available for the time period. If for example you are comparing a weeks worth of data with this time last week, then last weeks data (days 8-14) will most likely being showing hourly data, because by default the retention settings only keep raw data in the Data Warehouse for 10 days (see How to optimise the Data Warehouse - 5 Point Plan).
For SquaredUp DS v4.4 and above: The time comparison always shows the same objects. The top n setting is applied to the objects for the current time period, and then the same objects are shown for the time comparison as dashed lines.
For SquaredUp DS v4.3 and below: When you limit the number of results using the top n option in a time comparison in the Report tile, the top n lines are shown for the current time period can be different from the top n lines shown for the time comparison period. For example, if your top n settings limit the number of results to the top 5 results (ascending) and compare them to the results 30 days ago, there might be different results in the top 5 which leads to different objects shown in the graph.
Note: Only the lines shown for the current time period are shown in the legend, which may not be clear when using Open Access.