Creating Custom Reports

[Tczadzeck]

Good Afternoon,

I am not new to Lansweeper, but new to creating custom reports. We're currently trying to track how many users have Foxit Phantom PDF Standard on their computer. Currently we have a list of MAC addresses from Foxit to assist us with finding who has Foxit installed but it's a compiled list and might be showing inactive computers.

I'm trying to create a report within Lansweeper to produce an excel sheet which will show the Computer Name, Last Login User, MAC address and last contacted(was pinged).

Can anyone assist or point me in the right direction?

Tim

[SteveYaron]

This report has been useful. It's Software Titles on Assets (filtered).

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Memory,
tblAssets.Username,
tblADusers.Displayname As [Full Name],
tsysAssetTypes.AssetTypeIcon10 As icon,
tblADusers.Description,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tblSoftwareUni.Approved,
tsysIPLocations.IPLocation,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftware.Installdate,
tblADComputers.OU As [PC AD OU],
tblADComputers.Description As [PC AD Description]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tblADusers On tblAssets.Username = tblADusers.Username And
tblAssets.Domain = tblADusers.Userdomain
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblAssets.AssetName Like '%0%' And tblSoftwareUni.softwareName Not Like
'%bcgov%' And tblSoftwareUni.softwareName Not Like '%hotfix%' And
tblSoftwareUni.softwareName <> 'Bitlocker Protection Status' And
tblSoftwareUni.softwareName Not Like '%setlocalgroup%' And
tblSoftwareUni.softwareName Not Like '%config%' And
tblSoftwareUni.softwareName Not Like '%trendmicro%' And
tblSoftwareUni.softwareName Not Like '%redist%' And
tblSoftwareUni.softwareName Not Like '%rsalPrin%' And
tblSoftwareUni.softwareName Not Like '%linePlug%' And
tblSoftwareUni.softwareName Not Like '%ortbundle%' And
tblSoftwareUni.softwareName Not Like '%kwavepl%' And
tblSoftwareUni.softwareName Not Like '%LocAccntMa%' And
tblSoftwareUni.softwareName Not Like '%be flash player 24%' And
tblSoftwareUni.softwareName Not Like '%jre 1.8.0.112%' And
tblSoftwareUni.softwareName Not Like '%appvdeskt%' And
tblSoftwareUni.softwareName Not Like '%printermigra%' And
tblSoftwareUni.SoftwarePublisher <> 'Intel Corporation' And
tblAssetCustom.State = 1
Order By tblSoftware.Installdate Desc

[Tczadzeck]

Steve,

Thanks for the input, unfortunately if you don't understand SQL than the reports function is absolutely useless 🙂 We've tried editing software/publisher etc and are unable to bring up the software in general, and if we do it only brings up the software names but not the computers that are actually using the software.

Tim

[SteveYaron]

Start with the report Workstation: All Workstations. Then you can modify it to suit your needs.

[Tczadzeck]

Any thoughts or ideas Lansweeper community? I'm still working on this and unable to find and answer.