cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
scpspjk
Engaged Sweeper
hi everyone,

Two things:
1) I am trying to use "database scripts" to created a report. I can get the report create, and the results show just fine. However, when I go into Report Builder and edit the report, the windows in Report Builder are all blank. I cannot see the SQL code. Any hints? here is the code I am entering into "database scripts"
CREATE VIEW dbo.AAA_IS_AVG_Installed
AS
Select Top 100 Percent dbo.tblComputers.Computername As Computer,
dbo.tblOperatingsystem.Description, dbo.tblSoftware.softwareName As Software,
dbo.tblSoftware.softwareVersion As Version,
dbo.tblSoftware.Lastchanged
From dbo.tblSoftware
Inner Join dbo.tblComputers On dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername
Inner Join dbo.tblOperatingsystem On dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
Where dbo.tblSoftware.softwareName Like '%AVG%'
Order By dbo.tblComputers.Computername

GO

INSERT INTO [tsysreports] ([Reportquery],[Reporttitle]) VALUES ('AAA_IS_AVG_Installed','AAA_IS_AVG_Installed')

GO


2) How can I get this report added directly to Dashboard via "database scripts"?

Thanks
1 REPLY 1
Hemoco
Lansweeper Alumni
the name of the view must start with "web40rep"