Not sure if it is possible as I am not finding it (or I could be overlooking it). I have not done much with the asset side of things yet. I have building location filters in place via label and computer filter by IP Address. Is it possible to update the computers in the asset to correspond with the filter I have in place already? Right now, I have to actually choose a location for each computer via the locations that have been created.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
You can setup a filter to automatically apply the label to a machine in inventory, but if you want to link a Location Asset to a Computer Asset, you'll have to do so manually OR you can write a SQL rule to do the association for you based on labels. However, you can only do this if you've got the Help Desk module.
Answered 02/09/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Oh ok. I was hoping for it to be able to link them automatically. Oh well. Maybe in the future. Not anything too important. I am still trying to get a feel for everthing in the KBox. It is hard to find time to actually be able to dive into it like I would like to.
Answered 02/09/2010 by: ustacp
Second Degree Blue Belt

Please log in to comment
0
It can link them automatically - but you've got to write a rule to do it.
Answered 02/09/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
We do have the Help Desk but as you know, my SQL knowledge is non-existent. Maybe I will try to see what I can do by looking through some rules. I really need to learn some of it! I have a snow day tomorrow so I may try to read up on some of it.
Answered 02/09/2010 by: ustacp
Second Degree Blue Belt

Please log in to comment
0
You can create the labels by location name i.e. NYC and apply IP based filter to it. let me know if further clarificaiton required
Answered 02/09/2010 by: afzal
Fourth Degree Green Belt

Please log in to comment
0
ORIGINAL: afzal

You can create the labels by location name i.e. NYC and apply IP based filter to it. let me know if further clarificaiton required


I was actually trying to apply those filters to asset fields in the asset section of the KBox. I already have the lables and filters created for the locations.
Answered 02/09/2010 by: ustacp
Second Degree Blue Belt

Please log in to comment
0
I guess, you have created locations in Asset module, and have created location field in the computers asset to associate the computer to the location. There is no easy way to do it automatically, only insert query in helpdesk rules can perform this task but it is not recommended. Best option is to do it manually :)
Answered 02/09/2010 by: afzal
Fourth Degree Green Belt

Please log in to comment
0
Thats what airwolf suggested as well. Yeah, I already have all that setup as well. I was just looking to see if you could actually have KBox link to the filter without writing a rule.
Answered 02/10/2010 by: ustacp
Second Degree Blue Belt

Please log in to comment
0
There is no easy way to do it automatically, only insert query in helpdesk rules can perform this task but it is not recommended.

On the contrary, this is precisely what KACE support would recommend doing.
Answered 02/10/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Another way would be to create a report with the computer's name and labels and then use Excel to reduce the labels to the key location label that you want and then import them into the Location field for the computer asset.
Answered 02/10/2010 by: MacDude
Fourth Degree Brown Belt

Please log in to comment
0
While that would work, MacDude, it's not entirely automated. The benefit of creating a custom SQL rule is 100% automation. With a data import, your asset fields would only be as accurate as the last import date/time.
Answered 02/11/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
True, but Assets by nature is much more static than the Inventory.

In my mind this is akin to Filter Labels based on IP Address vs. LDAP labels based on where the machine lives.

That is, a machine that is assigned to an office in New York could have an LDAP label that reflects it's home office, but a dynamic label that reflects that it's current IP Address is on a subnet in Sheboygan. The *asset* belongs to New York, but it's currently traveling and is in Sheboygan.

Both types of labels are useful, but one is static and the other dynamic. I'd venture to say that the Asset field for location is more likely to be static rather then dynamic.


ORIGINAL: airwolf
While that would work, MacDude, it's not entirely automated. The benefit of creating a custom SQL rule is 100% automation. With a data import, your asset fields would only be as accurate as the last import date/time.
Answered 02/11/2010 by: MacDude
Fourth Degree Brown Belt

Please log in to comment
0
Assets aren't static by nature in my environment. We need up to the minute accuracy for license compliance, so all of our asset types have many rules that dynamically update fields based on data elsewhere in the database. This, of course, has taken quite a bit of time to setup. However, we've got dynamic reporting and we never have to perform manual imports.
Answered 02/11/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
ORIGINAL: airwolf

It can link them automatically - but you've got to write a rule to do it.


Hey airwolf, I'm trying to accomplish the same thing (automatically link a computer asset to a location asset) - would you share the sql code you developed to accomplish this? It would save me a lot of time [;)]

Thanks!
Answered 03/14/2010 by: gpritchard
Yellow Belt

Please log in to comment
0
ORIGINAL: gpritchard

Hey airwolf, I'm trying to accomplish the same thing (automatically link a computer asset to a location asset) - would you share the sql code you developed to accomplish this? It would save me a lot of time [;)]

Thanks!


First, create filter labels for all of your locations to automatically add them based on whatever criteria you use to determine location (i.e. IP subnet). Once you've got your location labels setup, you need to write a rule that will automatically choose locations for the machine assets (which will be assigned to a filter label for their respective locations). I can't give you precise code for your environment, because asset tables are different for every organization.
Answered 03/15/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
I have to have things automated too. Ive created filter labels for all my IP subnets, but where in Kace do you write the SQL rule that will automatically choose locations for the machine assets.
Answered 05/13/2011 by: dav.a.anderson
Orange Belt

  • dav,a,anderson,

    You've probably already gotten the answer to your question but here is my thought for future readers. This would be done with ticket rules to my understanding. You would create for that type of rules and then write the select and update query's to change the information in the data base. I believe that you'd have to set the rule to a frequency as apposed to on ticket save as there would be no ticket to save.

    Airwolf,

    Was there code submitted to accomplish the select and update? If so can we get it posted here?

    Thanks,

    Stephen
Please log in to comment
0
In Asset management I need to setup Departments with divisions.  Is that possible to do and if so how?  ie. I may have a Public Works department with five or six divisions under that department.  In another case I may have an HR department without any divisions. In a third case I may have the Fire department with two divisions.
Answered 05/25/2016 by: csinrud@lccountymt.gov
White Belt

Please log in to comment
Answer this question or Comment on this question for clarity