→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎10-23-2014 05:33 PM
Select Top 1000000 tblAssets.Domain,
tblAssets.AssetName,
tblOperatingsystem.Caption,
tblAssets.Lastseen,
tsysIPLocations.StartIP,
tsysIPLocations.EndIP,
tblAssets.IPNumeric
Round((Cast((DateDiff(mm, tblBIOS.ReleaseDate, GetDate())) As float) / 12),
0) As [PC Age],
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Inner Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where (tblOperatingsystem.Caption = 'Microsoft Windows 7 Professionnel' And
tsysIPLocations.StartIP != '010134059001' And tsysIPLocations.EndIP != '010134058255' And tblAssetCustom.State = 1)
Solved! Go to Solution.
‎10-27-2014 05:21 PM
‎10-27-2014 05:21 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now