API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 24th, 2019
126
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 107.92 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "cells": [
  3. {
  4. "cell_type": "code",
  5. "execution_count": 1,
  6. "metadata": {},
  7. "outputs": [],
  8. "source": [
  9. "import pandas as pd\n",
  10. "import paramiko\n",
  11. "from getpass import getpass"
  12. ]
  13. },
  14. {
  15. "cell_type": "markdown",
  16. "metadata": {},
  17. "source": [
  18. "## Compare RCN to RSN AD Users\n",
  19. "\n",
  20. "* Performed inner join on RSN to RCN on UnixID field.\n",
  21. "* uid_x and uid_y correspond to rsn and rcn respectively.\n",
  22. "* gid_x and gid_y correspond to rsn and rcn respectively.\n",
  23. "* Some Primary GID's are not correctly migrated; we are seeing that service accounts and `linj21` have improper Primary GID's. Unclear immediately how this was introduced.\n",
  24. "* Concern is around additional 400-500 users having Primary GID / migration issues"
  25. ]
  26. },
  27. {
  28. "cell_type": "code",
  29. "execution_count": 2,
  30. "metadata": {},
  31. "outputs": [],
  32. "source": [
  33. "servers = ['sc1lvrsntst1.sc1.science.roche.com','reswebappdev303.gene.com']"
  34. ]
  35. },
  36. {
  37. "cell_type": "markdown",
  38. "metadata": {},
  39. "source": [
  40. "## Obtain user Raw Data\n",
  41. "\n",
  42. "For each hostname:\n",
  43. "\n",
  44. "1. SSH to the Hostname\n",
  45. "1. Grab the adquery user output\n",
  46. "1. Convert to data format ingestible by Pandas"
  47. ]
  48. },
  49. {
  50. "cell_type": "code",
  51. "execution_count": 3,
  52. "metadata": {},
  53. "outputs": [
  54. {
  55. "name": "stdout",
  56. "output_type": "stream",
  57. "text": [
  58. "········\n"
  59. ]
  60. }
  61. ],
  62. "source": [
  63. "PASSWORD = getpass()"
  64. ]
  65. },
  66. {
  67. "cell_type": "code",
  68. "execution_count": 4,
  69. "metadata": {},
  70. "outputs": [],
  71. "source": [
  72. "def run_command(command, server):\n",
  73. " \"\"\"\n",
  74. " Given a command and server, run command on that server.\n",
  75. " Return output.\n",
  76. " \"\"\"\n",
  77. " client = paramiko.SSHClient()\n",
  78. " client.load_system_host_keys()\n",
  79. " client.set_missing_host_key_policy(paramiko.AutoAddPolicy())\n",
  80. " client.connect(server, username='garveyc1', password=PASSWORD)\n",
  81. " stdin, stdout, stderr = client.exec_command(command)\n",
  82. " return stdout.read().decode()\n",
  83. "\n",
  84. "def adquery_servers(servers:list):\n",
  85. " \"\"\"\n",
  86. " Given a list of servers, return adquery output for each.\n",
  87. " \"\"\"\n",
  88. " return {server: run_command('adquery user', server) for server in servers}\n",
  89. " "
  90. ]
  91. },
  92. {
  93. "cell_type": "code",
  94. "execution_count": 5,
  95. "metadata": {},
  96. "outputs": [],
  97. "source": [
  98. "server_dicts = adquery_servers(servers)"
  99. ]
  100. },
  101. {
  102. "cell_type": "code",
  103. "execution_count": 6,
  104. "metadata": {},
  105. "outputs": [],
  106. "source": [
  107. "def data_frames_from_srv_dicts(server_dicts):\n",
  108. " servers = server_dicts.keys()\n",
  109. " def parsed_output(server):\n",
  110. " return [s.split(':') for s in server_dicts[server].splitlines()]\n",
  111. " return {server: pd.DataFrame(parsed_output(server), columns =['unixID','x','uid','gid','desc', 'homedir','shell']) for server in servers}"
  112. ]
  113. },
  114. {
  115. "cell_type": "code",
  116. "execution_count": 7,
  117. "metadata": {},
  118. "outputs": [],
  119. "source": [
  120. "dfs = data_frames_from_srv_dicts(server_dicts)"
  121. ]
  122. },
  123. {
  124. "cell_type": "code",
  125. "execution_count": 8,
  126. "metadata": {},
  127. "outputs": [
  128. {
  129. "data": {
  130. "text/plain": [
  131. "dict_keys(['sc1lvrsntst1.sc1.science.roche.com', 'reswebappdev303.gene.com'])"
  132. ]
  133. },
  134. "execution_count": 8,
  135. "metadata": {},
  136. "output_type": "execute_result"
  137. }
  138. ],
  139. "source": [
  140. "dfs.keys()"
  141. ]
  142. },
  143. {
  144. "cell_type": "markdown",
  145. "metadata": {},
  146. "source": [
  147. "# Users"
  148. ]
  149. },
  150. {
  151. "cell_type": "code",
  152. "execution_count": 9,
  153. "metadata": {},
  154. "outputs": [],
  155. "source": [
  156. "rcn_adusers = dfs['reswebappdev303.gene.com']\n",
  157. "rsn_adusers = dfs['sc1lvrsntst1.sc1.science.roche.com']"
  158. ]
  159. },
  160. {
  161. "cell_type": "code",
  162. "execution_count": 10,
  163. "metadata": {},
  164. "outputs": [],
  165. "source": [
  166. "c1 = rsn_adusers.set_index('unixID').merge(rcn_adusers, on='unixID', how='inner')"
  167. ]
  168. },
  169. {
  170. "cell_type": "code",
  171. "execution_count": 11,
  172. "metadata": {},
  173. "outputs": [],
  174. "source": [
  175. "# empty list of discrepancy data frames\n",
  176. "discrepant_rows = []"
  177. ]
  178. },
  179. {
  180. "cell_type": "markdown",
  181. "metadata": {},
  182. "source": [
  183. "## Primary GID's that don't match"
  184. ]
  185. },
  186. {
  187. "cell_type": "code",
  188. "execution_count": 12,
  189. "metadata": {},
  190. "outputs": [
  191. {
  192. "data": {
  193. "text/html": [
  194. "<div>\n",
  195. "<style scoped>\n",
  196. " .dataframe tbody tr th:only-of-type {\n",
  197. " vertical-align: middle;\n",
  198. " }\n",
  199. "\n",
  200. " .dataframe tbody tr th {\n",
  201. " vertical-align: top;\n",
  202. " }\n",
  203. "\n",
  204. " .dataframe thead th {\n",
  205. " text-align: right;\n",
  206. " }\n",
  207. "</style>\n",
  208. "<table border=\"1\" class=\"dataframe\">\n",
  209. " <thead>\n",
  210. " <tr style=\"text-align: right;\">\n",
  211. " <th></th>\n",
  212. " <th>unixID</th>\n",
  213. " <th>x_x</th>\n",
  214. " <th>uid_x</th>\n",
  215. " <th>gid_x</th>\n",
  216. " <th>desc_x</th>\n",
  217. " <th>homedir_x</th>\n",
  218. " <th>shell_x</th>\n",
  219. " <th>x_y</th>\n",
  220. " <th>uid_y</th>\n",
  221. " <th>gid_y</th>\n",
  222. " <th>desc_y</th>\n",
  223. " <th>homedir_y</th>\n",
  224. " <th>shell_y</th>\n",
  225. " <th>discrepancies</th>\n",
  226. " </tr>\n",
  227. " </thead>\n",
  228. " <tbody>\n",
  229. " <tr>\n",
  230. " <th>3</th>\n",
  231. " <td>ahujan</td>\n",
  232. " <td>x</td>\n",
  233. " <td>744428</td>\n",
  234. " <td>744428</td>\n",
  235. " <td></td>\n",
  236. " <td>/gne/home/ahujan</td>\n",
  237. " <td>/bin/bash</td>\n",
  238. " <td>x</td>\n",
  239. " <td>744428</td>\n",
  240. " <td>1950</td>\n",
  241. " <td>Nitin Ahuja - Consultant, Arch Eng Ops</td>\n",
  242. " <td>/gne/home/ahujan</td>\n",
  243. " <td>/bin/csh</td>\n",
  244. " <td>ERROR: Primary GIDs do not match</td>\n",
  245. " </tr>\n",
  246. " <tr>\n",
  247. " <th>11</th>\n",
  248. " <td>ana2user</td>\n",
  249. " <td>x</td>\n",
  250. " <td>741783</td>\n",
  251. " <td>741783</td>\n",
  252. " <td>Ana2user, Ssf {MPL~South San Francisco}</td>\n",
  253. " <td>/gne/home/ana2user</td>\n",
  254. " <td>/bin/bash</td>\n",
  255. " <td>x</td>\n",
  256. " <td>741783</td>\n",
  257. " <td>1950</td>\n",
  258. " <td>SSF ana2user - ,</td>\n",
  259. " <td>/gne/home/ana2user</td>\n",
  260. " <td>/bin/bash</td>\n",
  261. " <td>ERROR: Primary GIDs do not match</td>\n",
  262. " </tr>\n",
  263. " <tr>\n",
  264. " <th>33</th>\n",
  265. " <td>bizopsvc</td>\n",
  266. " <td>x</td>\n",
  267. " <td>734127</td>\n",
  268. " <td>734127</td>\n",
  269. " <td>Gred Bizops, South San Francisco {PAC-~South S...</td>\n",
  270. " <td>/gne/home/bizopsvc</td>\n",
  271. " <td>/bin/csh</td>\n",
  272. " <td>x</td>\n",
  273. " <td>734127</td>\n",
  274. " <td>1950</td>\n",
  275. " <td>South San Francisco gRED Bizops - ,</td>\n",
  276. " <td>/gne/home/bizopsvc</td>\n",
  277. " <td>/bin/csh</td>\n",
  278. " <td>ERROR: Primary GIDs do not match</td>\n",
  279. " </tr>\n",
  280. " <tr>\n",
  281. " <th>51</th>\n",
  282. " <td>cdduser</td>\n",
  283. " <td>x</td>\n",
  284. " <td>50359</td>\n",
  285. " <td>50359</td>\n",
  286. " <td>Applications, CDD {Syst~South San Francisco}</td>\n",
  287. " <td>/gne/home/cdduser</td>\n",
  288. " <td>/bin/tcsh</td>\n",
  289. " <td>x</td>\n",
  290. " <td>50359</td>\n",
  291. " <td>2120</td>\n",
  292. " <td>CDD Applications - ,</td>\n",
  293. " <td>/gne/home/cdduser</td>\n",
  294. " <td>/bin/tcsh</td>\n",
  295. " <td>ERROR: Primary GIDs do not match</td>\n",
  296. " </tr>\n",
  297. " <tr>\n",
  298. " <th>52</th>\n",
  299. " <td>cfcddadm</td>\n",
  300. " <td>x</td>\n",
  301. " <td>51691</td>\n",
  302. " <td>51691</td>\n",
  303. " <td>Cddadmin, Centrify {Arch~South San Francisco}</td>\n",
  304. " <td>/gne/home/cddadmin</td>\n",
  305. " <td>/bin/bash</td>\n",
  306. " <td>x</td>\n",
  307. " <td>737982</td>\n",
  308. " <td>1950</td>\n",
  309. " <td>CENTRIFY CDDADMIN - ,</td>\n",
  310. " <td>/gne/home/cfcddadm</td>\n",
  311. " <td>/bin/csh</td>\n",
  312. " <td>ERROR: Primary GIDs do not match</td>\n",
  313. " </tr>\n",
  314. " <tr>\n",
  315. " <th>53</th>\n",
  316. " <td>cfmedche</td>\n",
  317. " <td>x</td>\n",
  318. " <td>23898</td>\n",
  319. " <td>23898</td>\n",
  320. " <td>Medchem, Centrify {Arch~South San Francisco}</td>\n",
  321. " <td>/gne/home/medchem</td>\n",
  322. " <td>/bin/tcsh</td>\n",
  323. " <td>x</td>\n",
  324. " <td>738107</td>\n",
  325. " <td>1950</td>\n",
  326. " <td>CENTRIFY MEDCHEM - ,</td>\n",
  327. " <td>/gne/home/cfmedche</td>\n",
  328. " <td>/bin/csh</td>\n",
  329. " <td>ERROR: Primary GIDs do not match</td>\n",
  330. " </tr>\n",
  331. " <tr>\n",
  332. " <th>54</th>\n",
  333. " <td>cfresabg</td>\n",
  334. " <td>x</td>\n",
  335. " <td>723407</td>\n",
  336. " <td>723407</td>\n",
  337. " <td>Resabgen, South San Francisco {GLOB~South San ...</td>\n",
  338. " <td>/gne/home/resabgen</td>\n",
  339. " <td>/bin/bash</td>\n",
  340. " <td>x</td>\n",
  341. " <td>740470</td>\n",
  342. " <td>1950</td>\n",
  343. " <td>South San Francisco Resabgen - ,</td>\n",
  344. " <td>/gne/home/cfresabg</td>\n",
  345. " <td>/bin/csh</td>\n",
  346. " <td>ERROR: Primary GIDs do not match</td>\n",
  347. " </tr>\n",
  348. " <tr>\n",
  349. " <th>55</th>\n",
  350. " <td>cfresgpa</td>\n",
  351. " <td>x</td>\n",
  352. " <td>713703</td>\n",
  353. " <td>713703</td>\n",
  354. " <td>Resgpan, Centrify {Arch~South San Francisco}</td>\n",
  355. " <td>/gne/home/resgpan</td>\n",
  356. " <td>/bin/csh</td>\n",
  357. " <td>x</td>\n",
  358. " <td>738030</td>\n",
  359. " <td>1950</td>\n",
  360. " <td>CENTRIFY RESGPAN - ,</td>\n",
  361. " <td>/gne/home/cfresgpa</td>\n",
  362. " <td>/bin/csh</td>\n",
  363. " <td>ERROR: Primary GIDs do not match</td>\n",
  364. " </tr>\n",
  365. " <tr>\n",
  366. " <th>56</th>\n",
  367. " <td>cfresgra</td>\n",
  368. " <td>x</td>\n",
  369. " <td>717435</td>\n",
  370. " <td>717435</td>\n",
  371. " <td>Resgran, Centrify {Arch~South San Francisco}</td>\n",
  372. " <td>/gne/home/resgran</td>\n",
  373. " <td>/bin/bash</td>\n",
  374. " <td>x</td>\n",
  375. " <td>738028</td>\n",
  376. " <td>1950</td>\n",
  377. " <td>CENTRIFY RESGRAN - ,</td>\n",
  378. " <td>/gne/home/cfresgra</td>\n",
  379. " <td>/bin/csh</td>\n",
  380. " <td>ERROR: Primary GIDs do not match</td>\n",
  381. " </tr>\n",
  382. " <tr>\n",
  383. " <th>57</th>\n",
  384. " <td>cfrespli</td>\n",
  385. " <td>x</td>\n",
  386. " <td>716507</td>\n",
  387. " <td>716507</td>\n",
  388. " <td>Resplims, South San Francisco {GLOB~South San ...</td>\n",
  389. " <td>/gne/home/resplims</td>\n",
  390. " <td>/bin/bash</td>\n",
  391. " <td>x</td>\n",
  392. " <td>740478</td>\n",
  393. " <td>1950</td>\n",
  394. " <td>South San Francisco resplims - ,</td>\n",
  395. " <td>/gne/home/cfrespli</td>\n",
  396. " <td>/bin/csh</td>\n",
  397. " <td>ERROR: Primary GIDs do not match</td>\n",
  398. " </tr>\n",
  399. " <tr>\n",
  400. " <th>58</th>\n",
  401. " <td>cfresseq</td>\n",
  402. " <td>x</td>\n",
  403. " <td>718180</td>\n",
  404. " <td>718180</td>\n",
  405. " <td>Resseqwb, South San Francisco {GLOB~South San ...</td>\n",
  406. " <td>/gne/home/resseqwb</td>\n",
  407. " <td>/bin/bash</td>\n",
  408. " <td>x</td>\n",
  409. " <td>740467</td>\n",
  410. " <td>1950</td>\n",
  411. " <td>South San Francisco Resseqwb - ,</td>\n",
  412. " <td>/gne/home/cfresseq</td>\n",
  413. " <td>/bin/csh</td>\n",
  414. " <td>ERROR: Primary GIDs do not match</td>\n",
  415. " </tr>\n",
  416. " <tr>\n",
  417. " <th>59</th>\n",
  418. " <td>cfrestcg</td>\n",
  419. " <td>x</td>\n",
  420. " <td>719615</td>\n",
  421. " <td>719615</td>\n",
  422. " <td>Restcga, South San Francisco {GLOB~South San F...</td>\n",
  423. " <td>/gne/home/restcga</td>\n",
  424. " <td>/bin/bash</td>\n",
  425. " <td>x</td>\n",
  426. " <td>740486</td>\n",
  427. " <td>1950</td>\n",
  428. " <td>South San Francisco Restcga - ,</td>\n",
  429. " <td>/gne/home/cfrestcg</td>\n",
  430. " <td>/bin/csh</td>\n",
  431. " <td>ERROR: Primary GIDs do not match</td>\n",
  432. " </tr>\n",
  433. " <tr>\n",
  434. " <th>60</th>\n",
  435. " <td>cfsmdius</td>\n",
  436. " <td>x</td>\n",
  437. " <td>26040</td>\n",
  438. " <td>26040</td>\n",
  439. " <td>Smdiuser, Centrify {Arch~South San Francisco}</td>\n",
  440. " <td>/gne/home/smdiuser</td>\n",
  441. " <td>/bin/bash</td>\n",
  442. " <td>x</td>\n",
  443. " <td>737971</td>\n",
  444. " <td>1950</td>\n",
  445. " <td>CENTRIFY SMDIUSER - ,</td>\n",
  446. " <td>/gne/home/cfsmdius</td>\n",
  447. " <td>/bin/csh</td>\n",
  448. " <td>ERROR: Primary GIDs do not match</td>\n",
  449. " </tr>\n",
  450. " <tr>\n",
  451. " <th>73</th>\n",
  452. " <td>compbio</td>\n",
  453. " <td>x</td>\n",
  454. " <td>17325</td>\n",
  455. " <td>17325</td>\n",
  456. " <td>bio, comp {Syst~South San Francisco}</td>\n",
  457. " <td>/gne/home/compbio</td>\n",
  458. " <td>/bin/bash</td>\n",
  459. " <td>x</td>\n",
  460. " <td>17325</td>\n",
  461. " <td>2058</td>\n",
  462. " <td>comp bio - application,Bioinfo, - application,...</td>\n",
  463. " <td>/gne/home/compbio</td>\n",
  464. " <td>/bin/bash</td>\n",
  465. " <td>ERROR: Primary GIDs do not match</td>\n",
  466. " </tr>\n",
  467. " <tr>\n",
  468. " <th>74</th>\n",
  469. " <td>compsci</td>\n",
  470. " <td>x</td>\n",
  471. " <td>728726</td>\n",
  472. " <td>728726</td>\n",
  473. " <td>Comp Genetics Acct, Ssf Gred Bcb {Arch~South S...</td>\n",
  474. " <td>/gne/home/compsci</td>\n",
  475. " <td>/bin/bash</td>\n",
  476. " <td>x</td>\n",
  477. " <td>728726</td>\n",
  478. " <td>2343</td>\n",
  479. " <td>SSF gRED bCB Comp Genetics acct - ,</td>\n",
  480. " <td>/gne/home/compsci</td>\n",
  481. " <td>/bin/bash</td>\n",
  482. " <td>ERROR: Primary GIDs do not match</td>\n",
  483. " </tr>\n",
  484. " <tr>\n",
  485. " <th>78</th>\n",
  486. " <td>cryouser</td>\n",
  487. " <td>x</td>\n",
  488. " <td>744090</td>\n",
  489. " <td>744090</td>\n",
  490. " <td>South San Francisco, Cryo-em User {Bioi~South ...</td>\n",
  491. " <td>/gne/home/cryouser</td>\n",
  492. " <td>/bin/csh</td>\n",
  493. " <td>x</td>\n",
  494. " <td>744090</td>\n",
  495. " <td>20599</td>\n",
  496. " <td>Cryo-EM user South San Francisco - ,</td>\n",
  497. " <td>/gne/home/cryouser</td>\n",
  498. " <td>/bin/csh</td>\n",
  499. " <td>ERROR: Primary GIDs do not match</td>\n",
  500. " </tr>\n",
  501. " <tr>\n",
  502. " <th>98</th>\n",
  503. " <td>ddgtest</td>\n",
  504. " <td>x</td>\n",
  505. " <td>27247</td>\n",
  506. " <td>27247</td>\n",
  507. " <td>Garrett, Doug {Syst~South San Francisco}</td>\n",
  508. " <td>/gne/home/ddgtest</td>\n",
  509. " <td>/bin/bash</td>\n",
  510. " <td>x</td>\n",
  511. " <td>27247</td>\n",
  512. " <td>1279</td>\n",
  513. " <td>Doug Test Garrett - Test, ,</td>\n",
  514. " <td>/gne/home/ddgtest</td>\n",
  515. " <td>/bin/bash</td>\n",
  516. " <td>ERROR: Primary GIDs do not match</td>\n",
  517. " </tr>\n",
  518. " <tr>\n",
  519. " <th>102</th>\n",
  520. " <td>divossrv</td>\n",
  521. " <td>x</td>\n",
  522. " <td>739372</td>\n",
  523. " <td>739372</td>\n",
  524. " <td>Divos Rserve, South San Francisco {Bioi~South ...</td>\n",
  525. " <td>/gne/home/divossrv</td>\n",
  526. " <td>/bin/bash</td>\n",
  527. " <td>x</td>\n",
  528. " <td>739372</td>\n",
  529. " <td>20582</td>\n",
  530. " <td>South San Francisco divos Rserve - ,</td>\n",
  531. " <td>/gne/home/divossrv</td>\n",
  532. " <td>/bin/bash</td>\n",
  533. " <td>ERROR: Primary GIDs do not match</td>\n",
  534. " </tr>\n",
  535. " <tr>\n",
  536. " <th>121</th>\n",
  537. " <td>ferrie1</td>\n",
  538. " <td>x</td>\n",
  539. " <td>737372</td>\n",
  540. " <td>737372</td>\n",
  541. " <td>Elena Ferri - Regular, Med Chemistry</td>\n",
  542. " <td>/gne/home/ferrie1</td>\n",
  543. " <td>/bin/bash</td>\n",
  544. " <td>x</td>\n",
  545. " <td>737372</td>\n",
  546. " <td>1950</td>\n",
  547. " <td>Elena Ferri - Regular, Med Chemistry</td>\n",
  548. " <td>/gne/home/ferrie1</td>\n",
  549. " <td>/bin/bash</td>\n",
  550. " <td>ERROR: Primary GIDs do not match</td>\n",
  551. " </tr>\n",
  552. " <tr>\n",
  553. " <th>127</th>\n",
  554. " <td>forte</td>\n",
  555. " <td>x</td>\n",
  556. " <td>10001</td>\n",
  557. " <td>10001</td>\n",
  558. " <td>Belforte, Heidi {MNHS~South San Francisco}</td>\n",
  559. " <td>/vqa/QA/belforte</td>\n",
  560. " <td>/bin/csh</td>\n",
  561. " <td>x</td>\n",
  562. " <td>10001</td>\n",
  563. " <td>140</td>\n",
  564. " <td>Forte Application Account,Kathryn Chan,53078</td>\n",
  565. " <td>/opt/forte</td>\n",
  566. " <td>/bin/csh</td>\n",
  567. " <td>ERROR: Primary GIDs do not match</td>\n",
  568. " </tr>\n",
  569. " <tr>\n",
  570. " <th>130</th>\n",
  571. " <td>gSage</td>\n",
  572. " <td>x</td>\n",
  573. " <td>12835</td>\n",
  574. " <td>12835</td>\n",
  575. " <td>WebLogic, Geneland {ATP~South San Francisco}</td>\n",
  576. " <td>/gne/home/gSage</td>\n",
  577. " <td>/bin/csh</td>\n",
  578. " <td>x</td>\n",
  579. " <td>12835</td>\n",
  580. " <td>140</td>\n",
  581. " <td>Geneland WebLogic Account - application,Bioinf...</td>\n",
  582. " <td>/gne/home/gSage</td>\n",
  583. " <td>/bin/csh</td>\n",
  584. " <td>ERROR: Primary GIDs do not match</td>\n",
  585. " </tr>\n",
  586. " <tr>\n",
  587. " <th>131</th>\n",
  588. " <td>galngs</td>\n",
  589. " <td>x</td>\n",
  590. " <td>748617</td>\n",
  591. " <td>748617</td>\n",
  592. " <td>Dixon Galion Svcacct, South San Francisco {Gen...</td>\n",
  593. " <td>/gne/home/galngs</td>\n",
  594. " <td>/bin/csh</td>\n",
  595. " <td>x</td>\n",
  596. " <td>748617</td>\n",
  597. " <td>1950</td>\n",
  598. " <td>South San Francisco dixon galion svcacct - ,</td>\n",
  599. " <td>/gne/home/galngs</td>\n",
  600. " <td>/bin/bash</td>\n",
  601. " <td>ERROR: Primary GIDs do not match</td>\n",
  602. " </tr>\n",
  603. " <tr>\n",
  604. " <th>136</th>\n",
  605. " <td>germline</td>\n",
  606. " <td>x</td>\n",
  607. " <td>746696</td>\n",
  608. " <td>746696</td>\n",
  609. " <td>Germline, South San Francisco {Bioi~South San ...</td>\n",
  610. " <td>/gne/home/germline</td>\n",
  611. " <td>/bin/bash</td>\n",
  612. " <td>x</td>\n",
  613. " <td>746696</td>\n",
  614. " <td>2383</td>\n",
  615. " <td>South San Francisco Germline - ,</td>\n",
  616. " <td>/gne/home/germline</td>\n",
  617. " <td>/bin/bash</td>\n",
  618. " <td>ERROR: Primary GIDs do not match</td>\n",
  619. " </tr>\n",
  620. " <tr>\n",
  621. " <th>144</th>\n",
  622. " <td>gpsadm</td>\n",
  623. " <td>x</td>\n",
  624. " <td>715231</td>\n",
  625. " <td>715231</td>\n",
  626. " <td>Gpspdust, Gpsadm {Syst~South San Francisco}</td>\n",
  627. " <td>/gne/home/gpsadm</td>\n",
  628. " <td>/bin/bash</td>\n",
  629. " <td>x</td>\n",
  630. " <td>715231</td>\n",
  631. " <td>1</td>\n",
  632. " <td>Gpspdust, Gpsadm {Syst~South San Francisco}</td>\n",
  633. " <td>/gne/home/gpsadm</td>\n",
  634. " <td>/bin/bash</td>\n",
  635. " <td>ERROR: Primary GIDs do not match</td>\n",
  636. " </tr>\n",
  637. " <tr>\n",
  638. " <th>148</th>\n",
  639. " <td>gredbee</td>\n",
  640. " <td>x</td>\n",
  641. " <td>742683</td>\n",
  642. " <td>742683</td>\n",
  643. " <td>Bee Stack For Gred, South San Francisco {Bioi~...</td>\n",
  644. " <td>/gne/home/gredbee</td>\n",
  645. " <td>/bin/csh</td>\n",
  646. " <td>x</td>\n",
  647. " <td>742683</td>\n",
  648. " <td>1950</td>\n",
  649. " <td>South San Francisco Bee Stack for gRED - ,</td>\n",
  650. " <td>/gne/home/gredbee</td>\n",
  651. " <td>/bin/csh</td>\n",
  652. " <td>ERROR: Primary GIDs do not match</td>\n",
  653. " </tr>\n",
  654. " <tr>\n",
  655. " <th>149</th>\n",
  656. " <td>gredenv</td>\n",
  657. " <td>x</td>\n",
  658. " <td>723141</td>\n",
  659. " <td>723141</td>\n",
  660. " <td>Admin Sysaccount, Gred Environment {gRED~South...</td>\n",
  661. " <td>/gne/home/gredenv</td>\n",
  662. " <td>/bin/bash</td>\n",
  663. " <td>x</td>\n",
  664. " <td>723141</td>\n",
  665. " <td>20581</td>\n",
  666. " <td>gRED Environment Admin SysAccount - ,</td>\n",
  667. " <td>/gne/home/gredenv</td>\n",
  668. " <td>/bin/bash</td>\n",
  669. " <td>ERROR: Primary GIDs do not match</td>\n",
  670. " </tr>\n",
  671. " <tr>\n",
  672. " <th>150</th>\n",
  673. " <td>gredflow</td>\n",
  674. " <td>x</td>\n",
  675. " <td>726836</td>\n",
  676. " <td>726836</td>\n",
  677. " <td>Appaccount Devsci, Gredflow Partek Flow {gRED~...</td>\n",
  678. " <td>/gne/home/gredflow</td>\n",
  679. " <td>/bin/csh</td>\n",
  680. " <td>x</td>\n",
  681. " <td>726836</td>\n",
  682. " <td>1950</td>\n",
  683. " <td>gredflow Partek Flow AppAccount DevSci - ,</td>\n",
  684. " <td>/gne/home/gredflow</td>\n",
  685. " <td>/bin/csh</td>\n",
  686. " <td>ERROR: Primary GIDs do not match</td>\n",
  687. " </tr>\n",
  688. " <tr>\n",
  689. " <th>151</th>\n",
  690. " <td>gredsolr</td>\n",
  691. " <td>x</td>\n",
  692. " <td>716188</td>\n",
  693. " <td>716188</td>\n",
  694. " <td>Punh Bzuffi Slaton, Gred Solr Search {gRED~Sou...</td>\n",
  695. " <td>/gne/home/gredsolr</td>\n",
  696. " <td>/bin/bash</td>\n",
  697. " <td>x</td>\n",
  698. " <td>716188</td>\n",
  699. " <td>562</td>\n",
  700. " <td>gRED Solr search app act - punh, bzuffi, josepsli</td>\n",
  701. " <td>/gne/home/gredsolr</td>\n",
  702. " <td>/bin/bash</td>\n",
  703. " <td>ERROR: Primary GIDs do not match</td>\n",
  704. " </tr>\n",
  705. " <tr>\n",
  706. " <th>152</th>\n",
  707. " <td>gredstor</td>\n",
  708. " <td>x</td>\n",
  709. " <td>739147</td>\n",
  710. " <td>739147</td>\n",
  711. " <td>Gred It Storage Admi, South San Francisco {gRE...</td>\n",
  712. " <td>/gne/home/gredstor</td>\n",
  713. " <td>/bin/bash</td>\n",
  714. " <td>x</td>\n",
  715. " <td>739147</td>\n",
  716. " <td>2377</td>\n",
  717. " <td>South San Francisco gRED IT storage admi - ,</td>\n",
  718. " <td>/gne/home/gredstor</td>\n",
  719. " <td>/bin/bash</td>\n",
  720. " <td>ERROR: Primary GIDs do not match</td>\n",
  721. " </tr>\n",
  722. " <tr>\n",
  723. " <th>153</th>\n",
  724. " <td>gredsys</td>\n",
  725. " <td>x</td>\n",
  726. " <td>739146</td>\n",
  727. " <td>739146</td>\n",
  728. " <td>Gred It Sysadmin Acc, South San Francisco {gRE...</td>\n",
  729. " <td>/gne/home/gredsys</td>\n",
  730. " <td>/bin/bash</td>\n",
  731. " <td>x</td>\n",
  732. " <td>739146</td>\n",
  733. " <td>2376</td>\n",
  734. " <td>South San Francisco gRED IT sysadmin acc - ,</td>\n",
  735. " <td>/gne/home/gredsys</td>\n",
  736. " <td>/bin/bash</td>\n",
  737. " <td>ERROR: Primary GIDs do not match</td>\n",
  738. " </tr>\n",
  739. " <tr>\n",
  740. " <th>...</th>\n",
  741. " <td>...</td>\n",
  742. " <td>...</td>\n",
  743. " <td>...</td>\n",
  744. " <td>...</td>\n",
  745. " <td>...</td>\n",
  746. " <td>...</td>\n",
  747. " <td>...</td>\n",
  748. " <td>...</td>\n",
  749. " <td>...</td>\n",
  750. " <td>...</td>\n",
  751. " <td>...</td>\n",
  752. " <td>...</td>\n",
  753. " <td>...</td>\n",
  754. " <td>...</td>\n",
  755. " </tr>\n",
  756. " <tr>\n",
  757. " <th>369</th>\n",
  758. " <td>reslab01</td>\n",
  759. " <td>x</td>\n",
  760. " <td>35060</td>\n",
  761. " <td>35060</td>\n",
  762. " <td>Labshare, Research {ATP~South San Francisco}</td>\n",
  763. " <td>/gne/home/reslab01</td>\n",
  764. " <td>/bin/csh</td>\n",
  765. " <td>x</td>\n",
  766. " <td>35060</td>\n",
  767. " <td>205</td>\n",
  768. " <td>Research Labshare - Application,</td>\n",
  769. " <td>/gne/home/reslab01</td>\n",
  770. " <td>/bin/csh</td>\n",
  771. " <td>ERROR: Primary GIDs do not match</td>\n",
  772. " </tr>\n",
  773. " <tr>\n",
  774. " <th>370</th>\n",
  775. " <td>resmedch</td>\n",
  776. " <td>x</td>\n",
  777. " <td>722103</td>\n",
  778. " <td>722103</td>\n",
  779. " <td>Gred Cdd, Medchemica Appaccoun {gRED~South San...</td>\n",
  780. " <td>/gne/home/resmedch</td>\n",
  781. " <td>/bin/bash</td>\n",
  782. " <td>x</td>\n",
  783. " <td>722103</td>\n",
  784. " <td>2120</td>\n",
  785. " <td>MedChemica AppAccoun gRED CDD - ,</td>\n",
  786. " <td>/gne/home/resmedch</td>\n",
  787. " <td>/bin/bash</td>\n",
  788. " <td>ERROR: Primary GIDs do not match</td>\n",
  789. " </tr>\n",
  790. " <tr>\n",
  791. " <th>371</th>\n",
  792. " <td>resncode</td>\n",
  793. " <td>x</td>\n",
  794. " <td>735927</td>\n",
  795. " <td>735927</td>\n",
  796. " <td>Wuxi Nextcode Applic, Ssf {gRED~South San Fran...</td>\n",
  797. " <td>/gne/home/resncode</td>\n",
  798. " <td>/bin/bash</td>\n",
  799. " <td>x</td>\n",
  800. " <td>735927</td>\n",
  801. " <td>1950</td>\n",
  802. " <td>SSF WuXi NextCODE Applic - ,</td>\n",
  803. " <td>/gne/home/resncode</td>\n",
  804. " <td>/bin/bash</td>\n",
  805. " <td>ERROR: Primary GIDs do not match</td>\n",
  806. " </tr>\n",
  807. " <tr>\n",
  808. " <th>372</th>\n",
  809. " <td>resseq</td>\n",
  810. " <td>x</td>\n",
  811. " <td>52230</td>\n",
  812. " <td>52230</td>\n",
  813. " <td>Sysacct, Research Sequencing {Bioi~South San F...</td>\n",
  814. " <td>/gne/home/resseq</td>\n",
  815. " <td>/bin/bash</td>\n",
  816. " <td>x</td>\n",
  817. " <td>52230</td>\n",
  818. " <td>2060</td>\n",
  819. " <td>Research Sequencing Sysacct - ,</td>\n",
  820. " <td>/gne/home/resseq</td>\n",
  821. " <td>/bin/bash</td>\n",
  822. " <td>ERROR: Primary GIDs do not match</td>\n",
  823. " </tr>\n",
  824. " <tr>\n",
  825. " <th>373</th>\n",
  826. " <td>ressuper</td>\n",
  827. " <td>x</td>\n",
  828. " <td>729642</td>\n",
  829. " <td>729642</td>\n",
  830. " <td>Appaccount - Gred, Ressuper {Bioi~South San Fr...</td>\n",
  831. " <td>/gne/home/ressuper</td>\n",
  832. " <td>/bin/bash</td>\n",
  833. " <td>x</td>\n",
  834. " <td>729642</td>\n",
  835. " <td>2349</td>\n",
  836. " <td>ressuper AppAccount - gRED - ,</td>\n",
  837. " <td>/gne/home/ressuper</td>\n",
  838. " <td>/bin/bash</td>\n",
  839. " <td>ERROR: Primary GIDs do not match</td>\n",
  840. " </tr>\n",
  841. " <tr>\n",
  842. " <th>374</th>\n",
  843. " <td>restapir</td>\n",
  844. " <td>x</td>\n",
  845. " <td>734498</td>\n",
  846. " <td>734498</td>\n",
  847. " <td>Gred Tapir Project, South San Francisco {Bioi~...</td>\n",
  848. " <td>/gne/home/restapir</td>\n",
  849. " <td>/bin/bash</td>\n",
  850. " <td>x</td>\n",
  851. " <td>734498</td>\n",
  852. " <td>2369</td>\n",
  853. " <td>South San Francisco gRED Tapir Project - ,</td>\n",
  854. " <td>/gne/home/restapir</td>\n",
  855. " <td>/bin/bash</td>\n",
  856. " <td>ERROR: Primary GIDs do not match</td>\n",
  857. " </tr>\n",
  858. " <tr>\n",
  859. " <th>375</th>\n",
  860. " <td>restibco</td>\n",
  861. " <td>x</td>\n",
  862. " <td>716642</td>\n",
  863. " <td>716642</td>\n",
  864. " <td>Appacct - Jlfitz, Restibco {Bioi~South San Fra...</td>\n",
  865. " <td>/gne/home/restibco</td>\n",
  866. " <td>/bin/bash</td>\n",
  867. " <td>x</td>\n",
  868. " <td>716642</td>\n",
  869. " <td>2255</td>\n",
  870. " <td>restibco AppAcct - jlfitz - ,</td>\n",
  871. " <td>/gne/home/restibco</td>\n",
  872. " <td>/bin/bash</td>\n",
  873. " <td>ERROR: Primary GIDs do not match</td>\n",
  874. " </tr>\n",
  875. " <tr>\n",
  876. " <th>376</th>\n",
  877. " <td>restst1</td>\n",
  878. " <td>x</td>\n",
  879. " <td>713581</td>\n",
  880. " <td>713581</td>\n",
  881. " <td>Test 1 - Josepsli, Rescomp {Syst~South San Fra...</td>\n",
  882. " <td>/gne/home/restst1</td>\n",
  883. " <td>/bin/bash</td>\n",
  884. " <td>x</td>\n",
  885. " <td>713581</td>\n",
  886. " <td>1950</td>\n",
  887. " <td>Rescomp Test 1 - josepsli - ,</td>\n",
  888. " <td>/gne/home/restst1</td>\n",
  889. " <td>/bin/bash</td>\n",
  890. " <td>ERROR: Primary GIDs do not match</td>\n",
  891. " </tr>\n",
  892. " <tr>\n",
  893. " <th>377</th>\n",
  894. " <td>restst2</td>\n",
  895. " <td>x</td>\n",
  896. " <td>713582</td>\n",
  897. " <td>713582</td>\n",
  898. " <td>Test 2 - Josepsli, Rescomp {Syst~South San Fra...</td>\n",
  899. " <td>/gne/home/restst2</td>\n",
  900. " <td>/bin/bash</td>\n",
  901. " <td>x</td>\n",
  902. " <td>713582</td>\n",
  903. " <td>1950</td>\n",
  904. " <td>Rescomp Test 2 - josepsli - ,</td>\n",
  905. " <td>/gne/home/restst2</td>\n",
  906. " <td>/bin/bash</td>\n",
  907. " <td>ERROR: Primary GIDs do not match</td>\n",
  908. " </tr>\n",
  909. " <tr>\n",
  910. " <th>378</th>\n",
  911. " <td>restst3</td>\n",
  912. " <td>x</td>\n",
  913. " <td>713583</td>\n",
  914. " <td>713583</td>\n",
  915. " <td>Test 3 - Josepsli, Rescomp {Syst~South San Fra...</td>\n",
  916. " <td>/gne/home/restst3</td>\n",
  917. " <td>/bin/tcsh</td>\n",
  918. " <td>x</td>\n",
  919. " <td>713583</td>\n",
  920. " <td>1950</td>\n",
  921. " <td>Rescomp Test 3 - josepsli - ,</td>\n",
  922. " <td>/gne/home/restst3</td>\n",
  923. " <td>/bin/tcsh</td>\n",
  924. " <td>ERROR: Primary GIDs do not match</td>\n",
  925. " </tr>\n",
  926. " <tr>\n",
  927. " <th>379</th>\n",
  928. " <td>restst4</td>\n",
  929. " <td>x</td>\n",
  930. " <td>713580</td>\n",
  931. " <td>713580</td>\n",
  932. " <td>Test 4 - Josepsli, Rescomp {Syst~South San Fra...</td>\n",
  933. " <td>/gne/home/restst4</td>\n",
  934. " <td>/bin/tcsh</td>\n",
  935. " <td>x</td>\n",
  936. " <td>713580</td>\n",
  937. " <td>1950</td>\n",
  938. " <td>Rescomp Test 4 - josepsli - ,</td>\n",
  939. " <td>/gne/home/restst4</td>\n",
  940. " <td>/bin/tcsh</td>\n",
  941. " <td>ERROR: Primary GIDs do not match</td>\n",
  942. " </tr>\n",
  943. " <tr>\n",
  944. " <th>383</th>\n",
  945. " <td>roboauto</td>\n",
  946. " <td>x</td>\n",
  947. " <td>746895</td>\n",
  948. " <td>746895</td>\n",
  949. " <td>Roboauto, South San Francisco {Bioi~South San ...</td>\n",
  950. " <td>/gne/home/roboauto</td>\n",
  951. " <td>/bin/bash</td>\n",
  952. " <td>x</td>\n",
  953. " <td>746895</td>\n",
  954. " <td>2384</td>\n",
  955. " <td>South San Francisco ROBOAUTO - ,</td>\n",
  956. " <td>/gne/home/roboauto</td>\n",
  957. " <td>/bin/bash</td>\n",
  958. " <td>ERROR: Primary GIDs do not match</td>\n",
  959. " </tr>\n",
  960. " <tr>\n",
  961. " <th>390</th>\n",
  962. " <td>sched</td>\n",
  963. " <td>x</td>\n",
  964. " <td>27518</td>\n",
  965. " <td>27518</td>\n",
  966. " <td>Scheduler, Map {Syst~South San Francisco}</td>\n",
  967. " <td>/gne/home/sched</td>\n",
  968. " <td>/usr/bin/bash</td>\n",
  969. " <td>x</td>\n",
  970. " <td>27518</td>\n",
  971. " <td>1326</td>\n",
  972. " <td>Map Scheduler - application,Application Account,</td>\n",
  973. " <td>/gne/home/sched</td>\n",
  974. " <td>/usr/bin/bash</td>\n",
  975. " <td>ERROR: Primary GIDs do not match</td>\n",
  976. " </tr>\n",
  977. " <tr>\n",
  978. " <th>399</th>\n",
  979. " <td>seurat</td>\n",
  980. " <td>x</td>\n",
  981. " <td>51956</td>\n",
  982. " <td>51956</td>\n",
  983. " <td>Seurat, Research {ATP~South San Francisco}</td>\n",
  984. " <td>/gne/home/seurat</td>\n",
  985. " <td>/bin/csh</td>\n",
  986. " <td>x</td>\n",
  987. " <td>51956</td>\n",
  988. " <td>1011</td>\n",
  989. " <td>Seurat research application-ryantw,benjamds,ac...</td>\n",
  990. " <td>/gne/home/seurat</td>\n",
  991. " <td>/bin/csh</td>\n",
  992. " <td>ERROR: Primary GIDs do not match</td>\n",
  993. " </tr>\n",
  994. " <tr>\n",
  995. " <th>405</th>\n",
  996. " <td>shivaswn</td>\n",
  997. " <td>x</td>\n",
  998. " <td>744573</td>\n",
  999. " <td>52</td>\n",
  1000. " <td>Niranajn - Internal account</td>\n",
  1001. " <td>/gne/home/shivaswn</td>\n",
  1002. " <td>/bin/bash</td>\n",
  1003. " <td>x</td>\n",
  1004. " <td>744573</td>\n",
  1005. " <td>1950</td>\n",
  1006. " <td>Niranjan Shivaswamy - Consultant, Arch Eng Ops</td>\n",
  1007. " <td>/gne/home/shivaswn</td>\n",
  1008. " <td>/bin/csh</td>\n",
  1009. " <td>ERROR: Primary GIDs do not match</td>\n",
  1010. " </tr>\n",
  1011. " <tr>\n",
  1012. " <th>415</th>\n",
  1013. " <td>solruser</td>\n",
  1014. " <td>x</td>\n",
  1015. " <td>709454</td>\n",
  1016. " <td>709454</td>\n",
  1017. " <td>Patent Db, Research Ibm {GI D~South San Franci...</td>\n",
  1018. " <td>/gne/home/solruser</td>\n",
  1019. " <td>/bin/bash</td>\n",
  1020. " <td>x</td>\n",
  1021. " <td>709454</td>\n",
  1022. " <td>2120</td>\n",
  1023. " <td>Research IBM Patent DB Contact - chrisj</td>\n",
  1024. " <td>/gne/home/solruser</td>\n",
  1025. " <td>/bin/bash</td>\n",
  1026. " <td>ERROR: Primary GIDs do not match</td>\n",
  1027. " </tr>\n",
  1028. " <tr>\n",
  1029. " <th>435</th>\n",
  1030. " <td>tamarafr</td>\n",
  1031. " <td>x</td>\n",
  1032. " <td>37522</td>\n",
  1033. " <td>37522</td>\n",
  1034. " <td>Franzmann, Tamara {GRBF~South San Francisco}</td>\n",
  1035. " <td>/gne/home/tamarafr</td>\n",
  1036. " <td>/bin/bash</td>\n",
  1037. " <td>x</td>\n",
  1038. " <td>37522</td>\n",
  1039. " <td>1950</td>\n",
  1040. " <td>Tamara Franzmann - Consultant, Bioinfo Softwar...</td>\n",
  1041. " <td>/gne/home/tamarafr</td>\n",
  1042. " <td>/bin/bash</td>\n",
  1043. " <td>ERROR: Primary GIDs do not match</td>\n",
  1044. " </tr>\n",
  1045. " <tr>\n",
  1046. " <th>447</th>\n",
  1047. " <td>udzielar</td>\n",
  1048. " <td>x</td>\n",
  1049. " <td>710664</td>\n",
  1050. " <td>710664</td>\n",
  1051. " <td>Udziela, Rafal {FISC~Warsaw}</td>\n",
  1052. " <td>/gne/home/udzielar</td>\n",
  1053. " <td>/bin/csh</td>\n",
  1054. " <td>x</td>\n",
  1055. " <td>710664</td>\n",
  1056. " <td>1950</td>\n",
  1057. " <td>Rafal Udziela - Regular, Ina Conversion CC</td>\n",
  1058. " <td>/gne/home/udzielar</td>\n",
  1059. " <td>/bin/csh</td>\n",
  1060. " <td>ERROR: Primary GIDs do not match</td>\n",
  1061. " </tr>\n",
  1062. " <tr>\n",
  1063. " <th>448</th>\n",
  1064. " <td>vandenee</td>\n",
  1065. " <td>x</td>\n",
  1066. " <td>746167</td>\n",
  1067. " <td>746167</td>\n",
  1068. " <td>Vanden Eynden, Ewout {FISC~Warsaw}</td>\n",
  1069. " <td>/gne/home/vandenee</td>\n",
  1070. " <td>/bin/csh</td>\n",
  1071. " <td>x</td>\n",
  1072. " <td>746167</td>\n",
  1073. " <td>1950</td>\n",
  1074. " <td>Ewout Vanden Eynden - Regular, ADMD RDR</td>\n",
  1075. " <td>/gne/home/vandenee</td>\n",
  1076. " <td>/bin/csh</td>\n",
  1077. " <td>ERROR: Primary GIDs do not match</td>\n",
  1078. " </tr>\n",
  1079. " <tr>\n",
  1080. " <th>451</th>\n",
  1081. " <td>vettelo</td>\n",
  1082. " <td>x</td>\n",
  1083. " <td>52010</td>\n",
  1084. " <td>52010</td>\n",
  1085. " <td>Vettel, Oliver {DIAB~Basel Dia}</td>\n",
  1086. " <td>/gne/home/vettelo</td>\n",
  1087. " <td>/bin/bash</td>\n",
  1088. " <td>x</td>\n",
  1089. " <td>52010</td>\n",
  1090. " <td>1950</td>\n",
  1091. " <td>Oliver Vettel - Regular, Pathology Admin</td>\n",
  1092. " <td>/gne/home/vettelo</td>\n",
  1093. " <td>/bin/bash</td>\n",
  1094. " <td>ERROR: Primary GIDs do not match</td>\n",
  1095. " </tr>\n",
  1096. " <tr>\n",
  1097. " <th>462</th>\n",
  1098. " <td>wawrynom</td>\n",
  1099. " <td>x</td>\n",
  1100. " <td>721187</td>\n",
  1101. " <td>721187</td>\n",
  1102. " <td>Wawrynowicz, Marek {FISC~Poznan}</td>\n",
  1103. " <td>/gne/home/wawrynom</td>\n",
  1104. " <td>/bin/csh</td>\n",
  1105. " <td>x</td>\n",
  1106. " <td>721187</td>\n",
  1107. " <td>1950</td>\n",
  1108. " <td>Marek Wawrynowicz - Consultant, ADMD Group Ser...</td>\n",
  1109. " <td>/gne/home/wawrynom</td>\n",
  1110. " <td>/bin/csh</td>\n",
  1111. " <td>ERROR: Primary GIDs do not match</td>\n",
  1112. " </tr>\n",
  1113. " <tr>\n",
  1114. " <th>468</th>\n",
  1115. " <td>wlodekj</td>\n",
  1116. " <td>x</td>\n",
  1117. " <td>725132</td>\n",
  1118. " <td>725132</td>\n",
  1119. " <td>Wlodek, Jakub {FISC~Warsaw}</td>\n",
  1120. " <td>/gne/home/wlodekj</td>\n",
  1121. " <td>/bin/csh</td>\n",
  1122. " <td>x</td>\n",
  1123. " <td>725132</td>\n",
  1124. " <td>72</td>\n",
  1125. " <td>Jakub Wlodek - Consultant, ADMD Group Services</td>\n",
  1126. " <td>/gne/home/wlodekj</td>\n",
  1127. " <td>/bin/csh</td>\n",
  1128. " <td>ERROR: Primary GIDs do not match</td>\n",
  1129. " </tr>\n",
  1130. " <tr>\n",
  1131. " <th>469</th>\n",
  1132. " <td>wlodekm</td>\n",
  1133. " <td>x</td>\n",
  1134. " <td>742938</td>\n",
  1135. " <td>742938</td>\n",
  1136. " <td>Wlodek, Mateusz {FISC~Poznan}</td>\n",
  1137. " <td>/gne/home/wlodekm</td>\n",
  1138. " <td>/bin/csh</td>\n",
  1139. " <td>x</td>\n",
  1140. " <td>742938</td>\n",
  1141. " <td>1950</td>\n",
  1142. " <td>Mateusz Wlodek - Consultant, ADMD RDR</td>\n",
  1143. " <td>/gne/home/wlodekm</td>\n",
  1144. " <td>/bin/csh</td>\n",
  1145. " <td>ERROR: Primary GIDs do not match</td>\n",
  1146. " </tr>\n",
  1147. " <tr>\n",
  1148. " <th>470</th>\n",
  1149. " <td>wojtkom1</td>\n",
  1150. " <td>x</td>\n",
  1151. " <td>734783</td>\n",
  1152. " <td>734783</td>\n",
  1153. " <td>Wojtkowski, Michal {FISC~Poznan}</td>\n",
  1154. " <td>/gne/home/wojtkom1</td>\n",
  1155. " <td>/bin/csh</td>\n",
  1156. " <td>x</td>\n",
  1157. " <td>734783</td>\n",
  1158. " <td>1950</td>\n",
  1159. " <td>Michal Wojtkowski - Regular, ADMD PD-PT-PP</td>\n",
  1160. " <td>/gne/home/wojtkom1</td>\n",
  1161. " <td>/bin/csh</td>\n",
  1162. " <td>ERROR: Primary GIDs do not match</td>\n",
  1163. " </tr>\n",
  1164. " <tr>\n",
  1165. " <th>472</th>\n",
  1166. " <td>wregab</td>\n",
  1167. " <td>x</td>\n",
  1168. " <td>745906</td>\n",
  1169. " <td>745906</td>\n",
  1170. " <td>Wrega, Bartlomiej {FISV~Warsaw}</td>\n",
  1171. " <td>/gne/home/wregab</td>\n",
  1172. " <td>/bin/csh</td>\n",
  1173. " <td>x</td>\n",
  1174. " <td>745906</td>\n",
  1175. " <td>1950</td>\n",
  1176. " <td>Bartlomiej Wrega - Consultant, ADMD PD-PT-PP</td>\n",
  1177. " <td>/gne/home/wregab</td>\n",
  1178. " <td>/bin/csh</td>\n",
  1179. " <td>ERROR: Primary GIDs do not match</td>\n",
  1180. " </tr>\n",
  1181. " <tr>\n",
  1182. " <th>475</th>\n",
  1183. " <td>wwwres</td>\n",
  1184. " <td>x</td>\n",
  1185. " <td>32860</td>\n",
  1186. " <td>32860</td>\n",
  1187. " <td>Apache, Research {ATP~South San Francisco}</td>\n",
  1188. " <td>/gne/home/wwwres</td>\n",
  1189. " <td>/bin/csh</td>\n",
  1190. " <td>x</td>\n",
  1191. " <td>32860</td>\n",
  1192. " <td>562</td>\n",
  1193. " <td>gRED Research general web application account ...</td>\n",
  1194. " <td>/gne/home/wwwres</td>\n",
  1195. " <td>/bin/csh</td>\n",
  1196. " <td>ERROR: Primary GIDs do not match</td>\n",
  1197. " </tr>\n",
  1198. " <tr>\n",
  1199. " <th>488</th>\n",
  1200. " <td>zielakm</td>\n",
  1201. " <td>x</td>\n",
  1202. " <td>732412</td>\n",
  1203. " <td>732412</td>\n",
  1204. " <td>Zielak, Marcin {FISC~Warsaw}</td>\n",
  1205. " <td>/gne/home/zielakm</td>\n",
  1206. " <td>/bin/csh</td>\n",
  1207. " <td>x</td>\n",
  1208. " <td>732412</td>\n",
  1209. " <td>1950</td>\n",
  1210. " <td>Marcin Zielak - Consultant, ADMD Group Services</td>\n",
  1211. " <td>/gne/home/zielakm</td>\n",
  1212. " <td>/bin/csh</td>\n",
  1213. " <td>ERROR: Primary GIDs do not match</td>\n",
  1214. " </tr>\n",
  1215. " <tr>\n",
  1216. " <th>489</th>\n",
  1217. " <td>zielink1</td>\n",
  1218. " <td>x</td>\n",
  1219. " <td>748482</td>\n",
  1220. " <td>748482</td>\n",
  1221. " <td>Zielinski, Konrad {FISC~Warsaw}</td>\n",
  1222. " <td>/gne/home/zielink1</td>\n",
  1223. " <td>/bin/csh</td>\n",
  1224. " <td>x</td>\n",
  1225. " <td>748482</td>\n",
  1226. " <td>1950</td>\n",
  1227. " <td>Konrad Zielinski - Consultant, ADMD RDR</td>\n",
  1228. " <td>/gne/home/zielink1</td>\n",
  1229. " <td>/bin/csh</td>\n",
  1230. " <td>ERROR: Primary GIDs do not match</td>\n",
  1231. " </tr>\n",
  1232. " <tr>\n",
  1233. " <th>490</th>\n",
  1234. " <td>ziemskij</td>\n",
  1235. " <td>x</td>\n",
  1236. " <td>721109</td>\n",
  1237. " <td>721109</td>\n",
  1238. " <td>Ziemski, Jacek {FISC~Warsaw}</td>\n",
  1239. " <td>/gne/home/ziemskij</td>\n",
  1240. " <td>/bin/csh</td>\n",
  1241. " <td>x</td>\n",
  1242. " <td>721109</td>\n",
  1243. " <td>1950</td>\n",
  1244. " <td>Jacek Ziemski - Regular, ADMD Group Services</td>\n",
  1245. " <td>/gne/home/ziemskij</td>\n",
  1246. " <td>/bin/csh</td>\n",
  1247. " <td>ERROR: Primary GIDs do not match</td>\n",
  1248. " </tr>\n",
  1249. " <tr>\n",
  1250. " <th>493</th>\n",
  1251. " <td>ztiflj</td>\n",
  1252. " <td>x</td>\n",
  1253. " <td>6141</td>\n",
  1254. " <td>6141</td>\n",
  1255. " <td>Fitz, Jim {Syst~South San Francisco}</td>\n",
  1256. " <td>/gne/home/ztiflj</td>\n",
  1257. " <td>/bin/tcsh</td>\n",
  1258. " <td>x</td>\n",
  1259. " <td>6141</td>\n",
  1260. " <td>11</td>\n",
  1261. " <td>Jim Fitz test,Library,2793</td>\n",
  1262. " <td>/gne/home/ztiflj</td>\n",
  1263. " <td>/bin/tcsh</td>\n",
  1264. " <td>ERROR: Primary GIDs do not match</td>\n",
  1265. " </tr>\n",
  1266. " </tbody>\n",
  1267. "</table>\n",
  1268. "<p>86 rows × 14 columns</p>\n",
  1269. "</div>"
  1270. ],
  1271. "text/plain": [
  1272. " unixID x_x uid_x gid_x \\\n",
  1273. "3 ahujan x 744428 744428 \n",
  1274. "11 ana2user x 741783 741783 \n",
  1275. "33 bizopsvc x 734127 734127 \n",
  1276. "51 cdduser x 50359 50359 \n",
  1277. "52 cfcddadm x 51691 51691 \n",
  1278. "53 cfmedche x 23898 23898 \n",
  1279. "54 cfresabg x 723407 723407 \n",
  1280. "55 cfresgpa x 713703 713703 \n",
  1281. "56 cfresgra x 717435 717435 \n",
  1282. "57 cfrespli x 716507 716507 \n",
  1283. "58 cfresseq x 718180 718180 \n",
  1284. "59 cfrestcg x 719615 719615 \n",
  1285. "60 cfsmdius x 26040 26040 \n",
  1286. "73 compbio x 17325 17325 \n",
  1287. "74 compsci x 728726 728726 \n",
  1288. "78 cryouser x 744090 744090 \n",
  1289. "98 ddgtest x 27247 27247 \n",
  1290. "102 divossrv x 739372 739372 \n",
  1291. "121 ferrie1 x 737372 737372 \n",
  1292. "127 forte x 10001 10001 \n",
  1293. "130 gSage x 12835 12835 \n",
  1294. "131 galngs x 748617 748617 \n",
  1295. "136 germline x 746696 746696 \n",
  1296. "144 gpsadm x 715231 715231 \n",
  1297. "148 gredbee x 742683 742683 \n",
  1298. "149 gredenv x 723141 723141 \n",
  1299. "150 gredflow x 726836 726836 \n",
  1300. "151 gredsolr x 716188 716188 \n",
  1301. "152 gredstor x 739147 739147 \n",
  1302. "153 gredsys x 739146 739146 \n",
  1303. ".. ... .. ... ... \n",
  1304. "369 reslab01 x 35060 35060 \n",
  1305. "370 resmedch x 722103 722103 \n",
  1306. "371 resncode x 735927 735927 \n",
  1307. "372 resseq x 52230 52230 \n",
  1308. "373 ressuper x 729642 729642 \n",
  1309. "374 restapir x 734498 734498 \n",
  1310. "375 restibco x 716642 716642 \n",
  1311. "376 restst1 x 713581 713581 \n",
  1312. "377 restst2 x 713582 713582 \n",
  1313. "378 restst3 x 713583 713583 \n",
  1314. "379 restst4 x 713580 713580 \n",
  1315. "383 roboauto x 746895 746895 \n",
  1316. "390 sched x 27518 27518 \n",
  1317. "399 seurat x 51956 51956 \n",
  1318. "405 shivaswn x 744573 52 \n",
  1319. "415 solruser x 709454 709454 \n",
  1320. "435 tamarafr x 37522 37522 \n",
  1321. "447 udzielar x 710664 710664 \n",
  1322. "448 vandenee x 746167 746167 \n",
  1323. "451 vettelo x 52010 52010 \n",
  1324. "462 wawrynom x 721187 721187 \n",
  1325. "468 wlodekj x 725132 725132 \n",
  1326. "469 wlodekm x 742938 742938 \n",
  1327. "470 wojtkom1 x 734783 734783 \n",
  1328. "472 wregab x 745906 745906 \n",
  1329. "475 wwwres x 32860 32860 \n",
  1330. "488 zielakm x 732412 732412 \n",
  1331. "489 zielink1 x 748482 748482 \n",
  1332. "490 ziemskij x 721109 721109 \n",
  1333. "493 ztiflj x 6141 6141 \n",
  1334. "\n",
  1335. " desc_x homedir_x \\\n",
  1336. "3 /gne/home/ahujan \n",
  1337. "11 Ana2user, Ssf {MPL~South San Francisco} /gne/home/ana2user \n",
  1338. "33 Gred Bizops, South San Francisco {PAC-~South S... /gne/home/bizopsvc \n",
  1339. "51 Applications, CDD {Syst~South San Francisco} /gne/home/cdduser \n",
  1340. "52 Cddadmin, Centrify {Arch~South San Francisco} /gne/home/cddadmin \n",
  1341. "53 Medchem, Centrify {Arch~South San Francisco} /gne/home/medchem \n",
  1342. "54 Resabgen, South San Francisco {GLOB~South San ... /gne/home/resabgen \n",
  1343. "55 Resgpan, Centrify {Arch~South San Francisco} /gne/home/resgpan \n",
  1344. "56 Resgran, Centrify {Arch~South San Francisco} /gne/home/resgran \n",
  1345. "57 Resplims, South San Francisco {GLOB~South San ... /gne/home/resplims \n",
  1346. "58 Resseqwb, South San Francisco {GLOB~South San ... /gne/home/resseqwb \n",
  1347. "59 Restcga, South San Francisco {GLOB~South San F... /gne/home/restcga \n",
  1348. "60 Smdiuser, Centrify {Arch~South San Francisco} /gne/home/smdiuser \n",
  1349. "73 bio, comp {Syst~South San Francisco} /gne/home/compbio \n",
  1350. "74 Comp Genetics Acct, Ssf Gred Bcb {Arch~South S... /gne/home/compsci \n",
  1351. "78 South San Francisco, Cryo-em User {Bioi~South ... /gne/home/cryouser \n",
  1352. "98 Garrett, Doug {Syst~South San Francisco} /gne/home/ddgtest \n",
  1353. "102 Divos Rserve, South San Francisco {Bioi~South ... /gne/home/divossrv \n",
  1354. "121 Elena Ferri - Regular, Med Chemistry /gne/home/ferrie1 \n",
  1355. "127 Belforte, Heidi {MNHS~South San Francisco} /vqa/QA/belforte \n",
  1356. "130 WebLogic, Geneland {ATP~South San Francisco} /gne/home/gSage \n",
  1357. "131 Dixon Galion Svcacct, South San Francisco {Gen... /gne/home/galngs \n",
  1358. "136 Germline, South San Francisco {Bioi~South San ... /gne/home/germline \n",
  1359. "144 Gpspdust, Gpsadm {Syst~South San Francisco} /gne/home/gpsadm \n",
  1360. "148 Bee Stack For Gred, South San Francisco {Bioi~... /gne/home/gredbee \n",
  1361. "149 Admin Sysaccount, Gred Environment {gRED~South... /gne/home/gredenv \n",
  1362. "150 Appaccount Devsci, Gredflow Partek Flow {gRED~... /gne/home/gredflow \n",
  1363. "151 Punh Bzuffi Slaton, Gred Solr Search {gRED~Sou... /gne/home/gredsolr \n",
  1364. "152 Gred It Storage Admi, South San Francisco {gRE... /gne/home/gredstor \n",
  1365. "153 Gred It Sysadmin Acc, South San Francisco {gRE... /gne/home/gredsys \n",
  1366. ".. ... ... \n",
  1367. "369 Labshare, Research {ATP~South San Francisco} /gne/home/reslab01 \n",
  1368. "370 Gred Cdd, Medchemica Appaccoun {gRED~South San... /gne/home/resmedch \n",
  1369. "371 Wuxi Nextcode Applic, Ssf {gRED~South San Fran... /gne/home/resncode \n",
  1370. "372 Sysacct, Research Sequencing {Bioi~South San F... /gne/home/resseq \n",
  1371. "373 Appaccount - Gred, Ressuper {Bioi~South San Fr... /gne/home/ressuper \n",
  1372. "374 Gred Tapir Project, South San Francisco {Bioi~... /gne/home/restapir \n",
  1373. "375 Appacct - Jlfitz, Restibco {Bioi~South San Fra... /gne/home/restibco \n",
  1374. "376 Test 1 - Josepsli, Rescomp {Syst~South San Fra... /gne/home/restst1 \n",
  1375. "377 Test 2 - Josepsli, Rescomp {Syst~South San Fra... /gne/home/restst2 \n",
  1376. "378 Test 3 - Josepsli, Rescomp {Syst~South San Fra... /gne/home/restst3 \n",
  1377. "379 Test 4 - Josepsli, Rescomp {Syst~South San Fra... /gne/home/restst4 \n",
  1378. "383 Roboauto, South San Francisco {Bioi~South San ... /gne/home/roboauto \n",
  1379. "390 Scheduler, Map {Syst~South San Francisco} /gne/home/sched \n",
  1380. "399 Seurat, Research {ATP~South San Francisco} /gne/home/seurat \n",
  1381. "405 Niranajn - Internal account /gne/home/shivaswn \n",
  1382. "415 Patent Db, Research Ibm {GI D~South San Franci... /gne/home/solruser \n",
  1383. "435 Franzmann, Tamara {GRBF~South San Francisco} /gne/home/tamarafr \n",
  1384. "447 Udziela, Rafal {FISC~Warsaw} /gne/home/udzielar \n",
  1385. "448 Vanden Eynden, Ewout {FISC~Warsaw} /gne/home/vandenee \n",
  1386. "451 Vettel, Oliver {DIAB~Basel Dia} /gne/home/vettelo \n",
  1387. "462 Wawrynowicz, Marek {FISC~Poznan} /gne/home/wawrynom \n",
  1388. "468 Wlodek, Jakub {FISC~Warsaw} /gne/home/wlodekj \n",
  1389. "469 Wlodek, Mateusz {FISC~Poznan} /gne/home/wlodekm \n",
  1390. "470 Wojtkowski, Michal {FISC~Poznan} /gne/home/wojtkom1 \n",
  1391. "472 Wrega, Bartlomiej {FISV~Warsaw} /gne/home/wregab \n",
  1392. "475 Apache, Research {ATP~South San Francisco} /gne/home/wwwres \n",
  1393. "488 Zielak, Marcin {FISC~Warsaw} /gne/home/zielakm \n",
  1394. "489 Zielinski, Konrad {FISC~Warsaw} /gne/home/zielink1 \n",
  1395. "490 Ziemski, Jacek {FISC~Warsaw} /gne/home/ziemskij \n",
  1396. "493 Fitz, Jim {Syst~South San Francisco} /gne/home/ztiflj \n",
  1397. "\n",
  1398. " shell_x x_y uid_y gid_y \\\n",
  1399. "3 /bin/bash x 744428 1950 \n",
  1400. "11 /bin/bash x 741783 1950 \n",
  1401. "33 /bin/csh x 734127 1950 \n",
  1402. "51 /bin/tcsh x 50359 2120 \n",
  1403. "52 /bin/bash x 737982 1950 \n",
  1404. "53 /bin/tcsh x 738107 1950 \n",
  1405. "54 /bin/bash x 740470 1950 \n",
  1406. "55 /bin/csh x 738030 1950 \n",
  1407. "56 /bin/bash x 738028 1950 \n",
  1408. "57 /bin/bash x 740478 1950 \n",
  1409. "58 /bin/bash x 740467 1950 \n",
  1410. "59 /bin/bash x 740486 1950 \n",
  1411. "60 /bin/bash x 737971 1950 \n",
  1412. "73 /bin/bash x 17325 2058 \n",
  1413. "74 /bin/bash x 728726 2343 \n",
  1414. "78 /bin/csh x 744090 20599 \n",
  1415. "98 /bin/bash x 27247 1279 \n",
  1416. "102 /bin/bash x 739372 20582 \n",
  1417. "121 /bin/bash x 737372 1950 \n",
  1418. "127 /bin/csh x 10001 140 \n",
  1419. "130 /bin/csh x 12835 140 \n",
  1420. "131 /bin/csh x 748617 1950 \n",
  1421. "136 /bin/bash x 746696 2383 \n",
  1422. "144 /bin/bash x 715231 1 \n",
  1423. "148 /bin/csh x 742683 1950 \n",
  1424. "149 /bin/bash x 723141 20581 \n",
  1425. "150 /bin/csh x 726836 1950 \n",
  1426. "151 /bin/bash x 716188 562 \n",
  1427. "152 /bin/bash x 739147 2377 \n",
  1428. "153 /bin/bash x 739146 2376 \n",
  1429. ".. ... .. ... ... \n",
  1430. "369 /bin/csh x 35060 205 \n",
  1431. "370 /bin/bash x 722103 2120 \n",
  1432. "371 /bin/bash x 735927 1950 \n",
  1433. "372 /bin/bash x 52230 2060 \n",
  1434. "373 /bin/bash x 729642 2349 \n",
  1435. "374 /bin/bash x 734498 2369 \n",
  1436. "375 /bin/bash x 716642 2255 \n",
  1437. "376 /bin/bash x 713581 1950 \n",
  1438. "377 /bin/bash x 713582 1950 \n",
  1439. "378 /bin/tcsh x 713583 1950 \n",
  1440. "379 /bin/tcsh x 713580 1950 \n",
  1441. "383 /bin/bash x 746895 2384 \n",
  1442. "390 /usr/bin/bash x 27518 1326 \n",
  1443. "399 /bin/csh x 51956 1011 \n",
  1444. "405 /bin/bash x 744573 1950 \n",
  1445. "415 /bin/bash x 709454 2120 \n",
  1446. "435 /bin/bash x 37522 1950 \n",
  1447. "447 /bin/csh x 710664 1950 \n",
  1448. "448 /bin/csh x 746167 1950 \n",
  1449. "451 /bin/bash x 52010 1950 \n",
  1450. "462 /bin/csh x 721187 1950 \n",
  1451. "468 /bin/csh x 725132 72 \n",
  1452. "469 /bin/csh x 742938 1950 \n",
  1453. "470 /bin/csh x 734783 1950 \n",
  1454. "472 /bin/csh x 745906 1950 \n",
  1455. "475 /bin/csh x 32860 562 \n",
  1456. "488 /bin/csh x 732412 1950 \n",
  1457. "489 /bin/csh x 748482 1950 \n",
  1458. "490 /bin/csh x 721109 1950 \n",
  1459. "493 /bin/tcsh x 6141 11 \n",
  1460. "\n",
  1461. " desc_y homedir_y \\\n",
  1462. "3 Nitin Ahuja - Consultant, Arch Eng Ops /gne/home/ahujan \n",
  1463. "11 SSF ana2user - , /gne/home/ana2user \n",
  1464. "33 South San Francisco gRED Bizops - , /gne/home/bizopsvc \n",
  1465. "51 CDD Applications - , /gne/home/cdduser \n",
  1466. "52 CENTRIFY CDDADMIN - , /gne/home/cfcddadm \n",
  1467. "53 CENTRIFY MEDCHEM - , /gne/home/cfmedche \n",
  1468. "54 South San Francisco Resabgen - , /gne/home/cfresabg \n",
  1469. "55 CENTRIFY RESGPAN - , /gne/home/cfresgpa \n",
  1470. "56 CENTRIFY RESGRAN - , /gne/home/cfresgra \n",
  1471. "57 South San Francisco resplims - , /gne/home/cfrespli \n",
  1472. "58 South San Francisco Resseqwb - , /gne/home/cfresseq \n",
  1473. "59 South San Francisco Restcga - , /gne/home/cfrestcg \n",
  1474. "60 CENTRIFY SMDIUSER - , /gne/home/cfsmdius \n",
  1475. "73 comp bio - application,Bioinfo, - application,... /gne/home/compbio \n",
  1476. "74 SSF gRED bCB Comp Genetics acct - , /gne/home/compsci \n",
  1477. "78 Cryo-EM user South San Francisco - , /gne/home/cryouser \n",
  1478. "98 Doug Test Garrett - Test, , /gne/home/ddgtest \n",
  1479. "102 South San Francisco divos Rserve - , /gne/home/divossrv \n",
  1480. "121 Elena Ferri - Regular, Med Chemistry /gne/home/ferrie1 \n",
  1481. "127 Forte Application Account,Kathryn Chan,53078 /opt/forte \n",
  1482. "130 Geneland WebLogic Account - application,Bioinf... /gne/home/gSage \n",
  1483. "131 South San Francisco dixon galion svcacct - , /gne/home/galngs \n",
  1484. "136 South San Francisco Germline - , /gne/home/germline \n",
  1485. "144 Gpspdust, Gpsadm {Syst~South San Francisco} /gne/home/gpsadm \n",
  1486. "148 South San Francisco Bee Stack for gRED - , /gne/home/gredbee \n",
  1487. "149 gRED Environment Admin SysAccount - , /gne/home/gredenv \n",
  1488. "150 gredflow Partek Flow AppAccount DevSci - , /gne/home/gredflow \n",
  1489. "151 gRED Solr search app act - punh, bzuffi, josepsli /gne/home/gredsolr \n",
  1490. "152 South San Francisco gRED IT storage admi - , /gne/home/gredstor \n",
  1491. "153 South San Francisco gRED IT sysadmin acc - , /gne/home/gredsys \n",
  1492. ".. ... ... \n",
  1493. "369 Research Labshare - Application, /gne/home/reslab01 \n",
  1494. "370 MedChemica AppAccoun gRED CDD - , /gne/home/resmedch \n",
  1495. "371 SSF WuXi NextCODE Applic - , /gne/home/resncode \n",
  1496. "372 Research Sequencing Sysacct - , /gne/home/resseq \n",
  1497. "373 ressuper AppAccount - gRED - , /gne/home/ressuper \n",
  1498. "374 South San Francisco gRED Tapir Project - , /gne/home/restapir \n",
  1499. "375 restibco AppAcct - jlfitz - , /gne/home/restibco \n",
  1500. "376 Rescomp Test 1 - josepsli - , /gne/home/restst1 \n",
  1501. "377 Rescomp Test 2 - josepsli - , /gne/home/restst2 \n",
  1502. "378 Rescomp Test 3 - josepsli - , /gne/home/restst3 \n",
  1503. "379 Rescomp Test 4 - josepsli - , /gne/home/restst4 \n",
  1504. "383 South San Francisco ROBOAUTO - , /gne/home/roboauto \n",
  1505. "390 Map Scheduler - application,Application Account, /gne/home/sched \n",
  1506. "399 Seurat research application-ryantw,benjamds,ac... /gne/home/seurat \n",
  1507. "405 Niranjan Shivaswamy - Consultant, Arch Eng Ops /gne/home/shivaswn \n",
  1508. "415 Research IBM Patent DB Contact - chrisj /gne/home/solruser \n",
  1509. "435 Tamara Franzmann - Consultant, Bioinfo Softwar... /gne/home/tamarafr \n",
  1510. "447 Rafal Udziela - Regular, Ina Conversion CC /gne/home/udzielar \n",
  1511. "448 Ewout Vanden Eynden - Regular, ADMD RDR /gne/home/vandenee \n",
  1512. "451 Oliver Vettel - Regular, Pathology Admin /gne/home/vettelo \n",
  1513. "462 Marek Wawrynowicz - Consultant, ADMD Group Ser... /gne/home/wawrynom \n",
  1514. "468 Jakub Wlodek - Consultant, ADMD Group Services /gne/home/wlodekj \n",
  1515. "469 Mateusz Wlodek - Consultant, ADMD RDR /gne/home/wlodekm \n",
  1516. "470 Michal Wojtkowski - Regular, ADMD PD-PT-PP /gne/home/wojtkom1 \n",
  1517. "472 Bartlomiej Wrega - Consultant, ADMD PD-PT-PP /gne/home/wregab \n",
  1518. "475 gRED Research general web application account ... /gne/home/wwwres \n",
  1519. "488 Marcin Zielak - Consultant, ADMD Group Services /gne/home/zielakm \n",
  1520. "489 Konrad Zielinski - Consultant, ADMD RDR /gne/home/zielink1 \n",
  1521. "490 Jacek Ziemski - Regular, ADMD Group Services /gne/home/ziemskij \n",
  1522. "493 Jim Fitz test,Library,2793 /gne/home/ztiflj \n",
  1523. "\n",
  1524. " shell_y discrepancies \n",
  1525. "3 /bin/csh ERROR: Primary GIDs do not match \n",
  1526. "11 /bin/bash ERROR: Primary GIDs do not match \n",
  1527. "33 /bin/csh ERROR: Primary GIDs do not match \n",
  1528. "51 /bin/tcsh ERROR: Primary GIDs do not match \n",
  1529. "52 /bin/csh ERROR: Primary GIDs do not match \n",
  1530. "53 /bin/csh ERROR: Primary GIDs do not match \n",
  1531. "54 /bin/csh ERROR: Primary GIDs do not match \n",
  1532. "55 /bin/csh ERROR: Primary GIDs do not match \n",
  1533. "56 /bin/csh ERROR: Primary GIDs do not match \n",
  1534. "57 /bin/csh ERROR: Primary GIDs do not match \n",
  1535. "58 /bin/csh ERROR: Primary GIDs do not match \n",
  1536. "59 /bin/csh ERROR: Primary GIDs do not match \n",
  1537. "60 /bin/csh ERROR: Primary GIDs do not match \n",
  1538. "73 /bin/bash ERROR: Primary GIDs do not match \n",
  1539. "74 /bin/bash ERROR: Primary GIDs do not match \n",
  1540. "78 /bin/csh ERROR: Primary GIDs do not match \n",
  1541. "98 /bin/bash ERROR: Primary GIDs do not match \n",
  1542. "102 /bin/bash ERROR: Primary GIDs do not match \n",
  1543. "121 /bin/bash ERROR: Primary GIDs do not match \n",
  1544. "127 /bin/csh ERROR: Primary GIDs do not match \n",
  1545. "130 /bin/csh ERROR: Primary GIDs do not match \n",
  1546. "131 /bin/bash ERROR: Primary GIDs do not match \n",
  1547. "136 /bin/bash ERROR: Primary GIDs do not match \n",
  1548. "144 /bin/bash ERROR: Primary GIDs do not match \n",
  1549. "148 /bin/csh ERROR: Primary GIDs do not match \n",
  1550. "149 /bin/bash ERROR: Primary GIDs do not match \n",
  1551. "150 /bin/csh ERROR: Primary GIDs do not match \n",
  1552. "151 /bin/bash ERROR: Primary GIDs do not match \n",
  1553. "152 /bin/bash ERROR: Primary GIDs do not match \n",
  1554. "153 /bin/bash ERROR: Primary GIDs do not match \n",
  1555. ".. ... ... \n",
  1556. "369 /bin/csh ERROR: Primary GIDs do not match \n",
  1557. "370 /bin/bash ERROR: Primary GIDs do not match \n",
  1558. "371 /bin/bash ERROR: Primary GIDs do not match \n",
  1559. "372 /bin/bash ERROR: Primary GIDs do not match \n",
  1560. "373 /bin/bash ERROR: Primary GIDs do not match \n",
  1561. "374 /bin/bash ERROR: Primary GIDs do not match \n",
  1562. "375 /bin/bash ERROR: Primary GIDs do not match \n",
  1563. "376 /bin/bash ERROR: Primary GIDs do not match \n",
  1564. "377 /bin/bash ERROR: Primary GIDs do not match \n",
  1565. "378 /bin/tcsh ERROR: Primary GIDs do not match \n",
  1566. "379 /bin/tcsh ERROR: Primary GIDs do not match \n",
  1567. "383 /bin/bash ERROR: Primary GIDs do not match \n",
  1568. "390 /usr/bin/bash ERROR: Primary GIDs do not match \n",
  1569. "399 /bin/csh ERROR: Primary GIDs do not match \n",
  1570. "405 /bin/csh ERROR: Primary GIDs do not match \n",
  1571. "415 /bin/bash ERROR: Primary GIDs do not match \n",
  1572. "435 /bin/bash ERROR: Primary GIDs do not match \n",
  1573. "447 /bin/csh ERROR: Primary GIDs do not match \n",
  1574. "448 /bin/csh ERROR: Primary GIDs do not match \n",
  1575. "451 /bin/bash ERROR: Primary GIDs do not match \n",
  1576. "462 /bin/csh ERROR: Primary GIDs do not match \n",
  1577. "468 /bin/csh ERROR: Primary GIDs do not match \n",
  1578. "469 /bin/csh ERROR: Primary GIDs do not match \n",
  1579. "470 /bin/csh ERROR: Primary GIDs do not match \n",
  1580. "472 /bin/csh ERROR: Primary GIDs do not match \n",
  1581. "475 /bin/csh ERROR: Primary GIDs do not match \n",
  1582. "488 /bin/csh ERROR: Primary GIDs do not match \n",
  1583. "489 /bin/csh ERROR: Primary GIDs do not match \n",
  1584. "490 /bin/csh ERROR: Primary GIDs do not match \n",
  1585. "493 /bin/tcsh ERROR: Primary GIDs do not match \n",
  1586. "\n",
  1587. "[86 rows x 14 columns]"
  1588. ]
  1589. },
  1590. "execution_count": 12,
  1591. "metadata": {},
  1592. "output_type": "execute_result"
  1593. }
  1594. ],
  1595. "source": [
  1596. "# Use case where GID's aren't equal to UID's but different from RCN\n",
  1597. "discrepant_rows2 = c1.loc[(c1.gid_x != c1.gid_y)]\n",
  1598. "discrepant_rows2 = discrepant_rows2.assign(discrepancies='ERROR: Primary GIDs do not match')\n",
  1599. "discrepant_rows.append(discrepant_rows2)\n",
  1600. "discrepant_rows2"
  1601. ]
  1602. },
  1603. {
  1604. "cell_type": "markdown",
  1605. "metadata": {},
  1606. "source": [
  1607. "## Shells that don't match"
  1608. ]
  1609. },
  1610. {
  1611. "cell_type": "code",
  1612. "execution_count": 13,
  1613. "metadata": {
  1614. "scrolled": true
  1615. },
  1616. "outputs": [
  1617. {
  1618. "data": {
  1619. "text/html": [
  1620. "<div>\n",
  1621. "<style scoped>\n",
  1622. " .dataframe tbody tr th:only-of-type {\n",
  1623. " vertical-align: middle;\n",
  1624. " }\n",
  1625. "\n",
  1626. " .dataframe tbody tr th {\n",
  1627. " vertical-align: top;\n",
  1628. " }\n",
  1629. "\n",
  1630. " .dataframe thead th {\n",
  1631. " text-align: right;\n",
  1632. " }\n",
  1633. "</style>\n",
  1634. "<table border=\"1\" class=\"dataframe\">\n",
  1635. " <thead>\n",
  1636. " <tr style=\"text-align: right;\">\n",
  1637. " <th></th>\n",
  1638. " <th>unixID</th>\n",
  1639. " <th>x_x</th>\n",
  1640. " <th>uid_x</th>\n",
  1641. " <th>gid_x</th>\n",
  1642. " <th>desc_x</th>\n",
  1643. " <th>homedir_x</th>\n",
  1644. " <th>shell_x</th>\n",
  1645. " <th>x_y</th>\n",
  1646. " <th>uid_y</th>\n",
  1647. " <th>gid_y</th>\n",
  1648. " <th>desc_y</th>\n",
  1649. " <th>homedir_y</th>\n",
  1650. " <th>shell_y</th>\n",
  1651. " <th>discrepancies</th>\n",
  1652. " </tr>\n",
  1653. " </thead>\n",
  1654. " <tbody>\n",
  1655. " <tr>\n",
  1656. " <th>3</th>\n",
  1657. " <td>ahujan</td>\n",
  1658. " <td>x</td>\n",
  1659. " <td>744428</td>\n",
  1660. " <td>744428</td>\n",
  1661. " <td></td>\n",
  1662. " <td>/gne/home/ahujan</td>\n",
  1663. " <td>/bin/bash</td>\n",
  1664. " <td>x</td>\n",
  1665. " <td>744428</td>\n",
  1666. " <td>1950</td>\n",
  1667. " <td>Nitin Ahuja - Consultant, Arch Eng Ops</td>\n",
  1668. " <td>/gne/home/ahujan</td>\n",
  1669. " <td>/bin/csh</td>\n",
  1670. " <td>ERROR: shells do not match</td>\n",
  1671. " </tr>\n",
  1672. " <tr>\n",
  1673. " <th>52</th>\n",
  1674. " <td>cfcddadm</td>\n",
  1675. " <td>x</td>\n",
  1676. " <td>51691</td>\n",
  1677. " <td>51691</td>\n",
  1678. " <td>Cddadmin, Centrify {Arch~South San Francisco}</td>\n",
  1679. " <td>/gne/home/cddadmin</td>\n",
  1680. " <td>/bin/bash</td>\n",
  1681. " <td>x</td>\n",
  1682. " <td>737982</td>\n",
  1683. " <td>1950</td>\n",
  1684. " <td>CENTRIFY CDDADMIN - ,</td>\n",
  1685. " <td>/gne/home/cfcddadm</td>\n",
  1686. " <td>/bin/csh</td>\n",
  1687. " <td>ERROR: shells do not match</td>\n",
  1688. " </tr>\n",
  1689. " <tr>\n",
  1690. " <th>53</th>\n",
  1691. " <td>cfmedche</td>\n",
  1692. " <td>x</td>\n",
  1693. " <td>23898</td>\n",
  1694. " <td>23898</td>\n",
  1695. " <td>Medchem, Centrify {Arch~South San Francisco}</td>\n",
  1696. " <td>/gne/home/medchem</td>\n",
  1697. " <td>/bin/tcsh</td>\n",
  1698. " <td>x</td>\n",
  1699. " <td>738107</td>\n",
  1700. " <td>1950</td>\n",
  1701. " <td>CENTRIFY MEDCHEM - ,</td>\n",
  1702. " <td>/gne/home/cfmedche</td>\n",
  1703. " <td>/bin/csh</td>\n",
  1704. " <td>ERROR: shells do not match</td>\n",
  1705. " </tr>\n",
  1706. " <tr>\n",
  1707. " <th>54</th>\n",
  1708. " <td>cfresabg</td>\n",
  1709. " <td>x</td>\n",
  1710. " <td>723407</td>\n",
  1711. " <td>723407</td>\n",
  1712. " <td>Resabgen, South San Francisco {GLOB~South San ...</td>\n",
  1713. " <td>/gne/home/resabgen</td>\n",
  1714. " <td>/bin/bash</td>\n",
  1715. " <td>x</td>\n",
  1716. " <td>740470</td>\n",
  1717. " <td>1950</td>\n",
  1718. " <td>South San Francisco Resabgen - ,</td>\n",
  1719. " <td>/gne/home/cfresabg</td>\n",
  1720. " <td>/bin/csh</td>\n",
  1721. " <td>ERROR: shells do not match</td>\n",
  1722. " </tr>\n",
  1723. " <tr>\n",
  1724. " <th>56</th>\n",
  1725. " <td>cfresgra</td>\n",
  1726. " <td>x</td>\n",
  1727. " <td>717435</td>\n",
  1728. " <td>717435</td>\n",
  1729. " <td>Resgran, Centrify {Arch~South San Francisco}</td>\n",
  1730. " <td>/gne/home/resgran</td>\n",
  1731. " <td>/bin/bash</td>\n",
  1732. " <td>x</td>\n",
  1733. " <td>738028</td>\n",
  1734. " <td>1950</td>\n",
  1735. " <td>CENTRIFY RESGRAN - ,</td>\n",
  1736. " <td>/gne/home/cfresgra</td>\n",
  1737. " <td>/bin/csh</td>\n",
  1738. " <td>ERROR: shells do not match</td>\n",
  1739. " </tr>\n",
  1740. " <tr>\n",
  1741. " <th>57</th>\n",
  1742. " <td>cfrespli</td>\n",
  1743. " <td>x</td>\n",
  1744. " <td>716507</td>\n",
  1745. " <td>716507</td>\n",
  1746. " <td>Resplims, South San Francisco {GLOB~South San ...</td>\n",
  1747. " <td>/gne/home/resplims</td>\n",
  1748. " <td>/bin/bash</td>\n",
  1749. " <td>x</td>\n",
  1750. " <td>740478</td>\n",
  1751. " <td>1950</td>\n",
  1752. " <td>South San Francisco resplims - ,</td>\n",
  1753. " <td>/gne/home/cfrespli</td>\n",
  1754. " <td>/bin/csh</td>\n",
  1755. " <td>ERROR: shells do not match</td>\n",
  1756. " </tr>\n",
  1757. " <tr>\n",
  1758. " <th>58</th>\n",
  1759. " <td>cfresseq</td>\n",
  1760. " <td>x</td>\n",
  1761. " <td>718180</td>\n",
  1762. " <td>718180</td>\n",
  1763. " <td>Resseqwb, South San Francisco {GLOB~South San ...</td>\n",
  1764. " <td>/gne/home/resseqwb</td>\n",
  1765. " <td>/bin/bash</td>\n",
  1766. " <td>x</td>\n",
  1767. " <td>740467</td>\n",
  1768. " <td>1950</td>\n",
  1769. " <td>South San Francisco Resseqwb - ,</td>\n",
  1770. " <td>/gne/home/cfresseq</td>\n",
  1771. " <td>/bin/csh</td>\n",
  1772. " <td>ERROR: shells do not match</td>\n",
  1773. " </tr>\n",
  1774. " <tr>\n",
  1775. " <th>59</th>\n",
  1776. " <td>cfrestcg</td>\n",
  1777. " <td>x</td>\n",
  1778. " <td>719615</td>\n",
  1779. " <td>719615</td>\n",
  1780. " <td>Restcga, South San Francisco {GLOB~South San F...</td>\n",
  1781. " <td>/gne/home/restcga</td>\n",
  1782. " <td>/bin/bash</td>\n",
  1783. " <td>x</td>\n",
  1784. " <td>740486</td>\n",
  1785. " <td>1950</td>\n",
  1786. " <td>South San Francisco Restcga - ,</td>\n",
  1787. " <td>/gne/home/cfrestcg</td>\n",
  1788. " <td>/bin/csh</td>\n",
  1789. " <td>ERROR: shells do not match</td>\n",
  1790. " </tr>\n",
  1791. " <tr>\n",
  1792. " <th>60</th>\n",
  1793. " <td>cfsmdius</td>\n",
  1794. " <td>x</td>\n",
  1795. " <td>26040</td>\n",
  1796. " <td>26040</td>\n",
  1797. " <td>Smdiuser, Centrify {Arch~South San Francisco}</td>\n",
  1798. " <td>/gne/home/smdiuser</td>\n",
  1799. " <td>/bin/bash</td>\n",
  1800. " <td>x</td>\n",
  1801. " <td>737971</td>\n",
  1802. " <td>1950</td>\n",
  1803. " <td>CENTRIFY SMDIUSER - ,</td>\n",
  1804. " <td>/gne/home/cfsmdius</td>\n",
  1805. " <td>/bin/csh</td>\n",
  1806. " <td>ERROR: shells do not match</td>\n",
  1807. " </tr>\n",
  1808. " <tr>\n",
  1809. " <th>131</th>\n",
  1810. " <td>galngs</td>\n",
  1811. " <td>x</td>\n",
  1812. " <td>748617</td>\n",
  1813. " <td>748617</td>\n",
  1814. " <td>Dixon Galion Svcacct, South San Francisco {Gen...</td>\n",
  1815. " <td>/gne/home/galngs</td>\n",
  1816. " <td>/bin/csh</td>\n",
  1817. " <td>x</td>\n",
  1818. " <td>748617</td>\n",
  1819. " <td>1950</td>\n",
  1820. " <td>South San Francisco dixon galion svcacct - ,</td>\n",
  1821. " <td>/gne/home/galngs</td>\n",
  1822. " <td>/bin/bash</td>\n",
  1823. " <td>ERROR: shells do not match</td>\n",
  1824. " </tr>\n",
  1825. " <tr>\n",
  1826. " <th>141</th>\n",
  1827. " <td>golivac</td>\n",
  1828. " <td>x</td>\n",
  1829. " <td>12637</td>\n",
  1830. " <td>2120</td>\n",
  1831. " <td>Chandra Goliva - regular,Scientific Computing,</td>\n",
  1832. " <td>/gne/home/golivac</td>\n",
  1833. " <td>/bin/csh</td>\n",
  1834. " <td>x</td>\n",
  1835. " <td>12637</td>\n",
  1836. " <td>2120</td>\n",
  1837. " <td>Chandra Goliva - regular,Scientific Computing,</td>\n",
  1838. " <td>/gne/home/golivac</td>\n",
  1839. " <td>/bin/tcsh</td>\n",
  1840. " <td>ERROR: shells do not match</td>\n",
  1841. " </tr>\n",
  1842. " <tr>\n",
  1843. " <th>368</th>\n",
  1844. " <td>resknim</td>\n",
  1845. " <td>x</td>\n",
  1846. " <td>715536</td>\n",
  1847. " <td>715536</td>\n",
  1848. " <td>Resknime, Centrify {Arch~South San Francisco}</td>\n",
  1849. " <td>/gne/home/resknime</td>\n",
  1850. " <td>/bin/bash</td>\n",
  1851. " <td>x</td>\n",
  1852. " <td>739500</td>\n",
  1853. " <td>1950</td>\n",
  1854. " <td>Centrify RESKNIME - ,</td>\n",
  1855. " <td>/gne/home/resknim</td>\n",
  1856. " <td>/bin/csh</td>\n",
  1857. " <td>ERROR: shells do not match</td>\n",
  1858. " </tr>\n",
  1859. " <tr>\n",
  1860. " <th>405</th>\n",
  1861. " <td>shivaswn</td>\n",
  1862. " <td>x</td>\n",
  1863. " <td>744573</td>\n",
  1864. " <td>52</td>\n",
  1865. " <td>Niranajn - Internal account</td>\n",
  1866. " <td>/gne/home/shivaswn</td>\n",
  1867. " <td>/bin/bash</td>\n",
  1868. " <td>x</td>\n",
  1869. " <td>744573</td>\n",
  1870. " <td>1950</td>\n",
  1871. " <td>Niranjan Shivaswamy - Consultant, Arch Eng Ops</td>\n",
  1872. " <td>/gne/home/shivaswn</td>\n",
  1873. " <td>/bin/csh</td>\n",
  1874. " <td>ERROR: shells do not match</td>\n",
  1875. " </tr>\n",
  1876. " <tr>\n",
  1877. " <th>452</th>\n",
  1878. " <td>victors</td>\n",
  1879. " <td>x</td>\n",
  1880. " <td>34521</td>\n",
  1881. " <td>1950</td>\n",
  1882. " <td>Victor Saucedo - Regular, PD Engineering</td>\n",
  1883. " <td>/gne/home/victors</td>\n",
  1884. " <td>/bin/csh</td>\n",
  1885. " <td>x</td>\n",
  1886. " <td>34521</td>\n",
  1887. " <td>1950</td>\n",
  1888. " <td>Victor Saucedo - Regular, PD Engineering</td>\n",
  1889. " <td>/gne/home/victors</td>\n",
  1890. " <td>/bin/bash</td>\n",
  1891. " <td>ERROR: shells do not match</td>\n",
  1892. " </tr>\n",
  1893. " </tbody>\n",
  1894. "</table>\n",
  1895. "</div>"
  1896. ],
  1897. "text/plain": [
  1898. " unixID x_x uid_x gid_x \\\n",
  1899. "3 ahujan x 744428 744428 \n",
  1900. "52 cfcddadm x 51691 51691 \n",
  1901. "53 cfmedche x 23898 23898 \n",
  1902. "54 cfresabg x 723407 723407 \n",
  1903. "56 cfresgra x 717435 717435 \n",
  1904. "57 cfrespli x 716507 716507 \n",
  1905. "58 cfresseq x 718180 718180 \n",
  1906. "59 cfrestcg x 719615 719615 \n",
  1907. "60 cfsmdius x 26040 26040 \n",
  1908. "131 galngs x 748617 748617 \n",
  1909. "141 golivac x 12637 2120 \n",
  1910. "368 resknim x 715536 715536 \n",
  1911. "405 shivaswn x 744573 52 \n",
  1912. "452 victors x 34521 1950 \n",
  1913. "\n",
  1914. " desc_x homedir_x \\\n",
  1915. "3 /gne/home/ahujan \n",
  1916. "52 Cddadmin, Centrify {Arch~South San Francisco} /gne/home/cddadmin \n",
  1917. "53 Medchem, Centrify {Arch~South San Francisco} /gne/home/medchem \n",
  1918. "54 Resabgen, South San Francisco {GLOB~South San ... /gne/home/resabgen \n",
  1919. "56 Resgran, Centrify {Arch~South San Francisco} /gne/home/resgran \n",
  1920. "57 Resplims, South San Francisco {GLOB~South San ... /gne/home/resplims \n",
  1921. "58 Resseqwb, South San Francisco {GLOB~South San ... /gne/home/resseqwb \n",
  1922. "59 Restcga, South San Francisco {GLOB~South San F... /gne/home/restcga \n",
  1923. "60 Smdiuser, Centrify {Arch~South San Francisco} /gne/home/smdiuser \n",
  1924. "131 Dixon Galion Svcacct, South San Francisco {Gen... /gne/home/galngs \n",
  1925. "141 Chandra Goliva - regular,Scientific Computing, /gne/home/golivac \n",
  1926. "368 Resknime, Centrify {Arch~South San Francisco} /gne/home/resknime \n",
  1927. "405 Niranajn - Internal account /gne/home/shivaswn \n",
  1928. "452 Victor Saucedo - Regular, PD Engineering /gne/home/victors \n",
  1929. "\n",
  1930. " shell_x x_y uid_y gid_y \\\n",
  1931. "3 /bin/bash x 744428 1950 \n",
  1932. "52 /bin/bash x 737982 1950 \n",
  1933. "53 /bin/tcsh x 738107 1950 \n",
  1934. "54 /bin/bash x 740470 1950 \n",
  1935. "56 /bin/bash x 738028 1950 \n",
  1936. "57 /bin/bash x 740478 1950 \n",
  1937. "58 /bin/bash x 740467 1950 \n",
  1938. "59 /bin/bash x 740486 1950 \n",
  1939. "60 /bin/bash x 737971 1950 \n",
  1940. "131 /bin/csh x 748617 1950 \n",
  1941. "141 /bin/csh x 12637 2120 \n",
  1942. "368 /bin/bash x 739500 1950 \n",
  1943. "405 /bin/bash x 744573 1950 \n",
  1944. "452 /bin/csh x 34521 1950 \n",
  1945. "\n",
  1946. " desc_y homedir_y \\\n",
  1947. "3 Nitin Ahuja - Consultant, Arch Eng Ops /gne/home/ahujan \n",
  1948. "52 CENTRIFY CDDADMIN - , /gne/home/cfcddadm \n",
  1949. "53 CENTRIFY MEDCHEM - , /gne/home/cfmedche \n",
  1950. "54 South San Francisco Resabgen - , /gne/home/cfresabg \n",
  1951. "56 CENTRIFY RESGRAN - , /gne/home/cfresgra \n",
  1952. "57 South San Francisco resplims - , /gne/home/cfrespli \n",
  1953. "58 South San Francisco Resseqwb - , /gne/home/cfresseq \n",
  1954. "59 South San Francisco Restcga - , /gne/home/cfrestcg \n",
  1955. "60 CENTRIFY SMDIUSER - , /gne/home/cfsmdius \n",
  1956. "131 South San Francisco dixon galion svcacct - , /gne/home/galngs \n",
  1957. "141 Chandra Goliva - regular,Scientific Computing, /gne/home/golivac \n",
  1958. "368 Centrify RESKNIME - , /gne/home/resknim \n",
  1959. "405 Niranjan Shivaswamy - Consultant, Arch Eng Ops /gne/home/shivaswn \n",
  1960. "452 Victor Saucedo - Regular, PD Engineering /gne/home/victors \n",
  1961. "\n",
  1962. " shell_y discrepancies \n",
  1963. "3 /bin/csh ERROR: shells do not match \n",
  1964. "52 /bin/csh ERROR: shells do not match \n",
  1965. "53 /bin/csh ERROR: shells do not match \n",
  1966. "54 /bin/csh ERROR: shells do not match \n",
  1967. "56 /bin/csh ERROR: shells do not match \n",
  1968. "57 /bin/csh ERROR: shells do not match \n",
  1969. "58 /bin/csh ERROR: shells do not match \n",
  1970. "59 /bin/csh ERROR: shells do not match \n",
  1971. "60 /bin/csh ERROR: shells do not match \n",
  1972. "131 /bin/bash ERROR: shells do not match \n",
  1973. "141 /bin/tcsh ERROR: shells do not match \n",
  1974. "368 /bin/csh ERROR: shells do not match \n",
  1975. "405 /bin/csh ERROR: shells do not match \n",
  1976. "452 /bin/bash ERROR: shells do not match "
  1977. ]
  1978. },
  1979. "metadata": {},
  1980. "output_type": "display_data"
  1981. }
  1982. ],
  1983. "source": [
  1984. "# Use case where shells don't match between RCN and RSN\n",
  1985. "discrepant_rows3 = c1.loc[c1.shell_x != c1.shell_y]\n",
  1986. "discrepant_rows3 = discrepant_rows3.assign(discrepancies= 'ERROR: shells do not match')\n",
  1987. "discrepant_rows.append(discrepant_rows3)\n",
  1988. "display(discrepant_rows3)"
  1989. ]
  1990. },
  1991. {
  1992. "cell_type": "markdown",
  1993. "metadata": {},
  1994. "source": [
  1995. "## Homedirs that don't match"
  1996. ]
  1997. },
  1998. {
  1999. "cell_type": "code",
  2000. "execution_count": 14,
  2001. "metadata": {},
  2002. "outputs": [
  2003. {
  2004. "data": {
  2005. "text/html": [
  2006. "<div>\n",
  2007. "<style scoped>\n",
  2008. " .dataframe tbody tr th:only-of-type {\n",
  2009. " vertical-align: middle;\n",
  2010. " }\n",
  2011. "\n",
  2012. " .dataframe tbody tr th {\n",
  2013. " vertical-align: top;\n",
  2014. " }\n",
  2015. "\n",
  2016. " .dataframe thead th {\n",
  2017. " text-align: right;\n",
  2018. " }\n",
  2019. "</style>\n",
  2020. "<table border=\"1\" class=\"dataframe\">\n",
  2021. " <thead>\n",
  2022. " <tr style=\"text-align: right;\">\n",
  2023. " <th></th>\n",
  2024. " <th>unixID</th>\n",
  2025. " <th>x_x</th>\n",
  2026. " <th>uid_x</th>\n",
  2027. " <th>gid_x</th>\n",
  2028. " <th>desc_x</th>\n",
  2029. " <th>homedir_x</th>\n",
  2030. " <th>shell_x</th>\n",
  2031. " <th>x_y</th>\n",
  2032. " <th>uid_y</th>\n",
  2033. " <th>gid_y</th>\n",
  2034. " <th>desc_y</th>\n",
  2035. " <th>homedir_y</th>\n",
  2036. " <th>shell_y</th>\n",
  2037. " <th>discrepancies</th>\n",
  2038. " </tr>\n",
  2039. " </thead>\n",
  2040. " <tbody>\n",
  2041. " <tr>\n",
  2042. " <th>52</th>\n",
  2043. " <td>cfcddadm</td>\n",
  2044. " <td>x</td>\n",
  2045. " <td>51691</td>\n",
  2046. " <td>51691</td>\n",
  2047. " <td>Cddadmin, Centrify {Arch~South San Francisco}</td>\n",
  2048. " <td>/gne/home/cddadmin</td>\n",
  2049. " <td>/bin/bash</td>\n",
  2050. " <td>x</td>\n",
  2051. " <td>737982</td>\n",
  2052. " <td>1950</td>\n",
  2053. " <td>CENTRIFY CDDADMIN - ,</td>\n",
  2054. " <td>/gne/home/cfcddadm</td>\n",
  2055. " <td>/bin/csh</td>\n",
  2056. " <td>ERROR: homedirs do not match</td>\n",
  2057. " </tr>\n",
  2058. " <tr>\n",
  2059. " <th>53</th>\n",
  2060. " <td>cfmedche</td>\n",
  2061. " <td>x</td>\n",
  2062. " <td>23898</td>\n",
  2063. " <td>23898</td>\n",
  2064. " <td>Medchem, Centrify {Arch~South San Francisco}</td>\n",
  2065. " <td>/gne/home/medchem</td>\n",
  2066. " <td>/bin/tcsh</td>\n",
  2067. " <td>x</td>\n",
  2068. " <td>738107</td>\n",
  2069. " <td>1950</td>\n",
  2070. " <td>CENTRIFY MEDCHEM - ,</td>\n",
  2071. " <td>/gne/home/cfmedche</td>\n",
  2072. " <td>/bin/csh</td>\n",
  2073. " <td>ERROR: homedirs do not match</td>\n",
  2074. " </tr>\n",
  2075. " <tr>\n",
  2076. " <th>54</th>\n",
  2077. " <td>cfresabg</td>\n",
  2078. " <td>x</td>\n",
  2079. " <td>723407</td>\n",
  2080. " <td>723407</td>\n",
  2081. " <td>Resabgen, South San Francisco {GLOB~South San ...</td>\n",
  2082. " <td>/gne/home/resabgen</td>\n",
  2083. " <td>/bin/bash</td>\n",
  2084. " <td>x</td>\n",
  2085. " <td>740470</td>\n",
  2086. " <td>1950</td>\n",
  2087. " <td>South San Francisco Resabgen - ,</td>\n",
  2088. " <td>/gne/home/cfresabg</td>\n",
  2089. " <td>/bin/csh</td>\n",
  2090. " <td>ERROR: homedirs do not match</td>\n",
  2091. " </tr>\n",
  2092. " <tr>\n",
  2093. " <th>55</th>\n",
  2094. " <td>cfresgpa</td>\n",
  2095. " <td>x</td>\n",
  2096. " <td>713703</td>\n",
  2097. " <td>713703</td>\n",
  2098. " <td>Resgpan, Centrify {Arch~South San Francisco}</td>\n",
  2099. " <td>/gne/home/resgpan</td>\n",
  2100. " <td>/bin/csh</td>\n",
  2101. " <td>x</td>\n",
  2102. " <td>738030</td>\n",
  2103. " <td>1950</td>\n",
  2104. " <td>CENTRIFY RESGPAN - ,</td>\n",
  2105. " <td>/gne/home/cfresgpa</td>\n",
  2106. " <td>/bin/csh</td>\n",
  2107. " <td>ERROR: homedirs do not match</td>\n",
  2108. " </tr>\n",
  2109. " <tr>\n",
  2110. " <th>56</th>\n",
  2111. " <td>cfresgra</td>\n",
  2112. " <td>x</td>\n",
  2113. " <td>717435</td>\n",
  2114. " <td>717435</td>\n",
  2115. " <td>Resgran, Centrify {Arch~South San Francisco}</td>\n",
  2116. " <td>/gne/home/resgran</td>\n",
  2117. " <td>/bin/bash</td>\n",
  2118. " <td>x</td>\n",
  2119. " <td>738028</td>\n",
  2120. " <td>1950</td>\n",
  2121. " <td>CENTRIFY RESGRAN - ,</td>\n",
  2122. " <td>/gne/home/cfresgra</td>\n",
  2123. " <td>/bin/csh</td>\n",
  2124. " <td>ERROR: homedirs do not match</td>\n",
  2125. " </tr>\n",
  2126. " <tr>\n",
  2127. " <th>57</th>\n",
  2128. " <td>cfrespli</td>\n",
  2129. " <td>x</td>\n",
  2130. " <td>716507</td>\n",
  2131. " <td>716507</td>\n",
  2132. " <td>Resplims, South San Francisco {GLOB~South San ...</td>\n",
  2133. " <td>/gne/home/resplims</td>\n",
  2134. " <td>/bin/bash</td>\n",
  2135. " <td>x</td>\n",
  2136. " <td>740478</td>\n",
  2137. " <td>1950</td>\n",
  2138. " <td>South San Francisco resplims - ,</td>\n",
  2139. " <td>/gne/home/cfrespli</td>\n",
  2140. " <td>/bin/csh</td>\n",
  2141. " <td>ERROR: homedirs do not match</td>\n",
  2142. " </tr>\n",
  2143. " <tr>\n",
  2144. " <th>58</th>\n",
  2145. " <td>cfresseq</td>\n",
  2146. " <td>x</td>\n",
  2147. " <td>718180</td>\n",
  2148. " <td>718180</td>\n",
  2149. " <td>Resseqwb, South San Francisco {GLOB~South San ...</td>\n",
  2150. " <td>/gne/home/resseqwb</td>\n",
  2151. " <td>/bin/bash</td>\n",
  2152. " <td>x</td>\n",
  2153. " <td>740467</td>\n",
  2154. " <td>1950</td>\n",
  2155. " <td>South San Francisco Resseqwb - ,</td>\n",
  2156. " <td>/gne/home/cfresseq</td>\n",
  2157. " <td>/bin/csh</td>\n",
  2158. " <td>ERROR: homedirs do not match</td>\n",
  2159. " </tr>\n",
  2160. " <tr>\n",
  2161. " <th>59</th>\n",
  2162. " <td>cfrestcg</td>\n",
  2163. " <td>x</td>\n",
  2164. " <td>719615</td>\n",
  2165. " <td>719615</td>\n",
  2166. " <td>Restcga, South San Francisco {GLOB~South San F...</td>\n",
  2167. " <td>/gne/home/restcga</td>\n",
  2168. " <td>/bin/bash</td>\n",
  2169. " <td>x</td>\n",
  2170. " <td>740486</td>\n",
  2171. " <td>1950</td>\n",
  2172. " <td>South San Francisco Restcga - ,</td>\n",
  2173. " <td>/gne/home/cfrestcg</td>\n",
  2174. " <td>/bin/csh</td>\n",
  2175. " <td>ERROR: homedirs do not match</td>\n",
  2176. " </tr>\n",
  2177. " <tr>\n",
  2178. " <th>60</th>\n",
  2179. " <td>cfsmdius</td>\n",
  2180. " <td>x</td>\n",
  2181. " <td>26040</td>\n",
  2182. " <td>26040</td>\n",
  2183. " <td>Smdiuser, Centrify {Arch~South San Francisco}</td>\n",
  2184. " <td>/gne/home/smdiuser</td>\n",
  2185. " <td>/bin/bash</td>\n",
  2186. " <td>x</td>\n",
  2187. " <td>737971</td>\n",
  2188. " <td>1950</td>\n",
  2189. " <td>CENTRIFY SMDIUSER - ,</td>\n",
  2190. " <td>/gne/home/cfsmdius</td>\n",
  2191. " <td>/bin/csh</td>\n",
  2192. " <td>ERROR: homedirs do not match</td>\n",
  2193. " </tr>\n",
  2194. " <tr>\n",
  2195. " <th>127</th>\n",
  2196. " <td>forte</td>\n",
  2197. " <td>x</td>\n",
  2198. " <td>10001</td>\n",
  2199. " <td>10001</td>\n",
  2200. " <td>Belforte, Heidi {MNHS~South San Francisco}</td>\n",
  2201. " <td>/vqa/QA/belforte</td>\n",
  2202. " <td>/bin/csh</td>\n",
  2203. " <td>x</td>\n",
  2204. " <td>10001</td>\n",
  2205. " <td>140</td>\n",
  2206. " <td>Forte Application Account,Kathryn Chan,53078</td>\n",
  2207. " <td>/opt/forte</td>\n",
  2208. " <td>/bin/csh</td>\n",
  2209. " <td>ERROR: homedirs do not match</td>\n",
  2210. " </tr>\n",
  2211. " <tr>\n",
  2212. " <th>368</th>\n",
  2213. " <td>resknim</td>\n",
  2214. " <td>x</td>\n",
  2215. " <td>715536</td>\n",
  2216. " <td>715536</td>\n",
  2217. " <td>Resknime, Centrify {Arch~South San Francisco}</td>\n",
  2218. " <td>/gne/home/resknime</td>\n",
  2219. " <td>/bin/bash</td>\n",
  2220. " <td>x</td>\n",
  2221. " <td>739500</td>\n",
  2222. " <td>1950</td>\n",
  2223. " <td>Centrify RESKNIME - ,</td>\n",
  2224. " <td>/gne/home/resknim</td>\n",
  2225. " <td>/bin/csh</td>\n",
  2226. " <td>ERROR: homedirs do not match</td>\n",
  2227. " </tr>\n",
  2228. " </tbody>\n",
  2229. "</table>\n",
  2230. "</div>"
  2231. ],
  2232. "text/plain": [
  2233. " unixID x_x uid_x gid_x \\\n",
  2234. "52 cfcddadm x 51691 51691 \n",
  2235. "53 cfmedche x 23898 23898 \n",
  2236. "54 cfresabg x 723407 723407 \n",
  2237. "55 cfresgpa x 713703 713703 \n",
  2238. "56 cfresgra x 717435 717435 \n",
  2239. "57 cfrespli x 716507 716507 \n",
  2240. "58 cfresseq x 718180 718180 \n",
  2241. "59 cfrestcg x 719615 719615 \n",
  2242. "60 cfsmdius x 26040 26040 \n",
  2243. "127 forte x 10001 10001 \n",
  2244. "368 resknim x 715536 715536 \n",
  2245. "\n",
  2246. " desc_x homedir_x \\\n",
  2247. "52 Cddadmin, Centrify {Arch~South San Francisco} /gne/home/cddadmin \n",
  2248. "53 Medchem, Centrify {Arch~South San Francisco} /gne/home/medchem \n",
  2249. "54 Resabgen, South San Francisco {GLOB~South San ... /gne/home/resabgen \n",
  2250. "55 Resgpan, Centrify {Arch~South San Francisco} /gne/home/resgpan \n",
  2251. "56 Resgran, Centrify {Arch~South San Francisco} /gne/home/resgran \n",
  2252. "57 Resplims, South San Francisco {GLOB~South San ... /gne/home/resplims \n",
  2253. "58 Resseqwb, South San Francisco {GLOB~South San ... /gne/home/resseqwb \n",
  2254. "59 Restcga, South San Francisco {GLOB~South San F... /gne/home/restcga \n",
  2255. "60 Smdiuser, Centrify {Arch~South San Francisco} /gne/home/smdiuser \n",
  2256. "127 Belforte, Heidi {MNHS~South San Francisco} /vqa/QA/belforte \n",
  2257. "368 Resknime, Centrify {Arch~South San Francisco} /gne/home/resknime \n",
  2258. "\n",
  2259. " shell_x x_y uid_y gid_y \\\n",
  2260. "52 /bin/bash x 737982 1950 \n",
  2261. "53 /bin/tcsh x 738107 1950 \n",
  2262. "54 /bin/bash x 740470 1950 \n",
  2263. "55 /bin/csh x 738030 1950 \n",
  2264. "56 /bin/bash x 738028 1950 \n",
  2265. "57 /bin/bash x 740478 1950 \n",
  2266. "58 /bin/bash x 740467 1950 \n",
  2267. "59 /bin/bash x 740486 1950 \n",
  2268. "60 /bin/bash x 737971 1950 \n",
  2269. "127 /bin/csh x 10001 140 \n",
  2270. "368 /bin/bash x 739500 1950 \n",
  2271. "\n",
  2272. " desc_y homedir_y \\\n",
  2273. "52 CENTRIFY CDDADMIN - , /gne/home/cfcddadm \n",
  2274. "53 CENTRIFY MEDCHEM - , /gne/home/cfmedche \n",
  2275. "54 South San Francisco Resabgen - , /gne/home/cfresabg \n",
  2276. "55 CENTRIFY RESGPAN - , /gne/home/cfresgpa \n",
  2277. "56 CENTRIFY RESGRAN - , /gne/home/cfresgra \n",
  2278. "57 South San Francisco resplims - , /gne/home/cfrespli \n",
  2279. "58 South San Francisco Resseqwb - , /gne/home/cfresseq \n",
  2280. "59 South San Francisco Restcga - , /gne/home/cfrestcg \n",
  2281. "60 CENTRIFY SMDIUSER - , /gne/home/cfsmdius \n",
  2282. "127 Forte Application Account,Kathryn Chan,53078 /opt/forte \n",
  2283. "368 Centrify RESKNIME - , /gne/home/resknim \n",
  2284. "\n",
  2285. " shell_y discrepancies \n",
  2286. "52 /bin/csh ERROR: homedirs do not match \n",
  2287. "53 /bin/csh ERROR: homedirs do not match \n",
  2288. "54 /bin/csh ERROR: homedirs do not match \n",
  2289. "55 /bin/csh ERROR: homedirs do not match \n",
  2290. "56 /bin/csh ERROR: homedirs do not match \n",
  2291. "57 /bin/csh ERROR: homedirs do not match \n",
  2292. "58 /bin/csh ERROR: homedirs do not match \n",
  2293. "59 /bin/csh ERROR: homedirs do not match \n",
  2294. "60 /bin/csh ERROR: homedirs do not match \n",
  2295. "127 /bin/csh ERROR: homedirs do not match \n",
  2296. "368 /bin/csh ERROR: homedirs do not match "
  2297. ]
  2298. },
  2299. "execution_count": 14,
  2300. "metadata": {},
  2301. "output_type": "execute_result"
  2302. }
  2303. ],
  2304. "source": [
  2305. "discrepant_rows4 = c1.loc[c1.homedir_x != c1.homedir_y]\n",
  2306. "discrepant_rows4 = discrepant_rows4.assign(discrepancies='ERROR: homedirs do not match')\n",
  2307. "discrepant_rows.append(discrepant_rows4)\n",
  2308. "discrepant_rows4"
  2309. ]
  2310. },
  2311. {
  2312. "cell_type": "markdown",
  2313. "metadata": {},
  2314. "source": [
  2315. "## Unix ID's that don't match"
  2316. ]
  2317. },
  2318. {
  2319. "cell_type": "code",
  2320. "execution_count": 15,
  2321. "metadata": {},
  2322. "outputs": [
  2323. {
  2324. "data": {
  2325. "text/html": [
  2326. "<div>\n",
  2327. "<style scoped>\n",
  2328. " .dataframe tbody tr th:only-of-type {\n",
  2329. " vertical-align: middle;\n",
  2330. " }\n",
  2331. "\n",
  2332. " .dataframe tbody tr th {\n",
  2333. " vertical-align: top;\n",
  2334. " }\n",
  2335. "\n",
  2336. " .dataframe thead th {\n",
  2337. " text-align: right;\n",
  2338. " }\n",
  2339. "</style>\n",
  2340. "<table border=\"1\" class=\"dataframe\">\n",
  2341. " <thead>\n",
  2342. " <tr style=\"text-align: right;\">\n",
  2343. " <th></th>\n",
  2344. " <th>unixID</th>\n",
  2345. " <th>x_x</th>\n",
  2346. " <th>uid_x</th>\n",
  2347. " <th>gid_x</th>\n",
  2348. " <th>desc_x</th>\n",
  2349. " <th>homedir_x</th>\n",
  2350. " <th>shell_x</th>\n",
  2351. " <th>x_y</th>\n",
  2352. " <th>uid_y</th>\n",
  2353. " <th>gid_y</th>\n",
  2354. " <th>desc_y</th>\n",
  2355. " <th>homedir_y</th>\n",
  2356. " <th>shell_y</th>\n",
  2357. " <th>discrepancies</th>\n",
  2358. " </tr>\n",
  2359. " </thead>\n",
  2360. " <tbody>\n",
  2361. " <tr>\n",
  2362. " <th>52</th>\n",
  2363. " <td>cfcddadm</td>\n",
  2364. " <td>x</td>\n",
  2365. " <td>51691</td>\n",
  2366. " <td>51691</td>\n",
  2367. " <td>Cddadmin, Centrify {Arch~South San Francisco}</td>\n",
  2368. " <td>/gne/home/cddadmin</td>\n",
  2369. " <td>/bin/bash</td>\n",
  2370. " <td>x</td>\n",
  2371. " <td>737982</td>\n",
  2372. " <td>1950</td>\n",
  2373. " <td>CENTRIFY CDDADMIN - ,</td>\n",
  2374. " <td>/gne/home/cfcddadm</td>\n",
  2375. " <td>/bin/csh</td>\n",
  2376. " <td>ERROR: Unix ID's do not match</td>\n",
  2377. " </tr>\n",
  2378. " <tr>\n",
  2379. " <th>53</th>\n",
  2380. " <td>cfmedche</td>\n",
  2381. " <td>x</td>\n",
  2382. " <td>23898</td>\n",
  2383. " <td>23898</td>\n",
  2384. " <td>Medchem, Centrify {Arch~South San Francisco}</td>\n",
  2385. " <td>/gne/home/medchem</td>\n",
  2386. " <td>/bin/tcsh</td>\n",
  2387. " <td>x</td>\n",
  2388. " <td>738107</td>\n",
  2389. " <td>1950</td>\n",
  2390. " <td>CENTRIFY MEDCHEM - ,</td>\n",
  2391. " <td>/gne/home/cfmedche</td>\n",
  2392. " <td>/bin/csh</td>\n",
  2393. " <td>ERROR: Unix ID's do not match</td>\n",
  2394. " </tr>\n",
  2395. " <tr>\n",
  2396. " <th>54</th>\n",
  2397. " <td>cfresabg</td>\n",
  2398. " <td>x</td>\n",
  2399. " <td>723407</td>\n",
  2400. " <td>723407</td>\n",
  2401. " <td>Resabgen, South San Francisco {GLOB~South San ...</td>\n",
  2402. " <td>/gne/home/resabgen</td>\n",
  2403. " <td>/bin/bash</td>\n",
  2404. " <td>x</td>\n",
  2405. " <td>740470</td>\n",
  2406. " <td>1950</td>\n",
  2407. " <td>South San Francisco Resabgen - ,</td>\n",
  2408. " <td>/gne/home/cfresabg</td>\n",
  2409. " <td>/bin/csh</td>\n",
  2410. " <td>ERROR: Unix ID's do not match</td>\n",
  2411. " </tr>\n",
  2412. " <tr>\n",
  2413. " <th>55</th>\n",
  2414. " <td>cfresgpa</td>\n",
  2415. " <td>x</td>\n",
  2416. " <td>713703</td>\n",
  2417. " <td>713703</td>\n",
  2418. " <td>Resgpan, Centrify {Arch~South San Francisco}</td>\n",
  2419. " <td>/gne/home/resgpan</td>\n",
  2420. " <td>/bin/csh</td>\n",
  2421. " <td>x</td>\n",
  2422. " <td>738030</td>\n",
  2423. " <td>1950</td>\n",
  2424. " <td>CENTRIFY RESGPAN - ,</td>\n",
  2425. " <td>/gne/home/cfresgpa</td>\n",
  2426. " <td>/bin/csh</td>\n",
  2427. " <td>ERROR: Unix ID's do not match</td>\n",
  2428. " </tr>\n",
  2429. " <tr>\n",
  2430. " <th>56</th>\n",
  2431. " <td>cfresgra</td>\n",
  2432. " <td>x</td>\n",
  2433. " <td>717435</td>\n",
  2434. " <td>717435</td>\n",
  2435. " <td>Resgran, Centrify {Arch~South San Francisco}</td>\n",
  2436. " <td>/gne/home/resgran</td>\n",
  2437. " <td>/bin/bash</td>\n",
  2438. " <td>x</td>\n",
  2439. " <td>738028</td>\n",
  2440. " <td>1950</td>\n",
  2441. " <td>CENTRIFY RESGRAN - ,</td>\n",
  2442. " <td>/gne/home/cfresgra</td>\n",
  2443. " <td>/bin/csh</td>\n",
  2444. " <td>ERROR: Unix ID's do not match</td>\n",
  2445. " </tr>\n",
  2446. " <tr>\n",
  2447. " <th>57</th>\n",
  2448. " <td>cfrespli</td>\n",
  2449. " <td>x</td>\n",
  2450. " <td>716507</td>\n",
  2451. " <td>716507</td>\n",
  2452. " <td>Resplims, South San Francisco {GLOB~South San ...</td>\n",
  2453. " <td>/gne/home/resplims</td>\n",
  2454. " <td>/bin/bash</td>\n",
  2455. " <td>x</td>\n",
  2456. " <td>740478</td>\n",
  2457. " <td>1950</td>\n",
  2458. " <td>South San Francisco resplims - ,</td>\n",
  2459. " <td>/gne/home/cfrespli</td>\n",
  2460. " <td>/bin/csh</td>\n",
  2461. " <td>ERROR: Unix ID's do not match</td>\n",
  2462. " </tr>\n",
  2463. " <tr>\n",
  2464. " <th>58</th>\n",
  2465. " <td>cfresseq</td>\n",
  2466. " <td>x</td>\n",
  2467. " <td>718180</td>\n",
  2468. " <td>718180</td>\n",
  2469. " <td>Resseqwb, South San Francisco {GLOB~South San ...</td>\n",
  2470. " <td>/gne/home/resseqwb</td>\n",
  2471. " <td>/bin/bash</td>\n",
  2472. " <td>x</td>\n",
  2473. " <td>740467</td>\n",
  2474. " <td>1950</td>\n",
  2475. " <td>South San Francisco Resseqwb - ,</td>\n",
  2476. " <td>/gne/home/cfresseq</td>\n",
  2477. " <td>/bin/csh</td>\n",
  2478. " <td>ERROR: Unix ID's do not match</td>\n",
  2479. " </tr>\n",
  2480. " <tr>\n",
  2481. " <th>59</th>\n",
  2482. " <td>cfrestcg</td>\n",
  2483. " <td>x</td>\n",
  2484. " <td>719615</td>\n",
  2485. " <td>719615</td>\n",
  2486. " <td>Restcga, South San Francisco {GLOB~South San F...</td>\n",
  2487. " <td>/gne/home/restcga</td>\n",
  2488. " <td>/bin/bash</td>\n",
  2489. " <td>x</td>\n",
  2490. " <td>740486</td>\n",
  2491. " <td>1950</td>\n",
  2492. " <td>South San Francisco Restcga - ,</td>\n",
  2493. " <td>/gne/home/cfrestcg</td>\n",
  2494. " <td>/bin/csh</td>\n",
  2495. " <td>ERROR: Unix ID's do not match</td>\n",
  2496. " </tr>\n",
  2497. " <tr>\n",
  2498. " <th>60</th>\n",
  2499. " <td>cfsmdius</td>\n",
  2500. " <td>x</td>\n",
  2501. " <td>26040</td>\n",
  2502. " <td>26040</td>\n",
  2503. " <td>Smdiuser, Centrify {Arch~South San Francisco}</td>\n",
  2504. " <td>/gne/home/smdiuser</td>\n",
  2505. " <td>/bin/bash</td>\n",
  2506. " <td>x</td>\n",
  2507. " <td>737971</td>\n",
  2508. " <td>1950</td>\n",
  2509. " <td>CENTRIFY SMDIUSER - ,</td>\n",
  2510. " <td>/gne/home/cfsmdius</td>\n",
  2511. " <td>/bin/csh</td>\n",
  2512. " <td>ERROR: Unix ID's do not match</td>\n",
  2513. " </tr>\n",
  2514. " <tr>\n",
  2515. " <th>368</th>\n",
  2516. " <td>resknim</td>\n",
  2517. " <td>x</td>\n",
  2518. " <td>715536</td>\n",
  2519. " <td>715536</td>\n",
  2520. " <td>Resknime, Centrify {Arch~South San Francisco}</td>\n",
  2521. " <td>/gne/home/resknime</td>\n",
  2522. " <td>/bin/bash</td>\n",
  2523. " <td>x</td>\n",
  2524. " <td>739500</td>\n",
  2525. " <td>1950</td>\n",
  2526. " <td>Centrify RESKNIME - ,</td>\n",
  2527. " <td>/gne/home/resknim</td>\n",
  2528. " <td>/bin/csh</td>\n",
  2529. " <td>ERROR: Unix ID's do not match</td>\n",
  2530. " </tr>\n",
  2531. " </tbody>\n",
  2532. "</table>\n",
  2533. "</div>"
  2534. ],
  2535. "text/plain": [
  2536. " unixID x_x uid_x gid_x \\\n",
  2537. "52 cfcddadm x 51691 51691 \n",
  2538. "53 cfmedche x 23898 23898 \n",
  2539. "54 cfresabg x 723407 723407 \n",
  2540. "55 cfresgpa x 713703 713703 \n",
  2541. "56 cfresgra x 717435 717435 \n",
  2542. "57 cfrespli x 716507 716507 \n",
  2543. "58 cfresseq x 718180 718180 \n",
  2544. "59 cfrestcg x 719615 719615 \n",
  2545. "60 cfsmdius x 26040 26040 \n",
  2546. "368 resknim x 715536 715536 \n",
  2547. "\n",
  2548. " desc_x homedir_x \\\n",
  2549. "52 Cddadmin, Centrify {Arch~South San Francisco} /gne/home/cddadmin \n",
  2550. "53 Medchem, Centrify {Arch~South San Francisco} /gne/home/medchem \n",
  2551. "54 Resabgen, South San Francisco {GLOB~South San ... /gne/home/resabgen \n",
  2552. "55 Resgpan, Centrify {Arch~South San Francisco} /gne/home/resgpan \n",
  2553. "56 Resgran, Centrify {Arch~South San Francisco} /gne/home/resgran \n",
  2554. "57 Resplims, South San Francisco {GLOB~South San ... /gne/home/resplims \n",
  2555. "58 Resseqwb, South San Francisco {GLOB~South San ... /gne/home/resseqwb \n",
  2556. "59 Restcga, South San Francisco {GLOB~South San F... /gne/home/restcga \n",
  2557. "60 Smdiuser, Centrify {Arch~South San Francisco} /gne/home/smdiuser \n",
  2558. "368 Resknime, Centrify {Arch~South San Francisco} /gne/home/resknime \n",
  2559. "\n",
  2560. " shell_x x_y uid_y gid_y desc_y \\\n",
  2561. "52 /bin/bash x 737982 1950 CENTRIFY CDDADMIN - , \n",
  2562. "53 /bin/tcsh x 738107 1950 CENTRIFY MEDCHEM - , \n",
  2563. "54 /bin/bash x 740470 1950 South San Francisco Resabgen - , \n",
  2564. "55 /bin/csh x 738030 1950 CENTRIFY RESGPAN - , \n",
  2565. "56 /bin/bash x 738028 1950 CENTRIFY RESGRAN - , \n",
  2566. "57 /bin/bash x 740478 1950 South San Francisco resplims - , \n",
  2567. "58 /bin/bash x 740467 1950 South San Francisco Resseqwb - , \n",
  2568. "59 /bin/bash x 740486 1950 South San Francisco Restcga - , \n",
  2569. "60 /bin/bash x 737971 1950 CENTRIFY SMDIUSER - , \n",
  2570. "368 /bin/bash x 739500 1950 Centrify RESKNIME - , \n",
  2571. "\n",
  2572. " homedir_y shell_y discrepancies \n",
  2573. "52 /gne/home/cfcddadm /bin/csh ERROR: Unix ID's do not match \n",
  2574. "53 /gne/home/cfmedche /bin/csh ERROR: Unix ID's do not match \n",
  2575. "54 /gne/home/cfresabg /bin/csh ERROR: Unix ID's do not match \n",
  2576. "55 /gne/home/cfresgpa /bin/csh ERROR: Unix ID's do not match \n",
  2577. "56 /gne/home/cfresgra /bin/csh ERROR: Unix ID's do not match \n",
  2578. "57 /gne/home/cfrespli /bin/csh ERROR: Unix ID's do not match \n",
  2579. "58 /gne/home/cfresseq /bin/csh ERROR: Unix ID's do not match \n",
  2580. "59 /gne/home/cfrestcg /bin/csh ERROR: Unix ID's do not match \n",
  2581. "60 /gne/home/cfsmdius /bin/csh ERROR: Unix ID's do not match \n",
  2582. "368 /gne/home/resknim /bin/csh ERROR: Unix ID's do not match "
  2583. ]
  2584. },
  2585. "metadata": {},
  2586. "output_type": "display_data"
  2587. }
  2588. ],
  2589. "source": [
  2590. "discrepant_rows5 = c1.loc[c1.uid_x != c1.uid_y]\n",
  2591. "discrepant_rows5 = discrepant_rows5.assign(discrepancies='ERROR: Unix ID\\'s do not match')\n",
  2592. "#discrepant_rows.append(discrepant_rows5)\n",
  2593. "display(discrepant_rows5)"
  2594. ]
  2595. },
  2596. {
  2597. "cell_type": "markdown",
  2598. "metadata": {},
  2599. "source": [
  2600. "## Bringing it all together"
  2601. ]
  2602. },
  2603. {
  2604. "cell_type": "code",
  2605. "execution_count": 16,
  2606. "metadata": {},
  2607. "outputs": [],
  2608. "source": [
  2609. "discrepancies = pd.concat(discrepant_rows).drop_duplicates()"
  2610. ]
  2611. },
  2612. {
  2613. "cell_type": "code",
  2614. "execution_count": 17,
  2615. "metadata": {},
  2616. "outputs": [],
  2617. "source": [
  2618. "outdf = discrepancies.reset_index(drop=True)"
  2619. ]
  2620. },
  2621. {
  2622. "cell_type": "code",
  2623. "execution_count": 18,
  2624. "metadata": {},
  2625. "outputs": [],
  2626. "source": [
  2627. "outdf.to_csv('centrify_user_discrepancies.csv', index=False)\n"
  2628. ]
  2629. },
  2630. {
  2631. "cell_type": "markdown",
  2632. "metadata": {},
  2633. "source": [
  2634. "# Groups\n"
  2635. ]
  2636. },
  2637. {
  2638. "cell_type": "code",
  2639. "execution_count": 19,
  2640. "metadata": {},
  2641. "outputs": [
  2642. {
  2643. "name": "stdout",
  2644. "output_type": "stream",
  2645. "text": [
  2646. "Discrepant Rows: 85\n",
  2647. "Total Rows: 494\n",
  2648. "Percent Discrepant: 17.20647773279352 %\n"
  2649. ]
  2650. }
  2651. ],
  2652. "source": [
  2653. "discrepant_rows = []\n",
  2654. "discrepant_rows.append(c1.loc[(c1.uid_x == c1.gid_x)])\n",
  2655. "discrepant_shape = discrepant_rows[0].shape[0]\n",
  2656. "total_rows = c1.shape[0]\n",
  2657. "print(f'Discrepant Rows: {discrepant_shape}')\n",
  2658. "print(f'Total Rows: {total_rows}')\n",
  2659. "print(f'Percent Discrepant: {int(discrepant_shape)/int(total_rows) * 100} %')"
  2660. ]
  2661. },
  2662. {
  2663. "cell_type": "code",
  2664. "execution_count": null,
  2665. "metadata": {},
  2666. "outputs": [],
  2667. "source": []
  2668. }
  2669. ],
  2670. "metadata": {
  2671. "kernelspec": {
  2672. "display_name": "Python 3",
  2673. "language": "python",
  2674. "name": "python3"
  2675. },
  2676. "language_info": {
  2677. "codemirror_mode": {
  2678. "name": "ipython",
  2679. "version": 3
  2680. },
  2681. "file_extension": ".py",
  2682. "mimetype": "text/x-python",
  2683. "name": "python",
  2684. "nbconvert_exporter": "python",
  2685. "pygments_lexer": "ipython3",
  2686. "version": "3.7.0"
  2687. }
  2688. },
  2689. "nbformat": 4,
  2690. "nbformat_minor": 2
  2691. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!