→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

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

I have a report that needs to be made that is urgently due. I've spent the last week trying to learn the interconnections of LANSweeper reporting but I can't make all these fields interconnect. Any help or a better starting spot would be very much appreciated.

Here are the fields needed:

Username | Hostname | OS Version | Laptop Model Number | Version of MS Office | Is Microsoft Teams installed? |

Thank you again for any assistance.
3 REPLIES 3
RCorbeil
Honored Sweeper II
Take a look at this thread.
Esben_D
Lansweeper Employee
Lansweeper Employee
Just creating a new report in Lansweeper, you can add these fields by checking the following:

Username = Username in tblAssets
Hostname = AssetName in tblAssets (enabled by default)
OS version = Version or Buildnumber depending on what you want, in tblAssets
Laptop Model Number = Model in tblAssetCustom

The best thing you can do is create a copy of the built-in report "Windows: Installed software by computer" You can enable or disable the fields you want to add or remove.

Once you've done that, you can add criteria to tblSoftware.softwareVersion in the table view part of the report editor.
LIKE '%Office%' and one column to the right LIKE '%Teams%' should do the trick.
Do note that all assets without a software with Office or Teams in the name will not appear in the report.

Here's what I've got so far: The last thing I really need is a separate column for displaying for displaying if Microsoft Teams is installed or not Thank you very much for your assistance so far


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName As Hostname,
tblAssets.Username,
tsysOS.OSname As OS,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssetCustom.Model,
tblSoftwareUni.softwareName As [Microsoft Office Version]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where (tblSoftwareUni.softwareName Like '%Microsoft Office Professional%' And
tblState.Statename = 'Active') Or
(tblSoftwareUni.softwareName Like '%Office 365%')