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
Thanks for quick response.

I've done what you asked. Now when I run the report on the web console it is fine but in report builder - I can get the output when I double click on the report but if I choose to edit the report the report definition(I hope that is the right term) is not available under the 'builder' tab and the 'result' doesn't bring back anything either. Is that gone forever or is there another step?

Thanks
Hemoco
Lansweeper Alumni
Try this sql code to recreate the report: (run from the database scripts tab)

CREATE VIEW [dbo].[web40repsoftwaretotal]
AS
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
GO