14
vringar
8y

Okay, so I have to write a script that will get user data from an AD, additional information from an XML, combine those two to get boss user relationship and output that mess into an excel sheet.
Oh, and both sources are ofc completely inconsistent. So I need full error handling on everything.
Aaaaaaand I have to write it in VB script... Using np++... Without plugins...
I hate my life!

Comments
  • 4
    ummm what is the reason?
  • 1
    Otherwise I need to do this for 5000 users manually. I need to contact each user's superior over their usage of some in house services.
  • 4
    Why not PowerShell?
  • 2
    You can store employee manager data in AD and query it direct why the XML
  • 1
    @philcr I have no control over the AD. I have been given an account that is only supposed to run one specific query, which only contains their name, management position and unit.
    But each units boss boss is in the next higher management unit and the naming of units makes so little sense, that I need the relation "unit to next higher unit" mapped for me.
  • 2
    @arcadesdude the original query was given to me in VB script. And as the idiot that I am, I underestimated the task massively. And I have never used any scripting language before, so I had little clue of what I was doing to myself.
    And Power shell isn't part of a standart win 7 installation, so it would at least take 2-3 weeks just for security to allow it. ( Installation would probably happen early march.)
  • 1
  • 2
    @arcadesdude I almost had it working when I left today. 😅 I hope I can finish it up by tomorrow afternoon. Cause if so I can finally get back to my LAMP stack and try to figure out how to set it up properly.
Add Comment