Systems Management

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.

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

Good luck! When you like the answers please rate the posts!

rated :)

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

cheers