/build/static/layout/Breadcrumb_cap_w.png

Currently Powered On Detail by Name

This came from the Konference Power Management reports made available here:
http://www.kace.com/support/customer/faq/index.php?action=artikel&cat=5&id=983&artlang=en

This is the modified SQL with corrected time calculation of Powered On and also is sorted by name instead of by time:

select M.NAME, S.CONNECT_TIME as START_TIME,
TIME_FORMAT(sec_to_time(UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(S.CONNECT_TIME)), '%H:%i:%S') as HOURS_POWERED_ON
from MACHINE M
join KBSYS.SMMP_CONNECTION S on S.KUID = M.KUID
where S.CLIENT_CONNECTED = 1
order by M.NAME

0 Comments   [ + ] Show comments

Answers (2)

Posted by: RichB 14 years ago
Second Degree Brown Belt
0
Here's the same report narrowed down to a computer name that begins with "NameBegins:"

select M.NAME, S.CONNECT_TIME as START_TIME,
TIME_FORMAT(sec_to_time(UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(S.CONNECT_TIME)), '%H:%i:%S') as HOURS_POWERED_ON
from MACHINE M
join KBSYS.SMMP_CONNECTION S on S.KUID = M.KUID
where (S.CLIENT_CONNECTED = 1 and M.NAME like 'NameBegins%')
order by M.NAME


We run these reports for various sites at midnight and send the results to the technicians responsible. In the future I would prefer to use an email format similar to what is sent with the "Email Alerts" where the report is only sent if there is matching criteria and the body of the email has links back to the computer records.
Posted by: RichB 14 years ago
Second Degree Brown Belt
0
When that SQL is used in the Email Alert Notification Query, it arrives with the computer records as links but the other columns are not adjusted to the new criteria. A table with only computer names is sent with blank columns for System Description, MAC Address and IP Address.
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