<div>
Hi subsun,<br />
<br />
I'm using Windows Server 2008 instead of R2 :-/
</div>


Hi subsun,

I'm using Windows Server 2008 instead of R2 :-/

<div>
Yes i have that QAD installed
</div>


<div>
Thanks for this info. i suppose this was by mistake.<br />
<br />
But anyways would keep in mind this info.
</div>


Thanks for this info. i suppose this was by mistake.

But anyways would keep in mind this info.

<div>
<div class="content wysiwyg-content">
Hi People,<br />
<br />
Can anyone please assist me with the Powershell script which can translate the last column result of my CSV file into DOMAIN\Ussername format ?<br />
<br />
CSV file format:<br />
<br />
UserArchived,Archive ID,PermissionType,SID<br />
Trifosa Hanimex, 1A413D4BD6F740E47BAF2A5E5C<wbr />D1DC11F111<wbr />0000,0,S-1<wbr />-5-21-1659<wbr />004503-287<wbr />218729-180<wbr />1674531-18<wbr />135<br />
Jamela Gunasakira, 1A413D4BD6F740E47BAFAEEE5C<wbr />D1DC11F111<wbr />0000,0,S-1<wbr />-5-21-1659<wbr />004503-282<wbr />458629-180<wbr />1674531-18<wbr />135<br />
.<br />
.<br />
.<br />
Nadya Samira, 1BCDEF4BD6F740E47BAF2A5E5C<wbr />D1DC11F111<wbr />0000,0,S-1<wbr />-5-21-1659<wbr />004503-287<wbr />218729-180<wbr />1932686-18<wbr />135<br />
<br />
Thanks in advance.
</div>
</div>


Hi People,

Can anyone please assist me with the Powershell script which can translate the last column result of my CSV file into DOMAIN\Ussername format ?

CSV file format:

UserArchived,Archive ID,PermissionType,SID
Trifosa Hanimex, 1A413D4BD6F740E47BAF2A5E5CD1DC11F1110000,0,S-1-5-21-1659004503-287218729-1801674531-18135
Jamela Gunasakira, 1A413D4BD6F740E47BAFAEEE5CD1DC11F1110000,0,S-1-5-21-1659004503-282458629-1801674531-18135
.
.
.
Nadya Samira, 1BCDEF4BD6F740E47BAF2A5E5CD1DC11F1110000,0,S-1-5-21-1659004503-287218729-1801932686-18135

Thanks in advance.

Translating AD SID in CSV into DOMAIN\username format ?

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.

Active Directory

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.