Notification

Icon
Error

Custom Reports backup

Posted: Friday, January 12, 2018 8:35:06 AM(UTC)
atul557

atul557

Member Original PosterPosts: 28
0
Like
Hi Team,

We wanted to know if we can take backup of custom report made in LS.
Apart from DB backup is there any other way so that a backup can be taken for all reports created.

Regards,

Atul SAnxious
miek_g
#1miek_g Member Posts: 11  
posted: 1/12/2018 6:30:02 PM(UTC)
I would also love to be able to do this, a full backup can be done https://www.lansweeper.c...p-your-installation.html But I would like to just backup any custom reports
esr
#2esr Member Alpha Tester Posts: 69  
posted: 1/12/2018 7:06:48 PM(UTC)
I'm using this currently....


Code:
Select Top 1000000 tsysreports.Reporttitle As Title,
  OBJECT_DEFINITION(Object_Id(tsysreports.Reportquery)) ViewScript
From tsysreports
Where tsysreports.Created Is Not Null
Order By Title
atul557
#3atul557 Member Original PosterPosts: 28  
posted: 1/15/2018 12:11:43 PM(UTC)
Originally Posted by: esr Go to Quoted Post
I'm using this currently....


Code:
Select Top 1000000 tsysreports.Reporttitle As Title,
  OBJECT_DEFINITION(Object_Id(tsysreports.Reportquery)) ViewScript
From tsysreports
Where tsysreports.Created Is Not Null
Order By Title


thanks for the report
Its really helpfull
miek_g
#4miek_g Member Posts: 11  
posted: 1/15/2018 2:00:56 PM(UTC)
I am receiving this error "The function is not recognized by SQL Server Compact. [ Name of function = Object_Id,Data type (if known) = ]"
Duncan.Miles
#5Duncan.Miles Member Posts: 8  
posted: 8/8/2019 11:01:48 AM(UTC)
Originally Posted by: esr Go to Quoted Post
I'm using this currently....


Code:
Select Top 1000000 tsysreports.Reporttitle As Title,
  OBJECT_DEFINITION(Object_Id(tsysreports.Reportquery)) ViewScript
From tsysreports
Where tsysreports.Created Is Not Null
Order By Title


Angel Just what I was after! great, thanks

Active Discussions

Lansweeper Default tabs not being deleted.
by  RobertB   Go to last post Go to first unread
Last post: Yesterday at 11:34:50 PM(UTC)
Lansweeper SCCM - Overrighting Lansweeper Info
by  The Boss  
Go to last post Go to first unread
Last post: Yesterday at 9:39:00 PM(UTC)
Lansweeper Windows Defender AV
by  Mikey!   Go to last post Go to first unread
Last post: Yesterday at 6:23:02 PM(UTC)
Lansweeper Changes in the licensing model
by  BullGates   Go to last post Go to first unread
Last post: Yesterday at 4:17:46 PM(UTC)
Lansweeper User deletion requirements
by  Adam Poole  
Go to last post Go to first unread
Last post: Yesterday at 2:45:58 PM(UTC)