SQL Query: Equipment Age

Hi,

I am trying to get a report configured that will take a custom property (year installed) and present output that lists the following.

Campus ! note this is a custome property

Building ! note this is a custome property

Average Age of Equipment (based on the year installed compared to current date)

Regards

Miron

Find more posts tagged with

sql

report

Hi,

Thanks i worked it out eventually. 5 min crash course in SQL..

Regards

Miron