/build/static/layout/Breadcrumb_cap_w.png

Matching Hardware Assets with a User

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?

0 Comments   [ + ] Show comments

Answers (2)

Posted by: cb3inco 7 years ago
Yellow Belt
1
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. 
Posted by: Hobbsy 7 years ago
Red Belt
1
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
UPDATE ASSET_DATA_5, ASSET, USER, MACHINE
SET 
ASSET_DATA_5.FIELD_10123 = USER.ID
WHERE
ASSET.ASSET_DATA_ID = ASSET_DATA_5.ID
AND
ASSET.MAPPED_ID = MACHINE.ID
AND
USER.USER_NAME = MACHINE.USER_NAME

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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