Matching Hardware Assets with a User

Question

Hi all,We have been on-boarding a number of global employees for our organization who we never managed their computers before. Internally in our office we've always had a naming scheme and with active directory assets are associated with a user in Kace by default.  However, we are providing users with an AD account, but their computers are not domain joined and usernames and machine names are not being standardized. I realize there is some work with whatever we decide, but wondered if anyone had ideas on how we could associate name with an asset. I was thinking of trying to run a script to pull the name of an Outlook .ost file and computer name, which would give us their company email address and computer name, but I'm not familiar with scripting like that.  Does anyone else have thoughts?

Answer

Hobbsy,I'm not sure that helps. The problem I have is that the machines are named whatever the user decided to.  And user accounts can be 'user' or some random name that doesn't make sense to us.

Answer

You can create a ticket rule to take the user value from within your inventory record and add the value to a User field within the Device Asset type,

Select Statement

Select

ASSET_DATA_5.FIELD_10123,

USER.ID

From

ASSET Inner Join

MACHINE On ASSET.MAPPED_ID = MACHINE.ID Inner Join

ASSET_DATA_5 On ASSET_DATA_5.ID = ASSET.ASSET_DATA_ID Inner Join

USER On USER.USER_NAME = MACHINE.USER_NAME

Update Statement