K1000 report: Day count since Ship Date
I'm relatively new to the KACE world.
I need a report that shows me how many days have passed since the ship date. I have tinkered a little bit with the ship date in the assisted method of creating reports, but my results have been poor.
I would need the machine name, service tag and number of days since ship date, sorted by the biggest number of days since ship date.
Could you help me to create the SQL query to achieve this, please? I'm a no go in SQL queries... :(
This environment runs on version 6.0
Please log in to answer
Posted by: h2opolo25 5 years ago
Posted by: aragorn.2003 5 years ago
You can use the following SQL statment. It shows you the Name, User, OS, Manufacturer, Model, Service Tag, Shipdate and the needed Daycount.
select distinct UCASE(m.NAME) as NAME, m.USER_FULLNAME, m.OS_NAME, m.CS_MANUFACTURER, m.CS_MODEL,w.SERVICE_TAG, w.START_DATE, DATEDIFF(Now(), w.START_DATE) as DayCount
from MACHINE as m, DELL_WARRANTY as w
where m.BIOS_SERIAL_NUMBER = w.SERVICE_TAG
order by w.START_DATE DESC