→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎06-29-2015 06:53 PM
Solved! Go to Solution.
‎07-03-2015 01:03 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Lasttriggered,
tblAssets.LastScheduled,
tblAssets.LastActiveScan,
tblAssets.LastIPScan,
tblAssets.LastLsPush
From tblAssets
Order By tblAssets.Lasttried Desc
‎07-07-2015 10:19 AM
‎07-03-2015 07:49 PM
‎07-03-2015 01:03 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Lasttriggered,
tblAssets.LastScheduled,
tblAssets.LastActiveScan,
tblAssets.LastIPScan,
tblAssets.LastLsPush
From tblAssets
Order By tblAssets.Lasttried Desc
‎07-02-2015 03:47 PM
‎06-30-2015 03:47 PM
Select Top 1000000 tblScanHistory.ScanServer,
tsysScanningMethods.ScanningMethod,
tblScanHistory.Description,
tblScanHistory.ScanTime,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress
From tblAssets
Left Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Right Join tblScanHistory On tblAssets.AssetID = tblScanHistory.AssetId
Inner Join tsysScanningMethods On tsysScanningMethods.ScanningMethodId =
tblScanHistory.ScanningMethodId
Where tblScanHistory.ScanTime Between '2015-06-15' And '2015-07-01'
Order By tblScanHistory.ScanTime Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now