Hi,
I'm new to the forum, but have been using OAv2 for a while, gradually ramping up from testing the waters to production use.
I have about 2,800 or so items in my "Other" table. Of these, about 500 are identified as "Networked" items. The other 2,300 are things like locally attached printers, software printer drivers.
I really don't care much about the 2,300+ "Non-networked" devices, as much of it is just fake stuff like pdf writers that are identified as locally attached printers, etc. and some might be duplicates or old entries for things that have changed (there is no way we have that many actual non-networked devices; most of them have to be garbage data). However, the fact that there are so many bogus "non-networked" items doesn't bother me because they are easy to just ignore. They don't really get in the way of doing other things in OA.
The items I REALLY care about are the "Networked" items in the "other" table. Of the 500+ I have, a great majority of them came from nmap scans that so far I have only been doing infrequently, and represent network hardware, surveillance cameras, printers, managed UPS's, and sundry networked doo-dads scattered throughout the enterprise.
For some reason, periodically ALL of the "Networked" items in the "other" table suddenly disappear from the database. All of them at once: everything with an IP number just vanishes in a split-second. When this happens, all of the "non-networked" items in that table remain. I now keep a backup of that table that I restore using myPhpAdmin when I discover that this has happened. Its rather annoying and may hinder acceptance of this tool by my staff when I start demonstrating it to them.
I'm still trying to track down a pattern, but it seems to happen when I am doing a "sweep" of the network for auditing (I have a batch file that I run which cycles through every IP number in one of our class-B internal address ranges and runs "audit.vbs" against each address). I don't know yet if it is coincidence that this happens when running this or not.
Are there any known bugs in OA or in audit.vbs that anyone knows of that would cause something like this? Or some kind of automatic purge process? Its almost like there is a malformed SQL query or something.
I read a discussion elsewhere on this forum where something similar was happening, but in that case it was that "system" audits were stepping on items in the "other" table where they had an IP number in common. I don't think that is what is happening to me, because I now use the system's network name for a UUID, and not the IP number.
Last edited by Jared on Thu Dec 06, 2012 4:08 am, edited 1 time in total.
|