/build/static/layout/Breadcrumb_cap_w.png

Asset Metering Counter

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

Answers (10)

Posted by: airwolf 14 years ago
Red Belt
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.
Posted by: chipdisk 14 years ago
Senior Yellow Belt
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?
Posted by: airwolf 14 years ago
Red Belt
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.
Posted by: chipdisk 14 years ago
Senior Yellow Belt
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?
Posted by: airwolf 14 years ago
Red Belt
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. [;)]

Comments:
  • Toad for MySQL is also a great tool. - hjoseph 8 years ago
Posted by: chipdisk 14 years ago
Senior Yellow Belt
0
thanks..
Posted by: chipdisk 14 years ago
Senior Yellow Belt
0
How aften does the Asset Meter change? Every 15mins? 30mins? 1hour?
Thanks
Posted by: wsteo 14 years ago
Senior Yellow Belt
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.
Posted by: wsteo 14 years ago
Senior Yellow Belt
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

Comments:
  • 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? - hjoseph 8 years ago
Posted by: ustacp 14 years ago
Second Degree Blue Belt
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!
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ