I have imported devices into the asset list because not all the information I wanted was coming over from the Inventory.
When I did this, I got some duplicates even though i have the mapped inventory field and asset field looking at the bios serial number.
Since my original import, there have been changes to the items we want to track and will have to do an import again.
What is everyone's suggestion on capturing all the data and not creating duplicates?
45DA0G.jpeg
Answer Summary:
Cancel
4 Comments   [ + ] Show Comments

Comments

  • I ignore all computer asset information and rely on Inventory. What sort of information are you importing into the Assets that you aren't capturing or can't modify in Inventory?
  • We are getting everything we want in the inventory. The items that come into the inventory, and then are shelved for a while and taken out of inventory(to keep the nodes slim) that we want to track. I know the easy solution would be to purchase more nodes to allow all devices to be in the inventory but that is not in they budget at this time.
  • Have you thought about writing a ticket rule to copy date from Inventory into your asset records? you can then delete the inventory to free up licenses and your asset records will remain intact
  • Hobbsy, wish i could do that but i do not have enough sql knowledge to write those rules and the company i work for wont spend the $ to have Dell to assist with it. That is why i turned to ITNinja for help. If anyone has sql query and update code to do this i would appreciate it.
Please log in to comment

Answer Chosen by the Author

0
Try this code then for starters:

You will need to go to your Device Asset Type and create the fields that you want to record eg Serial Number Manufacturer etc You will then need to find out what the FIELD_ID is for each of the fields.

The update statement below (in Yellow) will then need to be updated with the correct FIELD_ID number

Create the ticket rule and use

SELECT Statement

SELECT
MACHINE.ID as ID,
MACHINE.NAME as NAME
MACHINE.BIOS_SERIAL_NUMBER,
MACHINE.CS_MANUFACTURER as MANU,
MACHINE.CHASSIS_TYPE as CHASSIS,
MACHINE.MAC as MAC,
MACHINE.PROCESSORS as PROC,
MACHINE.RAM_TOTAL as RAM,
MACHINE.OS_NAME as OS

FROM
MACHINE

Update Query
Update
ASSET_DATA_5,
MACHINE

Set
ASSET_DATA_5.FIELD_27MACHINE.BIOS_SERIAL_NUMBER,
ASSET_DATA_5.FIELD_28MACHINE.CS_MANUFACTURER,
ASSET_DATA_5.FIELD_29MACHINE.CHASSIS_TYPE,
ASSET_DATA_5.FIELD_30MACHINE.MAC,
ASSET_DATA_5.FIELD_31MACHINE.PROCESSORS,
ASSET_DATA_5.FIELD_32MACHINE.RAM_TOTAL,
ASSET_DATA_5.FIELD_33MACHINE.OS_NAME

Where
ASSET_DATA_5.ID = MACHINE.ID

Once tested and you know that it works set this to run on a schedule maybe once a week?
Answered 07/03/2015 by: Hobbsy
Red Belt

Please log in to comment

Answers

Answer this question or Comment on this question for clarity