Custom Weekly Report for Sales Machines Checking in to K1000
We are trying to track the usage of the laptops for our Sales force over the next several months. I have been tasked with creating a custom SQL or other report (or maybe two reports) that can be scheduled to run once a week. This report will be based on a list of machines related to an existing Smart Label called "Sales Computers." We need it to display what machines have connected to the K1000 and how many times during the week they connected. Any help would be greatly appreciated!
Community Chosen Answer
I'm not sure that the amount the agent checks in is inventoried. I would think that would require a custom inventory. You can use this that will include the last inventory time.
SELECT NAME, LAST_INVENTORY, LAST_REBOOT, LAST_SHUTDOWN FROM MACHINE WHERE ((1 in (select 1 from LABEL, MACHINE_LABEL_JT where MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID AND MACHINE_LABEL_JT.LABEL_ID = LABEL.ID AND LABEL.NAME = 'Sales Computers') ) )