→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!

Community FAQ
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.

General Discussions

Find answers to technical questions about Lansweeper.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now