How to create CMDB reports with tags?

[Allen_Deepak]

Hello All,

We are onboarding some of the virtual servers by adding tags. For example, during VM provisioning, the tags of support group and service will be added which automatically creates CI and links with appropriate service and populates support group. however this process fails for majority of CIs. i'm looking for a way to generate a report of VMIs with tags and without tags to improve the onboarding process.

Any guidance on creating the reports of tags would be helpful.

[Dr Atul G- LNG]

Hi @Allen_Deepak 

[Tony Branton]

Hi Allen,

You can use Query Builder to generate a list of CIs with tags. An easy way to do this is to use Intelligent Search in CMDB Workspace:

Using Intelligent Search to find servers with tags

This will provide the following search result:

Intelligent Search result for "find servers with tags"

If you open Query Builder from the search results page you can find the query:

Query Builder query for finding servers with tags

To report on all servers without tags, you can use Query Builder's Related List condition. Start by dragging a CI class to the canvas to set the starting node. If you hover the mouse over the starting node, a filter icon will appear. Click on the filter icon to display the filter panel and expand the Related List condition section. Search for and select the Key Value table. Now for the sneaky bit: click on the "Greater than equal to 0" text and select "None". Click on the "Run" button and you'll see a list of servers (in my example) without tag values.

Query Builder is a powerful tool, and Intelligent Search provides a good starting point for seeing how Query Builder works with multiple tables.  Hope this helps.

[Allen_Deepak]

Thanks Tony for the information. This is indeed helpful. In our case, we add the tags to VMIs during provisioning. I tried to lookup for 'find all vmware virtual machine instances with tags', that gives me 0 results. Is this query builder is restricted only to admins? Because i couldn't add the field 'Key value' in the table from from Intelligent search as well. 

And I'm using cmdb_key_value table to see the number of VMs that are not tagged. This is very manual. looking for a solution to improve this manual activity.

Please let me know. Thanks in advance.