A computer or user's location is not automatically assigned. This requires the customer to either manually assign one or implement a method to automatically do so. The following instructions demonstrate how this can be accomplished by using a CMDB rule. Note: The customer can adapt these instructions to automatically assign locations to other asset types, such as to users or monitors, or to automatically assign other types of associations, such as departments or cost centers, to assets. If so, the SQL script would need to be changed by the customer to leverage the appropriate resource type, such as to vUser for users or vMonitor for monitors.
Important Note: A CMDB rule requires standardized values to be present in records to be able to identify these as what to evaluate. For example, if a computer's name also includes its location name, this can be identified and used to associate a CMDB location to. Or for users, an address or city or state can be evaluated if that data is present. But if no such standardized values exist in some or all records to be evaluated, then there is no reasonable logic that can be used by the CMDB rule to automate the assignment of locations. The customer would need to either first determine how data normalization can be implemented or decide on a different way to automatically assign locations to assets other than using a CMDB rule.
How to create locations and automatically assign them to computers or users
How to create a Data Connector import rule to automatically assign computers or users to locations
Import Rule fails to set or removes Asset Owner or Cost Center