To preserve device stability and security in today's industrial environment, vulnerabilities must be found and fixed. Asset managers face issues in managing End-of-Life (EOL) statuses, which are subject to constant change, and in traversing many data sources. It is challenging to have uniform view into important data without a centralized dashboard. We suggest putting in place a scraping method to collect data from various sources in order to overcome these issues. After the EOL data has been thoroughly verified and updated, the results will be shown on a consolidated, scalable, and dependable dashboard that easily links into the current systems. Advanced data slicing and dicing techniques will be used, utilizing Snowflake's capabilities, to handle enormous datasets efficiently. This all-encompassing strategy seeks to improve asset management procedures, strengthen device security, and offer useful information for defensible decision-making