Page History
...
Like this example, you have many different options to select the information you want to see from your environment. By using tags, owners, and locations from your SQL Servers instances, you get significant advantages from this section.
...
Choosing the information you want to see
...
The View Selection section allows you to choose what specific information or under which main parameter you want SQL Inventory Manager to display the information.
...
Tip | ||
---|---|---|
| ||
You can enable the option Applying filter as it changes to have immediate information, or you can disable this option when you want to make your selections first and see the requested information after you finish. |
...
Using filters
...
to refine what information you see
After you choose what data you want to see and by which parameter, you can also optionally select from the group of filters to narrow your search criteria. This section contains the following options:
Instance Tags
This option allows you to determine a specific instance tag or tags for your selection.
...
If you want to remove your selections, click Remove tag filters.
Database Tags
This option allows you to determine a specific database tag or tags for your selection.
...
If you want to remove your selections, click Remove tag filters.
Owner
This option allows you to determine a specific owner or owners for your selection.
...
If you want to remove your selections, click Remove owner filters.
Location
This option allows you to determine a specific location or locations for your selection.
...
If you want to remove your selections, click Remove location filters.
Instance
This option allows you to determine a specific instance or instances for your selection.
...
If you want to remove your selections, click Remove instance filters.
Version
This option allows you to determine a specific version or versions for your selection.
...
Tip | ||
---|---|---|
| ||
As you filter your information, the options you select appear on the top section of your graphs. You can uncheck from this section to individually remove filters. |
...
Viewing filtered information
After you specify the filters you need, SQL Inventory Manager displays graphs to provide a visual representation of the data you have selected. The bar and pie graphs let you quickly get a glance of your environment according to your parameters.
...
Tip | ||
---|---|---|
| ||
You can click a database or instance name to access its respective details. For more information on what is available on these views, refer to Viewing Database Details or Viewing instance details respectively. |
...
Saving your filtering criteria
Creating a useful filter to "weed out" unnecessary information takes time but is important when managing large environments. As a result, you may want to save that filter for future use. SQL Inventory Manager allows you to save filters for use in the Explorer and Instances views. Simply create the filter, and then click Save as Explorer favorite or click Save as Instances favorite, depending on which view you are in when creating the filter. To use that filter, click Load Explorer favorite or click Load Instances favorite.
...
Drill-down options for locating more specific information
...
Drill down to view by instances
When you view high-level objects such as tags, owners, locations, or versions, you can drill down to see their respective instances by clicking the arrow icon next to the object you want to see more specific information.
...
For example, if you are viewing "Data Size by Tags", you can click the arrow next to a tag name to drill down the instances that belong to this tag. The view changes to "Data Size by Instances" and filters it by the selected tag.
Drill down to view by databases
When you are viewing your information by instances, you can drill down one more level and view by databases.
Click
next to the instance you want to see its respective databases, and SQL Inventory Manager displays the list of databases that belong to the respective instance. The view changes to View by Databases and filters it by the selected instance.You can go back to the previous view by clicking
on the top left section of your databases list.How can you export the information available on the
Exporting Explorer view
...
information
You can export the information available on the Explorer view, by clicking the Export option on the right-bottom side of your graphs and selecting your preferred format for Exporting: PDF, XLS, or XML.
...
...