KACE SMA - Windows End of Support Report (ITNinja) (4379952)

This article was originally posted by ITNinja contributors. Given its continued relevance it is being included as part of the KACE knowledge base with minor modifications to meet the knowledge base standard.

This article shows how to create a report to get a list of managed Windows devices that are no longer under support.

Note: this is not of interest for companies who are running the LTSB/LTSC Version of Windows.

DISCLAIMER: The following custom report is offered with no expressed or implied warranty and is to be used at your own risk. KACE does not guarantee the use of this report unless designed by the KACE Professional Services team, nor does KACE guarantee the functionality or existence of this report in future versions of the KACE SMA.

The report shared in this article has been written based on these Windows 10 and Windows 11 articles: Windows 10 release information & Windows 11 release information.

The query will find all machines in the inventory of the current org where operating system name starts with "Microsoft Windows 1".

Steps to create the report:

1. To create the report, download the attachment on this article.
2. Navigate to Reporting | Reports - Choose Action: New (SQL) to create a new SQL report.
3. Paste the downloaded query in there. Break on column is "OS Common Name".

This is an example of how the report should look like: