→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎04-06-2015 08:11 PM
Solved! Go to Solution.
‎04-08-2015 11:24 AM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblOperatingsystem.Caption As CurrentOS,
tblAssets.SP,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblAssets.AssetID In (Select Top 1000000 tblOperatingsystemHist.AssetID
From tblOperatingsystemHist
Where tblOperatingsystemHist.Caption Like '%windows 7%' And
tblOperatingsystemHist.Action = 1 And tblOperatingsystemHist.Lastchanged >
GetDate() -1 ) And tblAssets.AssetID In (Select Top 1000000
tblOperatingsystemHist.AssetID From tblOperatingsystemHist
Where tblOperatingsystemHist.Caption Like '%windows xp%' And
tblOperatingsystemHist.Action = 2 And tblOperatingsystemHist.Lastchanged >
GetDate() -1 ) And tblOperatingsystem.Caption Like '%windows 7%' And
tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
‎04-08-2015 11:24 AM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblOperatingsystem.Caption As CurrentOS,
tblAssets.SP,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblAssets.AssetID In (Select Top 1000000 tblOperatingsystemHist.AssetID
From tblOperatingsystemHist
Where tblOperatingsystemHist.Caption Like '%windows 7%' And
tblOperatingsystemHist.Action = 1 And tblOperatingsystemHist.Lastchanged >
GetDate() -1 ) And tblAssets.AssetID In (Select Top 1000000
tblOperatingsystemHist.AssetID From tblOperatingsystemHist
Where tblOperatingsystemHist.Caption Like '%windows xp%' And
tblOperatingsystemHist.Action = 2 And tblOperatingsystemHist.Lastchanged >
GetDate() -1 ) And tblOperatingsystem.Caption Like '%windows 7%' And
tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now