cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
atul557
Engaged Sweeper III
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 S
5 REPLIES 5
miek_g
Engaged Sweeper III
I am receiving this error "The function is not recognized by SQL Server Compact. [ Name of function = Object_Id,Data type (if known) = ]"
esr
Champion Sweeper
I'm using this currently....


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
Duncan_Miles
Engaged Sweeper II
esr wrote:
I'm using this currently....


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


Just what I was after! great, thanks
atul557
Engaged Sweeper III
esr wrote:
I'm using this currently....


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
Engaged Sweeper III
I would also love to be able to do this, a full backup can be done https://www.lansweeper.com/kb/94/backing-up-your-installation.html But I would like to just backup any custom reports

New to Lansweeper?

Try Lansweeper For Free

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

Try Now