K1000 Email Alerts when changes occurred in the hardware Inventory
How do i configure Email alerts for the Hardware Inventory, when changes occurred,the configured recipient should get Email Alert Notification immediately
0 Comments
[ + ] Show comments
Answers (2)
Answer Summary:
Please log in to answer
Posted by:
Nico_K
9 years ago
You need to create a report for checking changes in the inventory.
Send this out regulary.
See this blog for the needed report:
http://www.itninja.com/blog/view/how-to-get-an-alert-in-case-of-inventory-changes-on-the-kace-k1000
Comments:
-
Not required K1000 Reports, need to get Email Alerts only when changes occurred not on regular basis or Scheduled task - anonymous_102124 9 years ago
-
I know, but since you cannot get the alert at itself you need to do this workaround. Create a report and send the report on a regular basis. Currently you don't have another possibility to get an alert - Nico_K 9 years ago
-
Oh, Fine... Thanks for the reply - anonymous_102124 9 years ago
Posted by:
cblake
9 years ago
Email-Alerts/Notifications can be sent at maximum every 15 minutes.
A ticket rule, notification, or scheduled SQL report for more customized content may be useful.
The following is an untested example. It is not guaranteed to work and should be used for reference/ideas only. Something like this might be useful SQL for seeing what changed within a given time period, filtering in/out things explicitly that you care about, and reporting it via any method you prefer:
select ASSET_HISTORY.TIME, ASSET.NAME, ASSET_HISTORY.DESCRIPTION from ASSET
left join ASSET_TYPE on ASSET.ASSET_TYPE_ID = ASSET_TYPE.ID
left join ASSET_HISTORY on ASSET.ID = ASSET_HISTORY.ASSET_ID
where (ASSET_TYPE.ID = 5 and NOW() < DATE_ADD(ASSET_HISTORY.TIME, INTERVAL 1 HOUR)
and ASSET_HISTORY.DESCRIPTION not like '%KB%'
and ASSET_HISTORY.DESCRIPTION not like '%reboot%' )
and ( ASSET_HISTORY.DESCRIPTION like 'video controllers changed from%'
or ASSET_HISTORY.DESCRIPTION like 'mac changed from%'
or ASSET_HISTORY.DESCRIPTION like 'processor changed from%'
or ASSET_HISTORY.DESCRIPTION like 'ram total changed from%'
or ASSET_HISTORY.DESCRIPTION like 'registry max size changed from%'
or ASSET_HISTORY.DESCRIPTION like 'ip changed from%'
or ASSET_HISTORY.DESCRIPTION like 'cd devices changed from%'
or (ASSET_HISTORY.DESCRIPTION like '%changed from%'
and ASSET_HISTORY.DESCRIPTION like '%disk%') or (ASSET_HISTORY.DESCRIPTION like '%changed from%'
and ASSET_HISTORY.DESCRIPTION like '%bios%') or (ASSET_HISTORY.DESCRIPTION like '%changed from%' and ASSET_HISTORY.DESCRIPTION like '%ram%') )
order by TIME DESC