Filling Active Directory descriptions

At work we have the procedure that every computeraccount has a specific description containing location, pc model, username. People were filling all this info by hand, not really efficient but it sort of worked the first few weeks…ended up with having 1000+ computer accounts having no description at all.
Now the good part, last year we’ve purchased Lansweeper for some reporting on servers within out domains. Now we didn’t setup the filters so we would only scan servers so we now have all servers/desktops/notebooks into a SQL database for Lansweeper. All info we needed for setting the description is in there we just needed to glue it together so here we go.

  • First install Lansweeper and setup scanning
  • Add IP-locations so you can get the fysical address of a device (minor disadvantage that Lansweeper isn’t checking the site a client is in)
  • Copy paste script below and suit for your needs 😉

Example:
Computername: PC01
Description: London – Dell Latitude D630 – Barbara Contoso

Leave a Reply

Your email address will not be published. Required fields are marked *