I have two source types -
One with a list of hosts and their software (DataIn).
The other with a list of ideal version numbers for that software (IdealData).
I want to be able to compare the newest entry for hosts against the newest ideal software version.
I can't just use the newest host entry because there may be multiple entries for different software.
EG. Comparing DataIn vs. IdealData
Sourcetypes -
DataIn - Time,IP,MAC,Hostname,Software,Version
IdealData - Time, Software, Version
DataIn -
1/15/15, , ,Box1,VisiCalc,4
1/15/15, , ,Box1,Lotus,2
1/10/15, , ,Box2,VisiCalc,1
IdealData -
1/16/15,VisiCalc,3
1/5/15,VisiCalc,1
In this situation Box 2 would not be running the latest version, but Box 1 would.
Ideally I'd love to produce a list of hosts, showing the software that is out of date, but everything I'm trying isn't working. I'd love any help.
... View more