Control Compliance Suite

Hi all

I do want to take advantage of the server status field in our CMDB. If a server is deployed or retired shall be represented with a Tag. I've been able to query all the servers from our CMDB through an ODBC connection using an SQL-statement.

I've got queries for UNIX and Common platforms. All but one field are populated as expected...

I did create the Tag category "Status" and the Tags "Deployed", "Inventory", "Retired", "Staging" and "NULL".

How can I set Tags via ODBC import?

I'm using the following query:

SELECT TRIM(ip_address) as IPAddress,
  LOWER(TRIM(name)) AS HostMachine,
  environment AS Integrity,
  service_level  AS Availability,
  Case
  when server_status_dv = 'Deployed' then '@:1:15:Status\Deployed'
  when server_status_dv = 'Inventory' then '@:1:16:Status\Inventory'
  when server_status_dv = 'Retired' then '@:1:14:Status\Retired'
  when server_status_dv = 'Staging' then '@:1:14:Status\Staging'
  else '@:1:11:Status\NULL'
  end AS Tags,
  applications_hosted_dv AS AssetOwner,
  environment AS AssetDepartment,
  sys_class_name_dv AS AssetLocation,
  support_group_dv AS AssetCustodian
FROM CMDB_CI_VM_INSTANCE
WHERE SYS_CLASS_NAME in ('linux_virtual','aix_virtual','solaris_virtual')
  AND ip_address IS NOT NULL
  AND name IS NOT NULL
ORDER BY HostMachine;

The result set does look fine while running the query against our DB2-database.

Any suggestions?

Regards

-Luca.

Without knowing much about how you import assets, you're probably looking at reconciliation rules via the asset import job itself, or leveraging EDI. (either way: reconciliation rules)

EDI would be the best way to go, then assigning the appropriate reconciliation rules as Matt stated.  I have just done something similar at my client and it works well.  Basically you would create a custom EDI with ODBC as your link.  use the SQL Query that you have and then assign each field either as Asset, Assessment or Status.  Obviously the Asset field will help you link up to your existing assets and the reset you can use as you wish.  You will need to create all of the tags before you setup any rules,