In this short video, we are going to show you how to create a custom inventory field in SQL Inventory Manager. Now custom inventory fields are used to help keep track of your inventory. Because everybody’s business is running a little bit differently. SQL Inventory Manager provides the ability to create these custom fields. So you can more effectively manage your inventory. And know what you have so that you can manage it better. In order to create a custom inventory field. Go to the administration page. Once the administration page loads, click on the manage custom inventory fields link. On the manage custom inventory fields window, you can see that I do not currently have any fields created. The fields can be created at the server instance or the database level. In this example, I am going to be creating two custom inventory fields, one at the instance level and another at the database level. The instance-level one is going to be used primarily to determine which department is responsible for this particular instance. So, for example, for the name of this particular inventory fill, I am going to call it department. And make it an instance level. Now for the type, you have a few different options. You have open-ended yes or no or a pick list or date. Since I am going to select from different departments, I am going to choose the picklist. Now the first option is going to be the default. So, in this case, I am going to make it on the signed. The following options are going to be finance, cells, engineering, and perhaps marketing. There could be a few other options there. But I am going to just leave it at this. I am going to save this. And then proceed to create my second inventory field. I am going to name this one, SOX. Just to see. So I can keep track of which databases require SOX. So I will make this a database level custom field. And make this a yes/no option. Now the default value is going to be automatically applied to pretty much all the databases that would be managed by SQL Inventory Manager. So, in this case, not since not all of my databases are going to require SOX. I am going to select the default values to be no. Save this option. And close out of this now. To kind of see these custom inventory fields in action. Let us go to instances. And take a look at one of the instances that has being managed by SQL Inventory Manager. In this particular case, I am going to pick my IDERA prod 301 server. And when the page loads, you will be able to see in the instance summary on the far right-hand side. Towards the bottom of that section, you will be able to see the department custom inventory for that I have created. And you can see that it is been assigned as unassigned. If I click on this edit icon here, I will be able to give it. Assign it to the proper department. So in this particular case, I am going to put it as cells. And click, OK. Now, remember. We create a database-level field earlier. So if I scroll down to look at the various databases. Or on this particular instance. I can go ahead. And select one. In this particular case, I am going to select the NorthWind database. And on this particular screen, you can see that the database inventory fields are listed here. And my SOX inventory feels apparently set as no. Now, this particular database, I do want to have SOX auditing. So I am going to click on the edit icon. It is like no. Or select, yes. Rather then click OK. And save those changes. Once again, this is about helping you make sense of your inventory. And doing the way that is specific to your own business. Hopefully, this has been very helpful for you. Thank you for watching. If you are interested in trialing SQL Inventory Manager, you can download it from our website at

Topics : Database Monitoring,Database Performance,

Products : SQL Inventory Manager,

How to Create a Custom Inventory Field in SQL Inventory Manager

IDERA SQL Inventory Manager provides fundamental information on your SQL Servers to help you keep track of and manage your database environment without having to be an expert in Microsoft SQL Server. Inventory Manager provides a broad enterprise-wide view of all your SQL Servers through automated discovery as well as simple, actionable information about the state of your environment. You can view core information such as how many databases exist, whether they are being backed up, get access to options like availability monitoring, and notification emails so you can take action as needed.

SQL Inventory Manager includes a feature that lets you add custom inventory fields to your servers, instances, and databases to allow for easier identification. When applied to an instance, this information appears in the Instance Summary section of the Instance Details view. Learn More →

Contact IDERA: