/build/static/layout/Breadcrumb_cap_w.png

How do I create a Custom Field to collect the Ship Date for a computer?

I am trying to create a Custom Field to use in a report.  I noticed in the Hardware section of the device inventory there is a field that shows the Ship Date of a computer.  I tried to create a Custom Inventory Rule to collect the data but so far no luck.  Any help would be appreciated, thanks!

0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: Nico_K 7 years ago
Red Belt
4

Top Answer

Since the information is already in the database (for Dell systems only so far) you can create simply a report querying the info.

This is a sample report, which collects the current service level, ship date and end of service for the devices.

SELECT DISTINCT(MACHINE.NAME), 
MACHINE.OS_NAME, 
MACHINE.CS_MODEL, 
MACHINE.CS_MANUFACTURER, 
DA.SHIP_DATE AS "Ship Date",
MAX(DW.END_DATE) AS "Warranty End Date",
DW.SERVICE_LEVEL_DESCRIPTION as "Service Level"
FROM MACHINE
LEFT JOIN DELL_ASSET DA on MACHINE.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG
LEFT JOIN DELL_WARRANTY DW on MACHINE.BIOS_SERIAL_NUMBER = DW.SERVICE_TAG
WHERE MACHINE.CS_MANUFACTURER like 'Dell%'
GROUP BY MACHINE.NAME
ORDER BY "Ship Date", MACHINE.NAME
Posted by: KevinG 7 years ago
Red Belt
0
It sounds like you are looking for Asset Management of Devices and then running a report based on this data.
If you have field(s) you want to populate for a particular Asset Type like devices.
You can import that data into the K1000 using the Asset import feature, which uses a csv file.
For more information on the use of the Asset module can be found in the K1000 Admin Guide
https://support.quest.com/technical-documents/kace-systems-management-appliance/7.0/administrator-guide/45#TOPIC-568918

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