cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dodgal
Engaged Sweeper
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
11 REPLIES 11
dodgal
Engaged Sweeper
Excellent! That worked a treat!

Thanks so much for you assistance - it was much appreciated.
Hemoco
Lansweeper Alumni
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
Engaged Sweeper
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
Lansweeper Alumni
I'm not sure I understand the problem, could you post any screenshots you have.
dodgal
Engaged Sweeper
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
Engaged Sweeper
Attached is the output from tsysreport as requested
Hemoco
Lansweeper Alumni
Create a new report an use "select * from tsysreports" as the sql.
Then export the results to excel.
dodgal
Engaged Sweeper
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
Lansweeper Alumni
Could you upload the output of "select * from tsysreports"