EXEC xp_logininfo N'NTLAB\E15770','all';
this should do that.  the user specified doesn't need to be directly created as a login or user in SQL Server, just have some access...

this command is the part that determines all the AD groups an AD user has database access through:
EXEC xp_logininfo N'DomainName\UserName','all';

What are the indexes on the table DDA_TRAN?  It looks like it might make more sense to have an index that starts with the 2 join columns, with maybe the...

Should be fairly straightforward considering you have aliases on each table, what have you tried and what problem were you having?

here's an attempt to list all security associated to a specific login, it's AD groups, and any database roles they belong to:
/* all permissions */
--check for...

ah, sorry, I see my mistake, the @ comes after -
SELECT requestID, orderID
  FROM
  (SELECT baserequestID, requestID, orderID, ROW_NUMBER() OVER (PARTITION BY baserequestID ORDER BY...

I ran those INSERT statements as you have them in my sandbox database, and reran my query, and I get:

requestID        orderID
ABC1706200013-1  ABC1706200013@@1ABC1706200013@@1
ABC1706200014-D  ABC1706200014@@1ABC1706200014@@1
ABC1706200015   

the problem is this isn't so straightforward in SSIS as you might want it to be.  If you use the Logging features of SSIS, you can record this info into...

I think it's the GROUP BY with a COALESCE that's mixing it up, maybe if you figure out the base of the requestID for grouping?
SELECT MAX(requestID), MAX(orderID)

how about this?
SELECT m.ID, t.Group_Num
  FROM #Main m
  CROSS APPLY (SELECT TOP 1 * FROM #Detail d WHERE d.ID = m.ID ORDER BY Default_Flag DESC,...

here is a query you can use to see user requests, their wait info, and if anyone is blocking them:
/* running requests */
SELECT s.session_id, s.host_name, s.program_name,...

it looks like your WHERE clause contradicts itself, the first combination of IDNum and CompletedDate also needs to be inside the parenthesis with the OR conditions, so maybe something like:

Go back it up right now... then you are sure that it is backed up! 🙂
https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-encryption-keys-manage-encryption-keys

Since this is a virtual server, are these "drives" sourced from a SAN?  If so, each LUN may be on the same physical spindles.  In that case, it won't provide...

Along those same lines, does each operator have a different goal or is it a common goal as Pietlinden suggested?  If each operator has a different goal which is why...