Best Practices Question

Is there a Ticket rule to populate Computer Asset Location based on Labels (IP)

08/09/2013 2831 views

Let me explain. First i have searched a number of close entries here, but nothing seems to hit me with 'yes, thats the one (with the exception of 1 thread which talks about it'

We have 157 locations (these are smart labels) which contain IP ranges. What I would like to do is assign the label to the Computer Asset's field (location field, which in turn is based on Asset Location type)

I understand this should be done through a ticketing rule. Is there someone who has created such a SQL script or can assist me here? We are fairly new using this KACE appliance but I do have a listing of our Asset Field defintions and ID's if this can help. I assume many would like to try this, and we are fine to run this as a nightly ticket rule during low peak hours. With 4000 or so machines, and only a handful of desktop support technicians it would make life a little easier having the Computer Asset update its location field (associated to location asset type) nightly so we could at a glance, view all assets within a location, or use this in conjunction with other filters on reports of assets.

The issue with manually updates is ... well ... the team can look for the label and figure out where it is on a 1 by 1 basis and likely would be less encouraged to also have to manually update it's location while connected to the network. Of course for available or spare inventory in our storage, we would be happy to manually update but we'd like the connected/matched  machines updated automatically.

Thank you,


0 Comments   [ + ] Show comments


Be the first to answer this question

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ