Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You can filter your instances by:

  • Instance - select Select the instances you want to see.

  • Owner  - select Select the owner of the instance you want to see. 
  • Location  - select Select the location for which you want to see their respective instances. 
  • SQL Server Version  - select Select specific SQL Server versions. 
  • Status  - use this option to filter Filter your instances according to the following instance status : (Unknown, Online, Connection Failure, Unsupported SQL Server Version, Authentication Failure, or Error)
  • Agent status - select Select specific agent status to filter your information. You can select from: Running, Stopped, Stopping, Starting, or Unknown. 
  • # of Jobs - use Use the sliders to specify an interval of a number of jobs.   The instances that fall in this interval will be displayed.   
  • # of Failed Jobs -  use   Use the sliders to specify the interval of jobs  which jobs whose last status was failed. The instances that fall in this interval will be displayed. 
Tip

When using filters take into account:

  • Some filters have the option to Add Filter in case the information you are looking for is not listed. Once you click on Add Filter, a dialog box appears. Type the name you are looking for on the Search bar, then select it from the list, and Save. Your filter will be included under the filter list where you Addedadded it.
  • Click the respective checkbox to add or remove your selections.
  • If you want to select filters first and apply the changes later, deselect the Apply Filter Instantly option.

...

You can save your preferred filtering options by typing a name in the Add Filter wizard of the Custom Filter section, section and click clicking Save. Once you save your filter, you can retrieve it from the drop-down bottom of the Custom Filter option option available in on the left side under the Filter Table By section. 

...