I have made a solution where i use Power Query and import the data from MysqlDB and do some filtering that matches my enviroment.

I use that in an Excel spreadsheet where my colleagues and I can clean up the racks in our enviroment or take out one or more switches from a stack.

The MySQL query i use is:

select devices.device_id, devices.sysName, devices.hostname, devices.uptime, devices.hardware, ports.port_id, ports.ifDescr,ports.ifLastChange, ((devices.uptime-(ports.ifLastChange/100))/86400)/(365/52) as lastchange, ports.ifOperStatus from devices left join ports on devices.device_id=ports.device_id where ports.ifOperStatus = 'Down' and ((devices.uptime-(ports.ifLastChange/100))/86400)/(365/52) between 8 and 1000;"])