Newly Installed Software

[maria_porter]

Hi,

I'm new to Lansweeper reporting, and I'm trying to create some reports to report when certain software packages are installed on computers. For example, I'm trying to build a report to show all computers that have had Office 2010 Pro Plus installed in the last 7 days.

Would anyone know how to go about this?

Thanks,

EDIT: We are using V5 Premium

[DanCenterlight]

I tried what was suggested above and was getting an error message. Invalid object name 'tblAssets'
I then noticed that I don't have the tblAssets on the right selection and so is tblsoftwareUni. Is there a setting that we did not enable that is why we don't have these tables?

To the OP sorry for the HiJack trying to get the same results.

[Hemoco]

DanCenterlight wrote:
I tried what was suggested above and was getting an error message. Invalid object name 'tblAssets'
I then noticed that I don't have the tblAssets on the right selection and so is tblsoftwareUni. Is there a setting that we did not enable that is why we don't have these tables?

To the OP sorry for the HiJack trying to get the same results.

Which Lansweeper version are you using? 4.2 or 5.0? We posted a 5.0 report.

[maria_porter]

That's worked perfectly for what we need. Thank you!

[Hemoco · Accepted solution]

Please try the report below for the information you are after.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysOS.OSname,
tblAssets.SP,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tblSoftware.Lastchanged
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%office%professional%plus%2010%' And
tblSoftware.Lastchanged > GetDate() - 7
Order By tblAssets.Domain,
tblAssets.AssetName

To use the specified report:
• 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 Report button to save it.
• The report will now also be listed under Dashboard\Reports\All Reports.