Default reports

[danielm]

Ok, it seems easy to accidentally rename or chanage the default reports when making new ones.
I thought it was saving as a new name but the old ones disapperas.

Is there any place where it lists all the DEFAULT report names?

[danielm]

thanks.
odd, i finally found it in a new install and it was slightly different but gave the same results. maybe since mines been upgraded since for ever.

Select Top 1000000 dbo.tblAssets.AssetID,
dbo.tblAssets.AssetUnique,
dbo.tblAssets.Domain,
dbo.tsysOS.OSname,
dbo.tsysOS.Image As icon,
RTrim(LTrim(Coalesce(dbo.tblOperatingsystem.Caption, '') + ' ' +
Coalesce(dbo.tblOperatingsystem.OtherTypeDescription, ''))) As OS,
dbo.tblOperatingsystem.Lastchanged
From dbo.tblComputersystem
Inner Join dbo.tblAssets On dbo.tblComputersystem.AssetID =
dbo.tblAssets.AssetID
Inner Join dbo.tblOperatingsystem On dbo.tblAssets.AssetID =
dbo.tblOperatingsystem.AssetID
Inner Join dbo.tblAssetCustom On dbo.tblAssets.AssetID =
dbo.tblAssetCustom.AssetID
Inner Join dbo.tsysOS On dbo.tblAssets.OScode = dbo.tsysOS.OScode
Where dbo.tblComputersystem.Domainrole > 1 And dbo.tblAssetCustom.State = 1
Order By dbo.tblAssets.AssetName

[Hemoco]

SQL query for this report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblComputersystem.Lastchanged,
tsysOS.Image As icon
From tblComputersystem
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblComputersystem.Domainrole > 1 And tblAssetCustom.State = 1
Order By tblAssets.AssetName

[danielm]

Actually, I just decided to Install lansweeper on a VM and look at the settings.
I accidentally Renamed and saved over my "Servers: All servers" report.
ah well.

[danielm]

Actually can anyone tell me what REPORT they see on the Lansweeper v5 , SERVERS tab, bottom "data" report. bellow the dashboard report. mine is busted 🙂