Select Top 1000000 tblComputerSystemProduct.Vendor As Vendor, tblComputerSystemProduct.Name As Model, dbo.tblBIOS.SerialNumber, tblSystemEnclosure.SMBIOSAssetTag As [Asset Tag], dbo.tblBIOS.SMBIOSBIOSVersion As [BIOS Version], dbo.tblComputers.Computer As Hostname, dbo.tblComputers.Username, dbo.tblComputers.LastActiveScan As [Last Seen], dbo.tblComputers.LastknownIP From dbo.tblComputers Inner Join dbo.tblBIOS On dbo.tblComputers.Computername = dbo.tblBIOS.Computername Inner Join tblSystemEnclosure On dbo.tblComputers.Computername = tblSystemEnclosure.Computername Inner Join tblComputerSystemProduct On dbo.tblComputers.Computername = tblComputerSystemProduct.Computername Where (tblComputerSystemProduct.Vendor <> 'VMware, Inc.' And tblSystemEnclosure.ChassisTypes <> 12) Order By tblComputerSystemProduct.Vendor
It's the view I use the most.
