Control Compliance Suite

Hi all

I would like to enhance the now working ODBC Asset import. I'm trying to map "Asset Custodian", "Asset Department", "Asset Location" and "Asset Owner", but I can't find them in the Entity Table Mapping view. How are they named?

Those are the values I do want to map:

This is the Entity Table Mapping form for Windows Machines:

Greetings

-Luca.

If you dropdown that "Asset Type" dropdown, do you have anything named "Common"?

No.. Just "Windows Machine".

I've got a side question for this task: I do want to set "Machine is server" to True.

Which Field Name do I have to select and which value do I have to send?

I did try the Field Name "Machine is server?" and 'YES' as the value, but it did not set the fields. I did try 'YES' because the csv-export of a dummy machine showed a 'YES' in that column.

Regards

-Luca.

Ah, right. I think I can get this for you... we'll see if I have time later to fire up my lab.

As far as "machine is server", yeah I believe you need to use "True / False"

Hi Matt

I had to create a ODBC connection for "Common". Then I've created an other SQL statement for the Common fields. It does now work (except the Tags for which I do create an other topic in this forum).

Thank you for your help

Regards

-Luca.

In the entity mapping table, drop the word Asset from your search. I believe those fields are the direct relation. So, there should be fields called Department (Asset Department), Custodian (Asset Custodian) and so on.

Good luck.

WH