Automatically add asset to location

This issue has been solved. See solution.
IGEURTSEN's picture

I would like to automatically add assets to a location. I would like to create a list with all computer with a certain IP and add these to a certain location.



For example all the assets in location1 have an IP address starting with 172.18.

So I want to do a check on these first two octets and add these PC's to the predefined location1.



I prefer to schedule this as a (notification server)task, so that when a PC moves from one to an other location, the asset automatically gets added to the correct location.



Can anyone help me out on this one?

JeffreyJRiggs's picture

did you ever get an update

did you ever get an update with this?
We too have the same situation... 100+ sites... sepearated by ip address... so that would make things easier for me.!!!!

JeffreyJRiggs's picture

.

.

AltAdminNC's picture

Locations

You could certainy query the inv_aex_ac_tcpip table and get computer's subnet, but you would need a policy or import rule to update the location information somewhere. I guess my first question would be regarding the "Location" of the computer. How do you plan on managing the locations?

bgreen's picture

Location to Subnet Association

Solution

Go to the Assocations tab for each of your Locations, and populate the "Location to Subnet" association.  Once that has been completed, go to Configuration-->Solutions Settings-->CMDB Solution-->"Update Network Resource Location" and enable the schedule.

Hope this helps,

Brad

lotsill's picture

How to assign a computer once.

Do anyone know how to configure the CMDB to have a computer assigned a lcoation only once?

Example,  As a laptop moves around building at remote sites it will keep on getting reassigned.

AltAdminNC's picture

Thanks bgreen

Up until now we have been pulling our office locations for computers from the primary user/AD information. Your suggestion to associate subnets to a location is a more accurate way to report where the computer is physically located. I already started building the subnet associations and it seems to work fine. Only thing is, I need the network guys to give me a COMPLETE list of subnets for each location!

grcg's picture

ditto

yeah...good luck with your network guys...that is a constant battle for me.

IGEURTSEN's picture

Thanks bgreen, Location to

Thanks bgreen, Location to Subnet Association seems to do the trick!

XIANRAIN's picture

This is a great feedback

This is a great feedback

cnpalmer75's picture

Similar issue...

I had a similar issue...

I was able to create Sites & Subnets and have those associated automatically using the AD import rules. However, I could not cretae Locations, which is the same as our Sites in AD.

Using the COnnector Solution I was able to create a data source from AD, and import Sites as Locations as well as automically associate Subnets to the Locations, much the same way the AD connector works.

Once that was completed I could then run the Location to Subnet Association and my Assets were automatically assigned to the proper Location based on their IP address.

This saved me from ahving to map subnets to locations by hand and everything runs on schedule so its all updated daily.