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

Comments

Please log in to comment

Community Chosen Answer

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.
Answered 01/12/2012 by: GillySpy
Seventh Degree Black Belt

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
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
Answered 01/12/2012 by: mac456
Purple Belt

Please log in to comment
0
Good luck! When you like the answers please rate the posts!
Answered 01/12/2012 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
rated :)

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

cheers
Answered 01/12/2012 by: mac456
Purple Belt

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