Evening all,
I have come to inherit a piece of work which – at the moment – entails a massive amount of manual referencing. When one of our servers hits a capacity threshold, it spits out an alert and a Treesize file is generated, detailing the largest files. The only identifier to who owns these files, is the staff number. The current – and extremely manual and time-consuming – process od establishing the owner by name, is to take this staff number and perform either an Advanced search in the GAL, or pulling up the Corporate Directory. In both instances, the staff number (m******) is the alias.
Ideally, I want to get rid of this manual nonsense. In its place, I’d like to have a workbook which took the alias (m******) and automatically referenced the GAL, in order to pull: the First Name, the Last Name and the associated Email address. This would then enable me to connect these fields to a mailmerge, therein making notification a pretty much fully automated process. If I could reach this point, I could also request that server reports are sent to me more frequently, and I’d be able to notify people a lot earlier.
The server report is Excel based: each row represents one file, and the column fields are:
Name | Path | Size | Last Changed | Last Accessed | File Type | Owner
It’s the ‘Owner’ column which contains the m****** alias which I’d like to query against the GAL.
I have done a LOT of research into this, but with mixed success. I managed to find a piece of VBA which did the reverse: if I knew the First Name and Last Name, then it referenced across to the GAL and returned the Alias (m******) But, I need it the other way around! 
Incidentally, that piece of code – although it worked – took about 2mins to query one name. It is querying a large organisations GAL though.
I hope that makes sense? I really would be grateful for any views or advice on how to get this to work – it’s doing my head in! :confused:
If it would help, I can also post the code which works (albeit in reverse)
Thanks in advance…
