Comments
-
This query has been VERY helpful. I adjusted it to the following to give me all my servers: SELECT [Node], [OS], [OS Version], [Total CPU Sockets], [Total CPU Cores], [CPU Vendor], [CPU Cores Per Socket] FROM (select N.Caption as [Node], Max(N.AssetInventory.ServerInformation.OperatingSystem) as [OS],…
-
Thanks, Christopher. I am about the worst SQL admin known to man and have been trying to successfully insert your recommendation with zero luck... Where would I add the two lines in the query I originally posted?