Deleteing old pc'

[d_i_saunders]

We are currenlty roadmapping a large number of pc's.

As each pc is removed form the site we record the tag.

Is there a simple database script that could read in a text file and remove the PC from lansweeper.

Or do I have to manaualy delete 2000+ pcs

how do other people manage roadmapping and decommisioing?

dave

[d_i_saunders]

"computername" is the asset Tag rather than the name?

Our pcs are named


XXYYYTAG

where XX is country

and YYY is the site.

However some people have fat fingures so have wrong tags.

however the Asset tag form Dell will always be correct.

dave

[Hemoco]

You could do it like this:

Create a new table "tbltemp" with one column "computername"

Fill the table with all the computers you want deleted.

Run the query

delete from tblcomputers where computername in (select computername from tbltemp)