Take advantage of "Database Scripts"

[scpspjk]

I would love to take advantage of the "Database Scripts" option in the Lansweeper Configration Utility, but I'm not sure that I can...

I have 40 sites to setup and I would like to make the process easier than a million mouse-clicks.

1. How can I use it to actually create a report that will appear in the Reports tab?
2. How can I use it to modify the reports that are shown on the Digital Dashboard? For example, remove the "No F-Secure..." report.
3. How can I use it to change the sort order of the reports that are shown on the Digital Dashboard?

Thanks for anyones time on this!

[Hemoco]

You will need some basic SQL knowledge:

1)

' This is a sample report
' Always start the name of your views with "web30rep"

'Create the view

CREATE VIEW dbo.web30rep...
AS
SELECT ...

GO

'Add the view to the reports table

INSERT INTO ...

GO

'Add the report to the reports page

INSERT INTO ... VALUES     (...)

Example:

1)

CREATE VIEW web30reptest
AS
SELECT computername from tblcomputers
GO

INSERT INTO tsysreports (Reportquery, Reporttitle)
SELECT     'web30reptest', 'this is a test'
GO

INSERT INTO Tsysreporthomepage
                      (HomepageQuery, Sortorder, Priority, Showcolor, Showpercentage)
SELECT     'web30reptest', 1234, 1, 1, 1
GO

2) should be something like this:

delete from Tsysreporthomepage where homepagequery='web30repNoFSecure'
GO

3) Example

update Tsysreporthomepage set sortorder=1234 where homepagequery='Web30repnonenglish'
GO