Reports for v5 - Changes

[ewp_wat]

Hi

I have some reports which will not work on v5. Can you please help me?
Thank you very much.

Best regards,
Roman

Report 1

Select Top 1000000 tblcomputers.Computer, tblComputerSystemProduct.Vendor As Manufacturer, tblComputerSystemProduct.Name As Model, Web40OSName.OSname, Web40OSName.SP, tblcomputers.LastknownIP, tblOperatingsystem.InstallDate, tblcomputers.Username, tblcomputers.Lastseen, tblADusers.Department, tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate, tblADComputers.OU From tblcomputers Inner Join Web40OSName On Web40OSName.Computername = tblcomputers.Computername Inner Join tblComputerSystemProduct On tblcomputers.Computername = tblComputerSystemProduct.Computername Inner Join tblOperatingsystem On tblcomputers.Computername = tblOperatingsystem.Computername Left Join tblADusers On tblADusers.Username = tblcomputers.Username And tblADusers.Userdomain = tblcomputers.Userdomain Inner Join tblCompCustom On tblcomputers.Computername = tblCompCustom.Computername Inner Join tblADComputers On tblcomputers.Computername = tblADComputers.Computername Order By tblcomputers.Computer



Report 2

Select Top 1000000 tblcomputers.Computername, tblcomputers.ComputerUnique As [Computer Name], tblcomputers.Username As Username, tblComputerSystemProduct.Vendor As [Computer Manufacturer], tblComputerSystemProduct.Name As [Computer Model], tblComputerSystemProduct.IdentifyingNumber As [Service Tag], tblCompCustom.PurchaseDate As [Purchase Date], tblCompCustom.Warrantydate As [Warranty Expiration], office.softwareName, tblcomputers.LastknownIP As [Last Known IP Address] From tblcomputers Left Join (Select tblSoftware.softwareName, tblSoftware.ComputerName From tblSoftware Where tblSoftware.softwareName Like '%Visio%' Or tblSoftware.softwareName Like '%Project%') office On office.ComputerName = tblcomputers.Computername Left Join tblComputerSystemProduct On tblcomputers.Computername = tblComputerSystemProduct.Computername Left Join tblCompCustom On tblcomputers.Computername = tblCompCustom.Computername Order By tblcomputers.ComputerUnique


Report 3

Select Top 1000000 tblcomputers.Computername, tblcomputers.Domain, tblcomputers.Computer, tblOperatingsystem.Caption, tblOperatingsystem.Description, tblOperatingsystem.OSType, tblADComputers.OU, tblComputerSystemProduct.Vendor, tblComputerSystemProduct.Name From tblcomputers Left Join tblOperatingsystem On tblcomputers.Computername = tblOperatingsystem.Computername Inner Join tblADComputers On tblcomputers.Computername = tblADComputers.Computername Inner Join tblComputerSystemProduct On tblcomputers.Computername = tblComputerSystemProduct.Computername Order By tblcomputers.Computer


Report 4

Select Top 1000000 tblcomputers.Computername, tblcomputers.ComputerUnique, tblcomputers.Domain, Web40OSName.OSname, tblComputersystem.Lastchanged, Web40OSName.Compimage As icon, tblcomputers.Computer, tblComputersystem.SystemType From tblcomputers Inner Join tblComputersystem On tblcomputers.Computername = tblComputersystem.Computername Inner Join web40ActiveComputers On tblcomputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblcomputers.Computername Where tblComputersystem.Domainrole > 1 Order By dbo.tblComputers.Computer

[Hemoco · Accepted solution]

Please use the reports below for Lansweeper 5.0.

Report 1

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname,
tblAssets.SP,
tblAssets.IPAddress,
tblOperatingsystem.InstallDate,
tblAssets.Username,
tblAssets.Lastseen,
tblADusers.Department,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblADComputers.OU
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tblOperatingsystem On tblOperatingsystem.AssetID = tblAssets.AssetID
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName

Report 2

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Username,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblSoftwareUni.softwareName
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tblOperatingsystem On tblOperatingsystem.AssetID = tblAssets.AssetID
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where (tblSoftwareUni.softwareName Like '%Visio%' And tblAssetCustom.State = 1)
Or
(tblSoftwareUni.softwareName Like '%project%' And tblAssetCustom.State = 1)
Order By tblAssets.Domain,
tblAssets.AssetName

Report 3

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblOperatingsystem.Caption,
tblAssets.Description,
tblOperatingsystem.OSType,
tblADComputers.OU,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets.AssetID
Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where tblAssetCustom.State = 1

Report 4

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tsysOS.OSname,
tblComputersystem.SystemType,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName