→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎10-08-2012 09:54 AM
Solved! Go to Solution.
‎03-11-2013 05:04 PM
cpmining wrote:
With Lansweeper 5 this report no longer works.
‎03-24-2013 04:09 AM
Select Top 1000000 tblAssets.Username,
tblAssets.AssetUnique,
tblAssets.AssetID,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber As Serial,
tblAssets.IPAddress As [IP Address],
tblAssetCustom.Warrantydate,
tblMonitor.MonitorModel,
tblMonitor.SerialNumber
From tblAssets
Left Outer Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblMonitor On tblAssets.AssetID = tblMonitor.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetID
‎03-25-2013 01:23 PM
cpmining wrote:
Is there any way for the MONITOR fields to display side by side rather than having two results per user?
‎03-09-2013 04:02 AM
The specified table does not exist. [ tblComputers ]
‎03-11-2013 05:04 PM
cpmining wrote:
With Lansweeper 5 this report no longer works.
‎03-24-2013 02:35 AM
Lansweeper wrote:cpmining wrote:
With Lansweeper 5 this report no longer works.
There is a built-in report "Computer: System configuration overview" you can start from. It can be found under Dashboard/Reports/All Reports.
‎10-10-2012 04:08 PM
Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, Web40OSName.OSname As OS, Web40OSName.SP, tblComputers.LastknownIP As IP, tblComputerSystemProduct.IdentifyingNumber As Tag, web40AllIPLocations.IPLocation, tblMonitor.MonitorModel, tblMonitor.MonitorManufacturer, tblMonitor.SerialNumber As [Monitor Serial], tblMonitor.ManufacturedDate As [Monitor Manufactured], tblBIOS.Caption As BIOS, tblBIOS.ReleaseDate As [BIOS Release], DateDiff(yy, tblBIOS.ReleaseDate, GetDate()) As [Computer Age], tblComputers.Username As [Last User], tblComputers.Userdomain As [Last User Domain] From tblComputers Left Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Left Join web40AllIPLocations On web40AllIPLocations.Computername = tblComputers.Computername Left Join tblMonitor On tblMonitor.Computername = tblComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join tblBIOS On tblComputers.Computername = tblBIOS.Computername Where tblComputers.Lastseen <> '' Order By tblComputers.ComputerUnique
‎10-08-2012 12:20 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblBIOS.Caption, tblBIOS.ReleaseDate, tblADusers.Name,
tblADusers.Company, DateDiff(yy, tblBIOS.ReleaseDate, GetDate()) As Age
From tblComputers Inner Join
tblBIOS On tblComputers.Computername = tblBIOS.Computername Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain
‎10-08-2012 11:05 AM
‎10-08-2012 10:53 AM
Select top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Userdomain, tblComputers.Username,
tblComputers.LastknownIP, tblComputerSystemProduct.IdentifyingNumber,
web40AllIPLocations.IPLocation, tblMonitor.SerialNumber,
tblMonitor.MonitorModel, tblMonitor.MonitorManufacturer,
tblMonitor.ManufacturedDate
From tblComputers Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
web40AllIPLocations On web40AllIPLocations.Computername =
tblComputers.Computername Left Join
tblMonitor On tblMonitor.Computername = tblComputers.Computername
Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now