
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-29-2011 10:01 AM
is there any way to delete the system name from the software list..for EG: SQL server is showing as installed in 100 systems, but out of that 21 only server remaining are SQL express..maintenance is very difficult..so how to delete those entries?
Awaiting fast reply..

- Labels:
-
Archive

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-04-2011 11:47 AM
A summary of what we've discussed so far:
- Your concern was that in SQL Server overviews computers were included that have SQL Server Express installed. You wanted to "delete" those computers from the overviews.
- Lansweeper cannot, in any way, differentiate between the various SQL editions. For instance, Lansweeper cannot know whether an SQL Server is Express or not. This information cannot be scanned anywhere.
- If you wish to create a list of computers that have an edition installed other than SQL Express, you will need to create a custom report. In the custom report you have to manually exclude the computers you don't want.
- In the Lansweeper report builder hit New and paste the following code into your new report. (Replace "YourComputer".)
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Computer, tblComputers.Domain, tblSoftware.softwareName
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblComputers.Computer <> 'YourComputer' And tblSoftware.softwareName Like
'Microsoft SQL Server%'
- This report excludes computers based on the "Computer" field. Look up the names of the computers you wish to exclude and add them to the code by replacing "YourComputer".
- To exclude multiple computers, use the code below.
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Computer, tblComputers.Domain, tblSoftware.softwareName
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblComputers.Computer <> 'YourComputer' And tblSoftware.softwareName Like
'Microsoft SQL Server%' And tblComputers.Computer <> 'YourComputer' And
tblComputers.Computer <> 'YourComputer'
- If you wish to save this report for future reference, give it a View Name and a Report Name and hit Save. If you wish to access this report through the website, add it to one of your report pages. You can do this in the configuration console under Reports & Alerts/Dashboard.
If you continue having issues, please provide us with some screenshots and a more detailed explanation of what you are trying to do.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-04-2011 08:08 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-01-2011 07:43 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-30-2011 03:19 PM
Srikanth08 wrote:
i will check..but meanwhile is there any way to delete the scrapped systems from lansweeper databse.i have deleted in Active directory..but still showing in lansweeper
You must configure this in your cleanup options. Have a look at the Lansweeper configuration console under Scanning Servers/(Your Server)/Options/Scanning & Cleanup Options. You'll want to enable one of the following options:
Remove computers not found in active directory from all tables.
Set computers to non-active if not found in active directory.
Remove computers disabled in active directory from all tables.
Set computers to non-active if disabled in active directory.
Cleanup actions are performed when the Lansweeper service is started and subsequently every 24 hours. So if you immediately wish to delete the obsolete entries, restart your Lansweeper service.
As for the report, please try the queries below. The previous report was just a basic report to show the principle and used the "Computername" field to identify the computers. What you are asking is to use the "Computer" field.
Exclude just isdpcs3450:
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Computer, tblComputers.Domain, tblSoftware.softwareName
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblComputers.Computer <> 'isdpcs3450' And tblSoftware.softwareName Like
'Microsoft SQL Server%'
Exclude additional computers by replacing "YourComputer":
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Computer, tblComputers.Domain, tblSoftware.softwareName
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblComputers.Computer <> 'isdpcs3450' And tblSoftware.softwareName Like
'Microsoft SQL Server%' And tblComputers.Computer <> 'YourComputer' And
tblComputers.Computer <> 'YourComputer'

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-30-2011 08:04 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-30-2011 07:47 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-29-2011 04:19 PM
You could create a custom SQL Server report that excludes the machines that have SQL Express installed. (But, again, you would have to manually identify these machines and add them to your criteria. Lansweeper cannot know which computers have an Express edition installed.)
Example report that excludes computers 18 and 23:
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblSoftware.softwareName
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblComputers.Computername <> '18' And tblSoftware.softwareName Like
'Microsoft SQL Server%' And tblComputers.Computername <> '23'

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-29-2011 04:01 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-29-2011 03:06 PM
