select SMS_G_System_COMPUTER_SYSTEM.Manufacturer, SMS_G_System_COMPUTER_SYSTEM.Model, SMS_R_System.NetbiosName, SMS_R_System.LastLogonUserName, SMS_R_System.LastLogonTimestamp, SMS_G_System_LOGICAL_DISK.Name, SMS_G_System_LOGICAL_DISK.FreeSpace, SMS_G_System_LOGICAL_DISK.Size, SMS_G_System_CM_CPU_TEMPERATURE.TemperatureC from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_PARTITION on SMS_G_System_PARTITION.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_LOGICAL_DISK on SMS_G_System_LOGICAL_DISK.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_CM_CPU_TEMPERATURE on SMS_G_System_CM_CPU_TEMPERATURE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_PARTITION.Size > 1500