Asset Fields

Asset Fields

Click here to associate this thread with a Package KB article.

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Dell KACE Appliances] >> K1000 Management Appliance >> Asset Fields

Page: [1]

Message

<< Older Topic Newer Topic >>

Asset Fields - 2/9/2010 4:10:40 PM

ustacp

Posts: 99
Joined: 8/31/2009
From: Ohio
Status: offline

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.

_____________________________

David Simmons
Network/Systems/Security Admin

Post #: 1

RE: Asset Fields - 2/9/2010 4:12:28 PM

airwolf

Posts: 563
Joined: 7/13/2009
From: teh interwebs
Status: offline

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.

_____________________________

Andy Flesner, MCSA - Flesner.com
author.programmer.serveradmin.gamer

Follow Me on Twitter

(in reply to ustacp)

Post #: 2

RE: Asset Fields - 2/9/2010 4:20:55 PM

ustacp

Posts: 99
Joined: 8/31/2009
From: Ohio
Status: offline

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.

_____________________________

David Simmons
Network/Systems/Security Admin

(in reply to airwolf)

Post #: 3

RE: Asset Fields - 2/9/2010 4:21:47 PM

airwolf

Posts: 563
Joined: 7/13/2009
From: teh interwebs
Status: offline

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

_____________________________

Andy Flesner, MCSA - Flesner.com
author.programmer.serveradmin.gamer

Follow Me on Twitter

(in reply to ustacp)

Post #: 4

RE: Asset Fields - 2/9/2010 7:08:42 PM

ustacp

Posts: 99
Joined: 8/31/2009
From: Ohio
Status: offline

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.

_____________________________

David Simmons
Network/Systems/Security Admin

(in reply to airwolf)

Post #: 5

RE: Asset Fields - 2/9/2010 11:56:43 PM

afzal

Posts: 44
Joined: 2/4/2010
From: Foresight Technologies
Status: offline

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

_____________________________

Afzal Yousufi
Foresight Technologies (Pvt.) Ltd.

(in reply to ustacp)

Post #: 6

RE: Asset Fields - 2/10/2010 12:05:40 AM

ustacp

Posts: 99
Joined: 8/31/2009
From: Ohio
Status: offline

quote:

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.

_____________________________

David Simmons
Network/Systems/Security Admin

(in reply to afzal)

Post #: 7

RE: Asset Fields - 2/10/2010 12:44:19 AM

afzal

Posts: 44
Joined: 2/4/2010
From: Foresight Technologies
Status: offline

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 :)

_____________________________

Afzal Yousufi
Foresight Technologies (Pvt.) Ltd.

(in reply to ustacp)

Post #: 8

RE: Asset Fields - 2/10/2010 8:59:24 AM

ustacp

Posts: 99
Joined: 8/31/2009
From: Ohio
Status: offline

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.

_____________________________

David Simmons
Network/Systems/Security Admin

(in reply to afzal)

Post #: 9

RE: Asset Fields - 2/10/2010 9:18:17 AM

airwolf

Posts: 563
Joined: 7/13/2009
From: teh interwebs
Status: offline

quote:

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.

_____________________________

Andy Flesner, MCSA - Flesner.com
author.programmer.serveradmin.gamer

Follow Me on Twitter

(in reply to ustacp)

Post #: 10

RE: Asset Fields - 2/10/2010 6:17:48 PM

MacDude

Posts: 6
Joined: 3/17/2008
Status: offline

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.

(in reply to airwolf)

Post #: 11

RE: Asset Fields - 2/11/2010 9:07:18 AM

airwolf

Posts: 563
Joined: 7/13/2009
From: teh interwebs
Status: offline

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.

_____________________________

Andy Flesner, MCSA - Flesner.com
author.programmer.serveradmin.gamer

Follow Me on Twitter

(in reply to MacDude)

Post #: 12

RE: Asset Fields - 2/11/2010 11:46:29 AM

MacDude

Posts: 6
Joined: 3/17/2008
Status: offline

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.

quote:

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.

(in reply to airwolf)

Post #: 13

RE: Asset Fields - 2/11/2010 12:30:48 PM

airwolf

Posts: 563
Joined: 7/13/2009
From: teh interwebs
Status: offline

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.

_____________________________

Andy Flesner, MCSA - Flesner.com
author.programmer.serveradmin.gamer

Follow Me on Twitter

(in reply to MacDude)

Post #: 14

RE: Asset Fields - 3/14/2010 3:42:29 AM

gpritchard

Posts: 1
Joined: 3/14/2010
Status: offline

quote:

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!

(in reply to airwolf)

Post #: 15

RE: Asset Fields - 3/15/2010 11:11:36 AM

airwolf

Posts: 563
Joined: 7/13/2009
From: teh interwebs
Status: offline

quote:

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.

< Message edited by airwolf -- 3/15/2010 11:13:06 AM >

_____________________________

Andy Flesner, MCSA - Flesner.com
author.programmer.serveradmin.gamer

Follow Me on Twitter

(in reply to gpritchard)

Post #: 16