Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
select ImeiNumber, [Name] from [wlt_tblDevices] d left join [dbo].[wlt_tblAssets] a on d.[ifk_AssignedAssetId] = a.Id where not exists (select 1 from [tblCommonTrackingData] c where d.ImeiNumber = c.vpkDeviceId and c.dGPSDateTime between '2016/07/01' and '2016/10/01')
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!