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!

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

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') ) )
Answered 07/23/2012 by: dugullett
Red Belt

  • 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.
  • 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!
Please log in to comment

Answers

1

Base your report on the label and query the asset history for entires like "Machine connected with address 10.112.36.76."

Answered 07/23/2012 by: SMal.tmcc
Red Belt

Please log in to comment
1

The trail is under asset history, see below you can see date and time when machine connects.

 

Can this be queried?

Answered 07/23/2012 by: SMal.tmcc
Red Belt

Please log in to comment
This content is currently hidden from public view.
Reason: Removed by user request
For more information, visit our FAQ's.

Answer this question or Comment on this question for clarity