‎03-08-2019 08:14 AM
Solved! Go to Solution.
‎03-08-2019 11:21 PM
Select Top 1000000
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblComputersystem.Lastchanged,
tblComputersystem.SystemType,
tblPROCESSOR.Name As CPU,
tblPROCESSOR.Caption As Name,
tblPROCESSOR.MaxClockSpeed As ClockSpeed,
tblAssets.Memory,
tblComputersystem.Model,
tblFloppy.Model As Model1,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
'http://www.dell.com/support/my-support/us/en/04/product-support/servicetag/' + tblAssetCustom.Serialnumber + '?show_warranty_model=true' As hyperlink_SerialNumber1,
tblAssetCustom.Serialnumber As hyperlink_name_SerialNumber1,
tblFloppy.Name As Name1
From tblAssets
Inner Join tblPROCESSOR On tblPROCESSOR.AssetID = tblAssets.AssetID And
tblPROCESSOR.DeviceID = 'CPU0'
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID And
tblFloppy.Name Like '\\.\PHYSICALDRIVE0'
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tsysOS.OSname Like 'Win 7' And tblAssetCustom.State = 1
Order By tblAssets.AssetName
‎03-11-2019 09:44 AM
‎03-08-2019 11:21 PM
Select Top 1000000
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblComputersystem.Lastchanged,
tblComputersystem.SystemType,
tblPROCESSOR.Name As CPU,
tblPROCESSOR.Caption As Name,
tblPROCESSOR.MaxClockSpeed As ClockSpeed,
tblAssets.Memory,
tblComputersystem.Model,
tblFloppy.Model As Model1,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
'http://www.dell.com/support/my-support/us/en/04/product-support/servicetag/' + tblAssetCustom.Serialnumber + '?show_warranty_model=true' As hyperlink_SerialNumber1,
tblAssetCustom.Serialnumber As hyperlink_name_SerialNumber1,
tblFloppy.Name As Name1
From tblAssets
Inner Join tblPROCESSOR On tblPROCESSOR.AssetID = tblAssets.AssetID And
tblPROCESSOR.DeviceID = 'CPU0'
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID And
tblFloppy.Name Like '\\.\PHYSICALDRIVE0'
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tsysOS.OSname Like 'Win 7' And tblAssetCustom.State = 1
Order By tblAssets.AssetName
‎03-08-2019 08:14 PM
‎03-08-2019 08:00 PM
‎03-08-2019 05:50 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now