My lansweeper homepage is messed up and I cannot open the all workstaions report in ReportBuilder. I get the following error: Invalid Object Name 'Web30repAllWorkstations'
I know that this has been solved before but I do not know what to do with the code. The solution simply says try this and displays some code. What do you do with this code?
CREATE VIEW dbo.Web30repAllWorkstations
AS
SELECT dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblComputersystem.Domainrole, dbo.tblComputersystem.Lastchanged
FROM dbo.tblComputersystem INNER JOIN
dbo.tblComputers ON dbo.tblComputersystem.Computername = dbo.tblComputers.Computername
WHERE (dbo.tblComputersystem.Domainrole < '2')
GO
