Just a few things:I'd recommend a separate report due to how Lansweeper separates Windows and Linux devices.I don't scan Linux devices in our environment so the report may or may not be entirely accurate.Select Top 1000000 tblAssets.AssetID, tblAsse...
The tblServices and tblServicesUni tables are where you want to look. The database dictionary is a very good reference for these kind of things, http://www.lansweeper.com/Forum/yaf_postsm38296_Lansweeper-database-dictionary.aspx#post38296Here's a qui...
Disclaimer: I am not a SQL expert by any means. I know enough to be dangerous. The primary issue is your second to last join to the tblADObjects table does not link back to the tblAssets table. I am not familiar with using commas to join tables, but...
We had a similar need in our environment, so we scan the Version value under the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows Mail\Inetcomm key. It's not ideal but it has been working so far.
This should be what you are needing.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tsysOS.Image As icon, tblAssets.Domain, tsysOS.OSname, tblAssets.Memory, Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As nume...