‎09-28-2015 02:48 PM
Solved! Go to Solution.
‎10-27-2015 03:27 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Lastseen,
tsysOS.Image As icon,
tFileVersions.Found,
tFileVersions.FileVersion,
tRegistry.Value As Datum,
t2Registry.Value As Tid
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join (Select tblFileVersions.AssetID,
tblFileVersions.Found,
tblFileVersions.FileVersion
From tblFileVersions
Where tblFileVersions.FilePathfull Like '%SCClient.exe') tFileVersions
On tblAssets.AssetID = tFileVersions.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'SCCMLastRunDate') tRegistry
On tblAssets.AssetID = tRegistry.AssetID
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'SCCMLastRunTime') t2Registry
On tblAssets.AssetID = t2Registry.AssetID
Where tsysIPLocations.IPLocation Like 'EDU.IFM.LIU.SE' And
tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Order By tblAssets.AssetName
‎10-28-2015 10:37 AM
‎10-27-2015 03:27 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Lastseen,
tsysOS.Image As icon,
tFileVersions.Found,
tFileVersions.FileVersion,
tRegistry.Value As Datum,
t2Registry.Value As Tid
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join (Select tblFileVersions.AssetID,
tblFileVersions.Found,
tblFileVersions.FileVersion
From tblFileVersions
Where tblFileVersions.FilePathfull Like '%SCClient.exe') tFileVersions
On tblAssets.AssetID = tFileVersions.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'SCCMLastRunDate') tRegistry
On tblAssets.AssetID = tRegistry.AssetID
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'SCCMLastRunTime') t2Registry
On tblAssets.AssetID = t2Registry.AssetID
Where tsysIPLocations.IPLocation Like 'EDU.IFM.LIU.SE' And
tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Order By tblAssets.AssetName
‎10-26-2015 02:18 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Lastseen,
tsysOS.Image As icon,
tFileVersions.Found,
tFileVersions.FileVersion,
tRegistry.Value As Datum,
t2Registry.Value As Tid
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join (Select tblFileVersions.AssetID,
tblFileVersions.Found,
tblFileVersions.FileVersion
From tblFileVersions
Where tblFileVersions.FilePathfull Like '%SCClient.exe') tFileVersions
On tblAssets.AssetID = tFileVersions.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'SCCMLastRunDate') tRegistry
On tblAssets.AssetID = tRegistry.AssetID
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'SCCMLastRunTime') t2Registry
On tblAssets.AssetID = t2Registry.AssetID
Where tsysIPLocations.IPLocation Like 'EDU.IFM.LIU.SE' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName
‎09-30-2015 01:41 PM
‎09-29-2015 04:08 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Lastseen,
tsysOS.Image As icon,
tFileVersions.Found,
tFileVersions.FileVersion,
tRegistry.Value
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join (Select tblFileVersions.AssetID,
tblFileVersions.Found,
tblFileVersions.FileVersion
From tblFileVersions
Where tblFileVersions.FilePathfull Like '%SCClient.exe ') tFileVersions
On tblAssets.AssetID = tFileVersions.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'SMSSLP ') tRegistry On tblAssets.AssetID =
tRegistry.AssetID
Where tsysIPLocations.IPLocation Like 'Example Location ' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now