The below SQL query can be run directly in SQL Server Management Studio (SSMS) to retrieve information on RME devices and the laptops/computers that they are used on.
SELECT C.PC_ID as Computer, R.DeviceBiosID as HardwareID, R.IpAddress, R.UserID, R.SDClientTimestamp as TimeStamps,
M.ShortDescription as Media, O.ShortDescription as Operation, R.OperationStatus, R.Source, R.Destination FROM RME_Log R
LEFT JOIN Computers C ON R.DeviceID = C.PC_Index
LEFT JOIN RME_MediaType M on R.MediaTypeID = M.TypeID
LEFT JOIN RME_OperationType O on R.OperationID = O.OperationID
Filters can be added at the end of the above query with a WHERE condition. Here are some examples:
To search by specific date:
WHERE SDConnexTimestamp between '2022-09-01' and '2021-09-30'
To search by specific device:
WHERE C.PC_ID = 'NAME_OF_PC'
To search by specific user:
WHERE R.UserID = 'NAME_OF_USER'