[Pansophy] NCR for LCLS-RB AMGV Leak Check

[Mike Dickey]

For whom ever gets this task, I made some queries to help find places, travelers, where a user's name or id shows up.

// search TRAV_HEADER for a USERS NAME
select  trav_id, trav_revision, trav_author, signer1, signer2, signer3, signer4
from    adapps.trav_header
where   obs is null
and     upper(trav_author) like '%GRABOWSKI%'
or      upper(signer1) like '%GRABOWSKI%'
or      upper(signer2) like '%GRABOWSKI%'
or      upper(signer3) like '%GRABOWSKI%'
or      upper(signer4) like '%GRABOWSKI%';


// search TRAV_NCR_EMAIL for a USERNAME
select  distinct trav_id, trav_revision, ncr_name
from    adapps.TRAV_NCR_EMAIL
where   upper(ncr_name) = 'ADAMG'
and     obs is null
order by trav_id;


// search TRAV_D3_EMAIL for a USERNAME
select  distinct trav_id, trav_revision, d3_name
from    adapps.TRAV_D3_EMAIL
where   upper(d3_name) = 'ADAMG'
and     obs is null
order by trav_id;

I hope this helps.

Mike Dickey
SRF Inventory Technician
Jefferson Lab
12000 Jefferson Ave
Newport News, VA 23606
(757) 269-7755

From: Pansophy <pansophy-bounces at jlab.org> On Behalf Of David Savransky via Pansophy
Sent: Tuesday, December 2, 2025 4:39 PM
To: pansophy <pansophy at jlab.org>
Cc: Michelle Oast <weinmann at jlab.org>
Subject: [Pansophy] NCR for LCLS-RB AMGV Leak Check

Hi Pansophy,

Can you please remove Adam G. And add Michelle O. To the disposition list for the NCRs associated with L2RB-CLNRM-AMGV-LEAK?

Thank you,

David S.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20251203/699a746c/attachment.htm>