/build/static/layout/Breadcrumb_cap_w.png

reporting

Hi Guys,

Is it possible to configure the k1000 to alert me or show me a report if something on a machine has changed? eg. If someone removes a ram stick from a machine.

Thanks

mac

0 Comments   [ + ] Show comments

Answers (4)

Posted by: GillySpy 12 years ago
7th Degree Black Belt
3
Yes, but you would have to tell it what you want to know about.

Three obvious options: Option A: using the built-in alerts:
  1. Reporting->email alerts->add new computer notification
  2. choose a threshold the wizard can handle
  3. you will now get a notification when a machine meets that criteria on its checkin
Option B: extend the notification to use a custom query -- this time on ASSET HISTORY
Look at the asset history of a machine. Whatever is in that you could report on.
  1. open the notification you created above (reports->email alerts->click on existing one)
  2. change the query to something like below
E.g.

Select MACHINE.ID
from MACHINE
join ASSET A on MAPPED_ID=MACHINE.ID and ASSET_TYPE_ID=5
join ASSET_HISTORY AH on AH.ASSET_ID=A.ID
where
AH.DESCRIPTION like '%ram change%' -- note that i do not know what this would be for RAM
and AH.TIME > date_sub(now(), interval 1 DAY)


Option C: run a scheduled report so you get the alert on many machines at one time (e.g. daily ). Benefit of this is you can choose which columns to return including the asset history
  1. Reporting->add new sql report
  2. use this SQL (note the SQL here is almost same as above but you can tweak it)
Select MACHINE.ID, MACHINE.NAME,
AH.DESCRIPTION -- description can be lengthy so you might want to substring it, etc
from MACHINE
join ASSET A on MAPPED_ID=MACHINE.ID and ASSET_TYPE_ID=5
join ASSET_HISTORY AH on AH.ASSET_ID=A.ID
where
AH.DESCRIPTION like '%ram change%' -- note that i do not know what this would be for RAM
and AH.TIME > date_sub(now(), interval 1 DAY)


A Less obvious option would be automatically creating a ticket when a threshold is exceeded and leveraging all the benefits that go with that (emails, audit trail, etc). The basic idea is that you could have your alert above send the ticket to the queue. see http://www.kace.com/support/kb/index.php?action=artikel&cat=8&id=719&artlang=en in step 3.2 you would use a query like the above. Inour helpdesk we get notifications from the system into our queue that tell us about certain things like the status of last nights maintenance run.
Posted by: mac456 12 years ago
Purple Belt
0
excellent! thanks for the quick respones. I am not sure what route I will go down but I will let you know how I get on. Thanks again
Posted by: GillySpy 12 years ago
7th Degree Black Belt
0
Good luck! When you like the answers please rate the posts!
Posted by: mac456 12 years ago
Purple Belt
0
rated :)

p.s If anyone has done this before, please help (not that big on SQL)

cheers
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

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