SOLVED Query CMPIVOT - List Devices for Date Use

[Fernando Monteiro]

CMPIVOT Query - I would like to know if it is possible to list machines that have been used for more than 5 years?

 

[Garth]

The question you should ask how exactly can you reliably determine the age of a device. And the only reliable way is to look up the age from the vendor. All other methods have issues...

 

[Prajwal Desai]

CMPIVOT Query - I would like to know if it is possible to list machines that have been used for more than 5 years?

CMPivot may not help in this case because it cannot determine what you need. Follow Garth's advice.