When GetDate() >= '' And tblOperatingsystem.Version = ''Īnd tblOperatingsystem.Caption Like '%Embedded%' Then 'EOL' When GetDate() >= '' And tblOperatingsystem.Version = '0'Īnd tblOperatingsystem.Caption Like '%LTS%' Then 'EOL' When GetDate() >= '' And tblOperatingsystem.Caption Like Or tblOperatingsystem.Caption Like '%Windows 7%') Then 'EOL' When GetDate() >= '' And (tblOperatingsystem.Caption Like '%2008%' TblOperatingsystem.Caption Like '%Pro%') And TblOperatingsystem.Caption Like '%Home%' Or TblOperatingsystem.Caption Like '%Education%' Or When GetDate() >= '' And tblOperatingsystem.Version = '1' When GetDate() >= '' And tblOperatingsystem.Version = '2' When GetDate() >= '' And tblOperatingsystem.Version = '3' When GetDate() >= '' And tblOperatingsystem.Version = '4' TblOperatingsystem.Caption Like '%Education%') And TblOperatingsystem.Caption Like '%Pro%') Then 'EOL'Īnd (tblOperatingsystem.Caption Like '%Enterprise%' Or When GetDate() >= '' And tblOperatingsystem.Version = '9'Īnd (tblOperatingsystem.Caption Like '%Home%' Or When tblOperatingsystem.Version = '3' Then 'EOL' TblOperatingsystem.Caption Not Like '%2016%' Then 'EOL' TblOperatingsystem.Caption Not Like '%LTS%' And When tblOperatingsystem.Version = '3' And When tblOperatingsystem.Version = '6' Then 'EOL' TblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL' When tblOperatingsystem.Version = '0' And When tblOperatingsystem.Caption Like '%2000%' Then 'EOL' TblAssetCustom.Custom6 As 'System Administrator',Ĭoalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon, Report is exported to Power BI where I created a nice clickable pie diagram with all builds, or all assets which are EOL (or approach their EOL date).īeware, this shows only the OS versions/Win10 editions which we have currently installed (but I believe that's most of them). I use (and manage) this hell of a report that reports all my assets, the exact build they have, the End of Life date and the days until EOL.
0 Comments
Leave a Reply. |