→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎04-25-2013 06:00 PM
‎04-26-2013 06:23 PM
ifm wrote:
The problem is that the list becomes to wide so that the third column is out of screen, and there is no slider so that I can turn right. The only way to get there is to search in the page for the vendor name.
ifm wrote:
Also it would be good if I could could click on the manufacturer name next to the chart to jump to the list for that manufacturer.
ifm wrote:
As you can see in the next picture some manufacturer have different names on different models. It would be great if we could "merge" them into a custom name to get them all in the same column.
ifm wrote:
I would also like a way to search for a certain BIOS version and get a list of the computers and what model they are.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblBIOS.Caption,
tblBIOS.ReleaseDate,
tblBIOS.SMBIOSBIOSVersion,
tblBIOS.SMBIOSMajorVersion,
tblBIOS.SMBIOSMinorVersion,
tblBIOS.SMBIOSPresent,
tblBIOS.Version
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Where tblAssetCustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now