I also slightly tweaked the report to accommodate the app's name change to Microsoft 365 Apps. I think the syntax could be tweaked for efficiency, but this works.Select Top 1000000 tblSoftware.softwareVersion As Version, Count(tblAssets.AssetID) As ...
Dell servers, I have learned, do not expose drive health statistics via WMI. This may not be true of every Dell server, but it's true for at least some. The solution I found while adding servers to another monitoring system is to make sure you have O...