Table

EmployeeID Name Type Department Title Office
100001 Hui Gao Employee Executive Team CEO Beijing
100002 Meimei Han Employee HR Department HR Manager Beijing
100003 Tao Lin Employee Finance Department Finance Manager Shanghai
100004 Hua Wei Intern Finance Department Finance Intern Shanghai
100005 Lei Li Employee IT Department IT Manager Beijing
100006 Jim Green Contractor IT Department IT Engineer Shanghai
100007 Lucy King Contractor IT Department IT Engineer Shenzhen
100008 Yi Zhao Employee Engineering Department Principle Engineer Beijing
100009 Er Qian Employee Engineering Department Senior Engineer Shenzhen
100010 San Sun Employee Engineering Department Engineer Shanghai
100011 Si Li Employee Engineering Department Engineer Shenzhen
100012 Wu Zhou Employee Engineering Department Engineer Shanghai
100013 Liu Wu Employee Engineering Department Engineer Shenzhen
100014 Qi Zheng Employee Engineering Department Engineer Beijing
100015 Ba Wang Employee Engineering Department Engineer Beijing

Echarts

PowerShell


Get-ADUser -SearchBase "OU=CorpUser,OU=ROOT,DC=minicontoso,DC=com" -Filter * -Properties * | Select-Object `
EmployeeID,Description,DisplayName,SamAccountName,UserPrincipalName,Department,Title,Office,@{Name='Manager';Expression={$_.Manager.split(",")[0].split("=")[1]}} `
| Format-Table

EmployeeID Description DisplayName SamAccountName UserPrincipalName          Department             Title              Office   Manager
---------- ----------- ----------- -------------- -----------------          ----------             -----              ------   -------
100001     Employee    Hui Gao     Hui.Gao        Hui.Gao@minicontoso.com    Executive Team         CEO                Beijing
100002     Employee    Meimei Han  Meimei.Han     Meimei.Han@minicontoso.com HR Department          HR Manager         Beijing  Hui Gao
100003     Employee    Tao Lin     Tao.Lin        Tao.Lin@minicontoso.com    Finance Department     Finance Manager    Shanghai Hui Gao
100004     Intern      Hua Wei     Hua.Wei        Hua.Wei@minicontoso.com    Finance Department     Finance Intern     Shanghai Tao Lin
100005     Employee    Lei Li      Lei.Li         Lei.Li@minicontoso.com     IT Department          IT Manager         Beijing  Hui Gao
100006     Contractor  Jim Green   Jim.Green      Jim.Green@minicontoso.com  IT Department          IT Engineer        Shanghai Lei Li
100007     Contractor  Lucy King   Lucy.King      Lucy.King@minicontoso.com  IT Department          IT Engineer        Shenzhen Lei Li
100008     Employee    Yi Zhao     Yi.Zhao        Yi.Zhao@minicontoso.com    Engineering Department Principle Engineer Beijing  Hui Gao
100009     Employee    Er Qian     Er.Qian        Er.Qian@minicontoso.com    Engineering Department Senior Engineer    Shenzhen Yi Zhao
100010     Employee    San Sun     San.Sun        San.Sun@minicontoso.com    Engineering Department Engineer           Shanghai Yi Zhao
100011     Employee    Si Li       Si.Li          Si.Li@minicontoso.com      Engineering Department Engineer           Shenzhen Yi Zhao
100012     Employee    Wu Zhou     Wu.Zhou        Wu.Zhou@minicontoso.com    Engineering Department Engineer           Shanghai Yi Zhao
100013     Employee    Liu Wu      Liu.Wu         Liu.Wu@minicontoso.com     Engineering Department Engineer           Shenzhen Yi Zhao
100014     Employee    Qi Zheng    Qi.Zheng       Qi.Zheng@minicontoso.com   Engineering Department Engineer           Beijing  Yi Zhao
100015     Employee    Ba Wang     Ba.Wang        Ba.Wang@minicontoso.com    Engineering Department Engineer           Beijing  Yi Zhao