Deletion of systems..

[Srikanth08]

Hi,

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..

[Hemoco]

Could you specify more clearly what the exact problem is?

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.

[Srikanth08]

please provide us the reply..

[Srikanth08]

no the system is not going..still it is showing..

[Hemoco]

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'

[Srikanth08]

it is not working..my system no is isdpcs3450..how to exculde that one..kindly send the query using that

[Srikanth08]

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

[Hemoco]

To "delete" those machines from the SQL Server software overview you would either have to uninstall SQL Server from them or delete them from your database altogether, which I don't think you want to do.

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'

[Srikanth08]

its OK..but can we delete those entries?

[Hemoco]

There is no way for Lansweeper to know whether the SQL Server edition is Express or not. This information is not included in the software name and cannot be retrieved from the registry.