...
Now we're loaded and ready to start doing some set logic.
This shows me the duplicate netids...
select netid from netids_from_service_now group by netid HAVING count(1)>1;
Status
As of the end of June 1, 2012, Backeberg has isolated just under 1000 duplicate netid entries. It's fairly straightforward to wipe these out, but we're going to put that off until after I'm out of ServiceNow training next week. I've built a script to do the wipeout; Bill has asked that I make a no-op version that collects a log, and run that in pre-prod. That's running June 12, 2012.