Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypeIcon16 As icon, tblFloppy.Manufacturer As [HD Manufacturer], tblFloppy.Model As [HD Model], tblFloppy.Size, tblFloppy.FirmwareRevision, tblFloppy.Status, tblAssets.Domain, tblAssets.Username, tblAssets.Userdomain, tblAssets.IPAddress, tblAssets.Description, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tblAssetCustom.Location, tsysIPLocations.IPLocation, tblAssets.Firstseen, tblAssets.Lastseen From tblFloppy Inner Join tblAssets On tblFloppy.AssetID = tblAssets.AssetID Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID Where tblFloppy.Status Is Not Null And tblFloppy.Status <> 'OK' And tblAssetCustom.State = 1 Order By tblAssets.AssetName
Explore the full platform, free for 14 days.
No credit card required.