/build/static/layout/Breadcrumb_cap_w.png

Best Practices Question


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

03/09/2017 1013 views
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!
Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

4
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
Answered 03/10/2017 by: Nico_K
Red Belt

All Answers

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

Answered 03/09/2017 by: KevinG
6th Degree Black Belt

 
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