cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
pgodfrin
Engaged Sweeper II
Greetings,
I have inadvertently damaged one of the built-in reports. How can I restore or re-install the original built in report?
thanks,
phil
4 REPLIES 4
pgodfrin
Engaged Sweeper II
After some discussion with support and a little creativity, I use this SQL that I run weekly:

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';


Save the output into a table or flat file and voila - report backups!



pgodfrin
Engaged Sweeper II
Oh duh - the posting has a malformed url, so I cut and paste it and I found it....
pg
pgodfrin
Engaged Sweeper II
Thanks went there, found this:
Take a look at the build-in report "Windows: Error events generated in last 7 days", you can also find it here: https://www.lansweeper.c...af_postst15670_Windows--Events-generated-in-last-7-days.aspx

Which ends in a 404.

Went through 14 pages of postings, seems a weak way to have a repository of reports. Is the source code in the install directory anywhere, or do you have a direct link here on support?

thanks,
pg
Esben_D
Lansweeper Employee
Lansweeper Employee
All built-in reports are available here on the forum in the Finished Reports topic. You could also do a search on the name of the report.