Month: June 2011

Modified version of “Hardware 03B – Computers for a specific primary console user”

Select D istinct R.Netbios_Name0 AS ‘Computer Name’, SCU.SystemConsoleUser0 as ‘User’, S.SiteName as ‘SMS Site Name’, SEU.SerialNumber0 AS ‘Serial Number’, SEU.SMBIOSAssetTag0 AS ‘Asset Tag’, CS.Manufacturer0 AS ‘Manufacturer’, CS.Model0 AS ‘Model’, SCU.NumberOfConsoleLogons0 AS ‘Console Logons’, CAST(CAST(SCU.TotalUserConsoleMinutes0 AS Decimal(20, 4)) / CAST(SCUM.TotalConsoleTime0 AS Decimal(20, 4)) * 100 AS Decimal(20, 0)) AS ‘% of Total Console Use’, SCU.TotalUserConsoleMinutes0 AS […]