Lansweeper Forum
»
Lansweeper
»
Reports and queries
»
Syntax for report txt sql or other scripts
 Rank: Administration Groups: Administration, Premium Users
Posts: 10,007
|
The sql script editor is not fully compliant with OSQL but these extra syntax words can be used : ' to make a comment GO = to execute the previous query sample report: Code:
' 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 (...)
|
|
|
|
|
|
Rank: Freeware user
Groups: Member
Posts: 9
|
ok thanks. I managed to add the viw in SQL as a dbo.web30noConfickerPatch but cant seem to find how to add it to the dashboard.
Im no genuis at SQL so probably doing something wrong.
|
|
|
|
|
|
Rank: Administration Groups: Administration, Premium Users
Posts: 10,007
|
After you have done this you need to add it to the table tsysreports. Afterwards you can use lsmanage to place it on the dashboard.
|
|
|
|
|
|
Lansweeper Forum
»
Lansweeper
»
Reports and queries
»
Syntax for report txt sql or other scripts
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
