Foundstone SQL Query-list hosts with unknown OS'es
(version: MVM 7.0+)
Mcafee support was not able to help me with this query, however after working within MVM's Faultline database, I came up with the following.
This query's output will be all IP addresses, discovered DNS names, discovered netbios names, etc...this is a good supplement to the manage OS fingerprints function in FCM
Use Faultline SELECTÂ Â Â Â vwAssets.IPAddressStr, Hosts.DNSName, Hosts.NBName, OSCategories.OSCategoryName, HostOSPrints.Percentage, OsPrints.Type, Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â OsPrints.Description FROMÂ Â Â Â Â Â Â Â Hosts INNER JOIN Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â HostOSPrints ON Hosts.HostID = HostOSPrints.HostID INNER JOIN Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â OsPrints ON HostOSPrints.OSPrintID = OsPrints.OSPrintID INNER JOIN Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â OSCategories ON Hosts.OSCategoryID = OSCategories.OSCategoryID AND OsPrints.OSCategoryID = OSCategories.OSCategoryID INNER JOIN Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â vwAssets ON Hosts.HostID = vwAssets.HostID WHEREÂ Â Â Â (HostOSPrints.Percentage < 100)
