Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dkel22

  1. dkel22

    MAC 10.8 issues connecting to FileShare

    We just randomly came accross an issue that just started. Our MAC 10.8 users cannot modify or write files to a folder shared on a server2012. They get finder error 36. Other MAC users have no problem using the share normally. We didnt find any updates or server changes that would cause the...
  2. dkel22

    DFSR Issues with Preseeding

    I am working on setting up DFSR on a new server. I have preseeded the new server via Robocopy using the following commands Robocopy.exe “\\source server\drive$\folder path” “destination drive\folder path” /b /e /copyall /r:6 /xd dfsrprivate /log:robo.log /tee The Robocopy completes...
  3. dkel22

    Script to ADD user to Group From CSV file

    I am trying to run a script during our user provisioning process to add users to a group based on selected criteria. Here's a code snippet below. I cannot sort out how to actually add the user to the group as the foundobject.ismember appartently doesn't work While Not rs.EOF 'Do nothing but...
  4. dkel22

    Active Directory User Provisioning Scripts

    Awesome thanks so much for the help and the ideas. I am going to use that function as our user processing script currently is 39 scripts deep and I can use it to combine them.
  5. dkel22

    Active Directory User Provisioning Scripts

    Will it also work if I update my While statement as something like below While Not rs.EOF 'Do nothing but iterate since they are already in AD. Set FoundObject = GetObject (rs.Fields(0).Value) If Instr(FoundObject.DistinguishedName,"Terminated Employees") = 1 Then rs.MoveNext userChanged = False
  6. dkel22

    Active Directory User Provisioning Scripts

    Here's the section of code I believe is relevant. I was hoping there's an easy way to build in a OU check during the iterations through the HR file If Instr(StatusEffectiveDateValue,"-") = 1 Then 'Send an error report for this line ElseIf Trim(keyValue) = "" Then 'Skip empty employee...
  7. dkel22

    Active Directory User Provisioning Scripts

    I have a set of vbs AD user provisioning scripts that create, modify, term etc users. I have one script that updates all the user information pulled from an excel HR file. It updates many attributes like description, title, manager and many more. The problem is that it is updating information...
  8. dkel22

    Setup Server for External Access

    OK so assuming I can get a firewall in place. Can I then setup RRAS for external access with only 1 NIC?
  9. dkel22

    Setup Server for External Access

    I am working on setting up a small business for a friend. They have a server 2008 that runs their main application. The server itself only has one NIC. Is it possible anyway with RRAS to setup the server for external access via an external IP address provided by their internet provider? I know...
  10. dkel22

    Possible to pass to LDAP arguments?

    I am creating a script that will create a group based on a user's direct reports. We want to be able to create a group based on direct reports of 2 different users. Is this possible. For example we call the script now as below cscript /nologo processReportsToGroups.vbs...
  11. dkel22

    Powershell SQL sp with Query Results

    It was giving me issues with converting datarow to int32 with both your methods. My workaround, although probably not optimal was [int]$y = $x[0] then calling the SP with $y
  12. dkel22

    VBScript to Take SQL Query Results and Pass to SP

    Where I've gotten so far. I am using the following to try and save the query results as a variable and then pass to the stored procedure. $x = invoke-sqlcmd -query "SELECT ID from zSysUser WHERE HRID = 1111" -database DATABASENAME -serverinstance SERVERNAME This will save the variable...
  13. dkel22

    Powershell SQL sp with Query Results

    Where I've gotten so far. I am using the following to try and save the query results as a variable and then pass to the stored procedure. $x = invoke-sqlcmd -query "SELECT ID from zSysUser WHERE HRID = 1111" -database DATABASENAME -serverinstance SERVERNAME This will save the variable...
  14. dkel22

    VBScript to Take SQL Query Results and Pass to SP

    Your suggestion works great when I am testing in SQL management PWise, thank you very much! I am a novice with scripting and SQL so that is very helpful. Do you happen to have any powershell experience? Ideally I would like to take your suggestion and make a powershell script from it. I am...
  15. dkel22

    ElseIf with Multiple conditionals

    Ok it seems to be working fine with ElseIf (Left(DivisionValue,2) = "X" OR Left(DivisionValue,2) = "Y" ) AND StatusValue = "Active" Then But when I try to run a script to pull everyone else with (per below) it is still grabbing users with division 40 and 41 with everyone else. How do I now...

Part and Inventory Search

Back
Top