We've several hundred users. I've started using kix for basic drive / print mapping tasks (and hope to expand on this). However, the @UserID variable doesn't equate to the users' home directory value. i.e John Smith needs a mapping to \\Server\J.Smith$

This is the same for every case. Any help in simplifying this task would be much appreciated.