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: 10  
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: 10  
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 Remove all users from old domain
by  cmuter   Go to last post Go to first unread
Last post: 9/20/2019 8:03:58 PM(UTC)
Lansweeper Static IP Address
by  cycleheat  
Go to last post Go to first unread
Last post: 9/20/2019 4:07:16 PM(UTC)
Lansweeper Bitlocker Encryption Recovery Key no information found
by  Stephane   Go to last post Go to first unread
Last post: 9/20/2019 2:26:19 PM(UTC)
Lansweeper InTune Scanning Issues
by  Esben.D  
Go to last post Go to first unread
Last post: 9/20/2019 12:34:59 PM(UTC)
Lansweeper Office 365 scanning issues
by  Esben.D   Go to last post Go to first unread
Last post: 9/20/2019 12:23:30 PM(UTC)
Lansweeper Hard Drive Tracking - Start to Finish
by  Lone Jedi  
Go to last post Go to first unread
Last post: 9/19/2019 8:11:56 PM(UTC)
Lansweeper Lansweeper Reporting Old Assets as New
by  Jpatterson   Go to last post Go to first unread
Last post: 9/19/2019 12:52:14 PM(UTC)
Lansweeper Cannot edit a ticket anymore
by  Esben.D  
Go to last post Go to first unread
Last post: 9/19/2019 12:32:42 PM(UTC)