How can I generate a software asset report that will give the usage time from a certain date? I wish I could automate the clearing of the Asset Metering Counter, then I wouldn't have a issue.

Please help..
Thanks,
Corey Williams - N.J.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
The KBOX doesn't keep historical data (aside from a few instances like asset history). If you want usage time from a certain date, you'll have to schedule reports to be emailed to you, and you'll have to reference those old reports. The KBOX is designed to give live data - it doesn't track much in terms of history.

We don't use metering, so I could be wrong - but based on what I know about the database, you're probably going to have to keep historical data outside the KBOX.
Answered 02/05/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
How about using the reporting. Would I be able to us:
SELECT *
FROM table
WHERE date_field
BETWEEN current_date()-7 AND current_date()

statement like this against the Asset Meter?
Answered 02/05/2010 by: chipdisk
Senior Yellow Belt

Please log in to comment
0
The problem is that there is no field you can use to report like that.

The METER_COUNTER table has the following fields:

  • ID
  • METER_ID
  • MACHINE_ID
  • WINDOW_BEGIN
  • LAST_LOGGED
  • MINUTES
  • TIMES_LAUNCHED


So, the only data you can report on includes: 1. the first time the software was run on a machine, 2. the last time the software was run on a machine, 3. the length of time the program was last run, and 4. the total number of times a machine has run the software. That's all you've got to work with - so for historical reporting you'll have to track snapshots in time (by using scheduled reports) outside the KBOX.
Answered 02/05/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
How do I connect to the Kbox SQL datebase to see all the tables available under Asset Metering like you did? Do you know if Kbox has documentation on this?
Answered 02/05/2010 by: chipdisk
Senior Yellow Belt

Please log in to comment
0
Download the MySQL GUI Tools (now called MySQL Workbench) from the MySQL website, and then connect to your KBOX using the R1 account. You need to go into your KBOX settings to make sure the account is enabled, and you'll want to change the password. The R1 account has read-only access, and we don't have write capability remotely in any way - so you can create queries, and reports based on those queries, but you cannot modify the database at all. Just figured I'd mention it before you drove yourself nuts trying to modify something. [;)]
Answered 02/05/2010 by: airwolf
Tenth Degree Black Belt

  • Toad for MySQL is also a great tool.
Please log in to comment
0
thanks..
Answered 02/05/2010 by: chipdisk
Senior Yellow Belt

Please log in to comment
0
How aften does the Asset Meter change? Every 15mins? 30mins? 1hour?
Thanks
Answered 02/05/2010 by: chipdisk
Senior Yellow Belt

Please log in to comment
0
This is the knowledge base article URL to access your KBOX database. You need your support account to access this page.

http://www.kace.com/support/customer/faq/index.php?action=artikel&cat=9&id=10&artlang=en


Software usage is aggregated monthly after it is uploaded to KBOX. For every process, a new record is created in a new month.
Answered 02/07/2010 by: wsteo
Senior Yellow Belt

Please log in to comment
0
I have a SQL report that can generate report on meter usage in the last N months. Replace 'INTERVAL 8 MONTH' with the number of months you want.

select
METER.PROCESS_NAME as 'Process Name',
SOFTWARE.DISPLAY_NAME as 'Software Name',
M.NAME as 'Machine',
M.IP as 'IP',
SUM(METER_COUNTER.MINUTES) as 'Minutes',
SUM(METER_COUNTER.TIMES_LAUNCHED) as 'Times Launched'
from MACHINE M, METER
left join METER_COUNTER on METER.ID = METER_COUNTER.METER_ID AND
METER_COUNTER.WINDOW_BEGIN > DATE_SUB(NOW(),INTERVAL 8 MONTH)
left join SOFTWARE ON METER.SOFTWARE_ID = SOFTWARE.ID
where
M.ID = METER_COUNTER.MACHINE_ID
GROUP BY METER.PROCESS_NAME, M.ID
Answered 02/08/2010 by: wsteo
Senior Yellow Belt

  • For some reason I am not seeing any data returned by this query. Is there any customization I need to do to this to get it to work?
Please log in to comment
0
ORIGINAL: wsteo

This is the knowledge base article URL to access your KBOX database. You need your support account to access this page.

http://www.kace.com/support/customer/faq/index.php?action=artikel&cat=9&id=10&artlang=en


Software usage is aggregated monthly after it is uploaded to KBOX. For every process, a new record is created in a new month.



Thanks for the Link wsteo!
Answered 02/10/2010 by: ustacp
Second Degree Blue Belt

Please log in to comment
Answer this question or Comment on this question for clarity