ITNinja

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.

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?

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.

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?

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. [;)]

thanks..

How aften does the Asset Meter change? Every 15mins? 30mins? 1hour?
Thanks

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.

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

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!