When you create an editable data class that has the attribute type Resource Foreign Key and associate it with an asset, you can create a virtual association for the asset using the data class. The virtual association is displayed as a dotted line connection in the Resource Association Diagram.
To create a virtual association
Open the CMDB SQL database and create and run the following SQL query:
create view vViewName AS
select _ResourceGuid as ParentResourceGuid, DC AS ChildResourceGuid
Where vViewName is the view name that you will use when you create virtual association, DC is the attribute of type Resource Foreign Key, and DB_Table is the table in the database that represents the data class you created.
Ensure that the column names are ParentResourceGuid and ChildResourceGuid to avoid errors.
From the Symantec Management Console, on the Settings menu, click All Settings.
In the left pane, expand Notification Server > Resource and Data Class Settings > Virtual Associations, right-click Asset Virtual Associations, and then click New > Virtual Association.
Enter the view name that you used in the SQL query and click Save. For example, from the SQL query mentioned in Step 1, the view name is vViewName.
The GUIDs ParentResourceGuid and ChildResourceGuid are displayed in the table.
To see the virtual association of the asset, open the Resource Association Diagram where the virtual association is displayed as a dotted line.