→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
hestia
Engaged Sweeper
Hello,

I'm trying to insert my custom report directly into the database. But when I try to run the report I got the following error: "Cannot find query"

I've run the following code:
insert into dbo.tsysreports (dbo.tsystreports.Reportquery, dbo.tsysreports.Reporttitle, dbo.tsysreports.CreatedBy, dbo.tsysreports.Created) 
values ('cust_ot_servers','OT Intake Servers','Lansweeper Installation', GETDATE());

create view dbo.cust_ot_servers as
Select
tblAssets.AssetName As Title,
tblADComputers.Description As Description,
null As Type,
REPLACE(REPLACE(REPLACE(tblComputersystem.Roles, 'LM_Workstation , LM_Server ,', ''),'NT , Server_NT',''), ',','') As Role,
tsysOS.OSname As "Operating System",
tblAssets.IPAddress As "Ip Addres",
null As "Environment Status",
tblAssets.Memory As Memory,
null As Alias,
null As Hostgroup,
null As Connection,
null As Version,
null As "Vendor Support ID",
tblSystemEnclosure.SerialNumber As "Serial Number",
null As "Nr. Sockets",
tblAssets.NrProcessors As "Nr. Cores",
null As "Management URL",
null As "Maintenance Window",
null As "Linked Datastore",
tblComputersystem.Model As "Hardware Type",
null As "Connection Port",
null As "Backup Engine",
null As "Attached Storage",
null As "Additional Role",
null As "Additional IP Address"
From tblComputersystem
Inner join tblSystemEnclosure on tblSystemEnclosure.AssetID = tblComputerSystem.AssetID
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblADComputers on tblADComputers.AssetId = tblAssets.AssetID
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblComputersystem.Domainrole > 1 And tblAssetCustom.State = 1;


What am I doing wrong?
1 REPLY 1
mc_connected
Engaged Sweeper II
Did you ever get this working? While I am grateful that we get lots of reports written for us, I find it cumbersome to add them all the time via the UI.