Rebuilding PCs

[LithiumKid1976]

hi
we sometimes rebuild our machines here, and as they are all "asset taged" we use the asset tag, as the pc name.

so, how long will it take for lansweeper to see that the pc now has a lot less software installed on it, as its a clean build?


or should we be removing the pc from the database 1st before we start the rebuild?
hope that makes sense.

Damien

[Cobra7]

First save this report as "UUIDcount" or edit the second report.

SELECT COUNT(UUID) AS PCcount, UUID
FROM tblComputerSystemProduct
GROUP BY UUID
HAVING (COUNT(UUID) > 1)

So what the 2nd report will do is pull in the information from the 1st one and add computer names into it.

SELECT 
  tblComputerSystemProduct.Computername,
  web30repUUIDcount.UUID
FROM
  tblComputerSystemProduct
  INNER JOIN web30repUUIDcount ON (tblComputerSystemProduct.UUID = web30repUUIDcount.UUID)
ORDER BY
  web30repUUIDcount.UUID

[NSG]

SELECT COUNT(UUID) AS PCcount, UUID
FROM tblComputerSystemProduct
GROUP BY UUID
HAVING (COUNT(UUID) > 1)

Works, it shows the UUID's but it doesn't show the computer names making deleting them from LanSweeper and AD hard is there any way that that can be added?

[kristoferO]

No I haven't had much time to play with it. I did make this view which was handy for what I needed. Shows only the name, uuid, mac address only if it has an IP address. lol there are probably better ways of doing this though.


CREATE VIEW [dbo].[SuspDupes]
AS
SELECT DISTINCT tblNetwork.Computername, tblComputerSystemProduct.UUID, tblNetwork.MACaddress, tblNetwork.IPAddress
FROM tblNetwork INNER JOIN
tblComputerSystemProduct ON tblNetwork.Computername = tblComputerSystemProduct.Computername
WHERE (NOT (tblNetwork.IPAddress IS NULL)) AND (NOT (tblNetwork.IPAddress = ''))



Edit: this just came to my mind lol simple but it will tell you if you have two systems with the same UUID.

SELECT COUNT(UUID) AS PCcount, UUID
FROM tblComputerSystemProduct
GROUP BY UUID
HAVING (COUNT(UUID) > 1)

[NSG]

Did you get any where whit UUID only?

Because aim trying to achieve the same effect only we have a software driver installed who has the same mac on all computer so all computers show up as duplicate computers. So aim kind of looking for a ServiceTag ore UUID rapport that shows all duplicated tags/id's

My SQL knowledge is very limited creating an rapport to serve my needs is not going to be passable

[kristoferO]

Is the UUID the one from the system board? if it is it's probably the best place to start with finding duplicates. I'm going to play around with it. if I come up with some thing I'll post it here.

SELECT DISTINCT tblComputerSystemProduct.Computername, tblComputerSystemProduct.UUID, tblNetwork.MACaddress
FROM tblComputerSystemProduct LEFT OUTER JOIN
tblNetwork ON tblComputerSystemProduct.Computername = tblNetwork.Computername
ORDER BY tblComputerSystemProduct.UUID, tblNetwork.MACaddress

[Hemoco]

try this for the mac addresses:

SELECT     TOP 100 PERCENT dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblNetwork.MACaddress, dbo.tblNetwork.IPAddress, 
                      dbo.tblNetwork.Lastchanged
FROM         dbo.tblNetwork INNER JOIN
                      dbo.tblComputers ON dbo.tblNetwork.Computername = dbo.tblComputers.Computername
WHERE     (dbo.tblNetwork.MACaddress IN
                          (SELECT     MACaddress
                            FROM          dbo.tblNetwork
                            GROUP BY MACaddress
                            HAVING      (MACaddress <> '') AND (COUNT(NetworkID) > 1)))
ORDER BY dbo.tblNetwork.MACaddress

[trt]

Could you post script for the duplicate report?

[Hemoco]

The "duplicate" report would be possible, but the reconcile would need additional programming.

[kristoferO]

We re-image alot, however the computer names change, and quite frequently... names are based on station location. So when I tried Lan sweeper, I started getting duplicates of computer after the system names were changed, or systems moved or swapped out.

Would there be any way to have lansweeper recognize the name change?