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!
Answers (3)
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') ) )
Comments:
-
DChristian did a post about tracking user logon/logoff time http://www.itninja.com/blog/view/how-to-find-user-log-on-and-log-off-time If this is an option for you than this can be included in a report. - dugullett 12 years ago
-
Though not quite as particular as what we were originally thinking, the select statement you provided will suffice for what we need. Thanks for your help! - jayp2200 12 years ago
Base your report on the label and query the asset history for entires like "Machine connected with address 10.112.36.76."
The trail is under asset history, see below you can see date and time when machine connects.
Can this be queried?
