Page History

...

IDERA SQL Inventory Manager gathers information that allows you to determine your SQL Server licensing requirements. The SQL Licensing view shows information like the instance version, edition, host computer name, CPU name, number of logical and physical processors, and whether the server is virtual. If your instance is using core licensing, this area also displays the number of sockets and cores, the core factor, and possible number of core licenses (number of cores multiplied by the core factor), whether this instance is fully licensed with SA, and a timestamp of the most recent change to the displayed information. To access this view, go to the the Instances tab tab, and then click click SQL Licensing.

To find more information on how to determine Microsoft SQL Server licenses, refer to to 

...

• Add SQL Server instances. Click this option to go to the respective wizard and add new SQL Server instances.
• Export. You can choose any of the following formats: PDF, XLS, or or XML for  for exporting the information displayed on the SQL Licensing view.
• Core Factor Table. Click this option to open the Core Factor Table for viewing SQL Server core-specific information for your instances.

Image Removed  Image Added

...

If you select one instance you can perform the following actions:

• View details
• Refresh datadata 
• Edit instance properties (Owner, Location, Comments and Credentials)
• Edit Tags
• Export
• More actions: Decommission, Disable Monitoring, Remove, Add SQL Server instance, Core Factor Table, and and Edit MS SQL license info.

Image RemovedImage Added

Viewing instance details

You can access an instance details view by selecting the instance and clicking clicking View Details on  on the action items bar or by clicking directly on the instance name. For more information about what information is available on the instance details view, refer to to Viewing instance details.

...

If you want to refresh the collected data for an instance, select the instance and click Refresh Data on click Refresh Data  Image Added on the action items bar. You can also find this option by clicking the gear icon next to the respective instance. You can only perform this action for one instance at a time.

Edit instance properties

Select an instance and click click Edit Properties on  on the action items bar. You can also find this option by clicking the gear icon next to the respective instance. On the properties dialog window you can change the owner, location, comments, and credentials. For more information go to to Editing instances properties.

...

By selecting an instance and clicking clicking Edit Tags on  on the action items bar, IDERA SQL Inventory Manager opens a new dialog window where you can add new tags or change the currently assigned tags of the selected instance. You can also find this option by clicking the gear icon next to the respective instance. For more information about editing tags for a specific instance, go to to Manage tags for a single instance.

...

You can export the information displayed in this view as a PDF, XLS, or XML format.

More Actions

Under More Actions you You can find additional options under the More Actions button Image Added on the actions items bar. The following options are available under More Actions: Decommission Decommission, Disable Monitoring, Remove, Add SQL Server instance, and Core Factor Table.

Decommission

Select an instance and click Decommission on the action items bar click Decommission under More Actions to stop monitoring and alerting on that instance. You can also find this option by clicking the gear icon next to the respective instance. For more information about decommissioning an instance or database, see see Decommissioned instances.

...

If you want to disable the monitoring of an instance, select the instance, go to to More Actions, and select select Disable Monitoring. You can also find this option by clicking the gear icon next to the respective instance. For more information about disabling instances, click click here.

Add SQL Server instance

If you want to access the the Add SQL Server instance wizard, go to to More actions and  and select this option. The wizard opens and allows you to browse and register SQL Server instances.

...

If you no longer want to manage an instance, you can remove it by selecting the respective instance, going to to More Actions on  on the action items bar, and selecting selecting Remove. You can also find this option by clicking the gear icon next to the instance. IDERA QL Inventory Manager displays all removed instances on the Ignored instances view. For more information about removing instances click here here.

Core Factor Table

If your instance is using SQL Server core licensing, you can view the current Core Factor Table values by selecting the appropriate instance, clicking More Actions and then clicking selecting Core Factor Table. These values are set by Microsoft and can help you calculate the number of possible core licenses for your physical servers. for more information about this feature, see see Using the Core Factor Table.

...

• # of Sockets. Displays the number of cores per processor, whether physical or virtual.
• # of Cores. Displays the sum of all the cores on a system. For example, if a system includes six cores per processor and contains two processors, then the total # of cores is 12. note that the sum does not mix physical and virtual cores but displays each type as a separate line. Check the Virtual the Virtual column for each row to determine if the core is virtual (displays "Yes") or physical (displays "No").
• Core Factor. Displays a numerical value that determines the number of core licenses necessary. While an administrator can change this value in the Core Factor Table, this number is provided by Microsoft based on the CPU in use.
• Possible Core Licenses. Displays the product of the total number of cores on a system multiplied by the the Core Factor.
• Fully Licensed with SA. Check this box to remove the license count for the instance. You can also manage this setting in the Edit MS SQL Server License Information dialog box.
• Last Changed. Displays a timestamp of the most recent change to this record. Changed values include SQL Server major version, CPU name, number of processors, and total number of cores.

...

• Edit Owner
• Edit Location
• Edit Credentials
• Edit Tags
• Export
• More Actions (Disable Monitoring, Enable Monitoring, Decommission, Remove, Add SQL Server instances, and and Core Factor Table)

For example, if you have a new DBA, you can select all instances on this tab and click click Edit Owner to  to change all instances owner at once.

...

• Click the option you want to perform on the action items bar: Edit Owner, Edit  Edit Location, Edit  Edit Credentials, Edit  Edit Tags, Export Export, Disable  Disable Monitoring, Decommission, Remove, Add SQL Server Instance, and and Core Factor Table.
• Or click the gear icon next to one of the selected instances. IDERA SQL Inventory Manager opens a dialog window that shows you on how many instances you are performing the changes.

Image RemovedImage Added

Exporting from the SQL Licensing view

On the action items bar of the SQL Licensing view, you can find the the Export option  option which allows you to choose your preferred format for exporting the information available on this view. You can export as a a PDF, XLS, or or XML file file. The filters you choose on this view will be taken into account for your exported reports.

...

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. IDERA SQL Inventory Manager now allows you to save filters for use in the Explorer and Instances views. Simply create the filter, and then click click Save as Explorer favorite or click  or click Save as Instances favorite, depending on which view you are in when creating the filter. To use that filter, click click Load Explorer favorite or click  or click Load Instances favorite.

You can enable or disable the option option Apply filter as it changes depending  depending if you want to see the changes as you apply the filter, or if you prefer to select your filters first and see the results when you finish.

...