Custom Software Report

[mtaggart]

Is there any way to create a custom report for group specific applications into 1 report vs. looking through the thousands of apps being reported in Software Publishers report natvie to Lansweeper?

For example, Specops Inventory allows you to create a folder, then you can put whatever apps you want in that specific folder to group things together.

I don't need that level of grouping (it would be nice if it was possible), but if I could at least create a report that displays only the apps I want it to report back to me, we could probably get by with that.

Also, how do we make Lansweeper scan each computer/laptop/server on a daily basis?

Thank you,

Mike

[Hemoco]

mtaggart wrote:
how do we make Lansweeper scan each computer/laptop/server on a daily basis?

Review your scanning setup under Configuration/Scanning Setup/Scanning Methods. Our online documentation explains how each scanning method works: http://www.lansweeper.com/documentation.pdf
Most scanning methods (e.g. IP Address Range Scanning) scan your machines once a day by default.

mtaggart wrote:
Is there any way to create a custom report for group specific applications into 1 report vs. looking through the thousands of apps being reported in Software Publishers report natvie to Lansweeper?

A sample report can be seen below. Replace Software A and Software B with the names of the software packages you would like to report on.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where (tblSoftwareUni.softwareName Like '%Software A%' Or
tblSoftwareUni.softwareName Like '%Software B%') And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
software,
version

To use the specified report, do the following:
• Browse to the Dashboard\Reports\Report Builder section of the web console.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it.
• The report will now also be listed under Dashboard\Reports\All Reports.