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:
Please log in to answer
Posted by:
Nico_K
7 years ago
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.
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
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
