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