Asset Management Suite

Hi guys, some help is needed here.

I know that i can assign a "Location" to "Network Subnet" to automate the organization of computers and network resources to hierarchy tree.

But, what i need is to do automatize the organization using the "name (hostname)" of a computer.

How i can do this  using CMDB rules? Any idea?

Thanks,

Hi Lippi,

Using CMDB Rules is posible update Computer´s location based on hostname standard.

1) Select Resource Type as Computer.

2) Create a SQL query or Logic Expression  to group these computers using the hostname data. For example, if you have computers which hostname starts with USANY004598 where USANY identifies the Location USA\New York, as second step, you could a Logic Expression like this:

Or maybe use a SQL Query to select the computers:

vc.[guid],

vc.[name]

from vcomputer vc

where vc.[name] like 'USANY%'

*vComputer can not bring all computers you need, so you could include anothers resources tables to obtain the proper results.

3) Configure the CMDB Rule to set the Computers Location association to USA\New York location. In the Step 3 (Add. resource associations to modify.) Select Forward associations, CMDB Association Types and select Location. Now is posible to set the proper location for the selected computers by hostname standards.

Another way is to use Connector Rules to import this information from spreadsheets (DataSource) where you´ve a computers lists and your respective location using Excell to automatically sets the location based on hostname.

The most common way to set computers location is use the task that automatically assigns location to the network devices that belong to the subnet. If is posible you could try use this default way.

Regards,