AD, powershell and ssis

  • Hi, i have a requirement that involves visiting multiple folders in AD for active, disabled etc computers.   Other attributes  might need to be extracted as well including associated users and locations.   From what im seeing in AD,  at least sometimes the description column here has the user name.  And the folder can be the location.    I can figure all that out later but here is the real question.

    Id like ssis in the picture because i need to integrate info from other sources too, mostly sql.   The report we'll generate from the integrated data is more or less a compliance list showing free space, bitlocker status, OS etc etc.  And with a recorded date from my etl because the boss may want to see how long a machine has been out of compliance.

    is the approach i see on the web and shown below viable?   or do i need to introduce something like powershell as a middleman between ssis and AD?  i followed thru (ado and oledb paths) on what is shown below and ultimately end up with "oledb provider for MS directory services" as what appears to be the closest thing to what im looking for.  i see server or file,  and location being things you need to enter with this type of provider.  And if this is the correct approach i can ask our tech guy what to enter there but i already see the dc server involved and perhaps the location that looks like a domain name.  when i follow thru with this path i am presented with options that require i enter a query, i think sql.   which makes me think im doing this wrong.  this poor guy seems to be (or has) taking it from the pundits  https://community.spiceworks.com/t/sql-query-activedirectory/752746 .

    ADssis

     

    • This topic was modified 3 weeks, 1 day ago by  stan.
  • i see an approach here that leverages the script task but not being that good at .net dont see how it can be limited to a specific domain controller https://learn.microsoft.com/en-us/sql/integration-services/extending-packages-scripting-task-examples/querying-the-active-directory-with-the-script-task?view=sql-server-ver16

    scriptaskforAD

  • this seems to answer the question if that provider mentioned previously is the/a right path...  https://stackoverflow.com/questions/66213672/import-active-directory-to-sql-server   .

     

    • This reply was modified 3 weeks, 1 day ago by  stan.
    • This reply was modified 3 weeks, 1 day ago by  stan.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply