KBI 311465 Customizing CMDB-X Fields For Reporting Tools Like Tableau
Version
Argent Advanced Technology – All Versions
Date
Tuesday, 18 October 2016
Summary
Argent’s open CMDB-X allows customers to easily integrate data with third-party reporting tools, like Tableau
This KBI discusses how Argent’s CMDB-X provides flexible open-text fields that customers can use for any purpose they wish
Technical Background
When adding a new server or device, the CMDB-X shows the usual suspects that an inventory system for servers and devices would expect:
- Server or Device Name
- Type of Device
- IP Address
- Etc.
However, the CMDB-X contains many more properties when the properties of the server are brought up (Right Click -> Properties)
Most of the empty, open-text fields in the ‘Windows Machine’ section, and all the open-text fields in the ‘Contact’ section, for example, could be used for whatever purpose the customer wishes
For example, one customer in the United States uses the ‘Description’ field to hold the lease expiration dates on their servers and devices
Another customer uses the ‘Point of Contact’ to hold serial numbers
The values are saved in a flat database table in Argent AT’s database called ARGSOFT_AT_NODE
This table holds all of the CMDB-X Nodes (as rows) and properties (as individual columns)
Resolution
N/A