2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
5 <meta name="description" content=" Starting to look into user accounts issues Send out form for LDAP Authentication Information Coded up pong.sh and pong.tcl to check and see if ccase-rmna-3 is up or down Created initial set of PQA User/Group Account files...">
6 <meta name="generator" content="Movable Type 5.2.3">
7 <title>PQA Merge: User Issues - Status</title>
8 <link rel="alternate" type="application/atom+xml" title="Recent Entries" href="http://defaria.com/blogs/Status/atom.xml">
9 <link rel="canonical" href="http://defaria.com/blogs/Status/2005/10/pqa-merge-user.html">
10 <meta name="viewport" content="width=device-width,initial-scale=1">
11 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
13 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles_ie.css">
14 <script src="/mt/mt-static/support/theme_static/rainier/js/html5shiv.js"></script>
17 <link rel="start" href="http://defaria.com/blogs/Status/">
19 <link rel="prev" href="http://defaria.com/blogs/Status/2005/10/pqa-merge-audit.html" title="PQA Merge Issues/Pong">
20 <link rel="next" href="http://defaria.com/blogs/Status/2005/10/most-pqa-issues.html" title="Most PQA Issues resolved...">
21 <!-- Open Graph Protocol -->
22 <meta property="og:type" content="article">
23 <meta property="og:locale" content="en-us">
24 <meta property="og:title" content="PQA Merge: User Issues">
25 <meta property="og:url" content="http://defaria.com/blogs/Status/2005/10/pqa-merge-user.html">
26 <meta property="og:description" content=" Starting to look into user accounts issues Send out form for LDAP Authentication Information Coded up pong.sh and pong.tcl to check and see if ccase-rmna-3 is up or down Created initial set of PQA User/Group Account files...">
27 <meta property="og:site_name" content="Status">
28 <meta property="og:image" content="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
30 <meta itemprop="description" content=" Starting to look into user accounts issues Send out form for LDAP Authentication Information Coded up pong.sh and pong.tcl to check and see if ccase-rmna-3 is up or down Created initial set of PQA User/Group Account files...">
31 <link itemprop="url" href="http://defaria.com/blogs/Status/2005/10/pqa-merge-user.html">
32 <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
37 <div id="container-inner">
38 <header id="header" role="banner">
39 <div id="header-inner">
40 <div id="header-content">
42 <a href="http://defaria.com/blogs/Status/">
51 <nav role="navigation">
53 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
62 <div id="content-inner">
63 <ul class="breadcrumb breadcrumb-list">
64 <li class="breadcrumb-list-item"><a href="http://defaria.com/blogs/Status/">Home</a></li>
65 <li class="breadcrumb-list-item">PQA Merge: User Issues</li>
67 <div id="individual-main" class="main" role="main">
68 <article id="entry-1720" class="entry entry-asset asset hentry">
69 <div class="asset-header">
70 <h2 itemprop="name" class="asset-name entry-title">PQA Merge: User Issues</h2>
71 <footer class="asset-meta">
72 <ul class="asset-meta-list">
73 <li class="asset-meta-list-item">Posted on <time datetime="2005-10-18T15:22:09-08:00" itemprop="datePublished">October 18, 2005</time></li>
74 <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
77 <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/pqa/">PQA</a></li>
83 <div class="entry-content asset-content" itemprop="articleBody">
85 <li>Starting to look into user accounts issues</li>
87 <li>Send out form for LDAP Authentication Information</li>
89 <li>Coded up pong.sh and pong.tcl to check and see if ccase-rmna-3 is up or down</li>
91 <li>Created initial set of PQA User/Group Account files</li>
93 <h2>PQA User/Group Account Files</h2>
95 <p>Here's what I did for user accounts. I've attached all the files and
96 will refer to them by name here.</p>
100 <p>First I took the export list from Clearquest (<tt>userinfo.txt.orig</tt>).
101 This is the untouched original export file.</p>
103 <p>Next I extracted user names that begin with "oem" -> <tt>OEMUsers.cqu</tt>. Then I noticed that some of these users only appeared to be subscribed to NAS or BT. I then separated those out to <tt>OldOEMUsers.cqu</tt>.</p>
107 <p>Patterning off of <tt>userinfo.txt.orig</tt> file for groups I created <tt>NewGroups.cqu</tt> to match the new groups you describe on your Users tab of the Excel Workbook. The group records from <tt>userinfo.txt.orig</tt> I stored off in <tt>Groups.cqu</tt> and then separated off groups that were only NAS or BT to <tt>OldGroups.cqu</tt>.</p>
111 <p>This left me with all of the other users which were split up into <tt>Users.cqu</tt> and <tt>RemovedUsers.cqu</tt> based on whether they
112 subscribed to Prod or TO.</p>
114 <h3>Changing databases= line</h3>
116 <p>For all files I made the following assumption: If the databases= line
117 contained no values then that means "all databases". So any users or
118 groups with a databases= line with no values I assume subscribed to TO
119 or Prod. I left these databases= lines alone.</p>
121 <p>For other users or groups, if TO or Prod appeared in the databases=
122 line I removed all values and put in Cont.</p>
124 <p>Please let me know if this comes close to what you wanted WRT users and groups.</p>
126 <nav class="page-navigation entry-navigation pagination content-nav">
127 <ul class="page-navigation-list">
129 <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2005/10/pqa-merge-audit.html" title="PQA Merge Issues/Pong">Previous entry</a></li>
132 <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2005/10/most-pqa-issues.html" title="Most PQA Issues resolved...">Next entry</a></li>
137 <aside id="zenback" class="zenback feedback">
138 Please paste Zenback script code here.
145 <aside class="widgets related" role="complementary">
146 <nav class="widget-search widget">
147 <div class="widget-content">
148 <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
150 <input type="text" name="search" value="" placeholder="Search...">
152 <input type="hidden" name="IncludeBlogs" value="8">
154 <input type="hidden" name="limit" value="20">
155 <button type="submit" name="button">
156 <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
162 <nav class="widget-archive-category widget">
163 <h3 class="widget-header">Categories</h3>
164 <div class="widget-content">
167 <ul class="widget-list">
170 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
178 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
186 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
194 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
202 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
210 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
218 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
226 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
234 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
242 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
250 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
258 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
270 <nav class="widget-archive-dropdown widget">
271 <h3 class="widget-header">Archives</h3>
272 <div class="widget-content">
274 <option>Select a Month...</option>
276 <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
280 <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
284 <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
288 <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
292 <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
296 <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
300 <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
304 <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
308 <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
312 <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
316 <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
320 <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
324 <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
328 <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
332 <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
336 <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
340 <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
344 <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
348 <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
352 <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
356 <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
360 <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
364 <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
368 <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
372 <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
376 <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
380 <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
384 <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
388 <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
392 <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
396 <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
400 <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
404 <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
408 <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
412 <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
416 <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
420 <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
424 <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
428 <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
432 <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
436 <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
440 <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
444 <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
448 <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
452 <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
456 <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
460 <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
464 <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
468 <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
472 <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
476 <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
480 <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
484 <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
488 <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
492 <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
496 <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
500 <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
504 <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
508 <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
512 <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
516 <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
520 <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
524 <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
528 <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
532 <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
536 <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
540 <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
544 <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
548 <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
552 <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
556 <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
560 <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
568 <div class="widget-syndication widget section">
569 <div class="widget-content">
570 <p><img src="http://defaria.com/mt/mt-static/images/status_icons/feed.gif" alt="Subscribe to feed" width="9" height="9" /> <a href="http://defaria.com/blogs/Status/atom.xml">Subscribe to this blog's feed</a></p>
578 <footer id="footer" role="contentinfo">
579 <div id="footer-inner">
580 <div id="footer-content">
581 <nav role="navigation">
583 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
589 <p class="license">© Copyright 2016.</p>
590 <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
596 <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
597 <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>