
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-31-2010 02:08 PM
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
- Labels:
-
Report Center

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-08-2010 12:43 PM
Thanks so much for you assistance - it was much appreciated.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-04-2010 04:44 PM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-04-2010 03:47 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-03-2010 04:11 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-03-2010 02:23 PM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-31-2010 05:26 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-31-2010 03:35 PM
Then export the results to excel.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-31-2010 03:23 PM
If I did this incorrectly let me know.
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-31-2010 03:18 PM
