
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-29-2018 05:31 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.Username,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssetCustom.Serialnumber,
tsysAssetTypes.AssetTypename,
tblProcessor.Name As CPU,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Where tblAssetCustom.Model Like '%OptiPlex 30%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName
tblAssets.Username,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssetCustom.Serialnumber,
tsysAssetTypes.AssetTypename,
tblProcessor.Name As CPU,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Where tblAssetCustom.Model Like '%OptiPlex 30%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName
Labels:
- Labels:
-
Report Center
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-29-2018 07:02 PM
It depends on exactly what you want when you say "OS version". Some possibilities:
tsysOS.OSname
e.g. "Win XP", "Win 7", "Win 10"
tblAssets.SP
Service pack
tblOperatingsystem.Caption
e.g. "Microsoft Windows 10 Pro", "Microsoft Windows 7 Professional", "Microsoft Windows Server 2012 R2 Standard"
Windows 10 ("no more versions!") version info:
tsysOS.OSname
e.g. "Win XP", "Win 7", "Win 10"
tblAssets.SP
Service pack
tblOperatingsystem.Caption
e.g. "Microsoft Windows 10 Pro", "Microsoft Windows 7 Professional", "Microsoft Windows Server 2012 R2 Standard"
Windows 10 ("no more versions!") version info:
tblAssets.Version
tblAssets.BuildNumber
