K1000 Reporting - Help with a custom report
I've created a custom report for our workstations and last shutdown time. The report is pulling back all the infromation I need , however , I want to open pull back workstations that have a shutdown time greater than 7 days when the report is run.
Here's my report syntax.
select LABEL.NAME as LABEL_NAME, MACHINE.NAME as MACHINE_NAME, MACHINE.USER_LOGGED as USER_LOGGED
left outer join ORG1.MACHINE_LABEL_JT on MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID
left outer join ORG1.LABEL on MACHINE_LABEL_JT.LABEL_ID = LABEL.ID
where LABEL.TYPE !='hidden' and LABEL.NAME = 'M_Desktop' or LABEL.NAME = 'M_Laptop'
I'm looking to add some line to open pull back machines with a greater shutdown that 7 days. Anybody provide any help?