→ 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: 
maria_porter
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

4 REPLIES 4
DanCenterlight
Engaged Sweeper
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.
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
Engaged Sweeper
That's worked perfectly for what we need. Thank you!
Hemoco
Lansweeper Alumni
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.