‎09-11-2018 02:48 PM
‎10-04-2018 06:14 PM
select lsrpt.Reporttitle, m.definition view_ddl , o.name view_name
from lansweeperdb.sys.objects o
join lansweeperdb.sys.sql_modules m on m.object_id = o.object_id
join lansweeperdb..tsysreports lsrpt on lsrpt.Reportquery = o.name COLLATE Latin1_General_CI_AI
where o.name like 'web50%'
and o.type = 'V';
‎09-13-2018 05:38 PM
‎09-12-2018 02:18 PM
‎09-12-2018 01:31 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now