All Installed Software report in Lansweeper 4.0

[dodgal]

Hi,

I'm using Lansweeper 4.0 premium version - scanning 2 domains.

I wanted to extract only the software installed on 1 of these domains so I amended the All Installed Software report to show only software installed on the required domain by adding from do.tblComputers.Domain where domain = my domain to the report.

Initially it looked good (that was Friday) but when I drilled deeper into the report today I find that on some of the software items are reporting for both domains - so clearly I was on the wrong track. Then don't ask me what I did but now my report in report builder brings back the error

"Invalid objectname 'web40repsoftware total'"

On the Web Console - I get Report has an invalid syntax. Execute Reader CommandText property has not been initialized.

It's obvious from the detail above that my SQL skills are NIL!

So I need help with the following:-

1. Reconstructing the All installed software report.

2. Creating a report to extract all software installed on a named domain.



Thanks in advance

[dodgal]

Excellent! That worked a treat!

Thanks so much for you assistance - it was much appreciated.

[Hemoco]

Could you edit the report, the copy paste this sql code into the sql box.
Then click on the area where all the tables are.
Then click on save.

Select Top 1000000 dbo.tblSoftware.softwareName As Software, dbo.tblSoftware.softwareVersion As Version, dbo.tblSoftware.SoftwarePublisher As Publisher, Count(dbo.tblSoftware.ComputerName) As Total From dbo.tblSoftware Inner Join dbo.tblComputers On dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername Inner Join dbo.web40ActiveComputers On dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername Group By dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion, dbo.tblSoftware.SoftwarePublisher Order By Count(dbo.tblSoftware.ComputerName) Desc

[dodgal]

The attached file shows a screen shot of the Report layout for the All software report and also for comparison a the Report layout for All microsoft sofware report.

[Hemoco]

I'm not sure I understand the problem, could you post any screenshots you have.

[dodgal]

Hi,

Any update on this? I have updated to LS 4.0.0.27 and still have the same problem with the Report 'Software: All installed software'. Viewname in Report builder is 'softwaretotal'. As mentioned earlier - output appears ok but the the actual view is missing.

Thanks

[dodgal]

Attached is the output from tsysreport as requested

[Hemoco]

Create a new report an use "select * from tsysreports" as the sql.
Then export the results to excel.

[dodgal]

If I understand you right I was to run this as a database script. When I did that I got this "Could not find stored procedure 'select * from tsysreports'"

If I did this incorrectly let me know.

Thanks

[Hemoco]

Could you upload the output of "select * from tsysreports"