Queries
11/15/2018 - 11:38 AM

Attendance Check for Mcu and vbox

Attendance Check for Mcu and vbox
content_copyfile_download
SELECT * FROM lbtSiteMas WHERE s_Name LIKE '%s1ecd486901%'

SELECT * FROM lbtVideoFolderCount WHERE Vboxid = '735762' ORDER BY AtTime DESC

SELECT * FROM lbtVboxAttendance WHERE Vboxid = '735762' ORDER BY AtTime DESC

SELECT * FROM lbtAttendance WHERE McuId = '735762' ORDER BY AtTime DESC

SELECT * FROM lbtEventsAll WHERE McuId = '735762' AND EventCode = '301' AND CAST(AtTime AS date) = '2018-11-15' ORDER BY AtTime DESC