Report seems to be including archived machines
Hello, i have this SQL code for a report as below however it looks like its including Archived machines (as the total number of machines in the report is more than we have in the inventory).
We currently archive our machines after 90 days, is there anyway to change the code so it does not include archive machines?
MACHINE Right Join
MACHINE_SOFTWARE_JT On MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID Left Join
SOFTWARE On SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
(SOFTWARE.DISPLAY_NAME = "VLC")
Be the first to answer this question