‎03-08-2013 01:52 PM
Select Top 1000000 upgrade_tblcomputers.Computername,
upgrade_tblcomputers.ComputerUnique,
upgrade_tblcomputers.Domain,
TsysChassisTypes.ChassisName As ComputerType
From upgrade_tblcomputers
Inner Join upgrade_tblsystemenclosure On upgrade_tblcomputers.Computername =
upgrade_tblsystemenclosure.Computername
Inner Join TsysChassisTypes On upgrade_tblsystemenclosure.ChassisTypes =
TsysChassisTypes.Chassistype
Where
upgrade_tblcomputers.Computername In (Select
upgrade_tblntlogevent.Computername From upgrade_tblntlogevent
Where upgrade_tblntlogevent.Sourcename = 'Disk' And
upgrade_tblntlogevent.TimeGenerated > GetDate() - 7)
Order By upgrade_tblcomputers.Computername
‎03-12-2013 11:53 AM
‎03-11-2013 04:19 PM
‎03-11-2013 08:54 AM
‎03-08-2013 03:18 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now