
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-25-2010 03:07 PM
We are trying to create a trigger on the tblComputerSystem table that alerts us by email to memory changes (increase or decrease) on machines. It works when we manually change the totalphysicalmemory column via a SQL query. But what we've discovered is that when a scan of a machine is triggered through LANSweeper, it deletes the whole row out of the tblComputersystem table and then as a separate transaction inserts a new row, rather than updating the row that's already there. As a result, the inserted and deleted tables in SQL don't have the necessary info to compare memory size.
Are we correct in this understanding? Either way, is there a way to do what we're trying to do?
Thanks for your help!
Jon
Are we correct in this understanding? Either way, is there a way to do what we're trying to do?
Thanks for your help!
Jon
Labels:
- Labels:
-
Report Center
4 REPLIES 4

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-04-2010 05:59 PM
This is outstanding, thanks!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2010 09:52 AM
If you take a look at the "recent changes" in the menu you can see the changes.
(only changes are recorded in these tables)
You can create a custom report that sends the changes for Memory each night (table tblPhysicalMemoryhist)
(only changes are recorded in these tables)
You can create a custom report that sends the changes for Memory each night (table tblPhysicalMemoryhist)

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-25-2010 09:27 PM
Downloaded version 4 today and have been poking around. It’s close, but what you term “Alerts” are more actual “Scheduled Reports”. Unless I’m missing something, there is no way to be notified if there is a change to a machine (in this case, memory has increased or decreased). Instead, you’re emailing me a nightly report that contains 99 out of 100 times the exact same data. That’s a nice start, but unless I also play detective in comparing reports of different memory sizes, I’m probably not going to notice a true change. Thanks for your help!
Jon
Jon

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-25-2010 03:46 PM
Try the beta version 4.0 from the forum, this does what you want.
