Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Minor edit

...

The principal function of this filtering option is the Advanced Filter button.

Advance Filter

When you select the Advanced Filter button, a drop-down menu opens with a list of configured filters.

At the top of the Dropdrop-Down down list, you have the option to Create New Filter, the button opens a new wizard:

...

On the Custom Filter Name define a name for the filter.

With the The Add Filter button adds a row of parameters to define the filter is added:

...

, according to the order, on each raw field you can select:

...

First ColumnSecond ColumnThird ColumnFourth Column
  • SQL Server
  • Status
  • Edition
  • # of DBs
  • Size (MB)
  • Owner
  • Location
  • Clustered
  • Discovery methods

...

  • Contains
  • Between
  • After
  • Before
  • >=
  • <=
  • Equals

...

  • List of instances
  • Instances status (UP, DOWN).
  • Edition (PRO, ULTIMATE, Enterprise)
  • Number of databases (10, 20, 30)
  • Size (MB) (100 MB, 200 MB, 600 MB)
  • Owner (Product Manager, Developer)
  • Location (CA, Austin)
  • Clustered (No, Yes)
  • Discovery methods (Browser, Service, Service 1)
  • Range of date and time

...

  • AND
  • OR
  • NOT
Note

The third column varies according to the first and second columns.

You can add as many rows as you require in your filter.

After configuring you your filter you can Apply Filters without Saving and the filter will be available in the principal drop-down list with an Unsaved Filter name.

Or Save and Filter and the filter will be saved with the name you assigned to it, after . After saving a tag will be placed above the grid.

Image Removed

Pointing to the filter name, the edit Edit and delete Delete options will display. The Save option will only be available for Unsaved filters.

...

The Delete option deletes the filter permanently.

Export Filter

You can export the filtered results in three different formats:

  • Excel
  • CSV
  • HTML

Clear Filters

When there are no filters applied this button is disabled.

With this option enabled, you can remove the tag filters placed above the grid. If only one filter is selected before clicking the Clear Filters button, only that filter is deleted.


Scroll pdf ignore
Excerpt

Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse